Skip to Content
This question has been flagged
invoicerefundcancel
8 Replies
6027 Zobrazenia
Avatar
Dino

Hello. We are using the accounting module in Odoo 10. We are new to Odoo AND do not have accounting knowledge (bad combination I know). We have made invoicing mistakes and now I need to refund/cancel/undo the invoices with errors.

When I use the "Refund Invoice" button, it responds with and error "The partner has to be the same on all lines for receivable and payable accounts!" and I cannot complete the cancellation. So what I have been doing in the meantime is creating new invoices with negative entries so that the General Ledger still balances.
However now I have a customer that has outstanding invoices and when I tried to create a new invoice with negative amounts (to cancel a previous invoice with errors), Odoo now wants to add outstanding amounts together so I cannot register a payment with these negative values.
I need help cancelling invoices that are unpaid.


Avatar
Zrušiť
Avatar
ewallindia@gmail.com
Best Answer

Hi,

the error "The partner has to be the same on all lines for receivable and payable accounts!" means that in your invoice lines' account entries' the reference for account_id is applied to different partners' receivable or payable accounts.
What I would suggest:

  1. Under the financial manager user go to accounting > adviser > journal entries. Find one which number is the same as invoice has

  2. In each line you would see the 'Account'. Ones which have positive debit are receivable. If there are 2 of them, check that they belong to the same partner. If not, try to understand why

  3. Then try to Cancel --> change account --> validate back

  4. Now accounts are the same and you can refund 


Avatar
Zrušiť
Avatar
ewallindia@gmail.com
Best Answer

Hi,

the error "The partner has to be the same on all lines for receivable and payable accounts!" means that in your invoice lines' account entries' the reference for account_id is applied to different partners' receivable or payable accounts.
What I would suggest:

  1. Under the financial manager user go to accounting > adviser > journal entries. Find one which number is the same as invoice has

  2. In each line you would see the 'Account'. Ones which have positive debit are receivable. If there are 2 of them, check that they belong to the same partner. If not, try to understand why

  3. Then try to Cancel --> change account --> validate back

  4. Now accounts are the same and you can refund 


Avatar
Zrušiť
Avatar
ewallindia@gmail.com
Best Answer

Hi,

the error "The partner has to be the same on all lines for receivable and payable accounts!" means that in your invoice lines' account entries' the reference for account_id is applied to different partners' receivable or payable accounts.
What I would suggest:

  1. Under the financial manager user go to accounting > adviser > journal entries. Find one which number is the same as invoice has

  2. In each line you would see the 'Account'. Ones which have positive debit are receivable. If there are 2 of them, check that they belong to the same partner. If not, try to understand why

  3. Then try to Cancel --> change account --> validate back

  4. Now accounts are the same and you can refund 


Avatar
Zrušiť
Avatar
ewallindia@gmail.com
Best Answer

Hi,

the error "The partner has to be the same on all lines for receivable and payable accounts!" means that in your invoice lines' account entries' the reference for account_id is applied to different partners' receivable or payable accounts.
What I would suggest:

  1. Under the financial manager user go to accounting > adviser > journal entries. Find one which number is the same as invoice has

  2. In each line you would see the 'Account'. Ones which have positive debit are receivable. If there are 2 of them, check that they belong to the same partner. If not, try to understand why

  3. Then try to Cancel --> change account --> validate back

  4. Now accounts are the same and you can refund 


Avatar
Zrušiť
Avatar
ewallindia@gmail.com
Best Answer

Hi,

the error "The partner has to be the same on all lines for receivable and payable accounts!" means that in your invoice lines' account entries' the reference for account_id is applied to different partners' receivable or payable accounts.
What I would suggest:

  1. Under the financial manager user go to accounting > adviser > journal entries. Find one which number is the same as invoice has

  2. In each line you would see the 'Account'. Ones which have positive debit are receivable. If there are 2 of them, check that they belong to the same partner. If not, try to understand why

  3. Then try to Cancel --> change account --> validate back

  4. Now accounts are the same and you can refund 


Avatar
Zrušiť
Avatar
faOtools
Best Answer

Hi,

the error "The partner has to be the same on all lines for receivable and payable accounts!" means that in your invoice lines' account entries' the reference for account_id is applied to different partners' receivable or payable accounts.
What I would suggest:

  1. Under the financial manager user go to accounting > adviser > journal entries. Find one which number is the same as invoice has

  2. In each line you would see the 'Account'. Ones which have positive debit are receivable. If there are 2 of them, check that they belong to the same partner. If not, try to understand why

  3. Then try to Cancel --> change account --> validate back

  4. Now accounts are the same and you can refund 


Avatar
Zrušiť
Avatar
Dino
Autor Best Answer

@odoo tools - thank you for your reply. Wish I could I could share a screen grab but I don't seem to find those tools on this forum. Hopefully the Table below will help. These are the rows and columns I have in my invoice. Is the "account_id" you refer to, the column that is labelled 'Account'?


Product
Description
Account
Quantity
Unit Price
Taxes
Amount
Name of Product 1
description of product 1
100300 Services
1
R0.00
15%
R0.00
Name of Product 2
description of product 2
100500 disbursements
1
R0.00
15%
R0.00
Name of product 3
description of product 3
100300 services
1
R0.00
15%
R0.00
Avatar
Zrušiť
faOtools

Hi, I updated my answer wuth hints where to find accounts

Related Posts Replies Zobrazenia Aktivita
How do we create a Refund for Validated Invoice in Odoo Version 10.0. Solved
invoice refund
Avatar
Avatar
Avatar
2
júl 18
4023
Stop build draft invoice after cancel invoice ? Solved
invoice cancel draft
Avatar
Avatar
1
máj 19
4379
Invoice and Refund details is broken
accounting invoice refund
Avatar
2
máj 15
4529
Payment of invoice using refunds
invoice payment refund
Avatar
Avatar
2
máj 15
4702
Supplier invoice refund error
invoice refund supplier
Avatar
Avatar
1
mar 15
8857