Sage 300 ERP – Tips, Tricks and Components
Greytrix is one of the oldest Sage Development Partner of two decades and Reseller of Sage 300 ERP (formerly known as Sage Accpac ERP) and has been awarded "Sage Partner of the Year" multiple times for rendering quality services for Sage product lines both as developers and resellers. Greytrix has accumulated hundreds of man years of experience in Sage 300 ERP. In these blogs, Greytrix will endeavour to share its knowledge with regards to implementation, training, customisation, components, current technology trends and help users to understand in depth techno – functional aspects of Sage 300 ERP! Contact our team at accpac@greytrix.com
Follow us on LinkedIn Follow us on Twitter Follow us on Facebook Follow us on YouTube
Skip to content
  • Home

Export utility and Un-reconcile functionality in GL Clearing

By Greytrix | November 30, 2020
0 Comment

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 GreyMatrix, Document Attachment, Document Numbering, Auto-Bank Reconciliation, Purchase Approval System, Three way PO matching, Bill 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.

Related Posts

  • GL Export utility
  • Sales Export Report Utility
  • Bank Master Export Utility
  • Vendor Master Export Utility
  • Customer Master Export utility
Category: Sage 300 Tags: GL account, GL Clearing, GL Reconciliation, Non-Reconciled transactions, Reconciled transactions
Post navigation
← Order Entry invoice forms How to use BlkPut to save data into Sage 300 using Advantage API in C# →

Greytrix Websites and Blogs

  • Greytrix
  • Greytrix Africa
  • Greytrix Australia
  • Sage X3 – Tips, Tricks and Components
  • Sage 100 & 500 ERP Tips and Tricks
  • Sage CRM – Tips, Tricks and Components
  • Salesforce.com Tips and Tricks by Greytrix
  • Sage Business Cloud – Tips, Tricks and Components
sage crm and sage 300 integration

Categories

  • Sage 300
    • ACCPAC SDK
  • Sage 50 US
  • Sage Business Cloud
  • TDS
  • Uncategorized

Recent Posts

  • Stronger Default Security for Login Password in Sage 300 v2021
  • Installation of web Customization in Sage 300c v 2019.1
  • How to change setting of number of active window for Sage 300c web page
  • Possible Cause and Resolution for UAC popup while opening Sage 300 Customized screen
  • How to use BlkPut to save data into Sage 300 using COMAPI in VB6.0

Archives

Awards

Greytrix Top ISV Partner
Greytrix Revenue Growth Enterprise Business
Greytrix Africa Highest Revenue
Greytrix Prtner of the Year
Greytrix Partner Award
Copyright 2019
Sage 300 ERP – Tips, Tricks and Components
Iconic One Theme | Powered by Wordpress