Summary

The Outstanding Balances Report will display any LEMS level outstanding balances for each work order included in the report.

Step by Step

1     Open the Outstanding Balances Report window (WO> Reports> Outstanding Balances).

2     Configure the report.

• Select a Report Type.
  • The Summary report will display the Work Order Number, Description, Status, Category, Billable Status, and AR Account. Each Work Order will also display a breakdown of the Beginning Balance, Activity, Billing, and Total amounts for each LEMS category on the work order, all LEMS categories combined on the work order, and all LEMS categories on the report as a whole.
  • The Detail report will display everything included in the Summary report as well as the Transaction Date, LEMS category for the transaction, Line Number, Reference Type, Reference Code, Reference Description, Activity amount, and Billing amount.
• Enter a Work Order or click the field label to select one from a list.
• Select a work order Status from the drop-down menu.
  • The work order status is specified on the Work Order Maintenance window (WO> Work Orders> Work Orders> open a work order> Status drop-down menu).
• Select a Billable Status from the drop-down menu.
  • The work order billable status is specified on the Work Order Maintenance window (WO> Work Orders> Work Orders> open a work order> Billable drop-down menu).
• Enter a work order Category code or click the field label to select one from the list.
  • Category codes are created and maintained on the Category Code Maintenance window (WO> Maintenance> Category).
• Specify an activity date range in the Activity From and Activity To fields.
• Check the Include uncommitted activity toggle to include entries that have not been committed.
• Check the Include uncommitted billings toggle to include pending billing transactions in the report.
• Check the Page break by work order toggle if you would like each work order to start on a new page.

3     Print the report.

• Click the Print icon to process the report immediately or enter a date and time in the field next to the Print icon to schedule the report to generate at a later time. You can view the progress of the report on the Job Viewer window (SS> Utilities> Show Scheduled Jobs).
  • Click the Print icon drop-down menu and select Print Preview to preview the report before printing.
  • Click the Print icon drop-down menu and select Excel to export the report data to an Excel spreadsheet as unformatted data.
  • Click the Print icon drop-down menu and select Excel (Formatted) to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
  • Once the report is generated, you can also display the report using the View Reports window (SS> Utilities> View Report).