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 firstname.lastname@example.org.
Tags300 Account Payable Account Receivable Accounts Payable Accpac AR customer Bill of Material BOM customer Document Numbering erp ERPMIG error General Ledger Greymatrix Greytrix TDS GUMU Inventory inventory control Invoice migration Optional Fields order entry Peachtree PJC Purchase Order quickbooks Report Report Manager Reports sage Sage 50 Sage 50 US Sage 300 Sage 300 2012 ERP Sage 300 ERP Sage 300 ERP 2012 Sage 300 ERP 2014 Sage 300 ERP Intelligence Sage Accpac Sage Accpac ERP Sales Order Shipment Shipment Entry TDS