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

Inconsistencies error in the G/L Entry table

(0) ShareShare
ReportReport
Posted on by O3I 34

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
    S.Kawamura Profile Picture
    S.Kawamura 1,520 on at
    RE: Inconsistencies error in the G/L Entry table

    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
    YUN ZHU Profile Picture
    YUN ZHU 78,729 Super User 2025 Season 1 on at
    RE: Inconsistencies error in the G/L Entry table

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

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,435 on at
    RE: Inconsistencies error in the G/L Entry table

    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

  • Inge M. Bruvik Profile Picture
    Inge M. Bruvik 999 Moderator on at
    RE: Inconsistencies error in the G/L Entry table

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

  • O3I Profile Picture
    O3I 34 on at
    RE: Inconsistencies error in the G/L Entry table

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

  • O3I Profile Picture
    O3I 34 on at
    RE: Inconsistencies error in the G/L Entry table

    No customizations that effect standard posting routines.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 999 Moderator on at
    RE: Inconsistencies error in the G/L Entry table

    Any customizations in your tenant ?

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

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,884 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,748 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans