{"id":5435,"date":"2013-12-05T13:14:59","date_gmt":"2013-12-05T13:14:59","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=5435"},"modified":"2018-09-17T05:06:58","modified_gmt":"2018-09-17T05:06:58","slug":"consolidate-transactions-in-sage-300-erp","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/12\/05\/consolidate-transactions-in-sage-300-erp\/","title":{"rendered":"Consolidate Transactions in Sage 300 ERP"},"content":{"rendered":"

In our previous blog<\/a>, we saw the options available in sage 300 ERP to clear and consolidate posted transactions,\u00a0. 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<\/strong>.<\/p>\n

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

\"1.<\/a><\/p>\n

Let\u2019s move on to GL Consolidate Posted Transactions screen, put filter on Account Type for account 1020 and enter all required details with Consolidate By<\/b> option:<\/p>\n

\"GL<\/a><\/p>\n

New Stuff:\u00a0<\/strong><\/em>Set Document Numbering based on Bank Code for AP Module in Sage 300 ERP<\/a><\/p>\n

Going further, reprint the Transaction Listing report for same account 1020<\/b> to check out the changes made by Consolidating feature.<\/p>\n

\"2.<\/a><\/p>\n

After consolidating all the data you will find following changes in Transaction listing report:<\/p>\n