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

Notifications

Announcements

Community site session details

Community site session details

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

Journal Posting Error: CONSISTENT Function Causing G/L Entry Inconsistency

(0) ShareShare
ReportReport
Posted on by 12

Hi All,

I need some help understanding and resolving an error I’m encountering. The issue only occurs when I try to post a journal transaction. However, when I use Preview Posting, everything looks fine and the journal entries are displayed correctly.

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.

This makes the situation a bit confusing, as there doesn’t seem to be any issue during the preview stage. Any insights or suggestions on what might be causing this would be greatly appreciated.

Thank you in advance for your help.

Best regards,
Alexander Adinata

Screenshot 2026-01-21 101956.png
I have the same question (0)
  • Suggested answer
    KasparsSemjonovs Profile Picture
    4,798 Super User 2025 Season 2 on at
    This error happens in some specific calculations/cases. Only way to solve it is to try to make the posting in a different way.
    Most likely in the line You have the account, balancing account and application link set. 
    What You can try is:
    1) Remove the application and post the journal line. Then do the application from Ledger entries
    2) Remove the Bal.Account No. from the line and create a second line with the opposite amount.
    3) as last resort is you can try to decrease/increase the amount by 0.01 and add additional line of this 0.01 with the same document number (might not be possible if the document type is invoice)

    Hope You manage to post it!
  • Suggested answer
    Pallavi Phade Profile Picture
    4,644 on at
    Namaste @CU29041010-0
     
    This bug occurs when debit and credit amount is not matching . In NAV version , we used to do commit transaction for gl entry to know what is calculating or entries getting generated  at the run tme But this i would not recommend as might be production issue . IF there is difference in 0.01 then also it will give error . Can you check any additonal entries or any roudning precision set in General LEdger Setup or any payment tolerance 
     
     
    Warm Regards
    Pallavi Phade 
    www.linkedin.com/in/pallaviphade131116
  • CU29041010-0 Profile Picture
    12 on at
    I tried to re-enter the journal, but it did not work.
    It's related to Payment and Cash Receipt Journal for foreign currency.
  • Alex A Profile Picture
    2,929 on at
    Try deleting the line and enter it again anew..?
    Which journal is it?

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

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,472

#2
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 742 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 684 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans