Interest amount in Payment/Allocation

Description

Adds Interest Amount in the payment window, allowing company to record additional amount when paying/receiving invoices (usually due to late payment). It's the opposite of the discount field.

Environment

None

Activity

Show:
Alan Lescano
April 18, 2017, 5:27 PM

Hi
This patch covers a case when the interest is an additional amount for a specific invoice payment, and makes more sense to tie it to that invoice. We should be able to see how much interest was allocated to a invoice, in the same way we do with discounts and write off, Furthermore, automatic bank reconciliation would be a problem because we would have 1 transactions in the real bank account, but 2 in iDempiere. Allocate payment to charge is an useful feature for many other user cases.
What do you think?

Alan Lescano
April 18, 2017, 5:54 PM

, this feature is partially implemented in the window Bank Statement. It is possible to add an interest amount there. But it's impracticable in automated payment means, and in automatic bank reconciliation. This patch just takes the interest amount to payment/allocation, creating a more dynamic way to insert that information

Carlos Ruiz
April 18, 2017, 5:55 PM

Thanks for the explanation.

Let me try a possible second approach. What about something like C_ChargeWriteOff_ID.

In my head I think it can work something like this:

  • at this moment write off amount is posted against a configured account in BP Group

  • with my idea if the write-off field has a value then the user can optionally fill a charge in the new field C_ChargeWriteOff_ID

  • if there is a charge write off - then the account used for write-off will be that one, otherwise will default to the same that we're using now

What is the advantage of this?
In my opinion is because you just found one of the cases where a payment/receipt can generate a valid difference, interests, but there are other cases where you can receive (or pay) more or less money for different reasons.
With the charge-write-off approach we would cover ANY case, instead of requiring to add new fields for different cases.

Look that in your implementation you have an issue because the interest revenue account you are using is about the bank interests, and this kind of interest from due invoices must go to a different account, that can be solved instead with the charge approach as you configure your interest revenue or interest expense charges properly.

WDYT?

Regards,

Carlos Ruiz

Alan Lescano
April 18, 2017, 6:05 PM

Yes, you are right about the bank interest account. It would be necessary additional ones.
Great idea about the C_ChargeWriteOff_ID. I will spend some time on this matter. Maybe the interest field, should be implemented only in the brazilian localization

Orlando Curieles
August 22, 2020, 6:34 PM

Closed as potential idea, 3 years without activity

Assignee

Alan Lescano

Reporter

Alan Lescano

Tested By

None

Components

Priority

Minor
Configure