web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

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

(2) ShareShare
ReportReport
Posted on by 42
Hi All,
 
User is getting the following 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.

Contact your system administrator.

Tables can be marked as inconsistent during comprehensive tasks, such as
posting. This prevents data from being updated incorrectly."
 
when running "Exchange Rates Adjustment" for specific Vendor Posting Group.
 
This error appeared after activating "G/L Revaluation" feature from feature management.
 
User has calculated and posted Exchange Rate Adjustment for periods before the activation.
 
I uninstalled all Customisations and still the same error
 
Anyone having this Error after activating the new feature?   
I have the same question (0)
  • Suggested answer
    OussamaSabbouh Profile Picture
    12,340 Super User 2026 Season 1 on at
    Hello,
    This is caused by enabling the new G/L Revaluation / Exchange Rate Adjustment feature on top of already adjusted data, which changes the posting logic and can trigger a CONSISTENT error when BC detects conflicts in G/L entries (data integrity check)—especially when running the job with filters like Vendor Posting Group; typically resolved by running the adjustment without filters, identifying problematic entries via preview, or reprocessing from a clean state (e.g., reversing prior adjustments if possible), otherwise it may require Microsoft support since it’s a system-level consistency safeguard.
    Regards,
    Oussama Sabbouh

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,744 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,068 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 596 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans