{"id":19509,"date":"2024-04-04T11:35:15","date_gmt":"2024-04-04T11:35:15","guid":{"rendered":"https:\/\/www.greytrix.com\/middle-east\/?p=19509"},"modified":"2026-02-04T12:16:03","modified_gmt":"2026-02-04T12:16:03","slug":"how-to-match-open-items-in-sage-x3","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/middle-east\/how-to-match-open-items-in-sage-x3\/","title":{"rendered":"How to Match Open Items in Sage X3"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
<\/div>\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Sage X3 uses an automatic matching process when posting open items, which is applied to other open items. To illustrate, when a payment is made for certain invoices, the system follows a specific sequence of actions. It enters the relevant information into a temporary MTCBATCH table, matches the documents within it, flags open item entries as closed, and finally removes them from the table.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t

How to Match Open Items in Sage X3<\/h1>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"How_to_Match_Open_Items_in_Sage-X3\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

How to Match Open Items in Sage X3<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Sage X3 uses an automatic matching process when posting open items, which is applied to other open items. To illustrate, when a payment is made for certain invoices, the system follows a specific sequence of actions. It enters the relevant information into a temporary MTCBATCH table, matches the documents within it, flags open item entries as closed, and finally removes them from the table.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

A) Accounting task<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"how\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\tClearing this field is a manual process. The steps below show 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.\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\tThe 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.\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\tB) Creating a Query tool to Identify the Incomplete Records.<\/strong>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
  1. Go to Setup > Usage > Reports > Query Tool<\/li><\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t
      \n \t
    1. Create a new Query like below. Make sure to add the link expression formula: [F: DAE] DAE2 = [F: MTB] ACCNUM<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"how\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t\t\t\t\t\t\t
        \n \t
      1. Validate and run the query.<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
        \n\t\t\t\t
        \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"how\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
        \n\t\t\t\t
        \n\t\t\t\t\t\t\t\t\tYou can see two sets of matching that failed. We can go to manual matching to view the entries and complete the matching as needed.\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
        \n\t\t\t\t
        \n\t\t\t\t\t\t\t\t\tC) Completing the matching using manual matching<\/strong>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
        \n\t\t\t\t
        \n\t\t\t\t\t\t\t\t\t
        1. Go to Financials > Matching > Manual matching<\/li><\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
          \n\t\t\t\t
          \n\t\t\t\t\t\t\t\t\t
            \n \t
          1. Complete the matching process if needed.<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
            \n\t\t\t\t
            \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"how\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
            \n\t\t\t\t
            \n\t\t\t\t\t\t\t\t\tD) REMOVE THE ENTRIES FROM THE SUSPENDED MATCHING TABLE –\n(A user with administrative permissions may be required for this process)\n<\/strong>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
            \n\t\t\t\t
            \n\t\t\t\t\t\t\t\t\t
            1. Go to Development > Utilities > Maintenances > In lines<\/li><\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
              \n\t\t\t\t
              \n\t\t\t\t\t\t\t\t\t
                \n \t
              1. Enter MTCBATCH in the \u2018Table\u2019 field<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
                \n\t\t\t\t
                \n\t\t\t\t\t\t\t\t\t
                  \n \t
                1. Click \u2018OK\u2019<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
                  \n\t\t\t\t
                  \n\t\t\t\t\t\t\t\t\t
                    \n \t
                  1. Click on \u2018Selection\u2026\u2019 from the list on the right<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
                    \n\t\t\t\t
                    \n\t\t\t\t\t\t\t\t\t
                      \n \t
                    1. Enter the Match number (MTCNUM) from the query tool results<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
                      \n\t\t\t\t
                      \n\t\t\t\t\t\t\t\t\t
                        \n \t
                      1. Click \u2018OK\u2019<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
                        \n\t\t\t\t
                        \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"how\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
                        \n\t\t\t\t
                        \n\t\t\t\t\t\t\t\t\tClick the delete icon from the list on the right. \t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
                        \n\t\t\t\t
                        \n\t\t\t\t\t\t\t\t\tClick \u2018Yes\u2019\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
                        \n\t\t\t\t
                        \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"how\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
                        \n\t\t\t\t
                        \n\t\t\t\t\t\t\t\t\tClick 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 \u20180\u2019.\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
                        \n\t\t\t\t
                        \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"how\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
                        \n\t\t\t\t
                        \n\t\t\t\t\t

                        About Us:<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
                        \n\t\t\t\t
                        \n\t\t\t\t\t\t\t\t\t

                        Greytrix Middle East<\/a> Subsidiary of Greytrix India Pvt Ltd, Headquartered in Mumbai. It is a leading Sage business partner and ISV Partner offering Consulting<\/a>, Implementation, and development services for Sage X3<\/a>, <\/strong>Sage 300 People (HRMS)<\/a>, and Sage Intacct, which covers Dubai, Saudi Arabia, and Qatar region.<\/p>

                        Our methodology involves a techno-functional expert team to analyze the client’s business processes, workflow, current system situation, and plans. Then, based on the analysis, we propose solutions that meet their requirement regarding the product consideration. In addition, we ensure to serve our clients with robust, future-proof, business-critical solutions that deliver best practices, processes, and functionality designed specifically for the business and its people.<\/p>

                        We offer professional services such as Implementation and Configuration<\/a>, Business Process Analysis, Project Management, Integrations and Migrations, and Technical & Functional Support, along with enhancements within Sage X3<\/a>,<\/strong> Sage 300 People (HRMS)<\/a>, and Sage Intacct across various industry verticals like Process Manufacturing (Food & Beverages, Chemical), Discrete manufacturing (Automotive, Textile & Apparel), Non-Profit, Health-care Industry and Services Industry (Financial, Software & Engineering), Distribution (Transportation & Logistics).<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

                        \n\t\t\t\t\t\t\t
                        <\/div>\n\t\t\t\t\t\t\t
                        \n\t\t\t\t\t
                        \n\t\t\t
                        \n\t\t\t\t\t\t
                        \n\t\t\t\t
                        \n\t\t\t\t\t

                        Our Partnerships<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
                        \n\t\t\t\t
                        \n\t\t\t\t\t\t\t
                        \n\t\t\t\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
                        \n\t\t\t\t\t\t
                        \n\t\t\t\t\t
                        \n\t\t\t
                        \n\t\t\t\t\t\t
                        \n\t\t\t\t
                        \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"Our\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

                        How to Match Open Items in Sage X3 How to Match Open Items in Sage X3 Sage X3 uses an automatic matching process when posting open items, which is applied to other open items. To illustrate, when a payment is made for certain invoices, the system follows a specific sequence of actions. It enters the …<\/p>\n

                        How to Match Open Items in Sage X3<\/span> Read More »<\/a><\/p>\n","protected":false},"author":1,"featured_media":19545,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"disabled","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-19509","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"yoast_head":"\nSteps to Match Open Items in Sage X3 ERP<\/title>\n<meta name=\"description\" content=\"Automate open item matching: load data into MTCBATCH, match entries, and then clear the table in Sage X3. Easily learn the process.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/middle-east\/how-to-match-open-items-in-sage-x3\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Steps to Match Open Items in Sage X3 ERP\" \/>\n<meta property=\"og:description\" content=\"Automate open item matching: load data into MTCBATCH, match entries, and then clear the table in Sage X3. Easily learn the process.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/middle-east\/how-to-match-open-items-in-sage-x3\/\" \/>\n<meta property=\"og:site_name\" content=\"Greytrix Middle East | Sage X3 Consulting | Implementation\" \/>\n<meta property=\"article:published_time\" content=\"2024-04-04T11:35:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-04T12:16:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/middle-east\/wp-content\/uploads\/2024\/04\/How_to_Match_Open_Items_in_Sage-X3.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"406\" \/>\n\t<meta property=\"og:image:height\" content=\"325\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"middleeastadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"middleeastadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.greytrix.com\/middle-east\/how-to-match-open-items-in-sage-x3\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/middle-east\/how-to-match-open-items-in-sage-x3\/\"},\"author\":{\"name\":\"middleeastadmin\",\"@id\":\"https:\/\/www.greytrix.com\/middle-east\/#\/schema\/person\/35ca38ced01f345c3029636a07a14159\"},\"headline\":\"How to Match Open Items in Sage X3\",\"datePublished\":\"2024-04-04T11:35:15+00:00\",\"dateModified\":\"2026-02-04T12:16:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/middle-east\/how-to-match-open-items-in-sage-x3\/\"},\"wordCount\":526,\"publisher\":{\"@id\":\"https:\/\/www.greytrix.com\/middle-east\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/middle-east\/how-to-match-open-items-in-sage-x3\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/middle-east\/wp-content\/uploads\/2024\/04\/How_to_Match_Open_Items_in_Sage-X3.webp\",\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/middle-east\/how-to-match-open-items-in-sage-x3\/\",\"url\":\"https:\/\/www.greytrix.com\/middle-east\/how-to-match-open-items-in-sage-x3\/\",\"name\":\"Steps to Match Open Items in Sage X3 ERP\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/middle-east\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/middle-east\/how-to-match-open-items-in-sage-x3\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/middle-east\/how-to-match-open-items-in-sage-x3\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/middle-east\/wp-content\/uploads\/2024\/04\/How_to_Match_Open_Items_in_Sage-X3.webp\",\"datePublished\":\"2024-04-04T11:35:15+00:00\",\"dateModified\":\"2026-02-04T12:16:03+00:00\",\"description\":\"Automate open item matching: load data into MTCBATCH, match entries, and then clear the table in Sage X3. Easily learn the process.\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/middle-east\/how-to-match-open-items-in-sage-x3\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/middle-east\/how-to-match-open-items-in-sage-x3\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/middle-east\/wp-content\/uploads\/2024\/04\/How_to_Match_Open_Items_in_Sage-X3.webp\",\"contentUrl\":\"https:\/\/www.greytrix.com\/middle-east\/wp-content\/uploads\/2024\/04\/How_to_Match_Open_Items_in_Sage-X3.webp\",\"width\":406,\"height\":325,\"caption\":\"How_to_Match_Open_Items_in_Sage-X3\"},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/middle-east\/#website\",\"url\":\"https:\/\/www.greytrix.com\/middle-east\/\",\"name\":\"Greytrix Middle East | Sage X3 Consulting | Implementation\",\"description\":\"Greytrix Middle East is the leading Sage partner for ERP & CRM software. Our software modules include all the essentials for simplifying your business capabilities like purchase, sales, people management, financial accounting, and inventory management.\",\"publisher\":{\"@id\":\"https:\/\/www.greytrix.com\/middle-east\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/middle-east\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.greytrix.com\/middle-east\/#organization\",\"name\":\"Greytrix Middle East | Sage X3 Consulting | Implementation\",\"url\":\"https:\/\/www.greytrix.com\/middle-east\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/middle-east\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.greytrix.com\/middle-east\/wp-content\/uploads\/2023\/01\/Header-logo-scaled.webp\",\"contentUrl\":\"https:\/\/www.greytrix.com\/middle-east\/wp-content\/uploads\/2023\/01\/Header-logo-scaled.webp\",\"width\":2560,\"height\":415,\"caption\":\"Greytrix Middle East | Sage X3 Consulting | Implementation\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/middle-east\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/middle-east\/#\/schema\/person\/35ca38ced01f345c3029636a07a14159\",\"name\":\"middleeastadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/middle-east\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/07b52eeb1ee8beb722fc7e5ce90006fc1c7ea2fc77901e6ba790bef6e37f000a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/07b52eeb1ee8beb722fc7e5ce90006fc1c7ea2fc77901e6ba790bef6e37f000a?s=96&d=mm&r=g\",\"caption\":\"middleeastadmin\"},\"sameAs\":[\"https:\/\/www.greytrix.com\/middle-east\/\"],\"url\":\"https:\/\/www.greytrix.com\/middle-east\/author\/middleeastadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Steps to Match Open Items in Sage X3 ERP","description":"Automate open item matching: load data into MTCBATCH, match entries, and then clear the table in Sage X3. Easily learn the process.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/middle-east\/how-to-match-open-items-in-sage-x3\/","og_locale":"en_US","og_type":"article","og_title":"Steps to Match Open Items in Sage X3 ERP","og_description":"Automate open item matching: load data into MTCBATCH, match entries, and then clear the table in Sage X3. Easily learn the process.","og_url":"https:\/\/www.greytrix.com\/middle-east\/how-to-match-open-items-in-sage-x3\/","og_site_name":"Greytrix Middle East | Sage X3 Consulting | Implementation","article_published_time":"2024-04-04T11:35:15+00:00","article_modified_time":"2026-02-04T12:16:03+00:00","og_image":[{"width":406,"height":325,"url":"https:\/\/www.greytrix.com\/middle-east\/wp-content\/uploads\/2024\/04\/How_to_Match_Open_Items_in_Sage-X3.webp","type":"image\/webp"}],"author":"middleeastadmin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"middleeastadmin","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.greytrix.com\/middle-east\/how-to-match-open-items-in-sage-x3\/#article","isPartOf":{"@id":"https:\/\/www.greytrix.com\/middle-east\/how-to-match-open-items-in-sage-x3\/"},"author":{"name":"middleeastadmin","@id":"https:\/\/www.greytrix.com\/middle-east\/#\/schema\/person\/35ca38ced01f345c3029636a07a14159"},"headline":"How to Match Open Items in Sage X3","datePublished":"2024-04-04T11:35:15+00:00","dateModified":"2026-02-04T12:16:03+00:00","mainEntityOfPage":{"@id":"https:\/\/www.greytrix.com\/middle-east\/how-to-match-open-items-in-sage-x3\/"},"wordCount":526,"publisher":{"@id":"https:\/\/www.greytrix.com\/middle-east\/#organization"},"image":{"@id":"https:\/\/www.greytrix.com\/middle-east\/how-to-match-open-items-in-sage-x3\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/middle-east\/wp-content\/uploads\/2024\/04\/How_to_Match_Open_Items_in_Sage-X3.webp","inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/middle-east\/how-to-match-open-items-in-sage-x3\/","url":"https:\/\/www.greytrix.com\/middle-east\/how-to-match-open-items-in-sage-x3\/","name":"Steps to Match Open Items in Sage X3 ERP","isPartOf":{"@id":"https:\/\/www.greytrix.com\/middle-east\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/middle-east\/how-to-match-open-items-in-sage-x3\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/middle-east\/how-to-match-open-items-in-sage-x3\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/middle-east\/wp-content\/uploads\/2024\/04\/How_to_Match_Open_Items_in_Sage-X3.webp","datePublished":"2024-04-04T11:35:15+00:00","dateModified":"2026-02-04T12:16:03+00:00","description":"Automate open item matching: load data into MTCBATCH, match entries, and then clear the table in Sage X3. Easily learn the process.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/middle-east\/how-to-match-open-items-in-sage-x3\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/middle-east\/how-to-match-open-items-in-sage-x3\/#primaryimage","url":"https:\/\/www.greytrix.com\/middle-east\/wp-content\/uploads\/2024\/04\/How_to_Match_Open_Items_in_Sage-X3.webp","contentUrl":"https:\/\/www.greytrix.com\/middle-east\/wp-content\/uploads\/2024\/04\/How_to_Match_Open_Items_in_Sage-X3.webp","width":406,"height":325,"caption":"How_to_Match_Open_Items_in_Sage-X3"},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/middle-east\/#website","url":"https:\/\/www.greytrix.com\/middle-east\/","name":"Greytrix Middle East | Sage X3 Consulting | Implementation","description":"Greytrix Middle East is the leading Sage partner for ERP & CRM software. Our software modules include all the essentials for simplifying your business capabilities like purchase, sales, people management, financial accounting, and inventory management.","publisher":{"@id":"https:\/\/www.greytrix.com\/middle-east\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/middle-east\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.greytrix.com\/middle-east\/#organization","name":"Greytrix Middle East | Sage X3 Consulting | Implementation","url":"https:\/\/www.greytrix.com\/middle-east\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/middle-east\/#\/schema\/logo\/image\/","url":"https:\/\/www.greytrix.com\/middle-east\/wp-content\/uploads\/2023\/01\/Header-logo-scaled.webp","contentUrl":"https:\/\/www.greytrix.com\/middle-east\/wp-content\/uploads\/2023\/01\/Header-logo-scaled.webp","width":2560,"height":415,"caption":"Greytrix Middle East | Sage X3 Consulting | Implementation"},"image":{"@id":"https:\/\/www.greytrix.com\/middle-east\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/middle-east\/#\/schema\/person\/35ca38ced01f345c3029636a07a14159","name":"middleeastadmin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/middle-east\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/07b52eeb1ee8beb722fc7e5ce90006fc1c7ea2fc77901e6ba790bef6e37f000a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/07b52eeb1ee8beb722fc7e5ce90006fc1c7ea2fc77901e6ba790bef6e37f000a?s=96&d=mm&r=g","caption":"middleeastadmin"},"sameAs":["https:\/\/www.greytrix.com\/middle-east\/"],"url":"https:\/\/www.greytrix.com\/middle-east\/author\/middleeastadmin\/"}]}},"rttpg_featured_image_url":{"full":["https:\/\/www.greytrix.com\/middle-east\/wp-content\/uploads\/2024\/04\/How_to_Match_Open_Items_in_Sage-X3.webp",406,325,false],"landscape":["https:\/\/www.greytrix.com\/middle-east\/wp-content\/uploads\/2024\/04\/How_to_Match_Open_Items_in_Sage-X3.webp",406,325,false],"portraits":["https:\/\/www.greytrix.com\/middle-east\/wp-content\/uploads\/2024\/04\/How_to_Match_Open_Items_in_Sage-X3.webp",406,325,false],"thumbnail":["https:\/\/www.greytrix.com\/middle-east\/wp-content\/uploads\/2024\/04\/How_to_Match_Open_Items_in_Sage-X3-150x150.webp",150,150,true],"medium":["https:\/\/www.greytrix.com\/middle-east\/wp-content\/uploads\/2024\/04\/How_to_Match_Open_Items_in_Sage-X3-300x240.webp",300,240,true],"large":["https:\/\/www.greytrix.com\/middle-east\/wp-content\/uploads\/2024\/04\/How_to_Match_Open_Items_in_Sage-X3.webp",406,325,false],"1536x1536":["https:\/\/www.greytrix.com\/middle-east\/wp-content\/uploads\/2024\/04\/How_to_Match_Open_Items_in_Sage-X3.webp",406,325,false],"2048x2048":["https:\/\/www.greytrix.com\/middle-east\/wp-content\/uploads\/2024\/04\/How_to_Match_Open_Items_in_Sage-X3.webp",406,325,false],"rt_custom":["https:\/\/www.greytrix.com\/middle-east\/wp-content\/uploads\/2024\/04\/How_to_Match_Open_Items_in_Sage-X3.webp",406,325,false]},"rttpg_author":{"display_name":"middleeastadmin","author_link":"https:\/\/www.greytrix.com\/middle-east\/author\/middleeastadmin\/"},"rttpg_comment":0,"rttpg_category":"<a href=\"https:\/\/www.greytrix.com\/middle-east\/category\/uncategorized\/\" rel=\"category tag\">Uncategorized<\/a>","rttpg_excerpt":"How to Match Open Items in Sage X3 How to Match Open Items in Sage X3 Sage X3 uses an automatic matching process when posting open items, which is applied to other open items. To illustrate, when a payment is made for certain invoices, the system follows a specific sequence of actions. It enters the…","_links":{"self":[{"href":"https:\/\/www.greytrix.com\/middle-east\/wp-json\/wp\/v2\/posts\/19509","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/middle-east\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/middle-east\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/middle-east\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/middle-east\/wp-json\/wp\/v2\/comments?post=19509"}],"version-history":[{"count":5,"href":"https:\/\/www.greytrix.com\/middle-east\/wp-json\/wp\/v2\/posts\/19509\/revisions"}],"predecessor-version":[{"id":24296,"href":"https:\/\/www.greytrix.com\/middle-east\/wp-json\/wp\/v2\/posts\/19509\/revisions\/24296"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/middle-east\/wp-json\/wp\/v2\/media\/19545"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/middle-east\/wp-json\/wp\/v2\/media?parent=19509"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/middle-east\/wp-json\/wp\/v2\/categories?post=19509"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/middle-east\/wp-json\/wp\/v2\/tags?post=19509"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}