{"id":29519,"date":"2025-10-20T09:43:25","date_gmt":"2025-10-20T09:43:25","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=29519"},"modified":"2025-10-20T09:45:59","modified_gmt":"2025-10-20T09:45:59","slug":"configuring-a-custom-grid-using-query-grid-manager-in-sage-crm-integrated-with-sage-100-using-gumu","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2025\/10\/20\/configuring-a-custom-grid-using-query-grid-manager-in-sage-crm-integrated-with-sage-100-using-gumu\/","title":{"rendered":"Configuring a Custom Grid Using Query Grid Manager in Sage CRM (Integrated with Sage 100 using GUMU&#x2122;)"},"content":{"rendered":"\n<p>The&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/sage-crm\/gumu-sage-100-erp-integration\" target=\"_blank\" rel=\"noreferrer noopener\">GUMU&#x2122; for Sage CRM \u2013 Sage 100 Integration<\/a> empowers businesses with <strong>real-time, bi-directional connectivity<\/strong> between Sage CRM and Sage 100 ERP. Among its many powerful tools, the <strong>Query Grid Manager<\/strong> stands out as a key feature that enables users to <strong>view ERP data directly within Sage CRM \u2014 without writing a single line of code<\/strong>.<\/p>\n\n\n\n<p>This article walks you through the <strong>setup and configuration of the Query Grid Manager<\/strong>, demonstrating how to create a dynamic <strong>AR Invoice grid<\/strong> that displays invoice data from Sage 100 inside Sage CRM.<\/p>\n\n\n\n<p><strong>Overview of Query Grid Manager<\/strong><\/p>\n\n\n\n<p>The <strong>Query Grid Manager<\/strong> allows Sage CRM administrators to <strong>create, manage, and display custom data grids<\/strong> that fetch and display Sage 100 ERP information in real-time. The <strong>Query Grid Manager<\/strong> can be accessed under <strong><mark style=\"background-color:#7bdcb5\" class=\"has-inline-color has-black-color\">Administration \u2192 <strong>Sage 100 Administration<\/strong> \u2192 Query Grid Manager<\/mark><\/strong> in Sage CRM.<\/p>\n\n\n\n<p><strong>Key Features<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Create custom grids in Sage CRM, using GUMU&#x2122; integration, to display real-time\/synced data from Sage 100.<\/li>\n\n\n\n<li>Display ERP data in grid format within Sage CRM entities.<\/li>\n\n\n\n<li>Configure column visibility, sorting, and filtering.<\/li>\n\n\n\n<li>Gain real-time ERP visibility without programming or coding.<\/li>\n<\/ul>\n\n\n\n<p><strong>Prerequisites<\/strong><\/p>\n\n\n\n<p>Before setting up the Query Grid Manager, ensure the following requirements are met:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Sage CRM Administrator Rights<\/strong> \u2013 Administrative access is necessary to configure and manage the Query Grid Manager.<\/li>\n\n\n\n<li><strong>GUMU&#x2122; Integration Installed<\/strong> \u2013 Verify that the latest version of the <strong>GUMU&#x2122; Sage CRM \u2013 Sage 100 integration<\/strong> is installed and configured.<\/li>\n\n\n\n<li><strong>Data Connectivity Setup<\/strong> \u2013 Sage CRM has a SQL backend, while Sage 100 may use a different backend. A connection (such as a linked server, ODBC) must be configured to enable data synchronization between Sage 100 and Sage CRM.<\/li>\n\n\n\n<li><strong>Basic SQL Knowledge<\/strong> \u2013 Familiarity with SQL, particularly <code>OPENQUERY<\/code>, is recommended for creating synchronization queries and managing CRM-side tables.<\/li>\n<\/ol>\n\n\n\n<p>Let\u2019s walk through an example of how to create a <strong>custom grid in Sage CRM<\/strong> using the <strong>Query Grid Manager<\/strong> to display <strong>AR invoices<\/strong> for a specific customer.<\/p>\n\n\n\n<p><strong>Configuration Steps Overview<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\" start=\"1\">\n<li>Create an SQL table in the Sage CRM database to store AR Invoice data.<\/li>\n\n\n\n<li>Define the grid query in the Query Grid Manager.<\/li>\n\n\n\n<li>Configure grid metadata for labels and formatting.<\/li>\n\n\n\n<li>Sync Sage 100 data into CRM for display.<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">Step 1: Create GTInvoice Table in Sage CRM Database<\/h3>\n\n\n\n<p>Run the following SQL script in the Sage CRM database to create a table for storing Sage 100 AR Invoice data:<\/p>\n\n\n\n<p><strong>Query:<\/strong><\/p>\n\n\n\n<p><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">CREATE TABLE GTInvoice (<br>GCompanyCode VARCHAR(50),<br>GCustomerNumber VARCHAR(50),<br>GInvoiceType VARCHAR(20),<br>GInvoiceNo VARCHAR(50),<br>GARDivisionNo VARCHAR(10),<br>GCUSTOMERNO VARCHAR(50),<br>GBillToCUSTOMERNO VARCHAR(50),<br>GBillToDivisionNo VARCHAR(10),<br>GInvoiceDueDate DATE,<br>GInvoiceDate DATE,<br>GCustomerPoNo VARCHAR(50),<br>GSalesOrderNo VARCHAR(50),<br>GShipDate DATE,<br>GSalespersonDivisionNo VARCHAR(10),<br>GSalespersonNo VARCHAR(50),<br>GInvoiceAmt NUMERIC(18,2),<br>GDiscountAmt NUMERIC(18,2),<br>GBalance NUMERIC(18,2),<br>HeaderSeqNo VARCHAR(50),<br>ModuleCode VARCHAR(50)<br>);<\/mark><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"703\" height=\"391\" src=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2025\/10\/image-5.png\" alt=\"create table\" class=\"wp-image-29521\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2025\/10\/image-5.png 703w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2025\/10\/image-5-300x167.png 300w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2025\/10\/image-5-660x367.png 660w\" sizes=\"(max-width: 703px) 100vw, 703px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Step 2: Define Grid Query in Query Grid Manager<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Navigate to Administration \u2192 Sage 100 Administration \u2192 Dynamic Grid Query Manager.<\/li>\n\n\n\n<li>Create a new record with Query Option = Show Data.<\/li>\n\n\n\n<li>Set Caption = GTInvoice Grid.<\/li>\n\n\n\n<li>Enter the query to fetch and display data from GTInvoice table.<\/li>\n<\/ol>\n\n\n\n<p><strong>Query:<\/strong><\/p>\n\n\n\n<p><em><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">SELECT<br>CASE<br>WHEN ISNULL(GInvoiceType,&#8221;) IN (&#8216;FC&#8217;,&#8217;PP&#8217;,&#8217;PY&#8217;,&#8217;BC&#8217;,&#8217;BF&#8217;) THEN &#8216;#&#8217;<br>ELSE &#8216;&amp;Tran=&#8217; + ISNULL(GInvoiceType,&#8221;)<br>+ &#8216;&amp;TranId=&#8217; + ISNULL(GInvoiceNo,&#8221;)<br>+ &#8216;&amp;CustomerNumber=&#8217; + REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(ISNULL(GARDivisionNo,&#8221;) + &#8216;-&#8216; + ISNULL(GCustomerNo,&#8221;), &#8216;%&#8217;, &#8216;%25&#8217;), &#8216; &#8216;, &#8216;%20&#8242;),&#8221;&#8221;,&#8217;%27&#8242;),&#8217;&amp;&#8217;, &#8216;%26&#8242;),&#8217;$&#8217;,&#8217;%24&#8242;),&#8217;#&#8217;,&#8217;%23&#8242;)<br>+ &#8216;&amp;InvoiceType=&#8217; + ISNULL(GInvoiceType,&#8221;)<br>+ &#8216;&amp;HeaderSeqNo=&#8217; + ISNULL(HeaderSeqNo,&#8221;)<br>+ &#8216;&amp;sBillToCustomerNo=&#8217; + ISNULL(GBillToCustomerNo,&#8221;)<br>+ &#8216;&amp;BillToDivisionNo=&#8217; + ISNULL(GBillToDivisionNo,&#8221;)<br>END AS Details,<br><br>GInvoiceNo,<br>CAST(GInvoiceDate AS DATE) AS InvoiceDate,<br>CAST(GInvoiceDueDate AS DATE) AS InvoiceDueDate,<br>GCustomerPoNo,<br>GSalesOrderNo,<br>CASE WHEN GShipDate IN (&#8216;1753-01-01&#8217;, &#8216;1900-01-01&#8217;) THEN NULL ELSE CAST(GShipDate AS DATE) END AS GShipDate,<br>GSalespersonDivisionNo + &#8216;-&#8216; + GSalespersonNo AS Salesperson,<br>GInvoiceAmt,<br>GDiscountAmt,<br>GBalance,<br>CASE<br>WHEN GBalance = 0.00 THEN &#8216;Fully Paid&#8217;<br>WHEN GBalance IS NOT NULL THEN &#8216;Open&#8217;<br>ELSE &#8216;History&#8217;<br>END AS sType<br>FROM GTInvoice<br>WHERE GARDivisionNo = &#8216;^^&#8217;<br>AND GCustomerNo = &#8216;~~&#8217;;<\/mark><\/em><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"975\" height=\"423\" src=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2025\/10\/image-6.png\" alt=\"query grid screen\" class=\"wp-image-29522\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2025\/10\/image-6.png 975w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2025\/10\/image-6-300x130.png 300w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2025\/10\/image-6-768x333.png 768w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2025\/10\/image-6-660x286.png 660w\" sizes=\"(max-width: 975px) 100vw, 975px\" \/><\/figure>\n\n\n\n<p>This query retrieves Sage 100 invoice data and formats it for display inside CRM.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 3: Configure Grid Metadata<\/h3>\n\n\n\n<p>Open the CustomgridConfig table in the Sage CRM SQL database (Right click on CustomGridConfig table&gt;Edit Top 200 Rows) and add metadata configuration entries for the GTInvoice grid, such as field names, display titles, formatting, and link templates. This ensures the grid columns appear correctly within CRM and hyperlinks function properly.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><td><strong>Column<\/strong><\/td><td><strong>Value<\/strong><\/td><\/tr><\/thead><tbody><tr><td><strong>cugc_fieldnames<\/strong><\/td><td>Details,GInvoiceNo,InvoiceDate,InvoiceDueDate,GCustomerPoNo,GSalesOrderNo,GShipDate,Salesperson,GInvoiceAmt,GDiscountAmt,GBalance,sType<\/td><\/tr><tr><td><strong>cugc_titleNames<\/strong><\/td><td>View Details,Invoice No.,Invoice Date,Invoice Due Date,Customer Po,Sales Order No.,Ship Date,Salesperson,Amt,Discount,Balance,Type<\/td><\/tr><tr><td><strong>cugc_templeteName<\/strong><\/td><td><code>&lt;a href=\\'\"+DetailPageURL+\"#=Details#\\'&gt;&lt;B&gt;View&lt;\/B&gt;&lt;\/a&gt;,,,,,,,,,,,<\/code><\/td><\/tr><tr><td><strong>cugc_formatNames<\/strong><\/td><td><code>,,d,d,,,d,,{0:C2},{0:C2},{0:C2},<\/code><\/td><\/tr><tr><td><strong>cugc_DtlpageMethodName<\/strong><\/td><td>RunARDetailsKendo<\/td><\/tr><tr><td><strong>cugc_jsfunname<\/strong><\/td><td>GetCustomSQLStaticGrid<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>Note:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><em>d<\/em> represents a date format.<\/li>\n\n\n\n<li><em>{0:C2}<\/em> represents a currency format.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"712\" height=\"471\" src=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2025\/10\/image-7.png\" alt=\"metadata\" class=\"wp-image-29524\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2025\/10\/image-7.png 712w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2025\/10\/image-7-300x198.png 300w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2025\/10\/image-7-660x437.png 660w\" sizes=\"(max-width: 712px) 100vw, 712px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Step 4: Sync ERP Data into CRM Table<\/h3>\n\n\n\n<p>Before displaying the grid, ERP data from Sage 100 must be synchronized into CRM using linked server queries.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Truncate Old Data<\/strong>\n<ul class=\"wp-block-list\">\n<li><strong>Query Option:<\/strong> Sync Data<\/li>\n\n\n\n<li><strong>Caption:<\/strong> TruncateGTInv<\/li>\n\n\n\n<li><strong>Query<\/strong>: <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">IF EXISTS (SELECT TOP(1) * FROM GTInvoice WHERE GCompanyCode = &#8216;MAS_ABC&#8217;) DELETE FROM GTInvoice WHERE GCompanyCode = &#8216;MAS_ABC&#8217;;<\/mark><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Fetch Data from Sage 100<\/strong>\n<ul class=\"wp-block-list\">\n<li><strong>Query Option:<\/strong> Sync Data<\/li>\n\n\n\n<li><strong>Caption:<\/strong> GTInvoice<\/li>\n\n\n\n<li><strong>Queries<\/strong>:\n<ul class=\"wp-block-list\">\n<li><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">IF OBJECT_ID(&#8216;tempdb..#InvoiceHeader&#8217;) IS NOT NULL DROP TABLE #InvoiceHeader<br>IF OBJECT_ID(&#8216;tempdb..#OpenInvoice&#8217;) IS NOT NULL DROP TABLE #OpenInvoice<\/mark> <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-green-cyan-color\">&#8211;Drop temporary tables if they exist<\/mark><br><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">SELECT * INTO #OpenInvoice FROM OPENQUERY(MAS_ABC, &#8216; SELECT InvoiceNo, InvoiceHistoryHeaderSeqNo, Balance FROM AR_OpenInvoice &#8216;)<\/mark> <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-green-cyan-color\">&#8211;Pull data from AR_OpenInvoice<\/mark><br><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">INSERT INTO GTInvoice ( GCompanycode, GInvoiceNo, GARDivisionNo, GCUSTOMERNO, GBillToCUSTOMERNO, GBillToDivisionNo, GInvoiceType, GInvoiceDate, GInvoiceDueDate, GShipDate, GSalesOrderNo, GCustomerPoNo, GSalespersonNo, GSalespersonDivisionNo, GInvoiceAmt, GDiscountAmt, GBalance, HeaderSeqNo ) SELECT &#8216;MAS_ABC&#8217; AS GCompanycode, H.InvoiceNo, H.ARDivisionNo, H.CUSTOMERNO, H.BillToCustomerNo, H.BillToDivisionNo, H.InvoiceType, H.InvoiceDate, H.InvoiceDueDate, H.ShipDate, H.SalesOrderNo, H.CustomerPoNo, H.SalespersonNo, H.SalespersonDivisionNo, (H.TaxableSalesAmt + H.NonTaxableSalesAMt + H.FreightAmt + H.SalesTaxAmt) AS GInvoiceAmt, H.DiscountAmt, O.Balance, H.HeaderSeqNo FROM #InvoiceHeader H LEFT JOIN #OpenInvoice O ON H.InvoiceNo = O.InvoiceNo AND H.HeaderSeqNo = O.InvoiceHistoryHeaderSeqNo<\/mark> <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-green-cyan-color\">&#8211;Merge into GTInvoice table<\/mark><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Testing the Grid in Sage CRM<\/strong><\/h3>\n\n\n\n<ol class=\"wp-block-list\" start=\"1\">\n<li>Open any <strong>Company<\/strong> record linked to Sage 100.<\/li>\n\n\n\n<li>Navigate to <strong>Custom Grid \u2192 View ERP tab<\/strong>.<\/li>\n\n\n\n<li>Verify that the AR invoices display with accurate columns such as:\n<ul class=\"wp-block-list\">\n<li>Invoice No.<\/li>\n\n\n\n<li>Invoice Date<\/li>\n\n\n\n<li>Due Date<\/li>\n\n\n\n<li>Customer PO<\/li>\n\n\n\n<li>Salesperson<\/li>\n\n\n\n<li>Amount and Balance<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<p><strong>Result<\/strong>: <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"975\" height=\"421\" src=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2025\/10\/image-9.png\" alt=\"result\" class=\"wp-image-29526\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2025\/10\/image-9.png 975w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2025\/10\/image-9-300x130.png 300w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2025\/10\/image-9-768x332.png 768w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2025\/10\/image-9-660x285.png 660w\" sizes=\"(max-width: 975px) 100vw, 975px\" \/><\/figure>\n\n\n\n<p>After configuration, users can view a fully functional AR Invoice grid in Sage CRM displaying data from Sage 100. This enables financial visibility for sales and finance teams. The same process can be extended to create grids for Sales Orders, Payments, Shipments, and Quotes.<\/p>\n\n\n\n<p>If you have any <strong>queries<\/strong> or <strong>customization requests<\/strong> for your Sage CRM \u2013 Sage 100 integration, feel free to contact us at <strong><a href=\"mailto:sage@greytrix.com\">sage@greytrix.com<\/a><\/strong>. Our team will be happy to assist you.<\/p>\n\n\n\n<p><span style=\"font-size: Medium;\"><strong>About Us<\/strong><\/span><\/p>\n\n\n\n<p>Greytrix \u2013 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.<\/p>\n\n\n\n<p>Greytrix\u00a0has some unique integration solutions developed for Sage CRM with Sage ERPs namely\u00a0Sage X3,\u00a0Sage Intacct,\u00a0Sage 100,\u00a0Sage 500,\u00a0and\u00a0Sage 300. We also offer best-in-class\u00a0Sage ERP\u00a0and\u00a0Sage CRM\u00a0customization and development services\u00a0to\u00a0Business\u00a0Partners,\u00a0End\u00a0Users, and Sage PSG worldwide. Greytrix\u00a0helps in\u00a0the migration of Sage CRM from\u00a0Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes\u00a0add-ons like\u00a0 Greytrix Business Manager,\u00a0Sage CRM Project Manager,\u00a0Sage CRM Resource Planner,\u00a0Sage CRM Contract Manager,\u00a0Sage CRM Event Manager,\u00a0Sage CRM Budget Planner,\u00a0Gmail Integration,\u00a0Sage CRM Mobile Service Signature,\u00a0Sage CRM CTI Framework.<gwmw style=\"display:none;\"><gwmw style=\"display:none;\"><gwmw style=\"display:none;\"><gwmw style=\"display:none;\"><\/gwmw><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><\/gwmw><\/gwmw><\/p>\n\n\n\n<p>Greytrix is a recognized\u00a0Sage Champion Partner\u00a0for GUMU&#x2122; Sage X3 \u2013 Sage CRM integration listed on\u00a0Sage Marketplace and Sage CRM \u2013 Sage Intacct integration listed on Sage Intacct Marketplace. The GUMU&#x2122; 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.<gwmw style=\"display:none;\"><gwmw style=\"display:none;\"><gwmw style=\"display:none;\"><gwmw style=\"display:none;\"><\/gwmw><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><\/gwmw><\/gwmw><\/p>\n\n\n\n<p>For more information on our integration solutions, please contact us at&nbsp;<a href=\"mailto:sage@greytrix.com\">sage@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The&nbsp;GUMU&#x2122; for Sage CRM \u2013 Sage 100 Integration empowers businesses with real-time, bi-directional connectivity between Sage CRM and Sage 100 ERP. Among its many powerful tools, the Query Grid Manager stands out as a key feature that enables users to view ERP data directly within Sage CRM \u2014 without writing a single line of code.\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2025\/10\/20\/configuring-a-custom-grid-using-query-grid-manager-in-sage-crm-integrated-with-sage-100-using-gumu\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[83,4206,192,4657,335,3986,4680,1],"tags":[4698,4693,1238,4694,1258,1286,1435,4696,4697,2010,2070,4695],"class_list":["post-29519","post","type-post","status-publish","format-standard","hentry","category-crm72","category-gumu-integration","category-integration-sage-crm","category-sage-100","category-sage-crm-2018-crm72","category-sage-crm-2019-r1-sage-crm-2018-crm72","category-sage-crm-2025","category-uncategorized","tag-ar-invoice-grid-sage-crm","tag-greytrix-gumu-integration","tag-gumu","tag-gumu-for-sage-crm-sage-100-2","tag-gumu-integration","tag-gumumas","tag-integration","tag-real-time-erp-data-in-crm","tag-sage-100-crm-customization","tag-sage-crm","tag-sage-crm-erp-integration","tag-sage-crm-query-grid-manager"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Configuring a Custom Grid Using Query Grid Manager in Sage CRM (Integrated with Sage 100 using GUMU&#x2122;) - Sage CRM \u2013 Tips, Tricks and Components<\/title>\n<meta name=\"description\" content=\"Learn how to configure the Query Grid Manager in Sage CRM integrated with Sage 100 using GUMU\u2122. Create real-time ERP data grids \u2014 like AR Invoices and Sales Orders \u2014 without custom coding.\" \/>\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\/blogs\/sagecrm\/2025\/10\/20\/configuring-a-custom-grid-using-query-grid-manager-in-sage-crm-integrated-with-sage-100-using-gumu\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Configuring a Custom Grid Using Query Grid Manager in Sage CRM (Integrated with Sage 100 using GUMU&#x2122;) - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Learn how to configure the Query Grid Manager in Sage CRM integrated with Sage 100 using GUMU\u2122. Create real-time ERP data grids \u2014 like AR Invoices and Sales Orders \u2014 without custom coding.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2025\/10\/20\/configuring-a-custom-grid-using-query-grid-manager-in-sage-crm-integrated-with-sage-100-using-gumu\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2025-10-20T09:43:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-20T09:45:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2025\/10\/image-5.png\" \/>\n<meta name=\"author\" content=\"greysagecrm\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagecrm\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2025\/10\/20\/configuring-a-custom-grid-using-query-grid-manager-in-sage-crm-integrated-with-sage-100-using-gumu\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2025\/10\/20\/configuring-a-custom-grid-using-query-grid-manager-in-sage-crm-integrated-with-sage-100-using-gumu\/\",\"name\":\"Configuring a Custom Grid Using Query Grid Manager in Sage CRM (Integrated with Sage 100 using GUMU&#x2122;) - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2025\/10\/20\/configuring-a-custom-grid-using-query-grid-manager-in-sage-crm-integrated-with-sage-100-using-gumu\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2025\/10\/20\/configuring-a-custom-grid-using-query-grid-manager-in-sage-crm-integrated-with-sage-100-using-gumu\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2025\/10\/image-5.png\",\"datePublished\":\"2025-10-20T09:43:25+00:00\",\"dateModified\":\"2025-10-20T09:45:59+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"description\":\"Learn how to configure the Query Grid Manager in Sage CRM integrated with Sage 100 using GUMU\u2122. Create real-time ERP data grids \u2014 like AR Invoices and Sales Orders \u2014 without custom coding.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2025\/10\/20\/configuring-a-custom-grid-using-query-grid-manager-in-sage-crm-integrated-with-sage-100-using-gumu\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2025\/10\/20\/configuring-a-custom-grid-using-query-grid-manager-in-sage-crm-integrated-with-sage-100-using-gumu\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2025\/10\/20\/configuring-a-custom-grid-using-query-grid-manager-in-sage-crm-integrated-with-sage-100-using-gumu\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2025\/10\/image-5.png\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2025\/10\/image-5.png\",\"width\":703,\"height\":391},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2025\/10\/20\/configuring-a-custom-grid-using-query-grid-manager-in-sage-crm-integrated-with-sage-100-using-gumu\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Configuring a Custom Grid Using Query Grid Manager in Sage CRM (Integrated with Sage 100 using GUMU&#x2122;)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\",\"name\":\"Sage CRM \u2013 Tips, Tricks and Components\",\"description\":\"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips &amp; tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\",\"name\":\"greysagecrm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"greysagecrm\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Configuring a Custom Grid Using Query Grid Manager in Sage CRM (Integrated with Sage 100 using GUMU&#x2122;) - Sage CRM \u2013 Tips, Tricks and Components","description":"Learn how to configure the Query Grid Manager in Sage CRM integrated with Sage 100 using GUMU\u2122. Create real-time ERP data grids \u2014 like AR Invoices and Sales Orders \u2014 without custom coding.","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\/blogs\/sagecrm\/2025\/10\/20\/configuring-a-custom-grid-using-query-grid-manager-in-sage-crm-integrated-with-sage-100-using-gumu\/","og_locale":"en_US","og_type":"article","og_title":"Configuring a Custom Grid Using Query Grid Manager in Sage CRM (Integrated with Sage 100 using GUMU&#x2122;) - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Learn how to configure the Query Grid Manager in Sage CRM integrated with Sage 100 using GUMU\u2122. Create real-time ERP data grids \u2014 like AR Invoices and Sales Orders \u2014 without custom coding.","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2025\/10\/20\/configuring-a-custom-grid-using-query-grid-manager-in-sage-crm-integrated-with-sage-100-using-gumu\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2025-10-20T09:43:25+00:00","article_modified_time":"2025-10-20T09:45:59+00:00","og_image":[{"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2025\/10\/image-5.png","type":"","width":"","height":""}],"author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2025\/10\/20\/configuring-a-custom-grid-using-query-grid-manager-in-sage-crm-integrated-with-sage-100-using-gumu\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2025\/10\/20\/configuring-a-custom-grid-using-query-grid-manager-in-sage-crm-integrated-with-sage-100-using-gumu\/","name":"Configuring a Custom Grid Using Query Grid Manager in Sage CRM (Integrated with Sage 100 using GUMU&#x2122;) - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2025\/10\/20\/configuring-a-custom-grid-using-query-grid-manager-in-sage-crm-integrated-with-sage-100-using-gumu\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2025\/10\/20\/configuring-a-custom-grid-using-query-grid-manager-in-sage-crm-integrated-with-sage-100-using-gumu\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2025\/10\/image-5.png","datePublished":"2025-10-20T09:43:25+00:00","dateModified":"2025-10-20T09:45:59+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"description":"Learn how to configure the Query Grid Manager in Sage CRM integrated with Sage 100 using GUMU\u2122. Create real-time ERP data grids \u2014 like AR Invoices and Sales Orders \u2014 without custom coding.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2025\/10\/20\/configuring-a-custom-grid-using-query-grid-manager-in-sage-crm-integrated-with-sage-100-using-gumu\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2025\/10\/20\/configuring-a-custom-grid-using-query-grid-manager-in-sage-crm-integrated-with-sage-100-using-gumu\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2025\/10\/20\/configuring-a-custom-grid-using-query-grid-manager-in-sage-crm-integrated-with-sage-100-using-gumu\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2025\/10\/image-5.png","contentUrl":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2025\/10\/image-5.png","width":703,"height":391},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2025\/10\/20\/configuring-a-custom-grid-using-query-grid-manager-in-sage-crm-integrated-with-sage-100-using-gumu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Configuring a Custom Grid Using Query Grid Manager in Sage CRM (Integrated with Sage 100 using GUMU&#x2122;)"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/","name":"Sage CRM \u2013 Tips, Tricks and Components","description":"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips &amp; tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f","name":"greysagecrm","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"greysagecrm"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/29519","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=29519"}],"version-history":[{"count":4,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/29519\/revisions"}],"predecessor-version":[{"id":29533,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/29519\/revisions\/29533"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=29519"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=29519"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=29519"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}