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 / Small and medium business | Business Central, N... / Inventory G/L reconcil...
Small and medium business | Business Central, N...
Unanswered

Inventory G/L reconciliation differences

(0) ShareShare
ReportReport
Posted on by BC2021

Hi,

    I have ran the above report after posting only a purchase invoice for £10, standard cost £7:

pastedimage1639423323256v1.png

GL entries posted are:

pastedimage1639423437157v2.png

I can see the £10 has been posted to the GL so I'm confused as to why the GL total on the report is zero.

Also after posting an assembly order there is a difference.  I've checked the GL entries and they are all correct so not sure why there is a difference?

pastedimage1639423664774v3.png

The difference is due to the resources, 3 resource lines x 3 = £23.17.  The £46.34 is £23.17 x 2 but the first line on screenshot below is for the BOM.

pastedimage1639423902759v4.png

I have checked the Inventory posting setup accounts are all balance sheet and they are also not included in the General posting setup.  I've also ran the Adjust cost - item entries but there was nothing to post so this can't be the reason for the differences.

Any help would be appreciated.

I have the same question (0)
  • Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,105 Moderator on at

    I am not sure i was able to follow you.

    Where do you see that the G/L total is zero?

  • BC2021 Profile Picture
    BC2021 on at

    Hi,

        Thanks for replying.  On the first screenshot the row labelled Direct cost applied Total is -£10 but the G/L total is blank giving a difference of £10. 

    Thanks.

  • Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,105 Moderator on at

    I can see there us a warning on that line. What is the complete message of that warning?

  • BC2021 Profile Picture
    BC2021 on at

    Hi Inge, the message is "There is a discrepancy between the posting date of the value entry and the associated G/L entry within the reporting period."  I thought it might be because I had not closed previous inventory periods so I did that and posted another invoice but the result was still the same.

    On the general posting setup I have purchase account and direct cost applied account going to a cost P&L account.

    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 > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,143

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans