Skip to Content
Menu
This question has been flagged
2 Replies
6622 Views

I need a solution for the following situation.

Early payment discount is applicable for both customer's and supplier's invoices.

Invoice amount: EUR 121 (including 21% VAT)
Payment term: 30 days, -5% discount if paid within 7 days

What I need is for Odoo to only take the 5% discount into consideration when processing the bankstatement.

Example:
Amount received: EUR 116 (121 - (5% of 100, amount excluding VAT))
When processing receipt or paid amount via the bankstatement and selecting the invoice corresponding with the invoice for which payment has been received/done, Odoo should split the invoice selected into 2 invoice lines, 1 for EUR 116 and 1 for EUR 5.
The received amount can be reconciled with the invoice line for EUR 116 and the second invoice line for EUR 5 can manually be written off to a discount account in the P&L.

Note:
As long as the invoice status is open, 100% of the invoice amount should be included in all other reports. This means that the 5% discount is only taken into account when selecting the invoice when processing the bankstatement.
Example
- The accounts receivable and payable should include 1 invoice line for 100% of the invoice amount.
- If customer invoice status is open, the customer statement should include 1 invoice line for 100% of the invoice amount.
- The aged reports should include 1 invoice line for 100% of the invoice amount.

Thanks in advance.

Avatar
Discard

I don't see how Odoo can split an Invoice into two lines but also not split the Invoice. You can have one or the other.

Your answer clearly indicates that you do not know much about early payment discounts and accounting.

But thanks anyway.

On Wednesday, July 4, 2018, 5:55:52 PM GMT+2, Ray Carnes <rcarnes@vcloud9.com> wrote:


I don't see how Odoo can split an Invoice into two lines but also not split the Invoice. You can have one or the other.

--
Ray Carnes

Sent by Odoo Inc. using Odoo.

Please post anything else you find out - it may be that I have something to learn.

The video at https://www.youtube.com/watch?v=lagIgJBW-r4 shows you how to have Odoo split to AR into multiple pieces, but it will split it in the GL and on the Aging as well.

I'm aware of the split and that is also how Odoo works for Odoo's version of early payment discount.

But actually an early payment discount, does not mean that the invoice amount minus the discount amount is due within the discount period and the remaining balance within the payment term period. At any time 100% of the invoice amount is due within the payment term period.
The payment discount should only be considered when processing the receipt.

I have a strong feeling that I need to put my developer to work on a solutions for me.

On Thursday, July 5, 2018, 2:47:16 AM GMT+2, Ray Carnes <rcarnes@vcloud9.com> wrote:


The video at https://www.youtube.com/watch?v=lagIgJBW-r4 shows you how to have Odoo split to AR into multiple pieces, but it will split it in the GL and on the Aging as well.

--
Ray Carnes

Sent by Odoo Inc. using Odoo.

@Rene Glauser,


I can't seem to find the module account_reconcile_rule_early_payment_discount.
Could you help me with a direct link?


Thanks in advance.

Best Answer

I also wanted to make sure, in case you didn't know, that there is no need to have Invoice Lines split to reconcile them with a discounted payment from the Bank:


Follow this example with an Invoice for $2,050 being paid early with a payment of $2,000.



First (blue), you see a bank payment for $2,000 when you go to reconcile your bank statement.



Next (red), you find the matching Invoice in Odoo for $2,050.



If you click the warning, Odoo has recognized that the payment isn't enough for the Invoice, so it is prompting you to register a partial payment. Ignore this since you want to close the Invoice.  (If you did register the payment the Invoice would remain open with a balance of $50).



Instead specify the account that will be used to debit the discount.



Review that the General Ledger shows the CREDIT for the Payment and the DEBIT for the Discount.

Avatar
Discard
Best Answer

You might be interested in those two OCA modules:

account_early_payment_discount 
account_reconcile_rule_early_payment_discount

Avatar
Discard