Running the Cash Impact Report

  1. Open the Cash Impact Report.
  2. 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.
  3. 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.
  4. Click Preview to view the output before running the report.
  5. Click Print to run the report and print the output.