{"id":19471,"date":"2018-06-08T05:38:38","date_gmt":"2018-06-08T05:38:38","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=19471"},"modified":"2024-04-24T06:41:47","modified_gmt":"2024-04-24T06:41:47","slug":"customized-ui-for-export-sales-details-in-csv-format","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/06\/08\/customized-ui-for-export-sales-details-in-csv-format\/","title":{"rendered":"Customized UI for Export Sales Details in CSV Format"},"content":{"rendered":"

As we know we can do as many validations & customizations in Sage 300 with respect to the data for our end users. We have developed new customized UI for exporting Sales Data in CSV format so that the customer can get the detailed Sales Data for a particular month in which he can tally all the invoices including their respective items & customers.
\nNew Stuff:-<\/strong>Barcode integration with shipment Screen in Sage300<\/a>
\nThe UI which we have created are as follows:
\n\"Sales<\/a>
\nIn the above UI we have provided date filter with Export & Close button. We have provided folder path for exporting 3 files in which we have displayed data as per Sales Invoices, their respective Customers & Item Details.<\/p>\n

    \n
  1. Sales: <\/strong>The data which are displaying in Sales Sheet are as follows:<\/li>\n<\/ol>\n

    \"Sales<\/a>
    \nIn the above screenshot of our sales sheet we have exported the detailed data of Sales Invoices in     Sage 300 ERP<\/a>.
    \n\u00a0 \u00a0 \u00a02. Items :<\/strong>
    \nSimilarly we have exported data of Items in Item Sheet in which we are showing the details of all the items which are used in the Sales Data.
    \n    \"Data\"<\/a>
    \nAs per the above screenshot, we have exported all the details of the particular item used in the Sales Invoices for the respected customers.
    \n\u00a0 \u00a0 \u00a03. Customer :<\/strong>
    \nSimilarly, we have exported Customer Sheet to show the detailed data of the particular customers for the specific Sales Invoices.
    \n    \"Information\"<\/a>
    \nThe main purpose of this blog is to show the end user all the Sales Data with their respective customers & items for the particular month in     Sage 300 ERP<\/a>.
    \nAbout Us<\/u><\/strong>
    \nGreytrix is a one stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.
    \n    Greytrix<\/a>\u00a0has unique solutions of\u00a0Sage 300 integration with Sage CRM,<\/a>\u00a0Salesforce.com\u00a0<\/a>and\u00a0Magento eCommerce<\/a>. We have the migration expertise of Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works<\/a>. We work on the latest Sage 300c technologies and offer best-in-class\u00a0Sage 300 | Sage 300c customization and development services<\/a>.\u00a0 This include upgrading old codes, creating new web screens, delivering new reporting tools like Sage Intelligence, PowerBI and SAP BO to Sage business partners, end users and Sage PSG worldwide.
    \nFor more details on Sage 300 | Sage 300c Services, please contact us at\u00a0    accpac@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"

    As we know we can do as many validations & customizations in Sage 300 with respect to the data for our end users. We have developed new customized UI for exporting Sales Data in CSV format so that the customer can get the detailed Sales Data for a particular month in which he can tally\u2026 Read More »<\/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":[2],"tags":[2528,2532,2533,2534,2543],"class_list":["post-19471","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-sales","tag-sales-details","tag-sales-details-export","tag-sales-export","tag-sales-invoice-info"],"yoast_head":"\nCustomized User Interface for CSV Export of Sales Data<\/title>\n<meta name=\"description\" content=\"Explore Introducing our unique (UI) that allows users to easily total bills, items, and customers by exporting comprehensive monthly sales data in CSV format.\" \/>\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\/2018\/06\/08\/customized-ui-for-export-sales-details-in-csv-format\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Customized User Interface for CSV Export of Sales Data\" \/>\n<meta property=\"og:description\" content=\"Explore Introducing our unique (UI) that allows users to easily total bills, items, and customers by exporting comprehensive monthly sales data in CSV format.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/06\/08\/customized-ui-for-export-sales-details-in-csv-format\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-08T05:38:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-24T06:41:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/06\/11-2.png\" \/>\n<meta name=\"author\" content=\"sage300\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"sage300\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 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\/2018\/06\/08\/customized-ui-for-export-sales-details-in-csv-format\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/06\/08\/customized-ui-for-export-sales-details-in-csv-format\/\",\"name\":\"Customized User Interface for CSV Export of Sales Data\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/06\/08\/customized-ui-for-export-sales-details-in-csv-format\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/06\/08\/customized-ui-for-export-sales-details-in-csv-format\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/06\/11-2.png\",\"datePublished\":\"2018-06-08T05:38:38+00:00\",\"dateModified\":\"2024-04-24T06:41:47+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"description\":\"Explore Introducing our unique (UI) that allows users to easily total bills, items, and customers by exporting comprehensive monthly sales data in CSV format.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/06\/08\/customized-ui-for-export-sales-details-in-csv-format\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/06\/08\/customized-ui-for-export-sales-details-in-csv-format\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/06\/08\/customized-ui-for-export-sales-details-in-csv-format\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/06\/11-2.png\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/06\/11-2.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/06\/08\/customized-ui-for-export-sales-details-in-csv-format\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Customized UI for Export Sales Details in CSV Format\"}]},{\"@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\/1aced4e22c30ccf606960de27c9542f5\",\"name\":\"sage300\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/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\":\"sage300\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Customized User Interface for CSV Export of Sales Data","description":"Explore Introducing our unique (UI) that allows users to easily total bills, items, and customers by exporting comprehensive monthly sales data in CSV format.","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\/2018\/06\/08\/customized-ui-for-export-sales-details-in-csv-format\/","og_locale":"en_US","og_type":"article","og_title":"Customized User Interface for CSV Export of Sales Data","og_description":"Explore Introducing our unique (UI) that allows users to easily total bills, items, and customers by exporting comprehensive monthly sales data in CSV format.","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/06\/08\/customized-ui-for-export-sales-details-in-csv-format\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2018-06-08T05:38:38+00:00","article_modified_time":"2024-04-24T06:41:47+00:00","og_image":[{"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/06\/11-2.png","type":"","width":"","height":""}],"author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/06\/08\/customized-ui-for-export-sales-details-in-csv-format\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/06\/08\/customized-ui-for-export-sales-details-in-csv-format\/","name":"Customized User Interface for CSV Export of Sales Data","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/06\/08\/customized-ui-for-export-sales-details-in-csv-format\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/06\/08\/customized-ui-for-export-sales-details-in-csv-format\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/06\/11-2.png","datePublished":"2018-06-08T05:38:38+00:00","dateModified":"2024-04-24T06:41:47+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"description":"Explore Introducing our unique (UI) that allows users to easily total bills, items, and customers by exporting comprehensive monthly sales data in CSV format.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/06\/08\/customized-ui-for-export-sales-details-in-csv-format\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/06\/08\/customized-ui-for-export-sales-details-in-csv-format\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/06\/08\/customized-ui-for-export-sales-details-in-csv-format\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/06\/11-2.png","contentUrl":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/06\/11-2.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/06\/08\/customized-ui-for-export-sales-details-in-csv-format\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Customized UI for Export Sales Details in CSV Format"}]},{"@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\/1aced4e22c30ccf606960de27c9542f5","name":"sage300","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/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":"sage300"},"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/19471","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/comments?post=19471"}],"version-history":[{"count":2,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/19471\/revisions"}],"predecessor-version":[{"id":34143,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/19471\/revisions\/34143"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=19471"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=19471"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=19471"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}