Outward Register GST

This post was originally published on this site

Use the A/R Invoice Entry screen to:

  • Enter invoices, credit notes, and debit note that update projects in Project and Job Costing if you use that program to manage your contracts.
  • Enter prepayments with invoices.
  • If you use Payment Processing, process or void a credit card prepayment in Sage Payment Solutions.
  • Edit invoices, credit notes, debit notes, and invoices in batches created in Accounts Receivable or imported from other accounting programs but can we maintain this record with Date range?

Yes, we have developed an Export utility to track those record with selected date range criteria.

Outward Register GST Report refers to the data that is fetched from AR Invoice screen and GL Batch screen. Sometimes it is difficult to track posted transactions for particular data range. To overcome this point, we have developed a report Outward Register GST Report in Sage 300 ERP. The Report has been developed with the filter criteria given below:-

Filter criteria:

  • From Date and To Date
  • From Customer code and To Customer code

Report UI:

The user needs to select the appropriate file path, date and Customer code and then click on Export Button that he needs and export the data to excel. If the date and Customer code is within the selected range then only the data will be exported but if the date and Customer code is not within the selected range then data will not be exported and then the system will generate the error such as Records not found.

Once the user clicks on the Export button the excel sheet data which is in below screenshot will create new AR Invoices screen entries in Sage 300. This report will provide you the data of posted transaction for the selected date range and Customer code.

Below is the sample output of this report.

This report will help you to track the posted transaction type from the AR Invoice Screen for the particular date range and Customer code.

Field Mapping:

Return period:- This will be a header level Document date field from AR invoice Respective screen

DocumentType:-This will be a header level Document type field from AR invoice Respective screen.

DocumentNumber :- This will be a Header level document number field from AR invoice Respective screen

DocumentDate :- This will be a header level Document date field from AR invoice Respective screen

Original Document Number:- Incase Doc type will be Credit or Debit then we need to capture Apply to document field from AR invoice Respective screen

CustomerName:- This will be a Header level Customer name field from AR invoice Respective screen

CustomerCode:- This will be a Header level Customer Code field from AR invoice Respective screen

We have mentioned some of fields from the Report as we have include many more fields in the reports and some describe above

The report will directly export data in Excel format, so with the help of that user can easily sort the data whichever he/she wants.

NOTE:-We can customize this report & add columns as per our requirement.

 

You May Also Like

About the Author: AJ Amjad Khan

Leave a Reply

Your email address will not be published. Required fields are marked *