Sage 300 ERP - Tips, Tricks and Components
GL Listing report – Summarized by Accounts
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 accpac@greytrix.com.
Blog Archives
- June 2013 (14)
- May 2013 (10)
- April 2013 (9)
- March 2013 (18)
- February 2013 (14)
- January 2013 (18)
- December 2012 (14)
- November 2012 (9)
- October 2012 (4)
- September 2012 (8)
- August 2012 (7)
- July 2012 (9)
- June 2012 (18)
- May 2012 (12)
- April 2012 (4)
- March 2012 (2)
- February 2012 (2)
- January 2012 (1)
- October 2011 (3)
- September 2011 (2)
- August 2011 (9)
- July 2011 (5)
- June 2011 (6)
- May 2011 (10)
- April 2011 (7)
Tags
account Account Payable Account Receivable Accounts Payable Accounts Receivable Apparel Bank Reconciliation customer database Data Migration Document Numbering E-filing erp error Export Data Financial Reporter General Ledger Greymatrix GUMU Inventory inventory control Invoice Invoice Entry migration MMS order entry PJC portal Posting Purchase Purchase Order quickbooks receipt Receipt Entry recurring Report Reports Sage 100 ERP Sage 200 Sage 300 ERP Sage Accpac ERP Sales Order Shipment TDS transactions






