Odoo Help


In which table fiscal position reside for partner?

on 3/23/15, 7:43 PM 1,380 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

--Ray Carnes--
| 9 7 9
Keyport, United States
--Ray Carnes--

Senior ERP Analyst

OpenERP 6.1, 7.0; Odoo 8.0, 9.0, 10.0 and 11.0.

Completed Odoo Functional and Technical Training.

Functional Areas:

  • CRM/Sales

  • Inventory

  • Manufacturing

  • Accounting

  • Purchasing

Major Skills:

  • Business Process Reengineering

  • Efficiency Consulting

  • User Needs and GAP Analysis;

  • Functional and Technical Design;

  • Prototyping and Proof of Concepts;

  • Requirements Specifications;

  • Agile Implementation;

  • Data Migration;

  • Configuration & Customization (UI and code);

  • Integration - Odoo and non Odoo Applications and Services;

  • Training and Knowledge Transfer;

  • Go Live Support;

  • Helpdesk;

  • Version Upgrades and Migration.

  • Accounting Expert.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

I am a skilled Communicator and I only take the serious things seriously!

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.

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

Dhinesh - Technical Consultant, Sodexis Inc

--Dhinesh - Technical Consultant, Sodexis Inc--
| 5 4 9
Pondicherry, India
--Dhinesh - Technical Consultant, Sodexis Inc--

Passionate coder in Python/OpenERP. Knows Django/Flask MVC frameworks. Did code in Java, PHP.

Contact me at: dvdhinesh.mail@gmail.com

Dhinesh - Technical Consultant, Sodexis Inc
On 3/23/15, 11:21 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: 1380 times
Last updated: 3/24/15, 7:53 AM