News and Announcements icon

Dynamics 365 CommunityForums Business Central forum The transaction cannot...

Business Central forum

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

22

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?

Categories:

Financial Management

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

gdrenteria 8,339 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

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 68,142 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. 1,382 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

News and Announcements

New Dynamics 365 Community Call! (ERP Edition)

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,142 Super User 2024 Season 2

#2

Martin Dráb 227,979 Super User 2024 Season 2

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans