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

"Inconsistencies in the G/L Entry table" error.

(4) Share

Report

Posted on by DannyR

123

Hi Guru,

After version 26.0 updated, I have sales order posting issued as follows. I already checked the records which in the G/L ledger entries but couldn't find any unmatched data. Please let me how I can fix this issue.

Currently, I have working with Business Central online version26.0.

Thank you for your kind attentions.

Danny

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (2)

Report

This looks like a customization issue.
I suggest you ask the developer to debug it first, the reason is as mentioned in the error message. It is caused by the consistent function.

Hope this can give you some hints.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Andrés Arias 4,190 Super User 2025 Season 2 on at

Like (3)

Report

Hello,

The mentioned error refers to a Consistent, I would recommend to check some customization or development that affects the standard operation.

I hope I can help.

Regards,

Andres

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,148 Super User 2025 Season 2 on at

Like (3)

Report

This seems to be an issue caused by your custom extension, which is triggering the error. It is highly recommended to contact your Microsoft partner to review and resolve it.

✅ Mark this answer as verified if it helps you.

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,639 Super User 2025 Season 2 on at

Like (2)

Report

Hello,

Please check any Rounding Effect is not affected to Post the Sales Transaction.

Because Inconsistency error arise when Debit Amount and Credit Amount must not be same.

Or else you can check the Customization or Developments.

Was this reply helpful? Yes No
Suggested answer

Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

Like (2)

Report

There could be a modification to the standard posting that cause the GL Entry to be inconsistent.

Please ask your partner to debug for you.

Was this reply helpful? Yes No
DannyR 123 on at

Like (1)

Report

Thank you for replied all Gurus.

About this issue, if I have tried the "Preview Posting" then all related posting is no error but make "Posting" then error happened.

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,637 Super User 2025 Season 2 on at

Like (2)

Report

Do you have any custom codes working on top?

First attempt I would have given in uninstalling all custom extensions and then check.

Was this reply helpful? Yes No
Suggested answer

Jeffrey Bulanadi 8,760 on at

Like (1)

Report
Hi DannyR,

I totally get how frustrating the “Inconsistencies in the G/L Entry table” error can be, especially after the BC 26.0 update. It’s a tricky one since it rarely tells you where the issue is.

To help with that, I built a small Business Central extension that tracks G/L entries in real time during posting. It pinpoints the exact entries causing the error — super handy for diagnosing the problem.

Here’s how you can use it:

Install the extension in your BC environment

Go to “Review G/L Inconsistencies”

Click “Start Tracking”

Try posting the sales order again

The tool will log the inconsistent G/L entries so you can check what’s off

Some typical causes in BC 26.0 include rounding issues in multi-currency, unbalanced custom posts, dimensions, or VAT glitches.

You can find the extension here:
GL Inconsistency Error Solution on GitHub

If you find it helpful, feel free to mark it as a suggested answer!

Cheers,
Jeffrey

Was this reply helpful? Yes No