Anyone know where fiscal position resides in the database for partner setting? I can't find it in res_partner, please help.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project
- MRP
This question has been flagged
2
Replies
3910
Views
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.
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.
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...
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up