Aged Work In Progress Report

The Aged Work in Progress report provides a breakdown of billable and no-charge costs that have not yet been invoiced and posted in Accounts Receivable for projects that use item invoices.

You can print the report showing totals for a selected range of contracts or for selected ranges of contracts and projects.

All the projects in a contract are grouped and subtotaled by currency.

The report groups costs into a current period and four aging periods. It also shows:

• The last invoice date and the total work in progress amount for each contract.

• An aged work in progress amount for each project.

• Aged work in progress amounts and total work in progress amounts for each customer.

• A total work in progress amount for the report.

Print the report any time you want a report of work in progress amounts.

Before you start

• Post in Accounts Receivable any unposted batches (including documents with zero totals) created in Project and Job Costing to ensure that the Aged Work in Progress report is up to date.

To print the Aged Work in Progress report:

1. Choose the Aged Work In Progress icon from the PJC Analytical Reports folder.

2. Specify the following report options:

• Age As Of. Specify the date on which to report the work in progress amounts. The program uses this date to assign amounts to aging periods by calculating the number of days between the transaction date and the Age As Of date.

• Cutoff By

  The report includes only those transactions or balances with a document date before the cutoff date you specify.

  There are two methods for selecting a cutoff date:

  • Transaction Date. Use this method if you want to include all transactions up to a specific date that is not the fiscal period end date. Enter a date in the Cutoff Date field.

  • Fiscal Year/Period. Use this method if you want to include all transactions up to the end of a fiscal period. Make your selection in the Year/Period field.

• Sort By

  Specify whether to sort costs on the report by customer or by currency, if you use multicurrency in your system.

  If you sort by customer, the report shows subtotals for each contract and customer in the customer's currency. It also provides a report total for each currency.

  If you sort by currency, the report shows subtotals for each contract in the customer's currency. It also provides a report total for each currency

• Print By. Specify whether to list amounts by contract only or by contract and project.

• Customer Number/To Customer Number. Specify the range of customers you want to include on the report.

• Contract/To Contract. Select the range of contracts for which you want a report.

• Project/To ProjectThese fields appear if you selected Contract And Project in the Print By field. Select the range of projects that you want to include on the report.

• Contract Start Date/To Contract Start Date. Select a range of contract start dates, if you want to limit the report to contracts that began within the specified range of dates. (If you do not specify a range, the program prints the report regardless of the contract start dates.)

• Project Start Date/To Project Start Date. This field appears only if you selected Contract And Project in the Print By field. Select a range of project start dates, if you want to limit the report to projects that began within the specified range of dates. (If you do not specify a range, the program prints the report regardless of the project start dates.)

• Contract Status. If you want to limit the report to contracts with a certain status, specify the status in this field.

• Project Status. This field appears if you selected Contract And Project in the Print By field. If you want to limit the report to projects with a certain status, specify the status in this field.

• Work In Progress Balance/To Work In Progress Balance. To limit the report to significant project or contract balances, specify the threshold amounts using these fields.

• Include Contracts And Projects With A Zero Balance. Select this option to include contracts and projects on the report whether or not they have unbilled balances in the work in progress account.

• Use Aging Periods. The aging periods you defined for your system appear in these fields, but you can change them.

3. Click Print.

Related Topics