Stock Item usage inquiry

Hi Donna,

If you refer to stock historical transaction you can see Inventory Transaction History inquiry to find the usage. If you refer to dead stock functionality that would be available in 2021R1.

Thank you! That’s a great tool for looking at individual transactions.

Is there any tool that groups usage into time intervals (i.e. usage per week/month)?

See my request for an Inventory Aging Report, which is widely used to see usage (i.e. fast and slow moving inventory)

Here is an example of the raw data from the 2021R1 sales demo.  It should work in any version of Acumatica.

Thank you! That’s the information I was looking for!

@dennisgodsill36 

Do you know how in the heck I download your xml file, all I can do is open it?

Apologies @asmith50 but there seems to be an issue with the file @dennisgodsill36 attached. Hopefully the see this post and can upload the file again.

Hi all,

Fixed the file and got it to work.

Hope this helps.

I included the txt version for downloading, just remember to change the file type to xml.

Thanks for all the leg work Dennis!

-Heather

Does anyone have a useful version of this that I can use to get aging information over 180/365 days along with number sold across all warehouse during the same period? Similar results to the Dead Stock Inquiry but in a GI and across multiple warehouses?