AP Aged Open Payables by Job Report

The AP Aged Open Payables by Job report shows the aging of AP invoices sorted by Job. You can access this report by selecting Accounts Payable > Reports > AP Aged Open Payables by Job

The report inputs include an aging date that is used to age the invoices in the appropriate columns, a number of days between columns for more flexibility for aging invoices, a flag to allow the user control of whether or not discounts are included in the invoice amounts, and a flag for whether you want to include invoices dated after the aging date.
Note: If you select the Tax Basis is net of retainage checkbox (located on the Audit Options tab of AP Company Parameters), then the retention / holdback tax will not be included in the Hold/Retainage column. If the box is unchecked then the retention / holdback tax will be included in the Hold/Retainage column.
Report ParametersDescription

Company

Accept default, or press F4 to select company

Sort by Vendor (S)ort Name or (N)umber

Enter S to sort by vendor name or N to sort by vendor number.

Beginning Vendor Sort Name

Press F4 to select the beginning vendor name for sorting.

Ending Vendor Sort Name

Press F4 to select the ending vendor name for sorting.

Beginning Vendor Number

Press F4 to select the beginning vendor number for sorting.

Ending Vendor Number

Press F4 to select the ending vendor number for sorting.

Beginning JC Company

Press F4 to select the beginning JC company.

Ending JC Company

Press F4 to select ending JC company.

Beginning Job

Press F4 to select beginning job.

Ending Job

Press F4 to select ending job.

Include Non-Job Invoices?

Select the check box to include all non-job related invoices. If you do not select the check box, the report includes only job related invoices.

Aging Date

Accept the default or enter the aging date.

Days Between Aging Columns

Accept default or enter number of days between aging.

Select by (M)onth or (I)nvoice Date

Enter M for month or I for invoice date. Using the month option restricts invoices posted up to the through month (without regards to date). If you select the date option, the report displays transactions with invoice dates on or before the though date (without regards to month).

Through Invoice Month

Enter or select the invoice through month.

Through Invoice Date

Enter or select the through invoice date.

Age by (D)ue Date or (I)nvoice Date

Enter D to age by due date or I to age by invoice date.

Deduct Discounts

Select the checkbox to deduct discounts from amounts. If you do not select the checkbox, the report does not include discounts.

AP Pay Category (Blank for All)

Press F4 to select a pay category or leave the field blank to include all categories.

Age Non Retainage Hold Invoices

Select the checkbox for the report to age non-retainage invoices on hold. If you do not select the checkbox, the report will not age non-retainage hold invoices