Odoo Help


In which table fiscal position reside for partner?

on 3/23/15, 7:43 PM 1,215 views

Anyone know where fiscal position resides in the database for partner setting? I can't find it in res_partner, please help.

Ray Carnes
On 3/23/15, 11:28 PM

1. Activate the developer mode - see https://www.odoo.com/forum/how-to/developers-13/how-can-i-activate-the-developer-mode-83

2. Hover over the field you want to know more about:

You will notice that the field storing this information is called property_account_position.  Unlike other simple fields, this is stored in the ir_property table.  The value that matches the corresponding type of fiscal position, as defined in the table account_fiscal_position is stored in a more complex, but logical way (once you understand) than a simple field value.

See https://www.odoo.com/forum/help-1/question/what-is-ir-property-used-for-48299


is there a way I can do a batch insert to this table, I have created a new fiscal position and wish to apply for 40,000++ customers.

on 3/24/15, 9:48 AM

See https://www.odoo.com/forum/help-1/question/how-to-mass-update-the-ar-and-ap-accounts-on-100-000-partners-sql-56201 - you may be able to work it out.

Bista Solutions US, Ray Carnes
on 3/24/15, 10:56 PM

There are some special fields in odoo called property fields. Fiscal position is one of them. It will not be present in the same object table. You can find it in "ir_property" table. For more info about property fields...

About This Community

This platform 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.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 3/23/15, 7:43 PM
Seen: 1215 times
Last updated: 3/24/15, 7:53 AM