Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Business Central forum

Programming bug

(0) ShareShare
ReportReport
Posted on by 645

I am receiving the "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, (etc., etc.)" error when posting a partial receipt on a P.O. within the Purchase Order screen.  There is nothing particularly complex about this P.O., or the receipt.  I've deleted the P.O. and re-entered it.  I still get the same error when I try to post the receipt and invoice.  One of the line items on the P.O. has a "Direct Unit cost Excl. Tax" of 0.165, but I am not posting any receipts against that particular line item.  In any event, this shouldn't be too complex for Financials to handle.

I've researched the error message online, and all of the postings reference code bugs that would cause (or allow) a rounding error.  The error would result in the G/L debit not being exactly equal to the G/L credit.

Since we (i.e. users) don't actually have access to the program source code modules in Financials, I believe this is an error in Microsoft's programming.  This particular client has no third-party extensions that affect inventory or purchasing.

PO-Error.png

Categories:
  • Verified answer
    Dave Boehm Profile Picture
    645 on at
    RE: Programming bug

    Thanks for your prompt reply Tammy.

    This turned out to be an issue with the General Posting setup.  The error messages addressed the symptoms, but not the root cause.  I've think I've got them taken care of, now.

  • Tammy Torgerson Profile Picture
    on at
    RE: Programming bug

    Hi David,

    Thank you for reaching out on this error. I am working to reproduce this error, but have not been able to do so yet. I have a few more questions on this Purchase Order which returns the error for you:

    1. It appears that you are also attempting to receive the 2nd line. What quantity are you attempting to receive for that line?

    2. After you click Post are you choosing Receive or Receive and Invoice?

    3. I don't see any taxes or discounts on this Purchase Order. Can you please confirm that we have neither?

    4. If you click on the Actions tab in the ribbon and then click on the Preview Posting button, do you have the same error returned? Or are you able to drill down on the G/L Entries to see if any clues can be obtained?

    Finally, do you have any other Purchase Orders returning this error?

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central forum

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans