web
You’re offline. This is a read only version of the page.
close
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

I have the same question (0)
  • Suggested answer
    Paras mehan Profile Picture
    Paras mehan 3,518 on at

    Hi,

    I think i suggested you some days ago regarding this.

    community.dynamics.com/.../266060

    Best Regards,

    Paras Mehan

  • AshishSharma003 Profile Picture
    AshishSharma003 220 on at

    Ya, Paras

    as replied ..

    "Thanks Paras,

    For few Items it is working fine but for few items it also creating a new Junk Value. "

    For an Item Item Valuation Report now shows '0' stock '0' Value but Stock Value ledger shows '0' Stock but 'XXXXXXX' Value.

  • Suggested answer
    Paras mehan Profile Picture
    Paras mehan 3,518 on at

    Please take a backup in test data and go by revaluation journal. once journal is posted then run post inventory cost to GL and then make varify that everything is fine.

    Hope this will work. I also face this type of issue and solved successfully by this method.

  • AshishSharma003 Profile Picture
    AshishSharma003 220 on at

    system shows following error:

    Open Outbound Entry 19XXXXXX found.

  • Paras mehan Profile Picture
    Paras mehan 3,518 on at

    at the time of posting ?

  • AshishSharma003 Profile Picture
    AshishSharma003 220 on at

    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.

  • Suggested answer
    Paras mehan Profile Picture
    Paras mehan 3,518 on at

    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

    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

    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

    OK Thanks

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans