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 Bill of Material BOM customer Data Migration Document Numbering erp ERPMIG error Excise General Ledger Greymatrix Greytrix Extended Report Pack Greytrix TDS Inventory inventory control Invoice Macro migration Optional Fields order entry Peachtree Purchase Order quickbooks Report Reports sage Sage 50 Sage 300 Sage 300 2012 ERP Sage 300 ERP Sage 300 ERP 2012 Sage 300 ERP 2014 Sage Accpac Sage Accpac ERP Sales Order Shipment Shipment Entry Simply Accounting TDS