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

GL Clearing Module for Sage 300 ERP

By sageaccpac | August 26, 2013
0 Comment

General Ledger (GL) module is heart of any finance package such as ERP system. Hence, to give an upper hand to user while using GL, we have developed a custom module named GL Clearing Module for Sage 300 ERP, which will help users to carry out internal reconciliation of GL Accounts i.e. to match Debit and Credit side of Transactions in GL.
Say for an instance, when user creates a PO Receipt Transaction, it will debit Inventory and Credit Payable Clearing Account. Thereafter, PO Invoice will debit Payable Clearing and Credit Payable Account.
Hence, after Day end Processing these transaction are reflected in GL. User can view debit, credit balance for a particular account and map the same as desired using our GL Clearing module.

GL Clearing

The New Stuff: Greytrix Extended Report Pack for Sage 300 ERP
Once user select a GL Account No, he/she will be able to view GL Details  (Batch/Entry No, Line no,Transaction Date, PO Transaction Document No., Debit/Credit Amount in both source and Functional Currency)
User can select individual detail line manually for mapping. There is also a provision of mass clearing by importing an excel file in a specific format, which will select multiple detail line at once for mapping.
System will allow not allow Users to save any entry that is out of balance; it will only save document when credit and debit are matching.
Users can also print GL Clearing Report to view Reconcilled transaction/Non-Reconcilled transaction/Both for specific GL Account.
Before periodic closure of a GL Account, Accounting staff must ensure that entries in the general ledger need to be correct and are in balance. Thus, GL Clearing Module comes handy for user and become really useful when user needs to store mapping of GL Accounts transaction.
Also Read:

1. Replace Optional Fields in GL Accounts of Sage 300 ERP
2. Exclude Inactive Accounts option in GL Chart of Accounts Report of Sage 300 ERP
3. Financial Reporter made reporting tranquil in Sage 300 ERP
4. GL Account Code Change in Sage 300 ERP

Related Posts

  • GL Clearing Report in Sage 300 ERP
  • Auto Generate Document Number in GL Clearing module for Sage 300 ERP
  • Migration of GL accounts from Sage BusinessWorks to Sage 300 ERP
Category: Sage 300 Tags: GL account, GL Clearing, GL Reconcillation, Non-Reconcilled transactions, Reconcilled transactions, Sage 300 ERP, Sage Accpac ERP
Post navigation
← IAP User login failure using Windows Authentication Method Pending Order Aging Report in Sage 300 ERP →

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 Intacct– Tips, Tricks and Components
sage crm and sage 300 integration

Categories

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

Recent Posts

  • Validation on Generating Duplicate Vendor/Customer
  • Enhanced O/E Sales History Screen based on Items
  • Mailing open invoices to the customer
  • Auto Populate Updated Unit Price on OE Invoice Screen based on Contact Pricing in Sage 300
  • Export IC Adjustment details using Sage 300 Customized Utility.

Archives

Awards

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