web
You’re offline. This is a read only version of the page.
close
Skip to main content
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
    Kavisha Profile Picture
    Kavisha 310 on at
    RE: Correct Item costing which has zero quantity and but has cost in inventory valuation

    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

  • Suggested answer
    TWBlaisdell Profile Picture
    TWBlaisdell on at
    RE: Correct Item costing which has zero quantity and but has cost in inventory valuation

    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

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

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

#1
Sumit Singh Profile Picture

Sumit Singh 2,708

#2
Sohail Ahmed Profile Picture

Sohail Ahmed 2,675 Super User 2025 Season 2

#3
Jeffrey Bulanadi Profile Picture

Jeffrey Bulanadi 2,203

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans