Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
4 Odpovědi
12064 Zobrazení

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
Zrušit
Nejlepší odpověď

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
Zrušit

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.

Nejlepší odpověď

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

Avatar
Zrušit
Nejlepší odpověď

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
Zrušit
Related Posts Odpovědi Zobrazení Aktivita
0
bře 15
3772
1
zář 25
168
2
zář 25
581
0
zář 25
9
0
zář 25
16