Skip to Content
Menu
This question has been flagged
3 Replies
4364 Views

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".


Avatar
Discard

Can you give more details on when, on which action you have encountered this issue?

Best Answer


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!

Avatar
Discard
Best Answer

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

Avatar
Discard
Author

Kindly refer my Answer. i have edited now

Author Best Answer

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.










Avatar
Discard
Related Posts Replies Views Activity
3
Jun 24
2041
2
Jun 24
2238
1
Jul 23
2635
1
May 23
7116
0
Aug 21
2370