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)

Sort by

Suggested answer

YUN ZHU 100,212 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

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 5,168 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

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,173 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

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,962 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

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,306 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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 9,097 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

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 9,116 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
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