Please Check the below requirement and guide me according ly..
Upto now our client is preparing the interest manually in excel and later they issue the invoice in Finance module (DR document) and attach the paper with the calculation.
Now they would like to have an automatic process for all the customers with the exception of the Intercompany.
The keys indicator will be:
Capital * Days of delay/ 360 * interest rate(see table)
(Legend days of delay= new duedate agreed - original duedate of invoice)
-Calculate interest based on line items (open items and items cleared with a payment)
-Calendar: 360 days
-Transfer days: zero
-Tolerance days: zero
-Interest processing: amount limit 20u20AC
Terms of payment: blank (to be define case by case)
Tax code: VJ NS Art 15 I comma
The interest will be registered only if we have posted the invoice in the system.
I confirm that the account number will be 5401000 cost center C010100238
Please suggest me how we can develop a programme
Thanks in advance,