Sometimes it happens that the payment receipt open item gets matched in Sage X3 but if you will check in the Accounting task you will find matching is 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 the 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 the below screenshot for the details.
To release those on hold journals we can follow the below steps.
- Go to the accounting task i.e. VALPCE function you can follow the below path to open the 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. Users need to wait until the status changes to Inactive.
- Now user needs to update the criteria transaction and to do the same open GESAMI function i.e. database mass update function. Users need to update transactions with the below criteria:
- First, choose a short code (ZMTC) and description (re-launch matching on hold)
- On the 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 screenshot 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.