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.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Účtovníctvo
- Sklady
- PoS
- Project
- MRP
This question has been flagged
4
Replies
12062
Zobrazenia
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.
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.
Please be aware that in some countries this is not allowed by law (Germany for example and others).
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/
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Registrácia| Related Posts | Replies | Zobrazenia | Aktivita | |
|---|---|---|---|---|
|
0
mar 15
|
3771 | ||
|
2
sep 25
|
577 | ||
|
0
sep 25
|
9 | ||
|
0
sep 25
|
16 | ||
|
1
sep 25
|
267 |
