web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... How do i create an agi...

Small and medium business | Business Central, N...

Suggested Answer

How do i create an aging inventory report?

(0) Share

Report

Report

Posted on by VKRS

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

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

THE Italian Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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)

Was this reply helpful? Yes No
AndrewThomas on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04

Check out the Community Spotlight Video Series

Quick Links

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

#1

OussamaSabbouh 612 Super User 2026 Season 1

#2

YUN ZHU 489 Super User 2026 Season 1

#3

Grigorios Mavrogeorgis 285 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans