Sage 300 ERP - Tips, Tricks and Components
As you know Out Of the Box GL Listing Report displays information like Credit, Debit, Net changes and Balances with Batch Entry Details grouped under Accounts in the selected range. Recently we received a requirement where they wanted to view this information at Account Level.
What we did is we parameterized the report to display information at Summary and Detail level.
Just to keep the cost low we did not include this filter or Option on the report UI, but can be done (provided we are paid for the effortsJ).
In the Detail Option we have retained the Original Out of the Box Report and in Summary option we have removed the Batch Entry Details and have summarized the information at Account Level. You can compare below screen shots to get better idea.
(Out of the box Detail Report)
If you find this content useful, please drop us an email at email@example.com.
Tags300 Account Payable Account Receivable Accounts Payable Accounts Receivable Accpac AR customer Bill of Material BOM customer Document Numbering erp ERPMIG error General Ledger Greymatrix Greytrix TDS GUMU Integration Inventory inventory control Invoice Macro migration Optional Fields order entry payment Peachtree PJC Purchase Order quickbooks Report Reports sage Sage 50 Sage 300 Sage 300 ERP Sage 300 ERP 2012 Sage 300 ERP 2014 Sage Accpac Sage Accpac ERP Sales Order Shipment Shipment Entry TDS