Dunning Process Setup

MYOB Acumatica provides you with capabilities that ease the process of producing dunning letters. For all customers, the dunning process checks customers' due documents and gives you the ability to prepare and send reminder letters of different levels of severity.

To start producing dunning letters, you define the process settings that suit your company (one-time setup) and then you run the process when needed. As a result of executing the process, you have prepared dunning letters that can be emailed to customers or printed to be sent by postal mail.

In this topic, you will read about the dunning process options offered by MYOB Acumatica and the general steps of setting up the process.

Dunning Process Options

In MYOB Acumatica, you can select how the system prepares dunning letters: by grouping overdue documents by customer account (the By Customer option) or by grouping overdue documents by customer and by the dunning level of a document (By Document). You select the appropriate option in the Dunning Process box on the Dunning tab of the Accounts Receivable Preferences (AR101000) form. By default, the By Customer option is selected. If you want more manual control over the process, you can select the By Document option.

The dunning process workflow and the rules of generating dunning letters depend on the selected option. For details, see the following topics:

We recommend that you make the Dunning Process selection when you begin implementing the process and keep that setting. You can switch from By Customer to By Document, but switching from By Document to By Customer is not recommended.

You can use the following forms to view the history of dunning letters that have been produced:

Dunning Level of a Document

A dunning level is a rule that defines a range for days past due, days to settle, and the amount of the dunning fee. A dunning level acts as a filter when you print or email dunning letters. By default, dunning level 1 has 30 days past due and 3 days to settle, and each new dunning level has 30 more days past due. When specifying these dunning settings, you can override the default values.

A dunning level is associated with a particular document (invoice or memo). The system assigns a dunning level to a document that is equal to the level of the last dunning letter that included this document. If the document has not been included in a dunning letter yet, the system sets the dunning level to 0 for the document.

You can view the current dunning level of a document in the Dunning Info section on the Financial tab of the Invoices and Memos (AR301000) form. Also, in this section, you can view the date of the last released dunning letter that included this document.

Dunning Level of a Customer Class

On the Accounts Receivable Preferences (AR101000) form, you can define the dunning levels to be used by default for new customer classes, using the most typical levels. (If you do not define them, they cannot be used for customer classes at all.) If dunning levels have been specified in the AR settings, they can also be defined for specific customer classes. For example, different dunning processes can be required for business-to-business (B2B) customers and business-to-consumer (B2C) customers, for key customers and regular customers, and for customers located in different countries.

You define the dunning levels of a customer class on the Dunning tab of the Customer Classes (AR201000) form. When you create a new customer class on the Customer Classes form, the list of dunning levels is copied to the Dunning tab from the Accounts Receivable Preferences form. A customer always inherits the dunning levels of the customer class, and they cannot be overridden for the individual customer.

For the class you are defining, you can delete unneeded levels, change the settings of existing levels, and add new levels that were not defined on the Accounts Receivable Preferences form. At any time, you can change the dunning levels specified for a customer class on the Customer Classes form and for accounts receivable on the Accounts Receivable Preferences form.

The dunning levels specified on the Accounts Receivable Preferences form are used for only the creation of new customer classes. If the dunning settings on the Accounts Receivable Preferences form are changed, the dunning level settings defined for existing customer classes are not updated. To change the dunning levels for existing customers, you should update the dunning levels of the appropriate customer class on the Customer Classes form.

Exclusion from the Dunning Process

You can exclude a customer account from the dunning process, regardless of the dunning process option selected. To do this for a customer, you should clear both the Send Dunning Letters by Email and Print Dunning Letters check boxes in the Print and Email Settings section on the Billing tab of the Customers (AR303000) form.

If you prepare dunning letters by document (that is, if the By Document option is selected in the Dunning Process box), you can exclude a particular document from the dunning process by selecting the Revoked check box that appears in the Dunning Info section of a document (the Invoices and Memos form). For instance, suppose that the dunning level of a particular document is 1, and it is time to prepare dunning letters; however, the customer has notified you that the invoice is settled, but because of bank holidays, the payment is late. By selecting the Revoked check box for the document, you can exclude this invoice from the dunning process to avoid negatively affecting your company's relations with this customer.

