Skip to Content
0
Former Member
Jan 20, 2012 at 12:04 PM

Create a program for Automatic calculation of Interest on arrears for Custo

89 Views

Hello Experts,

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:

Interest term:

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

-Posting;

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,

Satya