Some times it is happened that payment receipt open item getting matched in Sage X3 but if you will check in the Accounting task you will find matching are on hold even if the Accounting task is active.
In this blog we will see how to resolve this matching on hold error.
There are several times when user has posted any Invoice, Receipt or Payment and is not able to find the journal entry regarding the same, though the transaction is marked as validated as well as the Accounting task is in active state. See below screenshot for the details.
To release that on hold journals we can follow below steps.
- Go to the accounting task i.e. VALPCE function you can follow below path to open accounting task:
Usage >> Accounting Task
- Once you open the accounting task screen you need to first Inactivate the accounting task and need to stop the process. User need to wait until the status change to Inactive.
- Now user need to update the criteria transaction and to do the same open GESAMI function i.e. database mass update function. User need to update transaction with below criteria:
- First choose a short code (ZMTC) and description (re-launch matching on hold)
- On general tab select Module as a “Financial” module
- Select Table = MTCBATCH
- In a detail tab user need to set the “Update” grid with the details below
- Set Transaction = Modifications
- Field = MTCFLG
- Formula = 1
Check below screen shot for the details.
4. After entering the above details user need to create and validate the transaction.
5. Then user need to execute the transaction.
Note: user first need to execute the transaction with test mode and if the test mode is successfully completed then user can run the real update.
6. Once the update is completed from the GESAMI function user can go back to the Accounting task screen
7. Now user can Activate the accounting task and click on update button until the task gets active.
8. Here user can check that number of matching will get decrease from the accounting task. See below screenshot.
This is how user can release the on-hold journals from the accounting task which are already matched but still pending in accounting task.