Note: If you prepare dunning letters by customer, a particular document cannot be excluded from the dunning process.

Dunning Fee Collection

You may want to charge your customers for the expenses your company incurs while sending dunning letters. If you do this, you can specify a numbering sequence, which the system will use when it assigns numbers to dunning fees, in the Dunning Fee Numbering Sequence box on the Accounts Receivable Preferences (AR101000) form. If you leave this box empty, when the system assigns numbers to dunning fees, it uses the numbering sequence specified in the Invoice Numbering Sequence box of the form.

On the Dunning tab of the Accounts Receivable Preferences form, you can specify the amount of the dunning fee for each level. You specify dedicated non-stock item that provides a sales account and a subaccount (if applicable) to register the collected fee, and a tax category.

Note: Make sure that a correct account and a subaccount (if applicable) are specified for the non-stock item in the Sales Account and Sales Sub. boxes on the GL Accounts tab of the Non-Stock Items (IN202000) form.

When a dunning letter of a particular level is released, the system generates an invoice for customer with the fee amount specified for the level. This invoice is created with the Balanced status. You can adjust the fee amount, if needed, and then release the invoice on the Invoices and Memos form.

Note: If the dunning fee amount is set to zero, no invoice is generated.

If you will not need to adjust any dunning fee invoices, you can configure the automatic release of the dunning fee invoices when a corresponding dunning letters are released. To do this, select the Automatically Release Dunning Fee Documents check box on the Dunning tab of the Accounts Receivable Preferences form.

Note: The amount of the dunning fee is converted to the customer's currency if the Enable Currency Override check box is cleared on the Customers form.

Appearance and Content of Dunning Letters

In MYOB Acumatica, the Dunning Letter (AR661000) report is used to generate a printed version of a dunning letter. You can control the look and feel of this report in addition to the reporting functions. You can use the default look and feel of the report, or customize the report by using the MYOB Acumatica Report Designer. You can provide settings specifying who will receive the report-based email and which format should be used, as well as possibly a specific template to be used as the email body (for email personalization). For details on modifying reports, see the MYOB Acumatica Report Designer Guide.

By using the report form, you can print a dunning letter by using the Print action on the report toolbar or email it by using the Send action. By default, the system generates an email based on the DunningLetterNotification notification template, which you can edit by using the Email Templates (SM204003) form.

If you want to print or email multiple letters at once, you can use the Print/Release Dunning Letters (AR522000) mass-processing form. The mass-emailing process requires the mailing with the DUNNINGLETTER identifier to be configured for the customer accounts that you plan to notify. For details on mailings, see Managing Mailings. For details on the configuration of a dunning letter mailing, see To Set Up a Dunning Letter Mailing.

Dunning Process Configuration

You need to perform the following steps to set up the dunning process:

  1. Dunning process setup: You can configure the process of generating and sending dunning letters on the Dunning tab of the Accounts Receivable Preferences (AR101000) form. You can specify the settings for the levels, the dunning fee details, and the sending criteria for each letter in the sequence. Also, you can define the number of days you offer a customer to settle the due document. For details on configuring the dunning process, see To Set Up the Dunning Process.
  2. Report modification: If the default design of the Dunning Letter (AR661000) report does not suit you, you can modify it by using the MYOB Acumatica Report Designer.
  3. Mailing configuration: If you plan to send dunning letter by email, you need to configure the DUNNINGLETTER mailing for a customer class or a customer. If you want to send an email attachment with the details of due documents, select the Dunning Letter report to generate it. For details on setting up a dunning letter mailing, see To Set Up a Dunning Letter Mailing.

When you have finished setting up the process, you may proceed to preparing and sending dunning letters.