{"id":18246,"date":"2019-08-29T10:18:15","date_gmt":"2019-08-29T10:18:15","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagex3\/?p=18246"},"modified":"2019-10-18T06:03:19","modified_gmt":"2019-10-18T06:03:19","slug":"how-to-add-the-dashboard-in-sage-x3-version-12","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2019\/08\/29\/how-to-add-the-dashboard-in-sage-x3-version-12\/","title":{"rendered":"How to add the Dashboard in Sage X3 Version 12"},"content":{"rendered":"\n<p>In some requirement, user may wants to see some reports when they login to the Sage X3, or for the management people thy need to see the any sets of records like Open Sales Order, Open Invoice, outstanding and many more on the login of the Sage X3. We can achieve this by following the below steps.<\/p>\n\n\n\n<p>We need to make Query in Sage X3 through SQL Query Tools with the below navigation as follow:<\/p>\n\n\n\n<p>Setup &gt; Usage &gt; Report &gt; Query Tool<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img fetchpriority=\"high\" decoding=\"async\" width=\"915\" height=\"506\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/SQL-Query-tool.jpg\" alt=\"SQL Query Tool\" class=\"wp-image-18263\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/SQL-Query-tool.jpg 915w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/SQL-Query-tool-300x166.jpg 300w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/SQL-Query-tool-768x425.jpg 768w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/SQL-Query-tool-660x365.jpg 660w\" sizes=\"(max-width: 915px) 100vw, 915px\" \/><figcaption><strong>SQL Query Tool<\/strong><\/figcaption><\/figure>\n\n\n\n<p>Once we are done with the Query tool we need to create the new menu item with the below navigation:<\/p>\n\n\n\n<p>Administration &gt; Authoring &gt; Pages &gt; Menu Items<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"910\" height=\"298\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/menu-item.jpg\" alt=\"Menu Item\" class=\"wp-image-18262\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/menu-item.jpg 910w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/menu-item-300x98.jpg 300w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/menu-item-768x251.jpg 768w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/menu-item-660x216.jpg 660w\" sizes=\"(max-width: 910px) 100vw, 910px\" \/><figcaption><strong>Menu Item<\/strong><\/figcaption><\/figure>\n\n\n\n<p>Next step is to add the Landing page on the home screen as below:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" width=\"208\" height=\"143\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/landing-page.jpg\" alt=\"Landing Page\" class=\"wp-image-18261\"\/><figcaption><strong>Landing Page<\/strong><\/figcaption><\/figure><\/div>\n\n\n\n<p>We\nnow need to add the created Menu item in the Landing page as below:<\/p>\n\n\n\n<p>We will get the newly added menu item in the Queries as shown below:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"604\" height=\"385\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/Add-the-query-in-landing-page.jpg\" alt=\"Adding the query in landing page\" class=\"wp-image-18258\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/Add-the-query-in-landing-page.jpg 604w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/Add-the-query-in-landing-page-300x191.jpg 300w\" sizes=\"(max-width: 604px) 100vw, 604px\" \/><figcaption><strong>Adding the query in landing page<\/strong><\/figcaption><\/figure>\n\n\n\n<p>Need to click on the menu and will need to follow the below navigation to get the gadget:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"464\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/Gadget.jpg\" alt=\"Gadget\" class=\"wp-image-18260\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/Gadget.jpg 600w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/Gadget-300x232.jpg 300w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><figcaption><strong>Gadget<\/strong><\/figcaption><\/figure>\n\n\n\n<p>After clicking on the OK you will see the dashboard as below:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"976\" height=\"387\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/Dashboard.jpg\" alt=\"Dashboard\" class=\"wp-image-18259\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/Dashboard.jpg 976w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/Dashboard-300x119.jpg 300w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/Dashboard-768x305.jpg 768w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/Dashboard-660x262.jpg 660w\" sizes=\"(max-width: 976px) 100vw, 976px\" \/><figcaption><strong>Dashboard<\/strong><\/figcaption><\/figure>\n\n\n\n<p>With the above process we can design the any dashboard and place on the Landing page which user can see when it login into the Sage X3.<\/p>\n\n\n\n<p><strong>About Us<\/strong><br>\n<a href=\"https:\/\/www.greytrix.com\/\">Greytrix<\/a>&nbsp;\u2013 a globally recognized Premier Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation expertise.<\/p>\n\n\n\n<p><a href=\"https:\/\/www.greytrix.com\/\">Greytrix<\/a>&nbsp;caters to a wide range of Sage Enterprise Management (Sage X3) offerings \u2013 a Sage Business Cloud Solution. Our&nbsp;unique GUMU&#x2122; integrations include&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/sage-crm\/gumu-sage-x3-integration\">Sage X3 for Sage CRM<\/a>,&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/sage-x3\/gumu-x3-salesforce-integration\">Salesforce.com<\/a>&nbsp;and&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/magento-sage-integrations\/sage-x3-magento\">Magento eCommerce<\/a>&nbsp;along with Implementation and Technical Support worldwide for&nbsp;<a href=\"https:\/\/www.greytrix.com\/africa\/product\/consulting\/implementation-planning\">Sage X3 (Sage Enterprise Management)<\/a>. Currently we are&nbsp;<a href=\"https:\/\/www.greytrix.com\/africa\">Sage X3 Implementation Partner<\/a>&nbsp;in East Africa, Middles East, Australia, Asia.&nbsp;We also offer best-in-class&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/erp-development\/sage-x3\">Sage X3 customization and development services<\/a>,&nbsp;integrated applications such as&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/pos-system\">POS<\/a>&nbsp;|&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/warehouse-management-system\">WMS<\/a>&nbsp;|&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/payment-gateway\">Payment Gateway<\/a>&nbsp;|&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/shipping-system\">Shipping System<\/a>&nbsp;|&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/business-intelligence\">Business Intelligence<\/a>&nbsp;|&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/sage-x3\/ecommerce-magento-integration\">eCommerce<\/a>&nbsp;and have developed add-ons such as&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-add-ons\/catch-weight\">Catch \u2013 Weight&nbsp;<\/a>&nbsp;and&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-add-ons\/letter-of-credit\">Letter of Credit<\/a>&nbsp;for Sage X3 to Sage business partners, end users and Sage PSG worldwide.<\/p>\n\n\n\n<p>Greytrix is a recognized&nbsp;<a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/07\/26\/greytrix-on-boards-sage-global-rockstar-isv-program-with-gumu-for-sage-crm-sage-x3-solution\/\">Sage Rockstar ISV Partner<\/a>&nbsp;for GUMU&#x2122; Sage X3 \u2013 Sage CRM integration also listed on&nbsp;<a href=\"https:\/\/www.sage.com\/marketplace\/asb_ListingDetail?listingId=a1h24000007PC3aAAG\" target=\"_blank\" rel=\"noopener\">Sage Marketplace<\/a>; GUMU&#x2122; integration for Sage X3 \u2013 Salesforce is a 5-star app listed on&nbsp;<a href=\"https:\/\/appexchange.salesforce.com\/listingDetail?listingId=a0N30000000psM5EAI\" target=\"_blank\" rel=\"noopener\">Salesforce AppExchange<\/a>.<\/p>\n\n\n\n<p>For more information on Sage X3 Integration and Services, please contact us at&nbsp;<a href=\"mailto:x3@greytrix.com\">x3@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In some requirement, user may wants to see some reports when they login to the Sage X3, or for the management people thy need to see the any sets of records like Open Sales Order, Open Invoice, outstanding and many more on the login of the Sage X3. We can achieve this by following the\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/2019\/08\/29\/how-to-add-the-dashboard-in-sage-x3-version-12\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,2796,11],"tags":[496,2832,1942,1945,2735],"class_list":["post-18246","post","type-post","status-publish","format-standard","hentry","category-standard","category-technical","category-tips","tag-dashboard","tag-dashboard-in-sage-x3-version-12","tag-sage-x3-technical-assistance","tag-sage-x3-technical-blogs","tag-sage-x3-version-12"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/18246","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=18246"}],"version-history":[{"count":7,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/18246\/revisions"}],"predecessor-version":[{"id":18768,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/18246\/revisions\/18768"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=18246"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=18246"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=18246"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}