Skip to Content
This question has been flagged
invoicerefundcancel
8 Replies
5978 Views
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
Discard
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
Discard
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
Discard
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
Discard
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
Discard
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
Discard
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
Discard
Avatar
Dino
Author 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
Discard
faOtools

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

Related Posts Replies Views Activity
How do we create a Refund for Validated Invoice in Odoo Version 10.0. Solved
invoice refund
Avatar
Avatar
Avatar
2
जुल॰ 18
3972
Stop build draft invoice after cancel invoice ? Solved
invoice cancel draft
Avatar
Avatar
1
मई 19
4329
Invoice and Refund details is broken
accounting invoice refund
Avatar
2
मई 15
4506
Payment of invoice using refunds
invoice payment refund
Avatar
Avatar
2
मई 15
4652
Supplier invoice refund error
invoice refund supplier
Avatar
Avatar
1
मार्च 15
8820