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

"Item Age Composition - Value" Report: discrepancy?

(8) Share

Report

Posted on by LizHK

191

Hi,

One of our colleage approached to say that the totals of inventory values do not match with the totals of the age.

He says it's the first time I see this and I don't understand this at all (I actually have not ran this report previously)

Can someone explain what's going on here? I am not sure if this is a bug or if there is something that I'm missing that I don't understand.

I ran without all filters and they still show the discrepancies - I am so confused.

I looked at the learn prior to posting questions - and also found some examples but I didn't see anywhere that I was looking at that the totals didn't match - it is very confusing when the period totals is bigger than total inventory values and some of the spot checks didn't match with the period so I'm very confused.

Thank you,

Categories:

Dynamics 365 Business Central

I have the same question (4)

All responses (7)

Answers (0)

Sort by

Suggested answer

YUN ZHU 100,212 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi, hope the following helps.

Item Age Composition - Value (report)

https://learn.microsoft.com/en-us/dynamics365/business-central/reports/report-5808?wt.mc_id=DX-MVP-5004336

https://community.dynamics.com/blogs/post/?postid=db6e4259-af34-ef11-840a-000d3a11e031

In addition, the data of this report is mainly taken from "Item Ledger Entry". If you want to study the standard logic, you can check its code.

report 5808 "Item Age Composition - Value"

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 22,342 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hope this helps: https://learn.microsoft.com/en-us/dynamics365/business-central/reports/report-5808

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,173 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

This isn't a bug — the "Item Age Composition - Value" report uses valuation dates and posting dates to allocate inventory into aging buckets. Timing differences, rounding, or backdated transactions can cause totals to not match exactly. Try comparing with the Inventory Valuation report for consistency.

✅ Mark this answer as verified if it helps you

Was this reply helpful? Yes No
Suggested answer

EM-11081455-0 6 on at

Like (2)

Report
Copy link

Link copied!

Hi all,

The value on each column should be, the sum of Remaining Quantity on that period X the Unit Cost for that period.

The Remaining Quantity is on Item ledger Entry and you can confirm it with Item Age Composition - Quantity.

The Unit Cost for the period is calculated, check Value Entry and filtering Valuation Date for the period (Sum Cost Amount + Cost Expected) /(Sum Quantity)

Was this reply helpful? Yes No
Sachinth Nanayakkara 4 on at

Like (1)

Report
Copy link

Link copied!

I have the same issue with this report. Does this report have any problem where, after posting a positive adjustment entry, the value still shows as the full amount while the status is still open? The aged bucket value is incorrect, but the Inventory Value column shows the correct amount.

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 15,186 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

The Item Age Composition report almost never matches total inventory value.

It’s not a valuation report, it buckets ILEs by posting date and ignores things like revaluations, expected cost, partial consumption leftovers, and negative/zero-cost distortions.

So differences in totals = normal and expected.

Use Inventory Valuation for the “true” value.

Regards,

Oussama Sabbouh

1 people found this reply helpful.

Was this reply helpful? Yes No
LizHK 191 on at

Like (0)

Report
Copy link

Link copied!

Thank you - I expect minor differences as you talk about but values like these do not make any sense at all to me and my co-workers. I had to create my own report for this purpose because currently this report is of no use and don't know what purpose it's serving. Qty one matches perfectly but no matter how much I try to make sense of this report I couldn't.

Was this reply helpful? Yes No