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

Hi,

I have an error message when installing the "point of sale" application. I don't find this error.

"psycopg2.IntegrityError: null value in column "receivable_account_id" violates not-null constraintDETAIL: Failing row contains (1, Espèces, null, t, 6, f, 1, null, t, 1, 2021-07-05 15:04:43.600895, 1, 2021-07-05 15:04:43.600895)."

Thank you for your help

Avatar
Discard
Author

Thank you for your help !

I found the source of the error. I had deleted the accounting account 411101 Customers (Pos)

Best Answer

Hi Mauri, Just try upgrade the account module that may fix your issue.




Avatar
Discard
Author Best Answer

hi Kartik,

Thank you for your answer
pos_payment does not exist in the database. "Point of sales" has never been installed. The error message appears when I want to install this application
Thanks

Avatar
Discard
Best Answer

Hello Fabienne,

The error seems, that it is coming from pos_payment_method where this receivable_account_id(i.e Intermediary Account) is required.

Solution1 - Check in the database, is there any pos_payment_method exist, remove them all by sql query. And then try to install point_of_sale module and reset the pos_payment_method according to your business need.


Solution2 - If you want all older pos_payment_method which is already present in your database, then assign receivable_account_id value for that particular pos_payment_method.


Thanks.!

Avatar
Discard
Related Posts Replies Views Activity
0
Dec 24
17
0
Nov 24
1575
0
Nov 23
768
1
Feb 23
1314
0
May 22
888