Sage X3 uses an automatic matching process when posting open items which are applied to other open items. For example a payment made for some invoices is posted. During this posting process the details are loaded into a temporary table called MTCBATCH. Within this table the documents are matched together, open item entries are marked as closed, and the entries are then cleared from the MTCBATCH table.
Clearing this field is a manual process. The steps below shows us how to create a query tool to view the suspended matching items and how to clear them from the MTCBATCH table in sage X3.
The first thing to check is to make sure the accounting tasks are running. After you have verified that everything is running proceed with the next steps.
Creating a Query tool to Identify the Incomplete Records.
- Go to Setup > Usage > Reports > Query Tool
- Create a new Query like below. Make sure to add the link expression formula: [F:DAE]DAE2 = [F:MTB]ACCNUM
3. Validate and run the query.
You can see two sets of matching that failed. We can go to manual matching to view the entries and complete the matching as needed.
Completing the matching using manual matching
- Go to Financials > Matching > Manual matching
- Complete the matching process if needed.
REMOVE THE ENTRIES FROM THE SUSPENDED MATCHING TABLE-
(A user with administrative permissions may be required for this process)
- Go to Development > Utilities > Maintenances > In lines
- Enter MTCBATCH in the ‘Table’ field
- Click ‘OK’
- Click on ‘Selection…’ from the list on the right
- Enter the Match number (MTCNUM) from the query tool results
- Click ‘OK’
Click the delete icon from the list on the right
Click ‘Yes’
Click the scroll arrow to move to the next record with the same MTCNUM
Delete any remaining records
Go to Accounting Tasks and review the Matching field. Confirm that it says ‘0’.
About Us
Greytrix – a globally recognized Premier Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation expertise.
Greytrix caters to a wide range of Sage X3 (Sage Enterprise Management) offerings – a Sage Business Cloud Solution. Our unique GUMU™ integrations include Sage X3 for Sage CRM, Salesforce.com and Magento eCommerce along with Implementation and Technical Support worldwide for Sage X3 (Sage Enterprise Management). Currently we are Sage X3 Implementation Partner in East Africa, Middles East, Australia, Asia. We also offer best-in-class Sage X3 customization and development services, integrated applications such as POS | WMS | Payment Gateway | Shipping System | Business Intelligence | eCommerce and have developed add-ons such as Catch – Weight and Letter of Credit for Sage X3 to Sage business partners, end users and Sage PSG worldwide.
Greytrix is a recognized Sage Rockstar ISV Partner for GUMU™ Sage X3 – Sage CRM integration also listed on Sage Marketplace; GUMU™ integration for Sage X3 – Salesforce is a 5-star app listed on Salesforce AppExchange.
For more information on Sage X3 Integration and Services, please contact us at x3@greytrix.com. We will be glad to assist you.