Consolidate Transactions in Sage 300 ERP

By | December 5, 2013

In our previous blog, we saw the options available in sage 300 ERP to clear and consolidate posted transactions, . Here, we will have a detail view of GL Consolidate Posted transactions which allows the users to consolidate of sum up all the transactions posted in particular account or range of accounts for a particular period. This feature can be accessed by navigating to General Ledger >> GL Periodic Processing >> GL Consolidate Posted Transactions.

Before consolidating any transaction in General Ledger lets print a Transaction Listing report for period 1 of Account 1020 which we will bring up later on to discover the changes done by GL Consolidate Posted Transactions

1. GL Transaction Listing

Let’s move on to GL Consolidate Posted Transactions screen, put filter on Account Type for account 1020 and enter all required details with Consolidate By option:

GL consolidate

New Stuff: Set Document Numbering based on Bank Code for AP Module in Sage 300 ERP

Going further, reprint the Transaction Listing report for same account 1020 to check out the changes made by Consolidating feature.

2. GL transaction Listing

After consolidating all the data you will find following changes in Transaction listing report:

  • The Batch-Entry number used on reports is CNSLD.
  • The Description/Reference fields are set to CONSOLIDATED.
  • The new posting sequence number is 0
  • Source code is the one selected in GL Consolidate Posted transactions screen.
  • Transaction date is last date of selected period.

In this blog we learnt that how we can make use of GL consolidate posted transactions to save disk space and reduce detail in reports by consolidating (combining) details in the accounts for which you do not need a permanent record of every transaction.

About Us
Greytrix a globally recognized Premier Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM needs. Being recognized 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 expertise.

Greytrix offers unique GUMU™ integrated solutions of Sage 300 with Sage 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 service for applications such as POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP and in Sage 300c development services we offer services such as upgrades of older codes and screens to new web screens, newer integrations using sdata and web services  to Sage business partners, end users and Sage PSG worldwide. Greytrix offers over 20+ Sage 300 productivity-enhancing utilities that we can help you with 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.

For more details on Sage 300 and 300c Services, please contact us at We will be glad to assist you.