how are customers linked to accounts?

Question

Hello,
I am looking high and low for any kind of clue as to how the customers are linked to their account. I looked in all the accounts, and res_partner tables, but could not find out how the customer is linked to its account receivable, and account payable account. Does anyone know how they are linked? Thank you

Eric · Answer

Well, I finally found how the customers are linked to their accounts. In the ir.property table there are two fields that establishes their connection.
The 'value_reference' field has data that references the account table and the record id like this:
'account.account,12'
The 'res_id' field has data that references the res_partner table and record id like this:
'res.partner, 18'
what this does is use the account with an id of 12 and associates that account with the customer that has an id of 18

AJ Schrafel Paper Corp · Answer

If you activate developer mode and mouse over the field, it will give you the field name.

相关帖文	回复	查看
add multiple Account Receivable for one customer customer account	1 8月 23	6896
Accounts types does not appear accounts account	0 3月 15	3197
Does Odoo support "Bill me" or "Use my Account" for Shipping? 已解决 customer account shipping	1 3月 24	2622
Problems importing accounts import accounts account	0 12月 16	3083
Importing banks in v7? customer account bank	2 3月 15	4076

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！