AR Aged Analysis By Project Manager

You can use the AR Aged Analysis By Project Manager report to age outstanding invoices by project manager. You can access this report by selecting Accounts Receivable > Reports > AR Aged Analysis By Project Manager.

Note: Because the project manager is entered in the Job (or Project) Master, which may only be assigned to one contract, the report will only include the Project Manager on the first job code linked to the Contract. Note that only billing and receipt information posted to Contracts with assigned project managers will be included in the aging amounts on this report. Therefore, the AR Aging or AR Aging by Customer/Contract should be used for an exact reconciliation to the AR account in General Ledger.

Report Parameters

Description

Company

Accept the default, or press F4 to select a company.

Beginning Customer

Press F4 to select the beginning customer for sorting.

Ending Customer

Press F4 to select the ending customer for sorting.

Beginning Contract

Press F4 to select the beginning contract for sorting.

Ending Contract

Press F4 to select the ending contract for sorting.

Beginning Project Manager

Click the Field Lookup button or press F4 to select the beginning project manager for sorting.

Ending Project Manager

Click the Field Lookup button or press F4 to select the ending project manager for sorting.

Through Month

Select the date-range arrows to select the month for reporting through.

Aging Date

Select the Calendar button to select the Aging Date

Level of Detail (T)rans, (I)nvoice, (C)ust

Enter an option for the level of detail for reporting: T for transaction, I for invoice, or C for customer.

Include Invoices Through Date

Select the date to include invoices through on the report.

Include Adjustments/Payments Through

Select the date to include adjustments/payments through on the report.

Aging On (D)ue or (I)nvoice Date

Enter D to display aging by the due date or I to display aging by invoice date.

Deduct Discounts?

Select the checkbox to to deduct discounts from the report.

Days Between Columns

Enter the number of days for each report column. For example, if you enter "30" the date range for each column is thirty days.

Receivable Types to Include (1,2,3 or Blank for all)

Enter the receivable types you want to see on the report, separated by a comma. To see all receivable types, leave the field blank.