Customized UI for Export Sales Details in CSV Format

By | June 8, 2018

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.
New Stuff:-Barcode integration with shipment Screen in Sage300
The UI which we have created are as follows:

In 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.

  1. Sales: The data which are displaying in Sales Sheet are as follows:


In the above screenshot of our sales sheet we have exported the detailed data of Sales Invoices in Sage 300 ERP.
     2. Items :
Similarly 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.

As per the above screenshot, we have exported all the details of the particular item used in the Sales Invoices for the respected customers.
     3. Customer :
Similarly, we have exported Customer Sheet to show the detailed data of the particular customers for the specific Sales Invoices.

The 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.
About Us
Greytrix 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.
Greytrix has unique solutions of Sage 300 integration with Sage CRM, Salesforce.com and Magento eCommerce. 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. We work on the latest Sage 300c technologies and offer best-in-class Sage 300 | Sage 300c customization and development services.  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.
For more details on Sage 300 | Sage 300c Services, please contact us at [email protected]. We will be glad to assist you.