Sage 300 2018 Release – GL Batch Creation in two databases simultaneously

By | July 19, 2018

How you organize your chart of accounts depends on how you intend to use a particular feature of the General Ledger system. You must decide:

  • Which accounts you need.
  • Which account segments each account requires.
  • How you will assign account numbers.

Begin by listing the accounts you need, and then decide on an account numbering scheme that suits your financial reporting requirements. Companies can sometimes get over a hundred applications for a single requirement.

Let’s take Example to understand this How Sage 300 – Creating GL Batch in two databases simultaneously?

As the previous post, we have provided a solution to handle this challenge in Sage 300 Desktop version. (Refer below link)

New Stuff: GL Batch Creation in two databases simultaneously

And here we come up with the Desktop Version and developed same in Sage 2018 Desktop Version.

Short Overview of GL Batch Creation in two databases:

We have customized GL Batch Entry screen in such a way that, The batches for which “Ready to post” is set as “Yes”, after posting them, they get posted in two databases simultaneously where one is the source and other is target database.

The user needs to select the batches and set it Ready to post to yes.

Then all the batches will get posted in the source database and also get created and posted in the target database as well as the Fiscal year and Fiscal Period will be changed according to the target database fiscal calendar setting.

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 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 We will be glad to assist you.