Skip ke Konten
Menu
Pertanyaan ini telah diberikan tanda
4 Replies
12069 Tampilan

I have several Partners that are both a Customer and a Vendor.  I want to offset open Customer Invoices against open Vendor Bills - and just pay the difference.

Avatar
Buang
Jawaban Terbai

This can easily be achieved: Leave the bills/invoices unpaid, and just reconcile the net difference from the bank statement line  with the bills and invoices (as this is what would have been physically paid), and Odoo will automatically create the journal entry for the net difference AND mark each bill and invoice as fully paid. It doesn't get easiler than that.

Avatar
Buang

This is now the correct answer, a much simpler method. You may have to edit the amount applied to the lower amount invoice/bill during reconcilation (make it match the amount of the invoice/bill selected).

Another easy way, where the netting can be done ahead of a bank recon, is to go to the 'journal items' list, filter by AP/AR accounts for the partner, select the netting journal items, and in actions there is the 'reconcile' option. This is particularly handy when you are netting out bills/invoices prior to any payment processing.

Jawaban Terbai

Please be aware that in some countries this is not allowed by law (Germany for example and others).

Avatar
Buang
Jawaban Terbai

Odoo does not support this by default in their UI, only transactions to the same account are reconcilable. 

However, if you don't mind a little extra work, you can create a journal by hand, crediting the Trade Debtors and Debiting the Trade Creditors to the lower amount. This can then be reconciled against both the Invoice and Vendor Bill.

There is also an OCA module that does a similar thing by selecting both journal items to automatically net off: 

https://www.odoo.com/apps/modules/10.0/account_netting/

Avatar
Buang
Post Terkait Replies Tampilan Aktivitas
0
Mar 15
3783
0
Sep 25
13
3
Sep 25
1308
1
Sep 25
219
2
Sep 25
628