Dunning Wizard, Step 5: Recommendation Report

This window lists the transactions and documents, grouped by customers, for which SAP Business One recommends creating dunning letters. You can select the customers and documents to be included in the dunning run.

Note Note

This topic documents fields and other elements in this window that either are not self-explanatory or require additional information.

End of the note.

Recommendation Report Fields

Time
The exact time you displayed the Recommendation Report. Transactions and/or documents that comply with the specified parameters, but were posted after the displayed time, are not included in the recommendation report, and therefore will not be dunned in this run.

User
The name of the user who initiated the dunning wizard run.

Include Payments Up To
Specify a date that informs customers up until when payments were last recorded in the application. Customers who have made payments after this date will know that they can disregard the dunning letter. Example An SAP Business One user runs the dunning wizard on Monday morning, August 16, 2010. However, payments received during the weekend have not been entered in the application yet. The customer receiving the reminder is informed that the payment made during the weekend is not yet applied and the dunning letter can therefore be disregarded. End of the example.

New Due Date
Date to be displayed on printed dunning letter informing customer by when the company expects the payment for outstanding items. This date is not copied to displayed invoices or manual journal entries of type invoice.

Customer Code
The codes of the selected customers. Use the Expand/Collapse icon to view the documents and/or transactions related to a specific customer.

Letter No.
The successive numbers of the dunning letters that are recommended for a specific customer. Use the Expand/Collapse icon to view the list of transactions and/or documents included in each letter.

Level
Dunning level associated with the respective document and/or transaction. If required, you can change this value up to the level defined in the dunning term assigned to the customer.

Doc. No.
The document type, document number, and the specific row number in the document to which the dunning run is applied. Example The value IN 172/1 indicates that the dunning run is applied to A/R invoice no. 172, row number 1 in the journal entry created by the A/R invoice. This row is the one that is posted to the customer. End of the example. Note If the document type is JE (manual journal entry), OB (opening balance), or BC (closing balance), the row numbering starts with 0 and not with 1. So the value JE 285/0 would represent the first row in journal entry no. 285. End of the note.

Due Date
The due date of each document or transaction to be dunned in this dunning run. If you specified a different due date in the New Due Date field, the new date is considered in the dunning run.

Last Dunning Date
Date of the last dunning run, if a transaction or document was included in a previous dunning run.

Document Amount (FC)
Relevant only for foreign currency documents. The original total amount of the document or the journal entry in foreign currency (FC). Negative amounts represent transactions in which the customer is credited (such as incoming payments).

Document Amount (LC)
The original total amount of the document or the journal entry in local currency (LC). Negative amounts represent transactions in which the customer is credited (such as incoming payments). When you enter a local currency amount, the foreign currency is not calculated accordingly.

Open Amount (FC)
Relevant only for foreign currency documents. The amount of the document or transaction that is not yet paid, credited, or reconciled in foreign currency (FC). This is the amount to be dunned in this dunning run. Negative amounts represent transactions that credit the customer (such as A/R credit memos). These transactions are not dunned.

Open Amount (LC)
The amount of the document or transaction that is not yet paid, credited, or reconciled in local currency (LC). This is the amount to be dunned in this dunning run. Negative amounts represent transactions that credit the customer (such as A/R credit memos). These transactions are not dunned. When you enter a local currency amount, the foreign currency is not calculated accordingly.

Interest Days
The number of days for which interest is calculated. You can change this value if required. The days are counted from the due date of the document or transaction, and based on the number of days in one month as defined in the Dunning Terms - Setup window.

Interest %
The interest rate for the dunning period. The calculation is based on a formula comprising the annual interest rate and the number of interest days in the year as defined in the Dunning Terms - Setup window. Example Number of days in year: 360 Annual interest rate: 14% Interest days: 53 Interest % = (Interest days X Annual interest rate)/number of days in year (53X14%)/360=2.06% End of the example.

Interest Amount (FC)
The interest amount in foreign currency (FC) calculated for this document or transaction. The calculation is based on the definitions made in the Dunning Levels - Setup and Dunning Terms - Setup windows. If required, you can change the amount. When you enter a foreign currency amount, the local currency is calculated accordingly.

Interest Amount (LC)
The interest amount in local currency (LC) calculated for this document or transaction. The calculation is based on the definitions made in the Dunning Levels - Setup and Dunning Terms - Setup windows. If required, you can change the amount. When you enter a local currency amount, the foreign currency is not calculated accordingly.

Total incl. Interest (FC)
The total amount to be dunned per document or transaction, including the interest amount, if it exists, in foreign currency (FC). You can change this value if required. When you change the foreign currency amount, the local currency is calculated accordingly. In the letter row, the total amount to be dunned with this letter (from all the transactions and/or documents), including the interest amounts for each document or transaction. If you change the total or interest amount of a specific transaction/document, the total of the letter is updated accordingly.

Total incl. Interest (LC)
The total amount to be dunned per document or transaction, including the interest amount, if it exists, in local currency (LC). You can change this value if required. When you change the local currency amount, the foreign currency is not calculated accordingly. In the letter row, the total amount to be dunned with this letter (from all the transactions and/or documents), including the interest amounts for each document or transaction. If you change the total or interest amount of a specific transaction/document, the total of the letter is updated accordingly.

Fee (FC)
The fee per letter in foreign currency (FC), as defined in the Dunning Terms - Setup window. If you change this amount, the new fee is applicable for the current letter only. When you enter a foreign currency amount, the local currency is calculated accordingly.

Fee (LC)
The fee per letter in local currency (LC), as defined in the Dunning Terms - Setup window. If you change this amount, the new fee is applicable for the current letter only. When you enter a local currency amount, the foreign currency is not calculated accordingly.

Overall Total (FC)
The total amount per letter in foreign currency (FC), including the interest and fee.

Overall Total (LC)
The total amount per letter in local currency (LC), including the interest and fee.

Auto Posting
Indicates whether interest and fee, interest only, fee only, or neither of the two is posted automatically when executing the dunning run and creating dunning letters. The default value is taken from the business partner master data. You can change the setting, if required.

More Information

Dunning Wizard