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

Inventory Valuation 0 Quantity but Dollar Amount

(3) Share

Report

Posted on by GS-17051342-0

390

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 (6)

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,278 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 390 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
Suggested answer

OussamaSabbouh 19,159 Super User 2026 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hello,
For a FIFO item with Remaining Quantity = 0 but Inventory Value = $0.01, this is typically a rounding residual. Microsoft specifically documents that for non-Average costing methods such as FIFO, when an inventory increase becomes fully applied, Adjust Cost - Item Entries calculates any rounding residual and creates a separate zero-quantity value entry to correct it. So first run Adjust Cost - Item Entries, then Post Inventory Cost to G/L, and rerun the Inventory Valuation report; in your case the expected adjustment would normally be approximately -$0.01. If the cent remains, drill into the item's Value Entries and identify which entry contributes the $0.01 before making any manual adjustment—I would not post directly to the inventory G/L account because the Inventory Valuation report is calculated from Value Entries and you could create a G/L/subledger mismatch.
Regards,
Oussama Sabbouh

1 people found this reply helpful.

Was this reply helpful? Yes No