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.
TagsAccount Payable Account Receivable Accounts Payable Accounts Receivable Accpac Bank Reconciliation Bill of Material BOM customer Data Migration Document Numbering erp ERPMIG error Financial Reporter General Ledger Greymatrix Greytrix Extended Report Pack Greytrix TDS Integration 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 Accpac Sage Accpac ERP Sales Order Shipment Shipment Entry TDS transactions