Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Microsoft Dynamics NAV...
Small and medium business | Business Central, N...
Suggested answer

Microsoft Dynamics NAV - Inventory cost posting to GL but not to Item Ledger

(0) ShareShare
ReportReport
Posted on by KJones280481 5

Hi

We have a problem where a number of the Inventory general ledger codes don't match with the corresponding Item Category Code value showing on an Inventory Valuation Report. The GL is driven by purchases and consumption so it's proving extremely difficult to reconcile and find where the problem lies. There are no other entries in the GL apart from postings with source code 'INVTPCOST' - so it is not manual journal postings that are causing the issue.

One thing that we have spotted is that, on some entries, when you look into the detail of the RPO consumption and the list of entries that make up that RPO - there are item no's in that list that have values in the 'Cost Posted to G/L' column and values in the 'Item Ledger Entry Quantity Column'. However there are some entries that have a value in the cost posted to G/L column but no value in the Item Ledger Entry Quantity column - and the 'Adjustment' box is ticked. On the assumption that the Inventory Valuation Report is driven by the Item Ledger, then the fact that there is an entry in the GL column but not in the item ledger entry column would cause the inventory to show as out of balance. Below is an example of this - the 2 lines highlighted in green have a cost posted to the GL but no entry in the item ledger column and both have 'Yes' in the Adjustment column.

pastedimage1643292282480v1.png

Does anybody have any experience of this themselves or have any suggestions of how we can tackle this??

Any help would be greatly appreciated!

Many thanks

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Microsoft Dynamics NAV - Inventory cost posting to GL but not to Item Ledger

    Hello,

    Depending on the transaction line sometimes the Output Entry, like the first row, shows Quantity and Expected Cost. On the 11th row the Expected is reversed because the Actual is reflected and posted. The Quantity did not change from the 1st entry so no quantity entry is need to adjust the original.

    As for the 2 highlighted rows, with the Adjustment = YES flagged, I would want to look at the Item Card and its related Cost to determine if the Item has a unit cost of 0.00. Can you check the Item Unit Cost and Value Entries associated with the Item for .01 and 1.04.

    I will also offer if you want to do a review over Teams, feel free to reach out and I will send an invite and we can review together.

    Thanks,

    Steve

  • KJones280481 Profile Picture
    KJones280481 5 on at
    RE: Microsoft Dynamics NAV - Inventory cost posting to GL but not to Item Ledger

    Hi Steve

    Thanks for clarifying - so with this being the case are there any other steps you would recommend to follow as your first reply was if this was set to False, or do the same instructions still apply?

    Many thanks

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Microsoft Dynamics NAV - Inventory cost posting to GL but not to Item Ledger

    Hello,

    Yes, if checked this means TRUE.

    Thanks,

    Steve

  • KJones280481 Profile Picture
    KJones280481 5 on at
    RE: Microsoft Dynamics NAV - Inventory cost posting to GL but not to Item Ledger

    Hi Steve

    Thanks for your reply

    On the Inventory Setup - the box next to Automatic Cost Posting is ticked - I assume this means TRUE is that correct?

    Thanks

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Microsoft Dynamics NAV - Inventory cost posting to GL but not to Item Ledger

    KJones,

    Lets check a few setups:

    On the Inventory Setup, do you show Automatic Cost Posting = TRUE or FALSE?

    If am guessing you will say FALSE. If this is correct, you need to run either daily, weekly, and at a minimum, at month-end the routine called Adjust Cost-Item Entries. You can search for this. The pop-up has a Post to G/L flag so set this to TRUE. If you forget, I always teach my customer to run after that completes the Post Inventory Cost to G/L report. This will post the entries to the GL.

    Look and follow what I wrote and you will see the entries.

    Thanks,

    Steve

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans