Is there a way to run an Aged Inventory report?
Trudy,
Which product are you using?
Thanks
Jeff
MAS 200
Please define what you mean by "aged"
I'm looking for a report that will tell me how old my inventory is. For example, I have vendors that will allow me to return product for credit if it was purchased within the last 12 months. So is there a way to run a report on specific inventory items that were received in a specific date range?
All FIFO, LOT and Serial items have a record in the Item Costing file and each record has a receipt date so you could write a report based on the Item Costing file. You can also run a report based on the purchase order receipt history tables but that may take a bit longer.
Thanks for the response. The PO receipt history report may work for us because we would be looking for items that are un-serialized as well.
Please note that for Standard and Average costing methods it might not be possible to created an aged report.
*Community Hub is the new name for Sage City