{"id":34921,"date":"2024-08-29T08:43:59","date_gmt":"2024-08-29T08:43:59","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=34921"},"modified":"2025-06-23T06:10:08","modified_gmt":"2025-06-23T06:10:08","slug":"customized-gst-sales-register-report-in-sage300","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2024\/08\/29\/customized-gst-sales-register-report-in-sage300\/","title":{"rendered":"Customized GST Sales Register Report in Sage300"},"content":{"rendered":"\n

Since the GST Sales Outward Register is crucial to the SAGE 300<\/a>, as everyone knows. The information from the GL Batch screens, OE Transactions, Credit notes, Debit notes, and AR Invoices are included in the GST Sales Outward Register Report. Posting transactions for some data ranges might be challenging to track down. We established a GST Sales Outward Register Representative in order to handle this problem.<\/p>\n\n\n\n

New Stuff: API for PW Requisition Entry Import<\/a><\/p>\n\n\n\n

In this blog, we are discussing the GST sales register which we have customized as per client requirements.<\/p>\n\n\n\n

As you can see in below screenshot user may sort the data \u2018From\u2019 and \u2018To\u2019 Date, From\u2019 and \u2018To\u2019 Customer, and ‘From’ and ‘To’ Customer group, ‘From’ and ‘To’ Location, ‘From’ and ‘To’ Item no., ‘From’ and ‘To’ Item Category. Once file path is selected then based on the same, the report will be generated required data in excel-based format.<\/p>\n\n\n\n

\"Utility<\/a><\/center>\n
Fig 1: Utility of Sales Register Report<\/center><\/font>\n\n\n\n

<\/p>\n\n\n\n

Kindly review the details in the Output of sales register report below.<\/p>\n\n\n\n

\"\u00a0Output<\/a><\/center>\n
Fig 2: Output of Sales register report<\/center><\/font>\n\n\n\n

<\/p>\n\n\n\n

As you can see in the above screenshot the included customized fields are visible along with data.<\/p>\n\n\n\n

Below are the Additional columns that are included in this Customized report. It gives wide information on the sales as well as GST E invoice details of the Sales done.<\/p>\n\n\n\n

Field Mappings:-<\/strong><\/p>\n\n\n\n

\u2022 Unit of measure:- This will be the Detail line Unit of Measure field from the OE Invoice Screen.<\/p>\n\n\n\n

\u2022 Sale Price:- This will be the Discounted Extended Amount field from the OE Invoice screen. In the case of Item type for AR transaction then need to capture the detailed extended amount value. For the Summary type for AR transactions then need to fetch the detail Amount value of the AR transaction screen.<\/p>\n\n\n\n

\u2022 Cost:- This will be the detailed Extended cost\/amount field of the OE Invoice and AR Invoice screen. In the case of AR summary type the value will be blank.<\/p>\n\n\n\n

\u2022 GL Code:- This will be the detail Revenue Account field from the AR Invoice Screen.<\/p>\n\n\n\n

\u2022 Description:- This will be the detail line Description field for the Revenue Account from the AR Invoice Screen.<\/p>\n\n\n\n

\u2022 INCOTERMS:- This will be the header optional field of OE invoice screen.<\/p>\n\n\n\n

\u2022 SEGMENT:- This will be the optional field of the IC Item screen.<\/p>\n\n\n\n

\u2022 PO Number:- This will be the PO No. Field of OE Invoice screen.<\/p>\n\n\n\n

\u2022 Category:- This will be the category field of the IC Item master screen.<\/p>\n\n\n\n

\u2022 IRN:- This will be from the capture IRN screen for the generated document.<\/p>\n\n\n\n

\u2022 TCS :- This will be from detail level TCS (Tax Authority) from the OE invoice screen.<\/p>\n\n\n\n

\u2022 Tracking No.:- This will be the Tracking No. field customer tab of the OE Shipment Screen.<\/p>\n\n\n\n

The report will instantly export data in Excel format, allowing the user to quickly sort the data as desired.<\/p>\n\n\n\n

NOTE:-<\/strong>We can customize this report as per the client\u2018s requirement.<\/p>\n\n\n\n

About Us:-<\/strong><\/p>\n\n\n\n

Greytrix<\/u><\/a> \u2013 a globally recognized and one of the oldest Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customization, data migration, system integration’s, third party add-on development and implementation competence.<\/p>\n\n\n\n

Greytrix<\/u><\/a> offers unique GUMU™ integrated solutions of  Sage 300 with Sage CRM,<\/u><\/a> Salesforce.com<\/u><\/a>, Dynamics 365 CRM and MagentoeCommerce<\/u><\/a> along with Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works<\/u><\/a>. We also offer best-in-class Sage 300 customization and development services<\/u><\/a> and integration services for applications such as POS | WMS | <\/a>Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP<\/a> and for Sage 300c development services we offer, upgrades of older codes and screens to new web screens, latest integration’s using Data and web services to Sage business partners, end users and Sage PSG worldwide. Greytrix offers 20+ addons for Sage 300 to enhance productivity such as GreyMatrix<\/u><\/a>, Document Attachment<\/u><\/a>, Document Numbering<\/u><\/a>, Auto-Bank Reconciliation<\/u><\/a>, Purchase Approval System<\/u><\/a>, Three way PO matching<\/u><\/a>, Bill of Lading<\/u><\/a> and VAT for Middle East<\/u><\/a>. The GUMU™ integration for Dynamics 365 CRM \u2013 Sage ERP is listed on Microsoft Appsource with easy implementation package.<\/p>\n\n\n\n

For more details on Sage 300 and Sage 300c Services, please contact us at accpac@greytrix.com<\/u><\/a>, We will like to hear from you.<\/p>\n\n\n","protected":false},"excerpt":{"rendered":"

Since the GST Sales Outward Register is crucial to the SAGE 300, as everyone knows. The information from the GL Batch screens, OE Transactions, Credit notes, Debit notes, and AR Invoices are included in the GST Sales Outward Register Report. Posting transactions for some data ranges might be challenging to track down. We established a\u2026 Read More »<\/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":[2],"tags":[4197,3574,935,3568,4198,2528,2960],"class_list":["post-34921","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-ar-export","tag-excel-export","tag-export","tag-export-utility","tag-outward","tag-sales","tag-utility"],"yoast_head":"\nCustomized GST Sales Register Report in Sage 300<\/title>\n<meta name=\"description\" content=\"Learn how to create a customized GST sales register report in Sage 300 for accurate tax filing and better sales tracking. Simplify your GST compliance today.\" \/>\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\/sageaccpacerp\/2024\/08\/29\/customized-gst-sales-register-report-in-sage300\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Customized GST Sales Register Report in Sage 300\" \/>\n<meta property=\"og:description\" content=\"Learn how to create a customized GST sales register report in Sage 300 for accurate tax filing and better sales tracking. Simplify your GST compliance today.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2024\/08\/29\/customized-gst-sales-register-report-in-sage300\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2024-08-29T08:43:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-23T06:10:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2024\/08\/image.png\" \/>\n<meta name=\"author\" content=\"Greytrix\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Greytrix\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2024\/08\/29\/customized-gst-sales-register-report-in-sage300\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2024\/08\/29\/customized-gst-sales-register-report-in-sage300\/\",\"name\":\"Customized GST Sales Register Report in Sage 300\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2024\/08\/29\/customized-gst-sales-register-report-in-sage300\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2024\/08\/29\/customized-gst-sales-register-report-in-sage300\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2024\/08\/image.png\",\"datePublished\":\"2024-08-29T08:43:59+00:00\",\"dateModified\":\"2025-06-23T06:10:08+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/93977cd8aa8fbd1f151d3f664e29c9f2\"},\"description\":\"Learn how to create a customized GST sales register report in Sage 300 for accurate tax filing and better sales tracking. Simplify your GST compliance today.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2024\/08\/29\/customized-gst-sales-register-report-in-sage300\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2024\/08\/29\/customized-gst-sales-register-report-in-sage300\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2024\/08\/29\/customized-gst-sales-register-report-in-sage300\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2024\/08\/image.png\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2024\/08\/image.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2024\/08\/29\/customized-gst-sales-register-report-in-sage300\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Customized GST Sales Register Report in Sage300\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\",\"name\":\"Sage 300 ERP \u2013 Tips, Tricks and Components\",\"description\":\"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! \",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?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\/sageaccpacerp\/#\/schema\/person\/93977cd8aa8fbd1f151d3f664e29c9f2\",\"name\":\"Greytrix\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g\",\"caption\":\"Greytrix\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/greytrix\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Customized GST Sales Register Report in Sage 300","description":"Learn how to create a customized GST sales register report in Sage 300 for accurate tax filing and better sales tracking. Simplify your GST compliance today.","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\/sageaccpacerp\/2024\/08\/29\/customized-gst-sales-register-report-in-sage300\/","og_locale":"en_US","og_type":"article","og_title":"Customized GST Sales Register Report in Sage 300","og_description":"Learn how to create a customized GST sales register report in Sage 300 for accurate tax filing and better sales tracking. Simplify your GST compliance today.","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2024\/08\/29\/customized-gst-sales-register-report-in-sage300\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2024-08-29T08:43:59+00:00","article_modified_time":"2025-06-23T06:10:08+00:00","og_image":[{"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2024\/08\/image.png","type":"","width":"","height":""}],"author":"Greytrix","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Greytrix","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2024\/08\/29\/customized-gst-sales-register-report-in-sage300\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2024\/08\/29\/customized-gst-sales-register-report-in-sage300\/","name":"Customized GST Sales Register Report in Sage 300","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2024\/08\/29\/customized-gst-sales-register-report-in-sage300\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2024\/08\/29\/customized-gst-sales-register-report-in-sage300\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2024\/08\/image.png","datePublished":"2024-08-29T08:43:59+00:00","dateModified":"2025-06-23T06:10:08+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/93977cd8aa8fbd1f151d3f664e29c9f2"},"description":"Learn how to create a customized GST sales register report in Sage 300 for accurate tax filing and better sales tracking. Simplify your GST compliance today.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2024\/08\/29\/customized-gst-sales-register-report-in-sage300\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2024\/08\/29\/customized-gst-sales-register-report-in-sage300\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2024\/08\/29\/customized-gst-sales-register-report-in-sage300\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2024\/08\/image.png","contentUrl":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2024\/08\/image.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2024\/08\/29\/customized-gst-sales-register-report-in-sage300\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Customized GST Sales Register Report in Sage300"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/","name":"Sage 300 ERP \u2013 Tips, Tricks and Components","description":"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?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\/sageaccpacerp\/#\/schema\/person\/93977cd8aa8fbd1f151d3f664e29c9f2","name":"Greytrix","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g","caption":"Greytrix"},"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/greytrix\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/34921","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/comments?post=34921"}],"version-history":[{"count":10,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/34921\/revisions"}],"predecessor-version":[{"id":36073,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/34921\/revisions\/36073"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=34921"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=34921"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=34921"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}