{"id":30672,"date":"2026-11-19T12:28:21","date_gmt":"2026-11-19T12:28:21","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=30672"},"modified":"2026-11-19T12:28:23","modified_gmt":"2026-11-19T12:28:23","slug":"end-to-end-table-wise-dynamic-grid-example-in-gumu","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/11\/19\/end-to-end-table-wise-dynamic-grid-example-in-gumu\/","title":{"rendered":"End-to-End Table-wise Dynamic Grid Example in GUMU"},"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 an Inventory Details Dynamic Grid using Table-wise Configuration.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Unlike Query-wise configuration, where administrators define a SQL query to retrieve data, Table-wise configuration allows administrators to select a Sage 100 table and choose the required columns directly from the Dynamic Grid Query Manager.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This example demonstrates the configuration process, from selecting the Sage 100 table and columns to mapping the fields and displaying inventory information in Sage CRM.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Inventory Details Dynamic Grid \u2013 Example<\/strong><strong><\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The requirement is to display inventory information from Sage 100 in Sage CRM.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The grid will display the following information:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Item Code<\/li>\n\n\n\n<li>Warehouse Code<\/li>\n\n\n\n<li>Quantity On Hand<\/li>\n\n\n\n<li>Quantity on Purchase Order<\/li>\n\n\n\n<li>Quantity on Sales Order<\/li>\n\n\n\n<li>Average Cost<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">The example uses the Sage 100 table <em>IM_ItemWarehouse<\/em>. Confirm the exact table and field names available in your Sage 100 installation before configuring the grid.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Implementation flow:<\/strong> <strong><em><strong><em>Select Company \u2192 Configure Show Grid \u2192 Select Table \u2192 Add Columns \u2192 Configure Titles and Mapping \u2192 Select CRM Context \u2192 Save and Validate<\/em><\/strong><\/em><\/strong><strong><\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 1 \u2013 Open Dynamic Grid Query Manager<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Log in to Sage CRM with an account that has the required administrative permissions.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Navigate to: <strong>Administration \u2192 Sage 100 Administration \u2192 Dynamic Grid Query Manager<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Select the appropriate Sage 100 company for which the inventory details need to be displayed.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"395\" src=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot1-1-1024x395.png\" alt=\"\" class=\"wp-image-30673\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot1-1-1024x395.png 1024w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot1-1-300x116.png 300w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot1-1-767x296.png 767w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot1-1-660x255.png 660w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot1-1.png 1231w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 2 &#8211; Configure the Show Grid Option<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">In the Dynamic Grid Query Manager, configure the following fields:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Field<\/strong><strong><\/strong><\/td><td><strong>Configuration<\/strong><strong><\/strong><\/td><\/tr><tr><td>Query Options<\/td><td>Show Grid<\/td><\/tr><tr><td>Selection Type<\/td><td>Table-wise<\/td><\/tr><tr><td>Caption<\/td><td>Inventory Details<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The Show Grid option is used to configure the grid displayed in Sage CRM. The Table-wise selection type allows you to select a Sage 100 table and configure its columns through the interface. The Caption defines the name displayed for the grid.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 3 &#8211; <strong>Select the Sage 100 Table<\/strong><\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">In the Select Table dropdown, choose <strong>IM_ItemWarehouse<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This table is used in the example to retrieve inventory information by item and warehouse. After selecting the table, use the Select Column dropdown to choose the fields required for the grid.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"488\" src=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot2-1-1024x488.png\" alt=\"\" class=\"wp-image-30674\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot2-1-1024x488.png 1024w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot2-1-300x143.png 300w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot2-1-766x365.png 766w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot2-1-660x314.png 660w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot2-1.png 1077w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step <strong>4 \u2013 Select Columns and Configure Their Types<\/strong><\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The Table-wise configuration screen provides Select Column, Type, and Add controls. Choose a column from the selected table, select the appropriate data type from the available options, and click Add. Repeat until all required columns have been added.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Select Column: Choose a source column from the selected Sage 100 table.<\/li>\n\n\n\n<li>Type: Select the appropriate available data type. The screenshot shows Varchar as an example; do not use it for every field if another type is appropriate.<\/li>\n\n\n\n<li>Add: Add the selected column to the selected-column list.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Suggested display fields for the Inventory Details example:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Display Field<\/strong><strong><\/strong><\/td><td><strong>Purpose<\/strong><strong><\/strong><\/td><\/tr><tr><td>Item Code<\/td><td>Identifies the inventory item.<\/td><\/tr><tr><td>Warehouse Code<\/td><td>Identifies the warehouse associated with the item.<\/td><\/tr><tr><td>Quantity On Hand<\/td><td>Displays the on-hand quantity.<\/td><\/tr><tr><td>Quantity on Purchase Order<\/td><td>Displays the quantity on purchase order.<\/td><\/tr><tr><td>Quantity on Sales Order<\/td><td>Displays the quantity on sales order.<\/td><\/tr><tr><td>Average Cost<\/td><td>Displays the average inventory cost.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The exact source field names and data types must be selected from the options available in your installed GUMU and Sage 100 environment. The display labels above are illustrative and may not match the underlying database column names.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Use the available up\/down controls to reorder columns and the removal control to remove an unwanted column.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step<strong>\u00a05 \u2013 Configure Title Names<\/strong><\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The Title Names field defines the user-friendly column captions displayed in the Dynamic Grid. Enter titles in the same order as the selected columns:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Item Code, Warehouse Code, Quantity On Hand, Quantity on Purchase Order, Quantity on Sales Order, Average Cost<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ensure that the title sequence matches the selected-column sequence. This keeps the displayed captions aligned with their corresponding data fields.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"992\" height=\"420\" src=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot3-1.png\" alt=\"\" class=\"wp-image-30675\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot3-1.png 992w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot3-1-300x127.png 300w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot3-1-660x279.png 660w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot3-1-768x325.png 768w\" sizes=\"(max-width: 992px) 100vw, 992px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step<strong>\u00a0<strong>6 \u2013 Configure Context to Show Grid<\/strong><\/strong><\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The Context to show Grid dropdown determines the Sage CRM context in which the grid should be displayed. For this example, select Customer if the Inventory Details grid is intended to appear in the Customer context. Choose the appropriate context based on the business requirement and available options.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"629\" height=\"181\" src=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot4-1.png\" alt=\"\" class=\"wp-image-30676\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot4-1.png 629w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot4-1-300x86.png 300w\" sizes=\"(max-width: 629px) 100vw, 629px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step<strong>\u00a0<strong><strong>7 \u2013 Configure Sage CRM and Sage 100 Column Mapping\u00a0(If Required)<\/strong><\/strong><\/strong><\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The configuration screen also contains Sage CRM Column Name and Sage 100 Column Name fields.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Identify the Sage 100 field that needs to be associated with a Sage CRM field.<\/li>\n\n\n\n<li>Enter the appropriate field in Sage CRM Column Name.<\/li>\n\n\n\n<li>Select the corresponding field from the Sage 100 Column Name dropdown.<\/li>\n\n\n\n<li>Click Add to add the mapping to the list.<\/li>\n\n\n\n<li>Repeat for any additional mappings required by the implementation.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Use valid field names from the actual CRM and Sage 100 configuration. A display caption such as Item Code is not necessarily the database field name. Configure only the mappings required for your implementation.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step<strong>\u00a0<strong><strong><strong>8 \u2013 Save the Configuration<\/strong><\/strong><\/strong><\/strong><\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Review the configuration before saving:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Query Options is set to Show Grid.<\/li>\n\n\n\n<li>Selection Type is set to Table-wise.<\/li>\n\n\n\n<li>The correct Sage 100 company and table are selected.<\/li>\n\n\n\n<li>All required columns have been added and their types are appropriate.<\/li>\n\n\n\n<li>The column order matches the Title Names sequence.<\/li>\n\n\n\n<li>The intended CRM context is selected.<\/li>\n\n\n\n<li>Any required Sage CRM and Sage 100 column mappings are configured.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Save the Dynamic Grid Query configuration.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step<strong>\u00a0<strong><strong><strong><strong>9<\/strong> <strong>\u2013 Verify the Inventory Details Grid in Sage CRM<\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">After saving the configuration and completing any required synchronization, navigate to the Sage CRM context selected in Step 6. For this example, navigate to the appropriate Customer record and open the configured Dynamic Grid location.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Verify that the grid displays the configured columns and that the values correspond to the selected Sage 100 data.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Test<\/strong><\/td><td><strong>Expected Result<\/strong><\/td><\/tr><tr><td>Grid visibility<\/td><td>Inventory Details appears in the configured CRM context.<\/td><\/tr><tr><td>Column captions<\/td><td>The configured Title Names are displayed correctly.<\/td><\/tr><tr><td>Column order<\/td><td>Columns appear in the configured sequence.<\/td><\/tr><tr><td>Item Code<\/td><td>Displays the correct item identifier.<\/td><\/tr><tr><td>Warehouse Code<\/td><td>Displays the correct warehouse identifier.<\/td><\/tr><tr><td>Quantity fields<\/td><td>Display values corresponding to the selected Sage 100 fields.<\/td><\/tr><tr><td>Average Cost<\/td><td>Displays the corresponding cost value in the expected format.<\/td><\/tr><tr><td>Data consistency<\/td><td>Displayed values match the source data, subject to the configured synchronization behavior.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"304\" src=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot5-1024x304.png\" alt=\"\" class=\"wp-image-30677\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot5-1024x304.png 1024w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot5-765x227.png 765w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot5-660x196.png 660w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot5-300x89.png 300w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot5.png 1332w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The Inventory Details example demonstrates how to configure a Table-wise Dynamic Grid in GUMU by selecting a Sage 100 table, adding the required columns, defining user-friendly titles, choosing the Sage CRM context, and configuring field mappings where required.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This approach is useful when the required information can be configured using the available table and column selections without needing custom SQL query logic.<\/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 an Inventory Details Dynamic Grid using Table-wise Configuration. Unlike Query-wise configuration, where administrators define a SQL query\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/11\/19\/end-to-end-table-wise-dynamic-grid-example-in-gumu\/\">Read More: End-to-End Table-wise Dynamic Grid Example in GUMU &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":[1238,1258,1286,1435,2010],"class_list":["post-30672","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-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 Table-wise Dynamic Grid Example in GUMU - 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-table-wise-dynamic-grid-example-in-gumu\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"End-to-End Table-wise Dynamic Grid Example in GUMU - 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 an Inventory Details Dynamic Grid using Table-wise Configuration. Unlike Query-wise configuration, where administrators define a SQL query\u2026 Read More: End-to-End Table-wise Dynamic Grid Example in GUMU &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/11\/19\/end-to-end-table-wise-dynamic-grid-example-in-gumu\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2026-11-19T12:28:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-11-19T12:28:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot1-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1231\" \/>\n\t<meta property=\"og:image:height\" content=\"475\" \/>\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-table-wise-dynamic-grid-example-in-gumu\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/11\/19\/end-to-end-table-wise-dynamic-grid-example-in-gumu\/\",\"name\":\"End-to-End Table-wise Dynamic Grid Example in GUMU - 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-table-wise-dynamic-grid-example-in-gumu\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/11\/19\/end-to-end-table-wise-dynamic-grid-example-in-gumu\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot1-1-1024x395.png\",\"datePublished\":\"2026-11-19T12:28:21+00:00\",\"dateModified\":\"2026-11-19T12:28:23+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-table-wise-dynamic-grid-example-in-gumu\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/11\/19\/end-to-end-table-wise-dynamic-grid-example-in-gumu\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/11\/19\/end-to-end-table-wise-dynamic-grid-example-in-gumu\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot1-1.png\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot1-1.png\",\"width\":1231,\"height\":475},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/11\/19\/end-to-end-table-wise-dynamic-grid-example-in-gumu\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"End-to-End Table-wise Dynamic Grid Example in GUMU\"}]},{\"@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 Table-wise Dynamic Grid Example in GUMU - 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-table-wise-dynamic-grid-example-in-gumu\/","og_locale":"en_US","og_type":"article","og_title":"End-to-End Table-wise Dynamic Grid Example in GUMU - 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 an Inventory Details Dynamic Grid using Table-wise Configuration. Unlike Query-wise configuration, where administrators define a SQL query\u2026 Read More: End-to-End Table-wise Dynamic Grid Example in GUMU &raquo;","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/11\/19\/end-to-end-table-wise-dynamic-grid-example-in-gumu\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2026-11-19T12:28:21+00:00","article_modified_time":"2026-11-19T12:28:23+00:00","og_image":[{"width":1231,"height":475,"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot1-1.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-table-wise-dynamic-grid-example-in-gumu\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/11\/19\/end-to-end-table-wise-dynamic-grid-example-in-gumu\/","name":"End-to-End Table-wise Dynamic Grid Example in GUMU - 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-table-wise-dynamic-grid-example-in-gumu\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/11\/19\/end-to-end-table-wise-dynamic-grid-example-in-gumu\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot1-1-1024x395.png","datePublished":"2026-11-19T12:28:21+00:00","dateModified":"2026-11-19T12:28:23+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-table-wise-dynamic-grid-example-in-gumu\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/11\/19\/end-to-end-table-wise-dynamic-grid-example-in-gumu\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/11\/19\/end-to-end-table-wise-dynamic-grid-example-in-gumu\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot1-1.png","contentUrl":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/11\/Screenshot1-1.png","width":1231,"height":475},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/11\/19\/end-to-end-table-wise-dynamic-grid-example-in-gumu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"End-to-End Table-wise Dynamic Grid Example in GUMU"}]},{"@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\/30672","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=30672"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/30672\/revisions"}],"predecessor-version":[{"id":30683,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/30672\/revisions\/30683"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=30672"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=30672"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=30672"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}