News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... The transaction cannot...

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

Unanswered

The transaction cannot be completed because it will cause inconsistencies in the G/L Entry table

(1) Share

Report

Report

Posted on by DT-16050930-0

24

Full error message:

"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. Contact your system administrator. Tables can be marked as inconsistent during comprehensive tasks, such as posting. This prevents data from being updated incorrectly."

Vat Period was closed and attempted to run the "Calc and Post" Vat Settlement function. Is this because the period was closed?

Any ideas on how to resolve?

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

gdrenteria 12,929 Most Valuable Professional on at

Like (2)

Report

The transaction cannot be completed because it will cause inconsistencies in the G/L Entry table

Hi

As our colleague Yun indicates, this message is almost always related to some customization that affects the generation of accounting entries.

Record.Consistent(Boolean) Method - Business Central | Microsoft Learn

Capturing Inconsistent Transactions (AL Language) – Listening to The Echo (wordpress.com)

best

GR
Suggested answer

YUN ZHU 75,673 Super User 2024 Season 2 on at

Like (2)

Report

The transaction cannot be completed because it will cause inconsistencies in the G/L Entry table

This doesn't look like a standard issue. Is there any special customization added?
I suggest asking the developer to debug it.

Thanks

ZHU
Suggested answer

Khushbu Rajvi. 5,947 Moderator on at

Like (1)

Report

The transaction cannot be completed because it will cause inconsistencies in the G/L Entry table

Hope you will get some hint:

https://community.dynamics.com/forums/thread/details/?threadid=c7deeea1-607e-45e6-854a-bb823cb86cc1

https://support.microsoft.com/en-us/topic/-the-transaction-cannot-be-completed-because-it-will-cause-inconsistencies-in-the-g-l-entry-table-error-message-when-you-post-a-sales-invoice-a-purchase-invoice-or-a-service-invoice-that-uses-100-percentage-line-discount-in-microsoft-dynamics-nav-2009-cb1333d2-3c7b-762c-61c9-1d174545b796

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,661 Super User 2024 Season 2

#2

Martin Dráb 230,379 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans