Export utility and Un-reconcile functionality in GL Clearing

We have seen the various blogs on our Add-on GL Clearing Module for Sage 300 ERP, and how it is helpful the users to carry out internal reconciliation of GL Accounts by matching the Debit and Credits of Transactions in GL. In our today’s blog we will see about how user is able to Un-reconcile the reconciled batches. This is one of the enhancements that we have recently added to our module.

New Stuff:- Customer and Transaction Date Filter in OE Credit/Debit Notes Form

Due to human mistakes or if user wants to rollback reconciled batches for corrections in the clearance, it is now possible to un-reconcile or delete the batches and reconcile them again. We have provided Un-Reconcile button on the screen which can be used to delete or rollback the Reconciled transactions. We will also see the functionality of export utility introduced in this new version. By using Export utility provided on the screen user will be able to export the mapped as well as unmapped entries populated on the grid. These entries will be exported into an excel sheet. User can add or modify the ‘comment’ column as well as mapped transactions column of grid by setting it to 1/ 0, Yes/No or Y/N. This exported data can then be imported using the Import option available on our UI. There is also a provision of mass un-reconciling by importing an excel file exported by the export utility, which will select multiple detail line at once for un-reconciling. System will not allow Users to delete/un-reconcile any entry that is out of balance; it will only un-reconcile document when credit and debit are matching.


Document Number Generator – User Interface


Document Number Generator – Export

With the help of customized Document Number Generator screen of GL Clearing Module user will be able to un-reconcile the reconciled batches to avoid the mistakes in clearances and Export utility makes user work more easy and fast.

About Us

Greytrix – a globally recognized and one of the oldest Sage 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 sData 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 Export utility and Un-reconcile functionality in GL Clearing 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 *