Microsoft Dynamics AX (Archived)

Inventory Value report no qty but show inventory value

(0) Share

Report

Posted on by Dexin

452

Hi Guys,

I wanna to ask, why is the inventory value report show inventory value without inventory qty?

I gen the inventory value report, report show me a inventory value but no inventory qty.

How can it happen and how to resolve this

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (0)

André Arnaud de Cal... 301,231 Super User 2025 Season 2 on at

Like (0)

Report

Hi Dexin,

This can depend on the inventory costing model you are using or settings in the storage dimension groups.

For some inventory models, you need to do a regularly inventory closing which will recalculate the real costs based on e.g. FIFO or average. This can settle these amounts.

If you have multiple warehouses and not a financial value per warehouse, another warehouse can have 2.75 positive with quantity zero. However.... in that case, the report usually doesn't show the values, so I do think it is related to the first option.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

In addition, do you track financial inventory values at the batch level?

Can you double check that in your tracking dimension group form?

Best regards,

Ludwig

Was this reply helpful? Yes No
Dexin 452 on at

Like (0)

Report

Yes, I do activate financial cost by batch. What is the impact for this?

Was this reply helpful? Yes No
MATTGUO 22,349 Moderator on at

Like (0)

Report

Hi Dexin,

Could you please show your the screenshot of tracking and storage dimension groups?

Do you use the inventory model of moving average or weighted avg. date?

If so, my screenshot can show one of the reasons.

This post talked a lot about it: https://community.dynamics.com/ax/f/33/t/229915?pi61711=1#responses

Was this reply helpful? Yes No
Dexin 452 on at

Like (0)

Report

Hi all,

Thank you so much for sharing your valuable information.

I manage to sort out the root cause.

Actually the issue is explainable as below:

Storage dimension = Financially for Site and Warehouse

Tracking dimension = Financial marked for batch control

1. Purchase FG0001 at difference costing at different batch no

2. Issue out the is not sequential batch no, system will base on the FIFO method to allocate the cost,

Was this reply helpful? Yes No
Dexin 452 on at

Like (0)

Report

Guys,

Initially i am activating my inventory cost by site and warehouse.

Lastly i have activated the financial cost by Site, Warehouse and by batch no.

As a result, when i view my inventory value report by site, warehouse and batch, i can inventories have on physical qty but with inventory value (positive and negative value)

Please refer to below:

Anywhere to zerorize the inventory value for those inventory that with zero qty

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Dexin,

Have you already run an inventory recalculation for those items?

Best regards,

Ludwig

Was this reply helpful? Yes No
Dexin 452 on at

Like (0)

Report

Yes, i did done by inventory closing and recalculation but can't get ride of the figure. Anywhere to get ride of the figure?

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Hello Dexin,

I see.

The only other thing that I can imagine is posting a inventory counting journal for a quantity of 0.

Alternatively, try to make use of the adjustment functionality in the inventory closing and adjustment form, which should become available with the inventory close and that allows you to modify the value.

Best regards,

Ludwig

Was this reply helpful? Yes No
Dexin 452 on at

Like (0)

Report

I did tried both of your suggestion

1. Both the inventory counting and inventory closing adjustment couldn't allow to to adjust the inventory cost for no on-hand qty

Was this reply helpful? Yes No