web
You’re offline. This is a read only version of the page.
close
Skip to main content

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)
  • IB-29041624-0 Profile Picture
    IB-29041624-0 1,177 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.

  • IB-29041624-0 Profile Picture
    IB-29041624-0 1,177 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,059 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 994 Super User 2026 Season 1

#3
Teagen Boll Profile Picture

Teagen Boll 664 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans