Symptom
While generating a Dunning Letter, the Table 1 calculates the Overdue Days based on the day the Dunning was created, while Table 2 (Other Open Items) calculates the Overdue Days based on the days remaining to reach the Due Date.
Please note that the Table 2 is enabled by accessing the Business Configuration Fine Tune Activity "Dunning Strategies" and selecting the box "Include Items Not Overdue".
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Receivables Work Center.
- Go to Dunning View.
- Search and select Dunning ID XYZ(XYZ represents the ID of the Dunning).
- Click on Preview > Dunning Letter.
System is calculating the Overdue Days differently from Table 1 to Table 2 (Other open items).
Table 1 calculates the Overdue Days based on the day the Dunning was created, while Table 2 (Other Open Items) calculates the Overdue Days based on the days remaining to reach the Due Date.
Cause
For the items in the Table 2 of Non-due or not Overdue Items, the overdue number of days are calculated based on the date when the Dunning Letter is being generated, since these documents are not part of the Dunning, the Dunning dates would not be relevant for them which is the case for the items being shown in Table 1 of items being dunned.
Example:
Table 1
Invoice: ABC (ABC represents the number of the invoice)
Overdue Days: 20
Table 2
Invoice: DEF (DEF represents the number of the invoice)
Overdue Days: -5
On the next day, results will be following:
Table 1
Invoice: ABC
Overdue Days: 20
Table 2
Invoice: DEF
Overdue Days: -4
Resolution
System behavior is correct.
Table 1 of the Dunning Letter will show the Overdue Days based on the day Dunning was created.
Table 2 of the Dunning Letter will show the Overdue Days based on days remaining to reach the due date.
Keywords
Dunning Letter, Dunning, Overdue Items , KBA , SRD-FIN-ACR , Receivables , How To