Hi,
I am trying to create an inventory aging report with the Item Ledger Entries and Item Card Excel from Microsoft Business Central. I am pulling the data into Power BI to do my own manipulation because the Inventory Age Manipulation report is very limiting. I am calculating value with Remaining Quantity and the Unit Cost from the Item Card Excel
How can I get the inventory aging as of a past date? Because the remaining quantity always updates, I am unable to get the data as of a month-end of my choosing.
How have you guys been using the inventory aging reporting? To me it just seems very limited and difficult.
