In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Questions Inventory Ageing Report
Does anyone have created a Inventory Ageing Report, i'm struggling a bit to create one. I want to create it in GI.
I would be interested in learning about the Inventory Aging Report Caroline Hern created.
Wondering if anyone ever received an update on the aged inventory report? This is something that my company is currently looking to solve.
I reached out to Caroline Hern and did not get a reply. We are still looking for an inventory aging report. We are also looking for an inventory "turns" report if anyone has one.
I added a lesson to my Building Generic Inquiries & Pivot Tables course (click here) that shows how to build an Inventory Aging report using a Generic Inquiry and a Pivot Table. The end result looks like this:
With the ability to click the + next to a Warehouse and see the individual items like this:
The only catch is that you have to be using a Valuation Method of FIFO or Specific. This method doesn't work with Standard or Average.