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

Inventory Valuation Report show quantity 0 but have value

(6) Share

Report

Posted on by CU05030303-0

The costing method used is FIFO.
I have attempted to run the "Adjust Cost - Item Entries" process.
However, the value still reflects amount in the Inventory Valuation Report, even though the quantity is 0.
I am unable to identify which specific transaction is causing the issue.

Any solution to resolve this issue and bring the value to 0 in the Inventory Valuation Report?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (8)

Answers (0)

Jonas "Jones" Melgaard Super User 2025 Season 2 on at

Like (1)

Report

Hi,

What product is this screenshot from?

Dynamics 365 BC, GP, F&O, AX etc.

Was this reply helpful? Yes No
CU05030303-0 on at

Like (2)

Report

hi, this is from Dynamic 365 BC.

Was this reply helpful? Yes No
Jonas "Jones" Melgaard Super User 2025 Season 2 on at

Like (1)

Report

Thanks. I have moved your question to the BC forum, hope you don't mind.

Was this reply helpful? Yes No
Suggested answer

Dr Gomathi MVP, MCT... Super User 2025 Season 2 on at

Like (1)

Report
The issue where the Inventory Valuation Report shows a zero quantity but non-zero value despite using FIFO costing and running the Adjust Cost - Item Entries process is often caused by one or more of the following factors:
Possible Causes & Solutions
1. Unapplied or Partial Application of Purchase & Sales Transactions

Issue: If a purchase receipt (positive entry) is not fully applied to a sale (negative entry), Business Central may still hold some residual cost.

Solution:

Navigate to Item Ledger Entries for the affected items.

Identify any purchase receipt or inventory adjustment entries that are not fully applied.

Manually apply them using the Application Worksheet (if necessary).

2. Rounding Differences in Costing

Issue: Minor rounding differences can leave a small value in inventory.

Solution:

Check the Item Card > Costing Tab and review the decimal precision settings.

Use the Revaluation Journal to adjust the remaining cost to 0.

3. Costing Errors Due to Returns or Adjustments

Issue: If there was a return or an inventory adjustment that was not costed correctly, it may leave residual cost.

Solution:

Run the Inventory Valuation - WIP Report to see pending adjustments.

Check Item Ledger Entries for unexpected return or adjustment entries.

If needed, post a manual cost adjustment via the Revaluation Journal.

4. Costing Issue Due to Direct Posting to Inventory Accounts

Issue: If someone manually posted a journal entry to the Inventory G/L Account, it may leave residual value.

Solution:

Navigate to General Ledger Entries and check for manual postings to inventory accounts.

Reverse or adjust these entries properly.

5. Re-run Cost Adjustments & Posting

Solution Steps:

Run "Adjust Cost - Item Entries" again.

Run "Post Inventory Cost to G/L".

Recheck the Inventory Valuation Report.

6. Using the Revaluation Journal as a Last Resort

If none of the above resolves the issue, manually post a Revaluation Journal to bring the value to 0.

Try this

Check Item Ledger Entries for unapplied transactions.

Review rounding differences in costing.

Ensure all returns and inventory adjustments are properly costed.

Confirm that no manual journal entries are affecting inventory accounts.

Run the Adjust Cost - Item Entries and Post Inventory Cost to G/L processes again.

Use the Revaluation Journal as a last resort.

If you have any queries, please post it.

Was this reply helpful? Yes No
Gerardo Rentería Ga... Most Valuable Professional on at

Like (1)

Report

Hi, good day
I hope this can help you, and give you some hints.

Dollar Value in Average Costing Despite No Stock in Dynamics NAV

Inventory Value with 0 stock issue in Inventory Valuation Report

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet Super User 2025 Season 2 on at

Like (2)

Report

Are you using NAV, specifically a fairly old version, or BC?

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

YUN ZHU Super User 2025 Season 2 on at

Like (1)

Report

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

Khushbu Rajvi. Super User 2025 Season 2 on at

Like (1)

Report

Hope this helps: https://community.dynamics.com/forums/thread/details/?threadid=5bd53639-8308-4ee7-b24b-7b6b926c7f57

https://dynamicscommunities.com/community/groups/d365ugbc/forum/topic/remaining-qty-0-zero-but-item-valuation-report-shows-inventory-value/

Was this reply helpful? Yes No