report for age of consignment materials

[Former Member]

Is there a report that shows the age of consignment materials.Meaning to say when they were received into our inventory.

Thanks

Anusha

[JL23 · Accepted solution]

do you maintain the stock in batches?

[Former Member · Accepted solution]

Yes we have them batch managed. How will be the case if they were not batch managed?

[JL23 · Accepted solution]

Without batch management you would not be able to track the age, as you cannot seperate the stocks.

In batch record the GR date is saved.

I dont know any report that shows the age for consignment material directly (we do not have such).

But you can create a query that shows the GR date from the batch record (tables MCHA, MCH1 MCHB)

[Former Member · Accepted solution]

that was informative. thanks