Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
Hi Connection,
The below error found, What was the exact issue let someone please help me
| insert or update on table "account_move_line" violates foreign key constraint "account_move_line_account_id_fkey" |
| DETAIL: Key (account_id)=(866) is not present in table "account_account". |
Hi Geetha, it seems that the account id( Chart of Accounts) which you are using to register the payment is not available in the account.account - The main configuration page of Chat of accounts ( refer screenshot)
It may be Archived or inactive
please check once!
Hi,
You are trying to insert or update a
table named account_move_line and there is the values for the field
account_id which is a foreign key from the account_account table and
this value not present in the account_account table.
Make sure that account_id field values are present in the account_account table.
Hope it helps
Kindly refer my Answer. i have edited now
Hi Cybrosys/Gayathri
I have attached the Screenshot for your reference.
All accounts are specified in COA, But the error has been occur. Can you guys please help me to fix this.
From the webshop we made a purchase as a customer by selecting product and making a payment over to that at the time the error occurs.
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
3
Jun 24
|
3681 | ||
|
2
Jun 24
|
3205 | ||
|
1
Jul 23
|
3466 | ||
|
1
May 23
|
8709 | ||
|
0
Aug 21
|
2863 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
Can you give more details on when, on which action you have encountered this issue?