AP Cash Requirements Report window

AccountsPayableCS > Accounts Payable > Accounts Payable Reporting menu > AP Cash Requirements Report window

The Cash Requirements Report is a list of payments that will be due or eligible for discounts within a specified date range. You can specify whether to include check payments, electronic payments, or both. The report lists all credit transactions due for each vendor plus any debit transactions that can be applied to each vendor.

Report Type

Specify the way in which you want the report sorted.

• 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.

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.

Trans Date

This is the date you anticipate paying the invoices that are either due or for which you are eligible for a discount, depending on whether you select the Use Discount Date check box or not. The system compares this date against the discount date and the due date so invoices that are due or are eligible for a discount in the date range you enter appear on the report.

Use Discount Date

If you want to see invoices that are eligible to receive an early payment discount rather than when invoices are due, select this check box. If you select the check box, only invoices that are eligible for a discount during the date range you enter will be included in the report.

To see the items that are due by those dates, you must also run the report with the check box unchecked.

Check Payments

Select this check box to include items that will be paid by check.

Electronic Payments

Select this check box to include items that will be paid electronically.

Start and End Ranges: Due Date / Discount Due Date, Vendor Number, AP Code, and User-Defined Field (if selected as Additional Filter)

Use these ranges to specify what you want 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.

Date Range

From the drop-down, select a predefined period to run the report for.

Sort by AP Code

This option is only available if you have more than one AP Code set up. Select this check box if you want to group your vendors by AP Code.