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) / INVENTORY VALUATION VS...
Microsoft Dynamics NAV (Archived)

INVENTORY VALUATION VS GL BALANCE BY DIMENSION

(0) ShareShare
ReportReport
Posted on by algeloca 160

Hi All,

In my understanding, inventory valuation report and GL balance by dimension will have different values because un-invoiced purchase and sales orders with items that have been received or shipped will appear in the Inventory Valuation report but will not be posted to the general ledger. 

Any reply will be appreciated.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,096 on at

    They might give you different values, as the real cost of the item might not be yet invoiced, and there would be no cost, posted to GL. There might be still expected cost when you receive the items.

  • algeloca Profile Picture
    algeloca 160 on at

    I generated these two reports as of December 2015 with amount differences in total. I want to know what are the reasons why there are differences.

  • Alexander Ermakov Profile Picture
    Alexander Ermakov 28,096 on at

    There is Cost posted to GL field in the report - does this differs from GL Balance?

  • algeloca Profile Picture
    algeloca 160 on at

    Yes, cost posted to GL and GL balance have amount difference.

  • Verified answer
    Jens Glathe Profile Picture
    Jens Glathe 6,092 on at

    Hi Angelito,

    there could be several reasons. In the order from "most probably" to "exotic":

    1. You don't post expected cost to the G/L. This would be in the inventory setup, "Expected Cost". In this case Alexander's assumption is the same.

    2. You don't have "Automatic Cost posting" enabled, and some value entries are not yet posted to the G/L.

    3. "Adjust Cost - Item Entries" hasn't been run before posting to the G/L.

    4. You report a value to date, but you have applications over this date border (and on the wrong side). Meaning for example, the shipment has been posted with your date range, but not the invoice (and vice versa).

    5. Real bugs, like broken item ledger applications (it happens).

    And one last question: Is Valuation posted to G/L + Amount Received not Invoiced  + Amount Shipped not Invoiced the same as Inventory Value? If yes, then all is fine. Or a bug would be even more exotic.

    with best regards

    Jens

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