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... / Inconsistencies error ...
Small and medium business | Business Central, N...
Suggested Answer

Inconsistencies error in the G/L Entry table

(9) ShareShare
ReportReport
Posted on by O3I 86

Hi BC Gurus,

I'm running into an issue when trying to post a service invoice. 

When trying to post we get the error "The transaction cannot be completed because it will cause inconsistencies in the G/L Entry table. Check where and how the CONSISTENT function is used in the transaction to find the reason for the error.

This error only happens for certain customers and does not affect all of them. We also noticed that on the preview posting page, the G/L entries do not zero out. 

Any clues why this error happens to certain customers? 

Categories:
Dynamics 365 Business Central
  • Suggested answer
    IB-29041624-0 Profile Picture
    IB-29041624-0 1,191 Moderator on at

    Any customizations in your tenant ?

    It does not sound like this is using he standard posting routines?

  • O3I Profile Picture
    O3I 86 on at

    No customizations that effect standard posting routines.

  • O3I Profile Picture
    O3I 86 on at

    Also very odd that some customers work fine but others do not.

  • IB-29041624-0 Profile Picture
    IB-29041624-0 1,191 Moderator on at

    Could be some posting setup missing. But that usually results in another kind of error. Have you had your partner trying to debug it?

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,613 on at

    Hi

    Do you know if those customers have a different "VAT.Bus Posting group " than others?  or any discount that cause "rounding issue" like the price goes to 2.12345 but the rounding is 2.12?

    Also, as other suggested you can work with your partner on this. Below is an example how partner can help

    forum.mibuso.com/.../how-to-see-why-you-are-getting-consistency-error

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 103,085 Super User 2026 Season 2 on at

    Hi, If it is very difficult to find the reason, I recommend copying a new Sandbox environment and debugging it.

  • Suggested answer
    S.Kawamura Profile Picture
    S.Kawamura 1,532 on at

    I have faced the "Consistent" error a few times when using the service module.
    In my case, it was due to an inconsistency in the sales tax posting settings.

    Please try the following to identify the problem.
    1) Create a new service contract for the customer having the problem, and create and post a service invoice from the service contract.
    2) Create a new customer with exactly the same information as the customer with the problem, create a service contract, and then create and post a service invoice from the service contract.
    3) Compare the service ledger entries that are causing the problem with the service ledger entries created in 1) and 2).

    There should be a difference somewhere. In my case, it was the sales tax posting group. I am not sure clearly, but I remember it happened when I was using an annual prepaid service contract.

    I hope your problem will be solved.

    S.Kawamura

  • Suggested answer
    Aman Kakkar Profile Picture
    Aman Kakkar 3,597 Super User 2026 Season 1 on at
    Hi,
     
    What is the difference in the G/L Entries debit and credit? If it's close to 0.01 or 0.02 something, then it might be a rounding issue. Else it may be related to VAT or so.
     
     
    Hope this helps.
    Aman K
  • Suggested answer
    Dhiren Nagar Profile Picture
    Dhiren Nagar 2,890 Super User 2026 Season 2 on at
    Hi @O3I,
     
    During preview posting you can check if the G/L entries total is coming down to zero or not. If not find which entry is misleading and that is your clue to solve the issue.
     
    If possible add the screenshot of the G/L entries view showing dates, G/L Account No., G/L Account name, Amount, transaction no columns. That will help us analyze the issue and give suggestion.
     
    Regards,
    Dhiren.
  • Suggested answer
    TarikJerkovic Profile Picture
    TarikJerkovic 354 on at
    Hi @O3I 
     
    Check if you have enable this field Check Source Curr. Consistency  General Ledger Setup:
     
    I have same issue on posting Purchase Order when this field is enable (true) - also this is error message is bug with source curr in g l from version 27.0

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 715 Super User 2026 Season 2

#2
AndrewThomas81 Profile Picture

AndrewThomas81 390 Super User 2026 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 386 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans