web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Inventory Aging
Small and medium business | Business Central, N...
Suggested Answer

Inventory Aging

(6) ShareShare
ReportReport
Posted on by LonelyGiraffe000 22
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.
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Hylke Britstra Profile Picture
    Hylke Britstra 93 on at
    You have asked this question on the Microsoft Dynamics 365 Finance Forum (related to Finance and Operations), so my expectation is that your question will not have a proper answer here because you mentioned Microsoft Business Central which is a different application. 
     
    I advise you to ask this question on the 'Small and medium business | Business Central, NAV, RMS' forum: https://community.dynamics.com/forums/thread/?partialUrl=smb
  • Gerardo Rentería García Profile Picture
    Gerardo Rentería Ga... 25,225 Most Valuable Professional on at

    Hi, good day
    You can use this standard report as a guide.

    Item Age Composition - Value (report) - Business Central | Microsoft Learn

    Best Regards
    Gerardo

  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 31,452 Super User 2025 Season 2 on at
    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.
    I don't think that's really possible unless you do some very complex calculations to calculate the point in time inventory quantity. Can you clarify why you need this data in the past as opposed to just today?
     
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 20,441 Super User 2025 Season 2 on at

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,577

#2
YUN ZHU Profile Picture

YUN ZHU 888 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 778 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans