Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

How do i create an aging inventory report?

(0) ShareShare
ReportReport
Posted on by 5
Report has the following fields:
Fields Definition
Brand Brand Description
Product Group Inventory Posting Group
Item No Item Brand Description
Total Cost Sum of current Stock-on-hand item cost
0-6 Mths Sum of current Stock-on-hand item cost which stock-in date is 0 - 6 months
7-12 Mths Sum of current Stock-on-hand item cost which stock-in date is 7 - 12 months
13-18 Mths Sum of current Stock-on-hand item cost which stock-in date is 13 - 18 months
19-24 Mths Sum of current Stock-on-hand item cost which stock-in date is 19 - 24 months
25-30 Mths Sum of current Stock-on-hand item cost which stock-in date is 25 - 30 months
31-36 Mths Sum of current Stock-on-hand item cost which stock-in date is 31 - 36 months
Over 36 Mths Sum of current Stock-on-hand item cost which stock-in date is > 36 months
Last Stock-in Date Last Stock-in Date
Last Stock-out Date Last Stock-out Date
  • AndrewThomas Profile Picture
    155 on at
    RE: How do i create an aging inventory report?

    You should be able to build a spreadsheet that analyses open item ledger entries, probably better do to this in PowerBI to make refreshing it quicker

  • Suggested answer
    THE Italian Profile Picture
    on at
    RE: How do i create an aging inventory report?

    You might get in touch with your CSP Partner or reseller and show them what you would like to achieve. They could then create a report on your behalf based on the fields that you need. 

    They might mimic what is done in existing aging reports for this specific request (e.g. customer or vendor summery / detailed aging)

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

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

#1
YUN ZHU Profile Picture

YUN ZHU 304 Super User 2025 Season 1

#2
Mansi Soni Profile Picture

Mansi Soni 219

#3
Sagar_Dangar_MCP Profile Picture

Sagar_Dangar_MCP 180

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans