Use the General tab to select report options for the Cash Requirements Bank Summary 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.
|
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.
|
| 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
.
|
| 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
.
|
| 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.
|
