What does inventory with zero quantity and negative values on my inventory valuation report mean.

Ooko · 2017-10-24

I have run cost adjustment post to G/l batch job but when I run my inventory valuation report excluding expected cost in NAV some of my inventory with zero quantity have negative values, how do I resolve this. According to my understanding zero stocks should not have values

amr_wafa · 2017-11-05

Hi,

I think you are using Average Costing? if so, then this would be because the "Average Cost Calc. Type" is "Item" in Inventory Setup page.
In a test database, change it to "Item & Location & Variant" then you will see values will become zero.

You can then investigate the entries more and believe me, you will find the cause and the reason quickly

Thanks.
Amr.

Ooko · 2017-11-16

Thank so much Amir

amr_wafa · 2017-11-05

Hi,

I think you are using Average Costing? if so, then this would be because the "Average Cost Calc. Type" is "Item" in Inventory Setup page.
In a test database, change it to "Item & Location & Variant" then you will see values will become zero.

You can then investigate the entries more and believe me, you will find the cause and the reason quickly

Thanks.
Amr.

Ooko · 2017-11-16

Thank so much Amir

What does inventory with zero quantity and negative values on my inventory valuation report mean.

Best Answers

Answers

Categories