Interest calculation upon clearing by reset cleared payment

[Former Member]

Could you please help us on the following issue?

Scenario

Invoice 1 : $50  (posted on 01/07 with due date of 15/07)

Payment 1 :-$50  (received on 10/07, cleared invoice 1)

Invoice 2 : $40  (posted on 01/09 with due date of 15/09)

Reverse the invoice 1 on 01/11. Payment 1 becomes open again.

On 02/11, through account maintenance, Payment 1 now clears invoice 2 and remaining $10 remain open. Clearing date of invoice 2 is 02/11.

Because the invoice 2 was due on 15/09 but was cleared only 02/11, interest will be charged for period between due date and clearing date(between 15/09 to 02/11).

However, this payment was originally made on 10/07 and thus customer shouldn't be charged with interest.

Could you please guide us on how do we can get around this issue?

Regards,

Devang

[AmlanBanerjee · Accepted solution]

Hi Devang,

As the standard Interest calculation, takes clearing date as the baseline for calcultaing interest, so by normal configuration you will not be able to acheive the requirement.

However, your requirement can be met by customization.

First Option-Event 2010.

In this event, the you will find the clearing document (AUGBL) under FKKOP structure.

Take the Clearing payment document and pass it to DFKKO to find the origin key and the posting date.

If the origin key is 05, then its a payment document and if the posting date < the invoice due date, then raise exception Item_Blocked.

Second Option-Event 2065

In event 2065, you can change the date for the Interest Calculation To for clearing items. 

For amounts cleared in the account maintenance, as standard the due date of the invoice and clearing date of both items are used to calculate the interest.

In event 2065 you can use the due date of the invoice amount and the value date of the payment amount to calculate the interest for amounts cleared in the account maintenance.

Hope one of the above options will cater your requirement.

Thanks,

Amlan

[Former Member]

Hi Amlan,

Thanks a lot for your prompt  help. I will go ahead with event 2065. Thanks again.

Regards,

Devang