It seems basic inventory aging should be part of the Distribution version of the software.  You cannot run a distribution business without inventory aging reports.  Is there a reason aging reports are not part of the basic package?

Hi,

Just wondering if someone has created an Inventory Ageing report by day or a specific time frame?

Thanks!

Hey Uday,

I merged your Discussion Topic into this existing Discussion Topic.

I'm sorry we won't be able to meet at Summit. The conference has always been an excellent experience for me and is a great opportunity for all of us to build on the community created here in the AUG forum.

Thanks a lot, Shawn. You are 100% correct. I didn't think. I appreciate your thoroughness. That is what prospects grill us on. I will stay in touch with you. Good luck.  I can't attend the Summit. 

FIFO and LIFO are accounting methods used to determine the value of on-hand inventory based upon an assumption that either the oldest item was released when shipped (FIFO), or the newest time was released (LIFO). This is only an approximation and has no association with the actual product released from inventory. Using this to track time-sensitive freshness issues for food or drugs is a recipe for disaster.

Instead, implement either lot or serial tracking on each item in stock needing this level of management. Acumatica provides the ability to track expirations dates at the serial/lot level. This allows you to know exactly what you have in your warehouse and manage freshness. It is critical that you can provide traceability for items receipts, movements, and shipments of perishable items. Anything short of this will find you in hot water with the FDA.

Such an item aging report is a must for foods, drinks, drugs, ... otherwise our food could be moldy when sold in the store. Yes, we do track the expiration date but that is not enough. Age of item is also needed. 

This should be a standard report (out of the box). Was this request entered into feedback.acumatica.com ? I hate to put this request in feedback.acumatica.com since this is a major shortcoming. NetSuite will love to see this.

for my application, the stock valuation method is Specific.

do you have any report sample on stock aging for Acumatica?

my email= tiongchiewlaw@gmail.com

thank you very much.