{"id":28609,"date":"2024-03-05T11:08:56","date_gmt":"2024-03-05T11:08:56","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagex3\/?p=28609"},"modified":"2024-03-05T11:08:56","modified_gmt":"2024-03-05T11:08:56","slug":"how-to-add-a-single-report-to-sage-x3-modules","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2024\/03\/05\/how-to-add-a-single-report-to-sage-x3-modules\/","title":{"rendered":"HOW TO ADD A SINGLE REPORT TO SAGE X3 MODULES"},"content":{"rendered":"\n<p>As a user in Sage X3, you may have to run specific reports as part of your daily routine. Setting up a report as a single item for a particular module can help improve work flow and minimize any confusion you may have on which report to run.<\/p>\n\n\n\n<p>In the example below, we will be adding the Trial Balance Report as a menu item and&nbsp; later we can add to Financial sub-module.<\/p>\n\n\n\n<p>Creating a new Menu Item<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>&nbsp;Go to Administration &gt; Authoring &gt; Menu Items<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>&nbsp;Click on the new Menu item from the list on the right side.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>&nbsp;Enter a Code, Item and Description.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Select Function (classic) as link type.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In the &#8216; Function &#8216; field, enter AIMP ~ &lt;Report Code&gt;<\/li>\n<\/ul>\n\n\n\n<p>\u00a0 for example AIMP ~ &lt;BALGRP><\/p>\n\n\n\n\n\n<p>Click on Save Button. Test the setting by clicking on the title of your report in the list<\/p>\n\n\n\n<p>on the right side. As shown in below figure 2.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><imgtarget=\"_blank\" rel=\"noopener noreferrer\"><img fetchpriority=\"high\" decoding=\"async\" width=\"208\" height=\"247\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px;\"  src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/03\/Figure-2.webp\" alt=\"Options\" class=\"wp-image-28611\"\/><figcaption class=\"wp-element-caption\"><strong>Fig02: Options<\/strong><\/figcaption><\/figure>\n\n\n\n<p><strong>Adding Menu Items to our desired Modules<\/strong>&nbsp;<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Go to Administration &gt; Authoring &gt; Pages&nbsp; &gt; Menu Submodules<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><imgtarget=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" width=\"1024\" height=\"246\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px;\"  src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/03\/Figure-3-1024x246.webp\" alt=\"Menu Submodule\" class=\"wp-image-28612\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/03\/Figure-3-1024x246.webp 1024w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/03\/Figure-3-300x72.webp 300w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/03\/Figure-3-768x184.webp 768w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/03\/Figure-3-660x158.webp 660w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/03\/Figure-3.webp 1334w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><strong>Fig03: Menu Submodule<\/strong><\/figcaption><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click on the &#8216;Pencil&#8217; to Edit the Modules.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click on the &#8216;Add Button &#8216; to display report.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Select the menu item created in the previous step.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><imgtarget=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" width=\"1024\" height=\"282\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px;\"  src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/03\/Figure-4-1024x282.webp\" alt=\"Menu Items\" class=\"wp-image-28613\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/03\/Figure-4-1024x282.webp 1024w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/03\/Figure-4-300x83.webp 300w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/03\/Figure-4-768x212.webp 768w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/03\/Figure-4-1536x424.webp 1536w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/03\/Figure-4-660x182.webp 660w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/03\/Figure-4.webp 1922w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><strong>Fig04: Menu Items<\/strong><\/figcaption><\/figure>\n\n\n\n<p>Save the changes once finished . Also, logout the Sage X3 and login to see the changes.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><imgtarget=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"296\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px;\"  src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/03\/Figure-5-1024x296.webp\" alt=\"Trial Balance Report Screen\" class=\"wp-image-28614\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/03\/Figure-5-1024x296.webp 1024w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/03\/Figure-5-300x87.webp 300w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/03\/Figure-5-768x222.webp 768w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/03\/Figure-5-660x191.webp 660w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/03\/Figure-5.webp 1171w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><strong>Fig05: Trial Balance Report Screen<\/strong><\/figcaption><\/figure>\n\n\n\n<p>And click on the menu in the above figure we can see the Trial Balance Report Menu is been added in Financial Module, we can click and the report will open now and we need to pass the parameter. As shown in figure&nbsp; 6 below.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><imgtarget=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"306\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px;\"  src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/03\/Figure-6-1024x306.webp\" alt=\"Report Parameters\" class=\"wp-image-28615\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/03\/Figure-6-1024x306.webp 1024w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/03\/Figure-6-300x90.webp 300w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/03\/Figure-6-768x230.webp 768w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/03\/Figure-6-660x197.webp 660w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/03\/Figure-6.webp 1264w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><strong>Fig06: Report Parameters<\/strong><\/figcaption><\/figure>\n\n\n\n<p>Our report is now added to the module and now we can print the report.<\/p>\n\n\n\n<p><strong>About Us<\/strong><\/p>\n\n\n\n<p><a href=\"https:\/\/www.greytrix.com\/\">Greytrix<\/a> &#8211; 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 X3 (Sage Enterprise Management) offerings &#8211; a Sage Business Cloud Solution. Our&nbsp;unique GUMU&#x2122; integrations include <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> 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 <a href=\"https:\/\/www.greytrix.com\/africa\/product\/consulting\/implementation-planning\">Sage X3<\/a> (Sage Enterprise Management). Currently we are <a href=\"https:\/\/www.greytrix.com\/africa\">Sage X3 Implementation Partner<\/a> 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 <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/pos-system\">POS<\/a> | <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/warehouse-management-system\">WMS<\/a> | <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/payment-gateway\">Payment Gateway<\/a> | <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/shipping-system\">Shipping System<\/a> | <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/business-intelligence\">Business Intelligence<\/a> | <a href=\"https:\/\/www.greytrix.com\/product\/sage-x3\/ecommerce-magento-integration\">eCommerce<\/a> and have developed add-ons such as <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-add-ons\/catch-weight\">Catch \u2013 Weight <\/a>&nbsp;and <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-add-ons\/letter-of-credit\">Letter of Credit<\/a> for Sage X3 to Sage business partners, end users and Sage PSG worldwide.<\/p>\n\n\n\n<p>Greytrix is a recognized <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> for GUMU&#x2122; Sage X3 &#8211; Sage CRM integration also listed on <a href=\"https:\/\/www.sage.com\/marketplace\/asb_ListingDetail?listingId=a1h24000007PC3aAAG\" target=\"_blank\" rel=\"noopener\">Sage Marketplace<\/a>; GUMU&#x2122; integration for Sage X3 &#8211; Salesforce is a 5-star app listed on <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>As a user in Sage X3, you may have to run specific reports as part of your daily routine. Setting up a report as a single item for a particular module can help improve work flow and minimize any confusion you may have on which report to run. In the example below, we will be\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/2024\/03\/05\/how-to-add-a-single-report-to-sage-x3-modules\/\">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":[3642,2,5,3162,6,8,10,2796,11],"tags":[4049,1272,3875,1426,1653,4051,1762,1822,1839,2871,1945,4050],"class_list":["post-28609","post","type-post","status-publish","format-standard","hentry","category-sage-x3","category-configuration","category-features","category-greytrix","category-installation","category-sage-erp-x3","category-standard","category-technical","category-tips","tag-menu-ites","tag-menu-profile","tag-modules","tag-parameters","tag-report","tag-report-parameters","tag-sage-enterprise-management","tag-sage-x3","tag-sage-x3-blogs","tag-sage-x3-functional-blogs","tag-sage-x3-technical-blogs","tag-submodules"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/28609","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=28609"}],"version-history":[{"count":2,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/28609\/revisions"}],"predecessor-version":[{"id":28618,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/28609\/revisions\/28618"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=28609"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=28609"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=28609"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}