19.1.11

SAP Note 18127 - Dunning notices: dunning level lower than expected

Symptom:

Key words: SAPF150S, F150, dunning, dunning level
An account is only dunned, for example, with level 3, although invoices exist that could initiate a 4th dunning notice due to their days in arrears.

Cause and prerequisites

Generally, credit memos that have not been allocated exist, whose amount is higher than the balance of the highest dunning level.
The following example shows the logic of the dunning program:
There are 6 invoices on an account:
Amount Days/arrears Poss. dunning level
3,000.- 5 1
10,000.- 10 1
5,000.- 25 2
1,500.- 27 2
1,000.- 35 3
500.- 50 4
Furthermore, there are 2 credit memos over 2,000.- where one has an invoice reference to an invoice over 5,000.-.
In a first run, all invoices are sorted by the possible dunning level. The result is a balance per dunning level which is as follows:
Level Saldo
1 13,000.- Debit
2 6,500.- Debit
3 1,000.- Debit
4 500.- Debit
As a next step, the invoice-referenced credit memos are assigned the dunning level of the corresponding invoice and are cleared with the corresponding balance. Table of dunning balances:
Level Balance
1 13,000.- Debit
2 4,500.- Debit
3 1,000.- Debit
4 500.- Debit
Finally, the credit memos without reference to invoices are cleared, namely starting with the highest dunning level:
Level Balance
1 13,000.- Debit
2 4,500.- Debit
3 1,000.- Debit
4 1,500.- Credit
In the example, the result in the 4th dunning level is a credit balance so that no 4th dunning notice can be created. Now the attempt is made to clear the next lower dunning level:
Level Balance
1 13,000.- Debit
2 4,500.- Debit
3 500.- Credit
The balance also does not suffice for the 3rd dunning level. Next try:
Level Balance
1 13,000.- Debit
2 4,000.- Debit
Therefore, a 2nd dunning notice is written in this example.

Solution
You must ensure that for all credit memos, that belong to an invoice, the corresponding invoice reference is set. If several invoices have to be assigned, you can use one of the invoices to initiate a respective dunning level of the credit memos. A credit memo might even have to be blocked for dunning if you want to avoid a clearing with the oldest items.

No comments:

Post a Comment