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 98,060 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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,161 Moderator on at

Like (0)

Report
Copy link

Link copied!

Have you processed all the cost adjustments for the items?

Was this reply helpful? Yes No
PETERFL 101 on at

Like (0)

Report
Copy link

Link copied!

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,461 on at

Like (0)

Report
Copy link

Link copied!

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,161 Moderator on at

Like (0)

Report
Copy link

Link copied!

[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