Small and medium business | Business Central, N...

Inconsistencies error in the G/L Entry table

(9) Share

Report

Posted on by O3I

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

I have the same question (4)

All responses (12)

Answers (0)

Suggested answer

Inge M. Bruvik 1,153 Moderator on at

Like (0)

Report
Copy link

Link copied!

Any customizations in your tenant ?

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

Was this reply helpful? Yes No
O3I 78 on at

Like (0)

Report
Copy link

Link copied!

No customizations that effect standard posting routines.

Was this reply helpful? Yes No
O3I 78 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Inge M. Bruvik 1,153 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

MahGah 15,565 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 97,673 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

S.Kawamura 1,532 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Aman Kakkar 2,946 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

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.

You can check this post for more information - Inconsistencies error in the G/L Entry table - Business Central/NAV / Developers Forum - Dynamics User Group

Hope this helps.

Aman K

Was this reply helpful? Yes No
Suggested answer

Dhiren Nagar 2,254 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

TarikJerkovich 293 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No