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.
About Us
Greytrix – a globally recognized and one of the oldest Sage Development Partners is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience and expertise, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development, and implementation competence.
Greytrix has some unique integration solutions developed for Sage CRM with Sage ERPs namely Sage X3, Sage Intacct, Sage 100, Sage 500, and Sage 300. We also offer best-in-class Sage ERP and Sage CRM customization and development services to Business Partners, End Users, and Sage PSG worldwide. Greytrix helps in the migration of Sage CRM from Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes addons like Greytrix Business Manager, Sage CRM Project Manager, Sage CRM Resource Planner, Sage CRM Contract Manager, Sage CRM Event Manager, Sage CRM Budget Planner, Gmail Integration, Sage CRM Mobile Service Signature, Sage CRM CTI Framework.
Greytrix is a recognized Sage Champion Partner for GUMU™ Sage X3 – Sage CRM integration listed on Sage Marketplace and Sage CRM – Sage Intacct integration listed on Sage Intacct Marketplace. The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for the processing and execution of application programs at the click of a button.
For more information on our integration solutions, please contact us at sage@greytrix.com. We will be glad to assist you.
