Sage 300 ERP supports the concept of Payable clearing account which has credit effect at the time of PO receipt and has Debit effect at the time of PO invoice.
Below mentioned table will give you clear idea.
If we go with the financial effect mentioned in the above table it implies that our Payable clearing account should always have zero balances provided all the PO receipts has been invoiced.
News Stuff: Hide Cost at GRN Level
But, sometimes it may happen that payable clearing account possesses some balance. The reason may be either PO invoice is pending for particular receipts or the user has passed GL-JE using this account etc.
Sage 300 ERP facilitates a very useful report named as “Payable Clearing Audit List” which helps us to perform audit activity for an account.
Let us see how this report works. Below mentioned is the UI of the report which you will find when you navigate through Purchase order>>>P/O Analytical Reports>>>Payables Clearing Audit List
We can extract this report account set wise and period wise.
The output of the report displays the list of receipts and Invoices with vendor number, vendor Name, Debit and credit effect to the account, Document date and Document number.
This data is enough for carrying out audit activity for the account.
For e.g. if you see the document number IN175116 debit amount is 78.48 and document number RCP00000032 credit amount is 78.48 both the documents have the same vendor one document is receipt and another is Invoice which implies this transaction is complete, mark it as done and move forward.
By following this practice you can track open receipts against which Invoice is not done. Once you have the list of receipts against which invoice is not been raised, go ahead and raise the invoice by which your payable clearing account will become zero.
If still the account shows the balance then you will have to perform other practice to track the balance source like, you can use GL transaction listing report which will list down all the list of transaction which have been carried out using this account.
You can also use GL transaction History screen to verify whether any transaction other than source ledger AP, IC and PO is been done using this account. Please refer below screen shot.
You can further drilldown to the individual transactions for a particular period by selecting and double-clicking on the individual line it will take you to the actual entry.
Reverse the entry and do it from the respective sub ledger.
To restrict users from doing such type of entries you can follow another best way which is to mark this account as control account which ensures that only transaction from source ledger PO, AP and IC will only be posted to this account otherwise an error batch will get generated in GL batch list.
To mark an account as control account you can go through our related blog which will guide you for marking an account as control account.
GL Control Account Feature in Sage 300 ERP
In this way we can perform an audit for Payable clearing account which will indeed help us to maintain Ledger-Sub ledger
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 GreyMatrix, Document Attachment, Document Numbering, Auto-Bank Reconciliation, Purchase Approval System, Three way PO matching, Bill 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.