Skip to Content
This question has been flagged
productaccountincome
2 Respostes
5343 Vistes
Avatar
LS Development

Currently I become completely crazy with the column "property_account_income_id".

in my database I have installed module Sales and the module Accounting.

When you install accounting, product.py (into Account/Modele) this module add some news column into the table product_template like the column property_account_income_id.

After activate the developer mode, if you check the product form, you can see (in invoice) that you have a relation OneToMany on property_account_income_id into the modele product_template.

If you have a look into Settings->DataBase Stucture->fields: you find too the column property_account_income_id

into the same table product_template. When you update account income (with the Product form) you don't have any problem.

But..., when I use a database tools like 'pgAdmin3' OR 'dbVisualizer', I don't find this column into the table product_template.  WHY ?????? Where is this column?????

Avatar
Descartar
Avatar
LS Development
Autor Best Answer

Thx for your answer about my question, but other question.

- Why in the module account/models/product.py we find:

#-------------------------------------------
products
#----------------------------------------------------------
classProductTemplate(models.Model):
_inherit ="product.template"
taxes_id = fields.Many2many('account.tax', 'product_taxes_rel', 'prod_id', 'tax_id', string='Customer Taxes',
domain=[('type_tax_use', '=', 'sale')])
supplier_taxes_id = fields.Many2many('account.tax', 'product_supplier_taxes_rel', 'prod_id', 'tax_id', string='Vendor Taxes',
domain=[('type_tax_use', '=', 'purchase')])
property_account_income_id = fields.Many2one('account.account', company_dependent=True,
string="Income Account", oldname="property_account_income",
domain=[('deprecated', '=', False)],
help="This account will be used for invoices instead of the default one to value sales for the current product.")
property_account_expense_id = fields.Many2one('account.account', company_dependent=True,
string="Expense Account", oldname="property_account_expense",
domain=[('deprecated', '=', False)],

help="This account will be used for invoices instead of the default one to value expenses for the current product.")
and after use the table ir.property for the relation between product and account




Avatar
Descartar
Pinakin Nayi (pna)

I think you need to know the use of ir.property . Please find here documentation for ir.property

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

Avatar
Pinakin Nayi (pna)
Best Answer

That is property type field, you can find those fields in the table ir.property . Also you can find field. after activating developer mode , go to setting > Technical > Parameter > Company Properties

Avatar
Descartar
Related Posts Respostes Vistes Activitat
How to import income and expense account for product
product import account expense income
Avatar
Avatar
1
de març 15
10095
Set default Expenses and Income account on Product Categories Solved
product account category
Avatar
Avatar
1
de maig 21
16684
Accounting settings : multiple accountable accounts for the same product ?
accounting product customer account
Avatar
0
d’abr. 21
2369
AttributeError: 'NoneType' object has no attribute 'get'
function product account purchase_order
Avatar
0
de març 15
15803
Analytic Accounts, costs and revenues - Bug?
product account analytic project_cost
Avatar
0
de març 15
3459