By using this website, you agree to our Terms of Use (click here)
Hi there
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.
@doug-mcbride you can try sending @carolinehern a direct message through the forums.
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.
@doug-mcbride, yes I reached out as well. Although I received an initial reply, I've not heard back since then.
@Doug-Mcbride and @Justin-Sanchez I too reached out and I have received a response. Times are very busy. Perhaps there is something on the Roadmap for 2022 R1, in fact I should be checking to either Vote on this or place the idea on this so we can all vote on this feature.
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.