Selecting customers for basic dunning letter notification

Dunning Letter Select uses aging bucket values stored on CompanyCustomer and, when applicable, CompanyCustomerProcessLevel. The Receivable Activity Summary job populates these values.

If the job does not run recently, aging data is missing or outdated and selection may be incorrect. Run Receivable Activity Summary before Dunning Letter Select. When using Process Level or Process Level Group, set Break by Process Level to Y.

Use this procedure to select customers for basic dunning letter notification.

  1. Select > Receivables > Processing > Credit And Collections.
  2. On the Dunning Letters panel, select Basic Dunning Letter Select.
  3. Specify this information:
    Company
    Specify the receivable company to process and evaluates all customers under that company. An error displays if the company does not exist in the ReceivableCompany table.
    Report Option
    Specify the report option which controls the scope of customer evaluation.
    • Company Level Only - Processes customers at the company level by comparing customer aging to company thresholds, with optional filtering by Process Level or Process Level Group.
    • Company & National Account - The job processes National Account relationships first, converting aging to the customer group currency and comparing it to National Level thresholds. When selected, Process Level and Process Level Group cannot be used.
    Process Level
    Specify the receivable process level. When provided:
    • Evaluates aging only at that process level (CompanyCustomerProcessLevel).
    • Defaults the dunning text code from the Process Level if missing at company level.
    • Cannot be used with Process Level Group.
    • Cannot be used when Report Option is Company & National Account.
    Process Level Group
    Specify the receivable process level report header. When provided:
    • Resolves all process levels in the group and evaluates each per customer.
    • Uses the same dunning text code defaulting as Process Level.
    • Cannot be used with Process Level.
    • Cannot be used when Report Option is Company & National Account.
  4. On the Cycle Code panel, specify Receivable Cycle List. This is an optional dunning cycle filter. When values are entered, only matching customers are processed, and when left blank, all customers are included.
  5. On the Company Level panel, specify this information:
    Amount
    Specify the amount of the minimum past‑due threshold. The customer qualifies only if aging in the bucket is greater than zero and exceeds this amount, and zero or blank rows are ignored.
    Text Number
    Specify the dunning letter text code for this aging level. If blank with an amount, the system defaults from the Process Level, and an error is displayed if no Process Level or Process Level Group is provided.
    Iso Locale
    Specify the locale used to validate the dunning letter text. An error is displayed if no matching company, text number, and locale record exists.
    When Text Number is blank, the system uses the customer’s LanguageCode, and evaluates aging from the highest bucket to bucket 1, selecting the first (most severe) match.
  6. On the National Level panel, specify this information:
    Amount
    Specify the amount of the minimum past‑due threshold. The customer qualifies only if aging in the bucket is greater than zero and exceeds this amount, and zero or blank rows are ignored.
    Text Number
    Specify the dunning letter text code for this aging level. If blank with an amount, the system defaults from the Process Level, and an error is displayed if no Process Level or Process Level Group is provided.
    Iso Locale
    Specify the locale used to validate the dunning letter text. An error is displayed if no matching company, text number, and locale record exists.
    Uses the same structure as Company Level, but applies only when Report Option is Company & National Account, and evaluates national account aging after conversion to the customer group currency.
  7. Click Submit.