web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Correct Item costing ...
Small and medium business | Business Central, N...
Suggested Answer

Correct Item costing which has zero quantity and but has cost in inventory valuation

(0) ShareShare
ReportReport
Posted on by smshyd 155

Hi Experts,

    Due to some unknown issue, NAV has posted value entries in the present open Period, for Item Ledger Entry posted 2018,2019,2020 and 2021  For the average cost item (inventory setup for average is item wise and day) costing got messed up and now Inventory valuation is showing 0 quantity but some cost, How to correct that 

I have the same question (0)
  • Suggested answer
    TWBlaisdell Profile Picture
    TWBlaisdell Microsoft Employee on at

    Hello,

    Thank you for posting on the Forum. 

    I would start by focusing on the data and making sure that the data is complete and accurate. Design Details - Cost Adjustment - Business Central | Microsoft Docs  

    There may be certain data scenarios that need to be more actively managed. I would begin by reviewing the link: Inventory Zero Open Item Ledger Entries - Business Central | Microsoft Docs  This is related to open ILEs that didn't close due to negative inventory scenarios. 

    You may want to also work with your partner to download and run the Costing Error Detection Toolkit, or as a Partner you may do this directly, bu tyou can use the Report to analyze the data using the Costing Error Detection Toolkit Report to identify data issues: Content Detail | Welcome to PartnerSource Business Center (microsoft.com)

    These are some places to begin the review and analysis. It definitely takes detailed review and analysis of the undertying data, which includes Item Ledger Entries (Table 32), Value Entries (Table 5802), and Item Application Entries (Table 339) data.  

    Best Regards,
    Tom

  • Suggested answer
    Kavisha Profile Picture
    Kavisha 310 on at

    Hi

    Just do a Positive adjustment for the those items for qty 1 and then do revaluation journal for the item to make unit cost as 0 and then do a negative adjustment for that 1 qty.

    regards

    Kavisha

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,024 Super User 2026 Season 1

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,024 Super User 2026 Season 1

#3
YUN ZHU Profile Picture

YUN ZHU 1,383 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans