{"id":30659,"date":"2026-11-19T12:12:42","date_gmt":"2026-11-19T12:12:42","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=30659"},"modified":"2026-11-19T12:12:45","modified_gmt":"2026-11-19T12:12:45","slug":"end-to-end-query-wise-dynamic-grid-example","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/11\/19\/end-to-end-query-wise-dynamic-grid-example\/","title":{"rendered":"End-to-End Query-wise Dynamic Grid Example"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">In the previous blogs, we explored Query-wise and Table-wise Dynamic Grid Configuration and how Sync Data can be used to bring Sage 100 data into Sage CRM.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In this blog, we will take a practical example of creating a GT Invoice Dynamic Grid using Query-wise Configuration.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This example demonstrates the complete process, from creating the SQL table and configuring the Show Grid query to synchronizing Sage 100 invoice data and displaying it in Sage CRM.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>GT Invoice Dynamic Grid \u2013 Example<\/strong><strong><\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The requirement is to display GT Invoice information under:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Sage CRM \u2192 View ERP Data \u2192 Custom Grid<\/strong><strong><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The implementation consists of four main parts:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Create SQL Table \u2192 Configure Show Grid \u2192 Configure Metadata \u2192 Configure Sync Data<\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 1 \u2013 Create the GTInvoice SQL Table<\/strong><strong><\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">First, create a table named <strong>GTInvoice<\/strong> in the Sage CRM SQL database.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This table stores the invoice information that will be displayed in the Dynamic Grid.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The table includes fields for:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><br>Company Code, Customer Number, Invoice Type, Invoice Number, AR Division Number, Bill To Customer, Invoice Date, Invoice Due Date, Customer PO, Sales Order, Ship Date, Salesperson, Invoice Amount, Discount Amount, Balance, Header Sequence Number<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The implementation uses the following table structure:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">CREATE TABLE GTInvoice ( GCompanyCode VARCHAR(50), GCustomerNumber VARCHAR(50), GInvoiceType VARCHAR(20), GInvoiceNo VARCHAR(50), GARDivisionNo VARCHAR(10), GCUSTOMERNO VARCHAR(50), GBillToCUSTOMERNO VARCHAR(50), GBillToDivisionNo VARCHAR(10), GInvoiceDueDate DATE, GInvoiceDate DATE, GCustomerPoNo VARCHAR(50), GSalesOrderNo VARCHAR(50), GShipDate DATE, GSalespersonDivisionNo VARCHAR(10), GSalespersonNo VARCHAR(50), GInvoiceAmt NUMERIC(18,2), GDiscountAmt NUMERIC(18,2), GBalance NUMERIC(18,2), HeaderSeqNo VARCHAR(50), ModuleCode VARCHAR(50));<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 2 \u2013 Configure the Show Grid Query<\/strong><strong><\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Once the table is created, navigate to:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Administration \u2192 Sage 100 Administration \u2192 Dynamic Grid Query Manager<\/strong><strong><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Select:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Query Option: Show Grid<\/strong><strong><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Enter:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Caption: GTInvoice<\/strong><strong><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The Show Grid query retrieves the required invoice information from the <strong>GTInvoice<\/strong> table.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The query also prepares the invoice detail link and applies the required filtering based on the customer&#8217;s AR Division Number and Customer Number.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Show Grid Query<\/strong><strong><\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">SELECT CASE WHEN ISNULL(GInvoiceType,&#8221;&#8221;) IN (&#8221;FC&#8221;,&#8221;PP&#8221;,&#8221;PY&#8221;,&#8221;BC&#8221;,&#8221;BF&#8221;) THEN &#8221;#&#8221; ELSE &#8221;&amp;Tran=&#8221; + ISNULL(GInvoiceType,&#8221;&#8221;) + &#8221;&amp;TranId=&#8221; + ISNULL(GInvoiceNo,&#8221;&#8221;) + &#8221;&amp;CustomerNumber=&#8221; + REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( ISNULL(GARDivisionNo,&#8221;&#8221;) + &#8221;-&#8221; + ISNULL(GCustomerNo,&#8221;&#8221;), &#8221;%&#8221;, &#8221;%25&#8221;), &#8221; &#8221;, &#8221;%20&#8221;), &#8221;&#8221;&#8221;&#8221;, &#8221;%27&#8221;), &#8221;&amp;&#8221;, &#8221;%26&#8221;), &#8221;$&#8221;, &#8221;%24&#8221;), &#8221;#&#8221;, &#8221;%23&#8221;) + &#8221;&amp;InvoiceType=&#8221; + ISNULL(GInvoiceType,&#8221;&#8221;) + &#8221;&amp;HeaderSeqNo=&#8221; + ISNULL(HeaderSeqNo,&#8221;&#8221;) + &#8221;&amp;sBillToCustomerNo=&#8221; + ISNULL(GBillToCustomerNo,&#8221;&#8221;) + &#8221;&amp;BillToDivisionNo=&#8221; + ISNULL(GBillToDivisionNo,&#8221;&#8221;) END AS Details, GInvoiceNo, CAST(GInvoiceDate AS DATE) AS InvoiceDate, CAST(GInvoiceDueDate AS DATE) AS InvoiceDueDate, GCustomerPoNo, GSalesOrderNo, CASE WHEN GShipDate IN (&#8221;1753-01-01&#8221;, &#8221;1900-01-01&#8221;) THEN NULL ELSE CAST(GShipDate AS DATE) END AS GShipDate, GSalespersonDivisionNo + &#8221;-&#8221; + GSalespersonNo AS Salesperson, GInvoiceAmt, GDiscountAmt, GBalance, CASE WHEN GBalance = 0.00 THEN &#8221;Fully Paid&#8221; WHEN GBalance IS NOT NULL THEN &#8221;Open&#8221; ELSE &#8221;History&#8221; END AS sTypeFROM GTInvoiceWHERE GARDivisionNo = &#8221;^^&#8221;AND GCustomerNo = &#8221;~~&#8221;;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The query performs more than simply retrieving data. It also:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Creates the <strong>View<\/strong>&nbsp;link for invoice details.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Formats invoice and due dates.<\/li>\n\n\n\n<li>Handles default ship dates.<\/li>\n\n\n\n<li>Displays the salesperson.<\/li>\n\n\n\n<li>Calculates the invoice status.<\/li>\n\n\n\n<li>Filters invoices for the selected CRM customer.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"408\" src=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot1-1024x408.png\" alt=\"\" class=\"wp-image-30662\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot1-1024x408.png 1024w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot1-300x119.png 300w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot1-766x305.png 766w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot1-660x263.png 660w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot1.png 1120w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 3 \u2013 Configure Grid MetaData<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">This is the major change in the updated implementation. Previously, after creating the Show Grid query, grid metadata had to be manually configured in the CustomgridConfig table.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">With the new Dynamic Grid Query Manager functionality, the grid configuration can be entered directly in the Dynamic Grid Query Manager screen.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The screen provides fields such as:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Field Names<\/li>\n\n\n\n<li>Title Names<\/li>\n\n\n\n<li>Form Names<\/li>\n\n\n\n<li>Context to show Grid<\/li>\n\n\n\n<li>Sage CRM Column Name<\/li>\n\n\n\n<li>Sage 100 Column Name<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"428\" src=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot2-1024x428.png\" alt=\"\" class=\"wp-image-30663\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot2-1024x428.png 1024w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot2-767x321.png 767w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot2-300x125.png 300w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot2-660x276.png 660w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot2.png 1083w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Field Names<\/strong><strong><\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The Field Names should correspond to the fields returned by the Show Grid SQL query.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Details,GInvoiceNo,InvoiceDate,InvoiceDueDate,GCustomerPoNo,GSalesOrderNo,GShipDate,Salesperson,GInvoiceAmt,GDiscountAmt,GBalance,sType<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Title Names<\/strong><strong><\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The Title Names define the user-friendly captions displayed in the Sage CRM grid.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">View Details,Invoice No.,Invoice Date,Invoice Due Date,Customer Po,Sales Order No.,Ship Date,Salesperson,Amt,Discount,Balance,Type<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Form<\/strong><strong>at<\/strong><strong>&nbsp;Names<\/strong><strong><\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The Format Names field is used to define how specific values should be displayed in the Dynamic Grid.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">d \u2013 Used for date fields. It formats the value as a date.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">{0:C2} &nbsp;&nbsp;\u2013 Used for amount\/currency fields.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For example:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">,d,d,,,d,,{0:C2},{0:C2},{0:C2},<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Context to Show Grid<\/strong><strong><\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The Context to Show field determines where the Dynamic Grid will be displayed, such as Customer, Vendor, My CRM, or Team CRM.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Sage CRM Column Name &amp; Sage 100 Column Name<\/strong><strong><\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The Sage CRM Column Name and Sage 100 Column Name are used to link the corresponding fields between Sage CRM and Sage 100. This ensures that the data from the Sage 100 field is mapped to the appropriate Sage CRM field.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">After entering all required details.click <strong>Save<\/strong> to save the Dynamic Grid Query configuration.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 4 \u2013 Configure <strong>Sync Data<\/strong><\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">After configuring the Show Grid query and grid presentation, the next step is to populate the GTInvoice table with Sage 100 data.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Navigate to Administration \u2192 Sage 100 Administration \u2192 Dynamic Grid Query Manager and select Query Option: Sync Data.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For this implementation, two Sync Data queries are configured.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Query 1 \u2013 Clear Existing GT Invoice Data<\/strong><strong><\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Caption:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">TruncateGTInv<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Query:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">IF EXISTS ( SELECT TOP(1) * FROM GTInvoice WHERE GCompanyCode = &#8221;MAS_ABC&#8221; ) BEGIN DELETE FROM GTInvoice WHERE GCompanyCode = &#8221;MAS_ABC&#8221;; END<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"392\" src=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot3-1024x392.png\" alt=\"\" class=\"wp-image-30664\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot3-1024x392.png 1024w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot3-300x115.png 300w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot3-768x294.png 768w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot3-660x253.png 660w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot3.png 1084w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">This removes the existing invoice records for the configured Sage 100 company before the new data is imported.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Query 2<\/strong><strong>&nbsp;\u2013 Import Invoice Data from Sage 100<\/strong><strong><\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Create another Sync Data query.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Caption: GTInvoice<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The query retrieves invoice information from Sage 100 through the linked server. First, temporary tables are created for invoice header information and open invoice balance information.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">IF OBJECT_ID(&#8221;tempdb..#InvoiceHeader&#8221;) IS NOT NULL DROP TABLE #InvoiceHeader; IF OBJECT_ID(&#8221;tempdb..#OpenInvoice&#8221;) IS NOT NULL DROP TABLE #OpenInvoice; \/* Pull header and open invoice data from linked server <em>\/ SELECT * INTO #InvoiceHeader FROM OPENQUERY(MAS_ABC, &#8221;SELECT InvoiceNo, ARDivisionNo, CUSTOMERNO, BillToCustomerNo, BillToDivisionNo, HeaderSeqNo, InvoiceType, InvoiceDate, InvoiceDueDate, ShipDate, SalesOrderNo, CustomerPoNo, SalespersonNo, SalespersonDivisionNo, TaxableSalesAmt, NonTaxableSalesAMt, FreightAmt, SalesTaxAmt, DiscountAmt FROM AR_InvoiceHistoryHeader &#8221;); SELECT * INTO #OpenInvoice FROM OPENQUERY(MAS_ABC, &#8221;SELECT InvoiceNo, InvoiceHistoryHeaderSeqNo, Balance FROM AR_OpenInvoice &#8221;); \/<\/em> Insert combined data into GTInvoice *\/ INSERT INTO GTInvoice ( GCompanycode, GInvoiceNo, GARDivisionNo, GCUSTOMERNO, GBillToCUSTOMERNO, GBillToDivisionNo, GInvoiceType, GInvoiceDate, GInvoiceDueDate, GShipDate, GSalesOrderNo, GCustomerPoNo, GSalespersonNo, GSalespersonDivisionNo, GInvoiceAmt, GDiscountAmt, GBalance, HeaderSeqNo ) SELECT &#8221;MAS_ABC&#8221; 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;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Save Both the Querys. And Give Metadata.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 4 \u2013 View the GT Invoice Grid in Sage CRM<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">After synchronization is completed, navigate to the required customer in Sage CRM.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>View ERP Data \u2192 Custom Grid<\/strong><strong><\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"371\" src=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot4-1024x371.png\" alt=\"\" class=\"wp-image-30665\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot4-1024x371.png 1024w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot4-300x109.png 300w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot4-767x278.png 767w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot4-660x239.png 660w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot4.png 1297w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The GT Invoice example demonstrates how Query-wise Dynamic Grid functionality can be used to bring customized Sage 100 information into Sage CRM.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">With the new Dynamic Grid Query Manager functionality, the implementation is more centralized because the administrator can configure not only the SQL query but also the grid presentation directly within the Dynamic Grid Query Manager.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL Table \u2192 Show Grid Query \u2192 Field &amp; Column Configuration \u2192 Sync Data Query \u2192 Sage 100 Data \u2192 GTInvoice Data Table \u2192 Sage CRM Custom Grid<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This approach is particularly useful when the requirement involves multiple Sage 100 tables, custom SQL logic, calculated values, data transformation, customized column captions, and formatted presentation within Sage CRM.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><span style=\"font-size: Medium;\"><strong>About Us<\/strong><\/span><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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>In the previous blogs, we explored Query-wise and Table-wise Dynamic Grid Configuration and how Sync Data can be used to bring Sage 100 data into Sage CRM. In this blog, we will take a practical example of creating a GT Invoice Dynamic Grid using Query-wise Configuration. This example demonstrates the complete process, from creating the\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/11\/19\/end-to-end-query-wise-dynamic-grid-example\/\">Read More: End-to-End Query-wise Dynamic Grid Example &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":[4206,4825,192,4657,332],"tags":[793,1238,1258,1286,1435,2010],"class_list":["post-30659","post","type-post","status-publish","format-standard","hentry","category-gumu-integration","category-gumu-v5-6-0-5","category-integration-sage-crm","category-sage-100","category-sage-crm","tag-crm","tag-gumu","tag-gumu-integration","tag-gumumas","tag-integration","tag-sage-crm"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>End-to-End Query-wise Dynamic Grid Example - Sage CRM \u2013 Tips, Tricks and Components<\/title>\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\/2026\/11\/19\/end-to-end-query-wise-dynamic-grid-example\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"End-to-End Query-wise Dynamic Grid Example - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"In the previous blogs, we explored Query-wise and Table-wise Dynamic Grid Configuration and how Sync Data can be used to bring Sage 100 data into Sage CRM. In this blog, we will take a practical example of creating a GT Invoice Dynamic Grid using Query-wise Configuration. This example demonstrates the complete process, from creating the\u2026 Read More: End-to-End Query-wise Dynamic Grid Example &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/11\/19\/end-to-end-query-wise-dynamic-grid-example\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2026-11-19T12:12:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-11-19T12:12:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1120\" \/>\n\t<meta property=\"og:image:height\" content=\"446\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/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\/2026\/11\/19\/end-to-end-query-wise-dynamic-grid-example\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/11\/19\/end-to-end-query-wise-dynamic-grid-example\/\",\"name\":\"End-to-End Query-wise Dynamic Grid Example - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/11\/19\/end-to-end-query-wise-dynamic-grid-example\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/11\/19\/end-to-end-query-wise-dynamic-grid-example\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot1-1024x408.png\",\"datePublished\":\"2026-11-19T12:12:42+00:00\",\"dateModified\":\"2026-11-19T12:12:45+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/11\/19\/end-to-end-query-wise-dynamic-grid-example\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/11\/19\/end-to-end-query-wise-dynamic-grid-example\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/11\/19\/end-to-end-query-wise-dynamic-grid-example\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot1.png\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot1.png\",\"width\":1120,\"height\":446},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/11\/19\/end-to-end-query-wise-dynamic-grid-example\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"End-to-End Query-wise Dynamic Grid Example\"}]},{\"@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":"End-to-End Query-wise Dynamic Grid Example - Sage CRM \u2013 Tips, Tricks and Components","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\/2026\/11\/19\/end-to-end-query-wise-dynamic-grid-example\/","og_locale":"en_US","og_type":"article","og_title":"End-to-End Query-wise Dynamic Grid Example - Sage CRM \u2013 Tips, Tricks and Components","og_description":"In the previous blogs, we explored Query-wise and Table-wise Dynamic Grid Configuration and how Sync Data can be used to bring Sage 100 data into Sage CRM. In this blog, we will take a practical example of creating a GT Invoice Dynamic Grid using Query-wise Configuration. This example demonstrates the complete process, from creating the\u2026 Read More: End-to-End Query-wise Dynamic Grid Example &raquo;","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/11\/19\/end-to-end-query-wise-dynamic-grid-example\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2026-11-19T12:12:42+00:00","article_modified_time":"2026-11-19T12:12:45+00:00","og_image":[{"width":1120,"height":446,"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot1.png","type":"image\/png"}],"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\/2026\/11\/19\/end-to-end-query-wise-dynamic-grid-example\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/11\/19\/end-to-end-query-wise-dynamic-grid-example\/","name":"End-to-End Query-wise Dynamic Grid Example - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/11\/19\/end-to-end-query-wise-dynamic-grid-example\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/11\/19\/end-to-end-query-wise-dynamic-grid-example\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot1-1024x408.png","datePublished":"2026-11-19T12:12:42+00:00","dateModified":"2026-11-19T12:12:45+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/11\/19\/end-to-end-query-wise-dynamic-grid-example\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/11\/19\/end-to-end-query-wise-dynamic-grid-example\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/11\/19\/end-to-end-query-wise-dynamic-grid-example\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot1.png","contentUrl":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot1.png","width":1120,"height":446},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/11\/19\/end-to-end-query-wise-dynamic-grid-example\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"End-to-End Query-wise Dynamic Grid Example"}]},{"@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\/30659","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=30659"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/30659\/revisions"}],"predecessor-version":[{"id":30671,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/30659\/revisions\/30671"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=30659"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=30659"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=30659"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}