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 GST Sales Outward Register Representative in order to handle this problem.
New Stuff: API for PW Requisition Entry Import
In this blog, we are discussing the GST sales register which we have customized as per client requirements.
As you can see in below screenshot user may sort the data ‘From’ and ‘To’ Date, From’ and ‘To’ 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.
Kindly review the details in the Output of sales register report below.
As you can see in the above screenshot the included customized fields are visible along with data.
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.
Field Mappings:-
• Unit of measure:- This will be the Detail line Unit of Measure field from the OE Invoice Screen.
• 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.
• 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.
• GL Code:- This will be the detail Revenue Account field from the AR Invoice Screen.
• Description:- This will be the detail line Description field for the Revenue Account from the AR Invoice Screen.
• INCOTERMS:- This will be the header optional field of OE invoice screen.
• SEGMENT:- This will be the optional field of the IC Item screen.
• PO Number:- This will be the PO No. Field of OE Invoice screen.
• Category:- This will be the category field of the IC Item master screen.
• IRN:- This will be from the capture IRN screen for the generated document.
• TCS :- This will be from detail level TCS (Tax Authority) from the OE invoice screen.
• Tracking No.:- This will be the Tracking No. field customer tab of the OE Shipment Screen.
The report will instantly export data in Excel format, allowing the user to quickly sort the data as desired.
NOTE:-We can customize this report as per the client‘s requirement.
About Us:-
Greytrix – 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.
Greytrix offers unique GUMU™ integrated solutions of Sage 300 with Sage CRM, Salesforce.com, Dynamics 365 CRM and MagentoeCommerce along with Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 300 customization and development services and integration services for applications such as POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP 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, Document Attachment, Document Numbering, Auto-Bank Reconciliation, Purchase Approval System, Three way PO matching, Bill of Lading and VAT for Middle East. The GUMU™ integration for Dynamics 365 CRM – Sage ERP is listed on Microsoft Appsource with easy implementation package.
For more details on Sage 300 and Sage 300c Services, please contact us at accpac@greytrix.com, We will like to hear from you.