AP Dated Invoice / Payment Report window

AccountsPayableCS > Accounts Payable > Accounts Payable Reporting menu > AP Dated Invoice / Payment Report window

The Dated Invoice/Payment Report determines the total amount due in Accounts Payable at any specific time for an AP Code or range of vendors.

Report Type

Select the amount of detail to print on the report.

• Detailed: the detailed report includes transaction information for each invoice, including original and current amount due, and any debits or discounts you could apply.

• Summary: the summary report includes original and current amount due for each vendor, including any debits and/or discounts that are available. No individual transaction information is included.

AP Code

From the Lookup, select the AP Code you want to group by. This option is only available if you have more than one AP Code defined. Select All to print for all AP Codes (default).

Report Date

The report date sets the date that will be used to calculate the balance due.

Display Days Back

The number you enter in this box will determine which transactions will include detail in the report. If you enter 10 in this box, then detail will be included for all transactions within 10 days of the report date. All transactions that occurred prior to that date will be listed, but will not include detail.

Additional Filter

If you defined User-Defined Fields in the AP Module Preferences window, they will be available here as an additional filter for the report.

Start and End Range: Vendor Number (and User-Defined Field, if set up as Additional Filter)

Use these ranges to specify the vendors and/or items to include in the report. Leave the defaults of Start and End to include all values for a particular range or use the Lookup to enter the starting and/or ending value to include.

Exclude Vendors with a balance of $0 as of

Select this check box to remove any vendors with zero balances from the report. The date for this option defaults to the current system date.