Running the Cash Impact Report
- Open the Cash Impact Report.
-
Select the type of transactions to include on the report:
- A/R: Prints the A/R invoices with open balances on the report.
- A/P: Prints the A/P vouchers with open balances on the report.
- Both: Prints both A/P vouchers and A/R invoices with open balances on the report.
-
Specify this information:
- A/R Early Pay Discounts
- Select this check box to include the net (discounted) amount from invoices on the report. Clear this check box to include the gross (not discounted) amount from all invoices on the report.
- A/P Early Pay Discounts
- Select this check box to include the net (discounted) amount from all vouchers on the report. Clear this check box to include the gross (not discounted) amount from all vouchers on the report.
- Credit Hold
- Select whether you want to include orders where the customer
is on credit hold:
- Yes: Include only those customers who have been placed on credit hold. Only the orders that were placed after the customer was put on credit hold will display on the report.
- No: Include on the report only those customers not on credit hold.
- Both: Include all customers regardless of credit hold status.
- Payment Hold
- Select whether you want to include vendors who are on payment
hold:
- Yes: Include only those vendors who you have placed on payment hold on the report.
- No: Include only those vendors not on payment hold on the report.
- Both: Include all vendors regardless of payment hold status.
- Starting/Ending Currency
- Select the range of currency codes you want to include on the report. If you leave these fields blank, the system includes all codes.
- Translate to Domestic Currency
- Select this check box to translate amounts in the report to the domestic currency.
- Use Historical Currency Rate
- Select this check box to print the report using the Historical Currency Rate. The Historical Currency Rate is the exchange rate used when a transaction was created. Clear the check box if you do not want to print the report using the Historical Currency Rate. Clearing the check box causes the report to print transactions using the current exchange rate at the time you print the report.
- Summary or Detail
- For a summary of the report information, select Summary. For a detailed report, select Detail. Detail includes a breakdown of individual transactions.
- Customer Payments Basis
- Select the column in which to display the amount:
- Due Date = Due Date + number of days for the Terms
- Average Late = Invoice Date + the Customer's Average Number of Days Outstanding
- Latest Ever = Invoice Date + the Customer's Largest Number of Days Outstanding
- Most Recent = Invoice Date + the Customer's Last Days Outstanding
- Display Report Header
- Select this check box to include report headers in the output.
- Number of Days Lookback
- Specify the number of days between the first and second bucket.
- Number of Days per Column
- The number of days between buckets two through six is displayed.
- Click Preview to view the output before running the report.
- Click Print to run the report and print the output.
Parent topic: Finance Module