How to resolve “Due date being paid INVXXX” error while using the manual matching function

Described further are the steps that you need to take to resolve the “Due date being paid INVXXX” error message when using the manual matching function

Some important pointers

Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions. If necessary, seek the assistance of a qualified Sage business partner, network administrator, or Sage customer support analyst. Before you undertake any of the following steps please make sure you have all the necessary back ups in place. Make a list before you start, if there is anything that you aren’t sure of, please contact us.

Please take a note, steps listed ahead require knowledge of database engines and application databases (DBs) such as Microsoft/Transact SQL, Pervasive SQL, or MySQL, etc. Incorrect application of these steps may result in system breakages and Evomatiq Business Solutions assumes no responsibility for errors resulting from changes to the database engine or DBs. Before making changes, backup all system and application DBs required for a full restore.

If you are unsure of anything, contact support for assistance

Resolution

  1. Go to DEVELOPMENT, UTILITIES, MAINTENANCE, IN LINES (GMAINT)

  2. When prompted for table, type GACCDUDATE in the table field and click on OK.

  3. From the right menu, CLICK on SELECTION.

  4. Enter NUM=’XXXXX’ (where xxxx is the invoice number, payment/receipt number)

  5. Verify you are on the correct line by comparing the value. If you are not on the correct line, use the arrows at the top left to change

  6. Delete the values in the fields TMPCUR, TMPLOC, and If using v1.4 or v5, TMPRPT
    Note: Do this for each of the lines of the NUM the by clicking on the Next radio button at the top of the screen.

  7. Verify that the FLGCLE field has a 1 in it. If not, change it to a 1.

  8. Try again, the issue should now be resolved.