Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

how are customers linked to accounts?

By
Eric
on 9/18/13, 5:32 PM 885 views

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

0

AJ Schrafel Paper Corp

--AJ Schrafel Paper Corp--
2050
| 4 5 8
Bronx, United States
--AJ Schrafel Paper Corp--

Exploring OpenERP for business

AJ Schrafel Paper Corp
On 9/18/13, 6:25 PM

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

image description

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

Eric
on 9/18/13, 8:44 PM
0
Eric
On 9/18/13, 8:41 PM

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

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

2 follower(s)

Stats

Asked: 9/18/13, 5:32 PM
Seen: 885 times
Last updated: 3/16/15, 8:10 AM