Use the Cash Requirement Report to forecast your immediate cash needs for invoice payments. You can submit this report before every payment batch to determine your cash requirements for the batch. You can also submit this report for the next two or three payment batches to forecast your cash requirements for the future and improve your cash management.
You can submit this report for a single currency or for all currencies. The report is ordered by currency and lists cumulative invoice totals in the invoice currency. The report provides in your ledger currency a sum of all invoices of each currency, and a sum of all invoices on the report. The report alerts you if any invoices in the currency are missing exchange rates.
This report lists unpaid or partially paid invoices that match parameters you enter. The report does not include cancelled or fully paid invoices.
If you submit the Cash Requirement Report with No for the Summary Option parameter, the report lists all unpaid or partially paid invoices for a currency, by payment date and supplier name, starting with those invoices with the earliest due or discount date. Payables subtotals the amount due for each supplier and then for each payment date.
If you submit the Cash Requirement Report with Yes for the Summary Option parameter, the report lists the cash requirements by supplier for each currency and each payment date without displaying each invoice.
Note that this report may include invoices that you plan to pay with future dated payments. If the payment date you specify is before the expected maturity date, you will not require immediate cash to pay those invoices. You can submit the Bills Payable Maturity Date Report to help plan your cash needs for future dated payments.
Include Unvalidated Invoices. Enter Yes to include all unvalidated invoices in the report. Enter No to exclude unvalidated invoices. When you use this option, the amount of an unvalidated invoice may change before payment. For example, Invoice Validation has not completed certain tax calculations, or the invoice may be on hold for an amount related issue.
Include Unapproved Invoices. Enter Yes to include all unapproved invoices in the report. Enter No to exclude unapproved invoices.
Pay Through Date. Payables includes invoices that have either a due or discount date that falls on or before the Pay Through Date you enter.
Payment Date. Enter the payment date that you want Payables to use for this report. If you choose No for the Pay Only When Due report parameter, and the discount falls on or before the payment date, Payables reports the discounted amount, rather than the full invoice amount.
Template. Enter or select the template to use.
Summary Option. Enter Yes to submit the Cash Requirement Report in summary. The summary Cash Requirement Report displays the payment amount due to the suppliers included in the report, but does not display individual invoice information. Enter No to submit the Cash Requirement Report in detail.
Include Selected Invoices. Enter Yes to include all selected invoices in the report. Enter No to exclude selected invoices.
Amount. Amount due for an invoice in the invoice currency. If you choose Yes for the Pay Only When Due report parameter, Payables prints the total amount remaining for payment of an invoice. If you choose No, Payables prints the total amount remaining for payment on an invoice, less available discounts.
Payables includes the discounted amount, rather than the full invoice amount, if the discount date is on or before the Payment you enter.
Validated. Payables prints Yes if the invoice is Validated, No if the invoice is not validated, or, if the invoice has holds applied to it, Payables prints the number of holds. If you choose No for the Include Unvalidated Invoices report parameter, Payables does not include any invoices on hold in the report.
Cumulative Total in [Functional Currency]. At the end of the report, Payables prints in your ledger currency the sum of all invoice amounts in the report.
Cumulative Total. Cumulative total of invoice amounts, printed in the invoice currency. Payables prints a cumulative total after each Total for [Supplier].
Currency Total for [Foreign Currency]. After each complete list of foreign currency invoices, Payables prints in the invoice currency the sum of the foreign currency invoice amounts.
Date. If you choose Yes for the Pay Only When Due report parameter, Payables prints the payment due date for an invoice. If you choose No, Payables prints the discount date for an invoice.
Description. Invoice description.
Total for [Supplier]. Payables prints in the invoice currency the sum of invoice amounts for each supplier for each Date (Discount Date or Payment Date depending on your Pay Only When Due report parameter).
Total in [Functional Currency]. Currency Total for [Foreign Currency] printed in your ledger currency.