Finance | Project Operations, Human Resources, ...

Inventory Aging Report - Inventory value quantity vs On-hand quantity

(0) Share

Report

Posted on by Afonso Rodrigues

215

Hi all

I have run a Inventory aging report and in pretty much all item I have a much higher quantities on "Inventory value quantity" than on "On-hand quantity".

In AR, I never ship goods without invoicing them, this always happen at the same time.

In AP, the process is the opposite: It is very common that we receive the goods and only get invoiced by the vendor at a later stage.

Hence, I would imagine it would be possible to have higher values of "On-hand quantity" than "Inventory value quantity".

However, the report shows the opposite, which I cannot understand.

Is anyone able to give a justification for this? Thank you.

I have the same question (0)

All responses (5)

Answers (0)

André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (1)

Report

Hi Afonso,

Can you provide examples? Please also mention what inventory costing method you are using for the items.

Was this reply helpful? Yes No
Afonso Rodrigues 215 on at

Like (0)

Report

Hi Andre

The inventory costing method is FIFO.

What dou you mean by provide examples?

Was this reply helpful? Yes No
Afonso Rodrigues 215 on at

Like (0)

Report

Hi Andre

Hi have added those two pictures in my last comment (one for the report parameters and the other is the actual report). Let me know if you need anything else. Thanks

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

Hi Afonso,

This is a new report which I first had to enable via feature management. There is not that much of documentation. There is just a small summary of this report: Inventory aging report storage - Supply Chain Management | Dynamics 365 | Microsoft Docs

I do see the same behavior in my demo environment. For a presentation on inventory dimensions this week, I showed the impact of having the Financial option enabled for Storage dimensions or not. It looks like this also have an impact on this report.

The items in my example do have a different storage dimension group. One where Financial is not enabled for the warehouse and on the other the Financial option is enabled. The report will show correct details if the Financial option is enabled for the specific inventory dimensions.

When the Financial option is not enabled, it looks like the inventory value shows the value of the original purchase transaction. A quantity of 100 was purchased in warehouse 22. Then two times a quantity of 5 was moved with a transfer journal to warehouse 11 and 21.

When I look at your screenshot, there are also inventory values which are the same on several lines. You can review the settings on your Storage dimension groups and check if the Financial option is enabled or not. It can't be changed when you already have posted transactions.

Was this reply helpful? Yes No
aryaps 155 on at

Like (0)

Report

if you made this report pls share the details

Was this reply helpful? Yes No