How to Solve GL Error Batch in Sage 300 ERP

By | December 30, 2013

Have you come across GL Error Batches while using Sage 300 ERP and are unable to understand and solve them? Something Like ‘ERROR BATCH – Entries from batch ‘0000001’’ are Error batches generated by Sage 300 as a record of the entries which couldn’t be posted due to some wrong selections/settings by the users.

These batches serve 2 functions, 1 to notify the user that his/her batch is not posted and hence there is no Financial Impact on General Ledger, 2 to serve as a replica of the entry/s for posting after rectification of the wrong selections/setting

GreyMatrix: Integrated Apparel Solution for Sage 300 ERP

Once you see a batch with Description starting with ‘Error Batch’ you can run posting journals report.

In sage 300 ERP, Navigate to General ledger ->GL Reports -> Posting journals -> Posting Journal errors and click on a print button.

GL Posting Journals

When you click on print button, the system will generate a report which will show all Journal posting errors.

Print posting journal

 

In Above screenshot, we can see [Entry no. 1] in [batch no 1609] Posting was failed because Period 9 (Month “Dec”) was locked for General Ledger in common services ‘Fiscal Calendar 2014’ and after posting of batch No 1609, a system has created an error batch No. “1610”.

New Stuff: Setting up Price Inclusive of Taxes in Sage 300 ERP

Now first we have to identify, whether we are posting batch incorrect date or not? If posting date is Right, then we have to unlock the fiscal Period 9 and post the error batch “1610”.

If wrong posting date is set in batch, then correct the posting date in Batch No “1610” and post batch.

Common General Ledger Posting Errors and Fixes in Sage 300
Error: Posting to a locked fiscal period
Fix: Review all GL batch entries and confirm that you are posting the entries in a correct fiscal period. If you are posting in a correct period and a period is locked then unlock the fiscal period in common services->Fiscal calendar
Error: Invalid Input, Account code is not defined in General ledger
Fix: Mostly this type of error comes through sub-ledgers like “AP”,”AR”,”PO”,”IC”,”OE”, check If you have set segment override functionality in IC location master and for that particular location GL account is not created then system will create an error batch.
Create account code in a chart of account master for that particular location and post the error batch.
Error: Cannot Post to an Inactive Account
Fix: Review the GL batch entry and confirm that you are not posting the entries in the account, which is inactive in a chart of account.  If you have selected wrong GL account then correct it in error batch and repost the batch.
Error: Debit credit amount is not matching
Fix: Review the GL batch entry and confirm that debit credit amount is matching. If debit credit amount is not matching then the system will not post the batch and always create an error batch.
Error: Cannot post to a future year
Fix: Create a new fiscal year in a fiscal calendar in common services
Error: Journal detail source ledger XX is not on the control account’s XXXX eligible list
Fix: Review the GL Account setup and add the source ledger that you want to post to the control account.
Thus, by following the above-mentioned steps users can find the actual cause of GL posting error and can solve the error batches.

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, Salesforce.com 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 GreyMatrixDocument AttachmentDocument NumberingAuto-Bank ReconciliationPurchase Approval SystemThree way PO matchingBill of Lading and VAT for Middle East.

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