Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / How to Match Differenc...
Microsoft Dynamics NAV (Archived)

How to Match Difference between 'Inventory Valuation Report' and 'stock Value Ledger' for an Item

(1) ShareShare
ReportReport
Posted on by AshishSharma003 220

Dear Team,

How to Match Difference between 'Inventory Valuation Report' and 'stock Value Ledger' for an Item.

We are running 'Adjust Cost Item Entries' at the end of every month; and there is '0' Quantity of the item available at 'end of the month'

but

Valuation Report showing Qty as '0' and Value as 344

and

Stock Value ledger is showing closing  value as 19,21,122.

All reports are processed for same period i.e. Last date of the month on which 'Adjust Cost Item Entries' was processed.

How to troubleshoot this error plz guide.

Best Regards,

Ashish

*This post is locked for comments

  • Verified answer
    AshishSharma003 Profile Picture
    AshishSharma003 220 on at
    RE: How to Match Difference between 'Inventory Valuation Report' and 'stock Value Ledger' for an Item

    Thanks Roberts

    Thanks paras mehan for your help.

    I got a solution.

    Costing Error Detection and Data Correction White Paper for Microsoft Dynamics NAV

    It contains a program which will help you to identify the entries with errors.

    It a good tool.

    Plz check following link

    mbs.microsoft.com/.../NAVCostingErrorDetectionWP

  • Suggested answer
    RobertasR Profile Picture
    RobertasR 5,002 on at
    RE: How to Match Difference between 'Inventory Valuation Report' and 'stock Value Ledger' for an Item

    Hi,

    this is theoretically possible. Let's go through one of those possible scenarios (not saying that is exactly what happened, but it's just to illustrate how it can be 0 quantity with value). You have purchased goods for 1000 in January, so system puts expected value as 1000. The you have sold it in January, so system records 1000 as COGS and now the quantity is 0.

    If you run Cost Adjustment at the end of the month, it will do nothing in this scenario. Then in the beginning of February, you have received the invoice for purchased goods, that was 1344, instead of 1000. Posting such invoice would increase the value of purchased stock, but will not increase the value goods sold until you run cost adjustment.

    So, when you run the Stock Valuation report, it will show quantity 0, with remaining value for January.

    Now, when you run Cost Adjustment for February (let's assume you haven't purchased that particular item in February), because January is closed, system will post adjustment in February, meaning that your February Stock valuation will show quantity = 0, and value = -344. Running 2 month stock valuation, will show zero quantity and zero value.

    If that is something that happened in your case, not much can be done without changing figures of January/February. Going forward you need to make sure that Cost adjustment is run before closing the period, rather than at the end of the month.

    Hope that helps.

    Robertas

  • Suggested answer
    Paras mehan Profile Picture
    Paras mehan 3,518 on at
    RE: How to Match Difference between 'Inventory Valuation Report' and 'stock Value Ledger' for an Item

    is location is mandatory for you? do you have some entries without location ?

    Even take the one item and check if there(-or+) value showing also for location.

  • AshishSharma003 Profile Picture
    AshishSharma003 220 on at
    RE: How to Match Difference between 'Inventory Valuation Report' and 'stock Value Ledger' for an Item

    OK Thanks

  • Suggested answer
    Paras mehan Profile Picture
    Paras mehan 3,518 on at
    RE: How to Match Difference between 'Inventory Valuation Report' and 'stock Value Ledger' for an Item

    this is when you calculate the inventory value, to create the revaluation journal. The error message is NAV-speak for "you have negative inventory on an item, probably by variant code, and by location code".

    The only possible resolution is to not have negative stock on any item (by variant code, by location code). Negative stock breaks the valuation chains.

  • AshishSharma003 Profile Picture
    AshishSharma003 220 on at
    RE: How to Match Difference between 'Inventory Valuation Report' and 'stock Value Ledger' for an Item

    Hi Paras,

    In Application Work sheet an Open Outbound Entry 19XXXXXX found for the same item.

    how to post or treat that Open Outbound Entry.

  • Suggested answer
    Paras mehan Profile Picture
    Paras mehan 3,518 on at
    RE: How to Match Difference between 'Inventory Valuation Report' and 'stock Value Ledger' for an Item

    In line please mention date, Document no., item no., apply to entry(Item Ledger entry page will open. please select any entry from that page for related period ).

    Then in line do changes according to your difference amount and post.

    After this please run 1001 report. i hope this will balanced.

  • AshishSharma003 Profile Picture
    AshishSharma003 220 on at
    RE: How to Match Difference between 'Inventory Valuation Report' and 'stock Value Ledger' for an Item

    In Revaluation General -> On Header -> in Process Group -> by pressing 'Calculate Inventory Value’ Button -> on window ‘Edit - Calculate Inventory Value’ after providing required Item information & pressing OK button->

    System shows following Error:

    Open Outbound Entry 19XXXXXX found.

  • Paras mehan Profile Picture
    Paras mehan 3,518 on at
    RE: How to Match Difference between 'Inventory Valuation Report' and 'stock Value Ledger' for an Item

    at the time of posting ?

  • AshishSharma003 Profile Picture
    AshishSharma003 220 on at
    RE: How to Match Difference between 'Inventory Valuation Report' and 'stock Value Ledger' for an Item

    system shows following error:

    Open Outbound Entry 19XXXXXX found.

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics NAV (Archived)

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans