Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
Hi, I am trying to put 'Product Category' to the POS Order Analysis. Still very new to OpenERP. So far I did:
In 'pos_order_report.py' add
'categ_id': fields.many2one('product.category','Category of Product', readonly=True),
to the pos_order_report class, and then
pt.categ_id as categ_id, ... group by ... pt.categ_id
in the SQL
In 'pos_order_report_view.xml' add
<field name="categ_id" invisible="1"/>
in the view_report_pos_order_tree and
The Error it shows when I try to filter by "Category of Product" is:
ProgrammingError: Column report_pos_order.categ_id does not exist
LINE 1: ...HERE (("report_pos_order"."year" = '2013') AND ("report_po...
What am I doing wrong?
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.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 7/3/13, 2:48 PM|
|Seen: 2030 times|
|Last updated: 3/16/15, 8:10 AM|