GL Export utility

A General Ledger batch generated in Sage 300 ERP is group of many journal entries, each of the journal entry contains atleast two transaction details. One detail line is the debit amount and another is for the credit amount. These such entries and batches will not affect G/L account balances until we post the batches in Sage 300 ERP

Use the G/L Journal Entry screen to:

  • Create new batches
  • Add journal entries to existing batches
  • Change and delete journal entries
  • View and reverse posted batches or entries
  • Add intercompany transactions for a Sage 300 ERP Intercompany Transactions (ICT) company.
  • Drill down on posted and unposted entries that originated in other Sage 300 ERP ledgers to view source transactions.

New Stuff: –Project Job Costing – Project Style option in Contract Maintenance

You cannot edit entries in batches that have been deleted or posted. However, you can automatically create a reversing entry in a new batch that means both batches are created separately and for detailed purposes, users need to check each batch separate manually.

Therefore, we have created a utility for GL batch details where the user can export all the GL details based on user-specified from and to posting date, and below are details of user Interface of GL Export utility. (Refer below screenshot)

GL Export utility-user Interface

GL Export utility-user Interface

From and to GL batch Number: – This will header level GL batch Number field.

From and to Posting date: – This will Posting date field.

Path to select excel file:- Path specify Purpose.

Export button: – Export the data on the specified path.

Close button: – for UI closing purpose.

As you can see in the above screenshot and mention above details, the user will be able to specify ‘From’ and ‘To’ GL batchnumber and GL PostingDate, based on the same, the report will be generated also users need to select an appropriate path for data generation purpose.

Now click on the Export button, the system will generate Details of GL batch on the Mentioned path from GL Journal Entry screen.

GL Export utility-Output

GL Export utility-Output

Below is the excel-based generated output of the “GL batch” report.

  • Batch Number: – Header level batch number field.
  • Batch Desc: – Header level batch Desc field.
  • Entry Date: – Header level Entry Date field.
  • Source Code: – Source Code field.
  • Account Id:- detailed level Account  number field

With the help of ‘” GL batch export utility” the user can maintain all the details of GL batch in a single generated excel sheet where the user can check credit and the debit amount and other respective details of Batch and this activity become easy instead of doing manually.

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 customizations, data migration, system integrations, 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 Magento eCommerce 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 integrations 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 GreyMatrixDocument AttachmentDocument NumberingAuto-Bank ReconciliationPurchase Approval SystemThree way PO matchingBill 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.

The post GL Export utility appeared first on Sage 300 ERP – Tips, Tricks and Components.

You May Also Like

About the Author: Optimize Our Inventory

Leave a Reply

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