Due date being paid error

SOLVED

We are getting the following error "Due date being paid" when we try and match 2 entries in Sage X3 version 6.5 Patch 30.

The customer in question has  a Bill-To and a different Pay-To and we are now trying match the Invoice Transaction to the GL Transaction that was automatically generated by X3 when the Bill To Customer paid.

Any Ideas why we would be getting this error and how can we resolve.

Parents Reply Children
  • 0 in reply to Shereef

    To search the knowledgebase:

    1. Go to https://support.na.sage.com/
    2. In the top right corner, click on Log on
    3. Select Log on for downloads and personalized content
    4. Enter the email address and password that you have registered with Note: The assumption is that the account that you are registered with has Sage X3 as a registered product.
    5. Click Log on Note: The top right corner will not say Welcome <Your name>
    6. In the Search the knowledgebase box, type 16941 and press ENTER
    7. You will see a result that you can click on

    The resolution from this article is below. However there is an attached document in the knowledgebase that is too large for this post.

    Cause

    There may be erroneous amounts in the TMP* fields of the GACCDUDATE record  


    Resolution
    • Perform an Accounting Cancellation on the payment then re-post the payment
    • If this is for a credit memo rather than a payment, clear the tmp fields on both the invoice and the credit memo.
    • If the issue persists, perform an Accounting Cancellation, delete the payment, re-enter then repost the payment
    • Additional resolutions are available in the attached document

    Additional information:

    Check the auto journal PRINC,which is used when posting payments, Line 10.

    1. Setup, Financials, Accounting interface, Automatic journals (GESGAU)
    2. Select PRINCfrom left list.
    3. Select Linesbutton.
    4. Select Line number 10
    5. Make sure the Debit-credit compensation is checked. In standard X3 this is checked.