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

Ooko

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

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

Thank so much Amir

amr_wafa

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

Thank so much Amir