Why the Value and the Quantity report needed to be separate reports is beyond me.<\/p>\n
When we run these reports, we see that you can define an Ending Date<\/strong>.<\/p>\n When you define an Ending Date, it will run the report aged in different time buckets with the ending date that you defined.<\/p>\n What confused some users is that this Ending Date is not when you want to run the inventory aging as of<\/strong>. Rather, you’re just defining the ending date of when the report display the time buckets. For example, if you change the Ending Date to a prior date, it will only show you the inventory aging for those time periods based on the current inventory value<\/strong>.<\/p>\n But what if you want to get a snapshot of your inventory aging as of a certain date?<\/p>\n For example, you’re working with a bank to get a loan. As a collateral, they want the value and the quantities of your inventory.<\/p>\n However, banks are not dumb, they know that inventory value that’s been sitting in your warehouse for a while is not going to be worth the same as what you originally bought it for. They will want you to provide a supporting document to see how old your inventory values are as it relates to your total Inventory Valuation.<\/p>\n What do you do if an external party wants you to provide your aging report as of a specific day?<\/p>\n Your best bet would be to remember to run the standard item aging reports on that specific day. If you forgot to run the aging reports for those dates, then you have to restore a backup and run the report for that specific day.<\/p>\n Having to remember to run the report or restoring a backup every time you need this report is not realistic and a colossal waste of time. In addition, you never know when you’re going to need it.<\/p>\n![\"\"](\"https:\/\/www.apcdynamics.com\/articles\/wp-content\/uploads\/2024\/06\/BaseAging.png\")
<\/p>\nThe Confusion<\/h1>\n
The Business Case<\/h1>\n
Back Dating the Item Age Report<\/h1>\n