Generating automatic cash application report

  1. Sign in as Receivables Specialist, Receivables Manager, or Receivables Administrator.
  2. Select Run Receivables Processes > Receivables Automatic Application > Automatic Cash Application.
  3. In the Selection section, specify this information:
    Company
    Select a company number.
    Selected Applications Only
    If you select this check box, then only selected status records are processed:
    • Records from transactions that were processed in the EFT Payment Creation action.
    • Records from transactions that were from online applications that have not been processed.

    If this field is not selected, then in addition to processing selected status records, eligible payments are used to create application records.

    Operator
    If you select the Operator ID Required field in Company, then specify an operator code.
    Post Date
    Select the Global Ledger posting date. If this field is blank, then the Batch Date is the default. If both the Batch Date and the Post Date fields are blank, then the application date is the default.
    Post Date Override
    If you select a Post Date field, then select whether this date overrides the Global Ledger dates that are assigned to individual payments.
    Payment Batch
    If you are automatically applying payments for a specific batch only, then select the payment batch number. If this field is blank, then all payment batches for the company are processed.
    National Account Credits
    Select whether national account credits are processed.
    Override Method
    Select an override method for automatic cash application. For balance forward customers, payment remittance records can be interfaced, but those remittance records can only be applied if the remittance override method is selected.
    Cash Application Code
    If User Defined is selected for the Override Method, select a cash application code.
    Currency Override
    Select whether payments can be applied to open items with different base currencies.
  4. In the Algorithm section, specify this information:
    Variance
    If you select Algorithm in Override Method, then specify the variance amount that is used with one-to-one matching.
    Reason Code
    If you specify a variance amount, then select a reason code. A shortage adjustment is created by the system for the difference between the payment and transaction amount.
    Maximum Invoices
    If you select Algorithm in Override Method, then specify the maximum number of oldest invoices used for one-to-one matching.
    Combination
    If you select Algorithm in Override Method, then specify the maximum number of oldest invoices combined.
  5. Click OK.