Generating advanced dunning letter file

Advanced Dunning Letter File Generation produces the dunning letter output. It reads selected dunning records and generates print files, CSV files, and optional IDM documents.

The job builds a work file with customer, invoice, and dunning text data, then generates the final output. When enabled, it also updates dunning history, customer records, and sets the dunning cycle status to Complete.

  1. Select > Receivables > Processing > Credit And Collections.
  2. On the Dunning Letters panel, select Advanced Dunning Letter File Generation.
  3. Specify this information:
    Company
    Specify the receivables company to process. You must specify either Company or Company Group but not both.
    Company Group
    Specify a General Ledger company group that processes all member companies. It cannot be used with Company, Process Level, Process Level Group, or Aging Filter.
    Print File
    Specify a value.The default value is "N".
    • N - Do not generate a print file. Tthe dunning letter print report is suppressed and generates only the CSV output.
    • Y - Generate a print file. Produces a formatted dunning letter that includes customer details, dunning text, and a list of open items with key transaction and balance information.
    CSV File
    Specify a value. The default is "Y".
    • Y - Yes: Generate a CSV file containing all dunning letter transactions.
    • N - No: Do not generate a CSV file.
    • C - Collection: Generate a CSV file containing only transactions flagged for collection (Send to Credit Agency = “Y” on the dunning letter level).
    • E - Exclude Collection: Generate a CSV file excluding collection-level transactions. Only non-collection transactions are included.
    Update History
    Specify a value. The deafult is "N".
    • N - Do not update history. The job generates output files without updating history or customer records and sets the dunning cycle status to Generated, allowing review before finalizing.
    • Y - Update history. The job creates dunning history for qualifying transactions, updates the customer’s last dunning information, adds a customer comment, and sets the dunning cycle status to Complete.
    .
    Report Options
    Specify a value. The default is "N". This controls the sort order and addressing of dunning letters.
    • N - Customer Number: Letters are sorted by customer number and addressed to the customer’s primary address.
    • B - Customer Bill-To: Letters are sorted and grouped by customer bill-to. Each bill-to address receives its own dunning letter containing only the invoices associated with that bill-to.
    Letter Format
    Specify a value. The default is "00" and only visible when company does not use IDM.
    • 00 - Standard: The default letter format with customer address, company return address, dunning text, and transaction detail.
    • 01 - Sweden: An alternate format that includes additional global address formatting specific to Swedish postal conventions.
    File Name
    Specify a custom file name for the output files, up to 50 characters. If blank, the default name is used.
    Company Collection ID
    Specify an identifier for the company in external collection systems, up to 20 characters. This value is included in the CSV output to identify the source company.
    Include Customer Tax ID
    Specify a value. The default is "N".
    • N - The customer’s Tax ID is not included in the output.
    • Y - The customer’s Tax ID is included in the work file and output.
    IDM Printer
    The printer destination for IDM‑generated dunning letters. Defaults to the company’s user default printer. Visible only when Use IDM is enabled for the Receivable Company.
    Report By Aging
    When enabled, the system sorts the work file by aging period instead of by customer, grouping output by how far past due transactions are.
  4. Click Submit.