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

Inconsistencies error in the G/L Entry table

(0) 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 (0)

All responses (7)

Answers (0)

Suggested answer

Inge M. Bruvik 1,077 Moderator on at

Like (0)

Report

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?

Was this reply helpful? Yes No
O3I 60 on at

Like (0)

Report

RE: Inconsistencies error in the G/L Entry table

No customizations that effect standard posting routines.

Was this reply helpful? Yes No
O3I 60 on at

Like (0)

Report

RE: Inconsistencies error in the G/L Entry table

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

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

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

MahGah 15,529 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 94,484 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

S.Kawamura 1,530 on at

Like (0)

Report

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

Was this reply helpful? Yes No