Sunday, December 30, 2018

Report to Display Opening Balance, Transactions and Running Balance for all Customers

1. Navigate to Reports > Financial > Balance Sheet > Customize Detail.
2. On the Edit Layout page > Layout pane, click on the Accounts Receivable section.
3. On the Account Section pane, set the Group By field to Customer.
4. Click on the Filters link.
5. Add a filter for Account Type (Financial folder > Account (Line) sub-folder > Account Type field) and set it to equal to AcctRec.
6. Save or Preview the report.
7. Customize the report again to add/remove sections.

No comments:

Post a Comment