Cash Requirements General Tab

Use the General tab to select report options for the Cash Requirements report and to save sets of options for reuse.

Contents

Field Description
Report Name You can change the default report name.
Payment Date

Select one of the following to indicate the date for which you want to know cash requirements:

  • Today's Date: The report uses the current date.
  • Accounting Period End Date: The report uses the last day of the current accounting period.
  • Specific Date: The report uses the date that you specify.

This option applies only to vouchers with payment terms set to Date. DPS includes vouchers due for payment on or before the date you specify.

Format

Select one of the following report formats:

  • Voucher Detail: The report displays line detail for each voucher. Vouchers are grouped by vendor, and the report displays voucher totals and vendor totals
  • Voucher Summary: The report displays voucher amount, previous payments, discounts taken, and the amount to be paid for each voucher. Vouchers are grouped by vendor, and the report displays vendor totals.
  • Vendor Summary: The report displays totals for the following for each vendor: voucher amounts, previous payments, discounts, and amounts to be paid. The report does not display any information for individual vouchers.

The format that you select becomes part of the report name.

Liability Code To include only vouchers that are posted to a specific liability code, select the liability code. The report only displays vendors that have vouchers posted to that liability code. If you use multiple companies, the list of available liability codes is limited to those for the active company. A liability code is linked to a company in the Organization field on the Liability Accounts tab in Settings > Cash Management > Accounts Payable.
Bank Code To include only vouchers that are posted to a specific bank code, select the bank code. The report only displays vendors that have vouchers posted to that bank code. If you use multiple companies, the list of available bank codes is limited to those for the active company. A bank code is linked to a company in the Organization field in Settings > Cash Management > Banks.
Payment Currency To include only vouchers with a specific payment currency, select the currency. The payment currency for a voucher is the currency for the account that is assigned to the voucher's bank code. You select that currency in the Currency field in Settings > General Ledger > Chart of Accounts.
Exclude Negative Payments Select this check box to exclude vendors for which the net amount due for all vouchers included on the report (the vendor total in the To be Paid column) is a negative amount. Whether or not you select this option, the report always includes vendors with a positive net amount due. If a vendor has some vouchers with a negative amount but has a positive net amount due, the report displays information for both the negative and positive vouchers.

Presentation Currency

Field Description
Display Amounts in Presentation Currency Select this check box to display all amounts in a single presentation currency. In Presentation Currency, select that currency. In Exchange Rate as of, enter the date that you want used to select the exchange rates when it converts other currencies to the presentation currency.
Presentation Currency Select the presentation currency for the report. The drop-down list includes all currencies that are enabled for your enterprise.
Exchange Rate as of Enter the date that you want used to select the exchange rates when it converts other currencies to the presentation currency. The process uses the exchange rates from the daily exchange rate table for the date that you specify.