Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ
2 Trả lời
5146 Lượt xem

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

Ảnh đại diện
Huỷ bỏ
Tác giả Câu trả lời hay nhất

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

Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

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

image description

Ảnh đại diện
Huỷ bỏ
Tác giả

Thank you for your help. I actually found the relationship in the ir_property table which uses two fields to make the connection.

Bài viết liên quan Trả lời Lượt xem Hoạt động
1
thg 8 23
7100
0
thg 3 15
3417
1
thg 3 24
2798
0
thg 12 16
3272
2
thg 3 15
4265