Small and medium business | Business Central, N...

Inventory Valuation 0 Quantity but Dollar Amount

(2) Share

Report

Posted on by GS-17051342-0

388

Hi,

I have this zero quantity .01 inventory value on the inventory valuation report. How do I make the $.01 go away?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Daniel Zafon 12 on at

Like (0)

Report
Copy link

Link copied!

Hi,
The times I've seen something similar it has usually been with items using the Average Cost method, although in your case it's FIFO. It could be related to rounding issues, as I've come across that on a few occasions.

Do you have multiple warehouses? If so, are you filtering by a specific warehouse or excluding any warehouses when running the report?

Was this reply helpful? Yes No
Suggested answer

Teagen Boll 3,775 Super User 2026 Season 2 on at

Like (1)

Report
Copy link

Link copied!

I have a feeling it is a rounding issue from a cost adjustment of some kind. You may be able to quickly see the value entries for a 0.01 actual cost line. I would test this in a copy/sandbox first but if you run the Adjust Cost - Item Entries process and post to the G/L does that revalue/correct the penny amount?

Best,
Teagen Boll, CPA
LinkedIn
Blog posts

Was this reply helpful? Yes No
Suggested answer

Grigorios Mavrogeorgis 3,269 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi, start with Adjust Cost - Item Entries on that item, then Post Inventory Cost to G/L. Often the cent is just an item charge or invoice that posted after the entry closed, and the adjustment clears it by itself.
Glad to help - follow up if anything is unclear.
► If this solved it, marking it verified helps others too.
Regards,
Grigorios Mavrogeorgis
Business Central Consultant & AL Developer
Work: Gmsoft Limited
Blog: insidebusinesscentral
LinkedIn: linkedin.com/in/gregorymavrogeorgis

Was this reply helpful? Yes No
GS-17051342-0 388 on at

Like (0)

Report
Copy link

Link copied!

Grigorios - I did adjust cost - item entries and it didn't do anything.

Teagan - Adjust Cost - Item entries didn't do anything.

Daniel - I do have multiple warehouses and this shows up on a specific one.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 102,974 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Microsoft explained this issue in its official documentation.
Business Central Design Details: Known Item Application Issue (where the inventory level is zero although open item ledger entries exist)
More details: https://learn.microsoft.com/en-us/dynamics365/business-central/design-details-inventory-zero-level-open-item-ledger-entries?wt.mc_id=DX-MVP-5004336

Hope this helps.
Thanks.
ZHU

Was this reply helpful? Yes No