thanks hda, now i can see how it is picking up the values. i assigned another receivables account to a customer and now i can see an entry in ir_property i.e. for 'res.partner,3' it got a value of account.account,2.
so i can write a logic, if count of property_account_receivable is > 1 than check if the res.partner id is there, if yes than pick up the assigned out otherwise keep the default account. should be fine to write this query using patindex (dont know if postgresql got patindex). just a question, why would one want to assign accounts via property field, is there any special reason for that - would relational field not suffice in a rush i can use query, but u r right, better way would be to use read or browse method. thanks khalid -------------------- m2f -------------------- -- http://www.openobject.com/forum/viewtopic.php?p=49833#49833 -------------------- m2f -------------------- _______________________________________________ Tinyerp-users mailing list http://tiny.be/mailman2/listinfo/tinyerp-users
