Items with negative unit costs on Valuation report

(0) Share

Report

Posted on by PETERFL

101

Hi All,

When we run our inventory valuation report at the end of our financial year ( December 2022), there are some items that have negative unit costs for a number of locations.

What could cause the negative unit costs and how can it be corrected.

We are using D365BC -Cloud

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

YUN ZHU 95,712 Super User 2025 Season 2 on at

Like (0)

Report

Hi, If the quantity is 0, but the amount is negative, this may be a problem from the NAV era.

Hope the following can give you some hints.

https://learn.microsoft.com/en-nz/dynamics365/business-central/design-details-inventory-valuation

https://archerpoint.com/why-does-inventory-valuation-show-zero-hand-has-value/

https://www.apcommerce.com/articles/why-you-have-negative-inventory-value-with-0-quantity-%E2%80%93-navision-37b-to-navision-50/

Thanks.

ZHU

Was this reply helpful? Yes No
PETERFL 101 on at

Like (0)

Report

Hi,

Thanks for your reply

This is an example of what is happening on the inventory valuation report. for Item A we are using FIFO valuation method

Item A (location 1) 2 -10.00 -20.00

Item A (location 2) 2 -100.00 -200.00

Item A (location 3) 5 -1.00 -5.00

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

Have you processed all the cost adjustments for the items?

Was this reply helpful? Yes No
PETERFL 101 on at

Like (0)

Report

Thanks for responding.

How do I process all the cost adjustments for the items and it is possible to post the adjustments in 2022 December 31st)

Was this reply helpful? Yes No
Suggested answer

Manan_Shah 1,459 on at

Like (0)

Report

Hi Peter,

Please check below link, It will help to understand the Process of Adjustment Item entries.

www.solsyst.com/.../adjust-cost-what-it-is-and-why-you-need-it

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

[quote user="PETERFL"]
Thanks for responding.

How do I process all the cost adjustments for the items and it is possible to post the adjustments in 2022 December 31st)
[/quote]
You can read more about configuring and doing cost adjustment in my blog article:

https://bc365.co/2022/01/15/cost-adjustment-in-microsoft-dynamics-365-business-central/

Hope you find that helpful.

Was this reply helpful? Yes No