Previous | Next | Contents | Index | Navigation | Glossary | Library |
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 functional 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.
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.
Include Unapproved Invoices. Enter Yes to include all unpaid invoices in the report, regardless of their hold status. Enter No to exclude invoices on hold.
Suggestion: If you use the Cash Requirement Report to predict cash needs for a future payment batch, it is best to exclude invoices on hold, since Payables also excludes invoices on hold during payment batches.
Pay Group. Enter the Pay Group for which you want to run the report or leave the field blank to submit the report for all Pay Groups.
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.
Payment Method. Payables includes invoices with the payment method you enter. Leave the field blank to submit the report for all payment methods.
Currency. Enter the currency for the invoices you want to include in the report or leave the field blank to submit the report for all currencies. Payables orders the report by currency and prints the currency code at the top of each page of the report.
High Priority (1)/Low Priority (99). Payables includes all invoices with a payment priority between the high and low priority values you enter (1 is the highest priority, 99 is the lowest).
Payables includes the discounted amount, rather than the full invoice amount, if the discount date is on or before the Payment you enter.
Approved. Payables prints Yes if the invoice is Approved, No is the invoice is not approved, or, if the invoice has holds applied to it, Payables prints the number of holds. If you choose No for the Include Unapproved 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 functional 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 functional currency.
Previous | Next | Contents | Index | Navigation | Glossary | Library |