Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Inventory value as per...
Microsoft Dynamics NAV (Archived)

Inventory value as per inv. valuation - cost spec and general ledger

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi,

I try to match inventory value between "general ledger account" of inventory and nav report "inv. valuation - cost spec", however there always have different exist.

Is that affected by decimal places setting?

Some user share need to set 5 decimal places under "general ledger setup" which was NAV default setting, once i set it, the unit cost can't control to 2 decimal places under all of currencies and inventory value will affected by rounding.

Tried to set item A inventory in qty 100 and inventory out partially, at the end of inventory qty was 0 and negative value.

Any method to handle above situation?

Thanks for your kindly reply.

Wade Bergman.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Inventory value as per inv. valuation - cost spec and general ledger

    thanks for reply.

    small different, but the mainly concern is why there have different, and after year and year like showball effect.

    May i verify that, all inventory value post to general ledger entries should be come from inventory, after Adjust Cost Item Entries, the exchange and rounding problem should be settle, right?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Inventory value as per inv. valuation - cost spec and general ledger

    What is the value difference between G/L Account & Inventory Value? Is it small or large?

    Any JVs being posted directly in Inventory G/L Account?

    What if you run the report as on date, is it still showing any difference?

    Have you run Adjust Cost Item Entries Batch Job and checked the result?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Inventory value as per inv. valuation - cost spec and general ledger

    Thanks for reply.

    Yes, expected cost posting to G/L is enabled.

    we using FIFO cost method

  • Ishan Profile Picture
    Ishan 1,285 on at
    RE: Inventory value as per inv. valuation - cost spec and general ledger

    Hi..

    Which costing method area you using?

    In Inventory setup Expected Cost Posting to G/L is enabled?

    Regards,

    Ishan Patel

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans