Printing basic dunning letters
Use this procedure to generate dunning letters by selecting overdue AR items, creating a work file, printing letters, updating customer records, and optionally creating IDM records.
You must run DunningLetterSelect before DunningLetterPrint because it creates the CompanyCustomerReviewSelect records that drive customer selection and dunning text assignment.
- Select > Receivables > Processing > Credit And Collections.
- On the Dunning Letters panel, select Basic Dunning Letter Print.
- 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.
- Process Level
- Specify a receivable process level that processes only matching CompanyCustomerReviewSelect records and invoice details. It cannot be used with Process Level Group.
- Process Level Group
- Specify a a receivable process level report header that includes and processes CompanyCustomerReviewSelect records for all included process levels. It cannot be used with Process Level.
- Alignment Forms
- Specify the number of alignment pages printed before the actual dunning letters. Accepts values 0-9. This is only visible when the company does not use IDM.
- By Currency
-
Specify the By Currency. The default value is "N".
- N - Do not print by currency code. Converts all amounts to the company’s base currency and prints one dunning letter per customer.
- Y - Print by currency code. Shows amounts in the original transaction currency and generates a separate dunning letter for each customer currency.
- Include Credits
-
Specify the Include Credits. The default value is "N".
- N - Do not include credit balance items. Credit memos are excluded from the dunning letter detail.
- Y - Include credit balance items. Credit memos are included in the dunning letter detail listing.
- Report Sequence
-
Specify the Report Sequence to control the sort order of dunning letters in the output. The default value is "N". This is only visible when the company does not use IDM.
- N - Customer Number. Letters are sorted by customer number.
- A - Customer Alpha Name. Letters are sorted by customer search name.
- P - Postal Code. Letters are sorted by the customer postal code.
- B - Customer Bill-To. Letters are sorted and addressed by customer bill-to.
- Cycle Codes
- Optional filter for dunning cycles; when cycle codes are entered, only matching customers print dunning letters. When all 10 slots are blank, no filtering applies.
- IDM Printer
- This is optional. Printer destination for IDM-generated dunning letters. It defaults to the company user’s printer and this is only visible when Use IDM is enabled.
- Aging Options
- This is optional. Only available when Company is entered, not Company Group. When enabled, it includes or excludes selected aging periods from dunning letters based on days past due, and excludes invoices in disabled periods.
- Select Aging Periods
-
This is only visible when Aging Options is enabled. Each checkbox represents an aging period defined for the receivable company.
- • For standard aging (4 periods): Periods 1–4 map to the company’s age period day ranges, and Period 5 is the “Over” bucket.
- • For expanded aging (7 periods): Periods 1–7 map to the company’s age period day ranges, and Period 8 is the “Over” bucket.
- Click Submit.