How do we find any product sold/bought by particular customer / supplier? It would be nice if we can list those items and see from what invoice/sales order number it comes from.
The main purposes is to see the price history applied for the item on particular customer/supplier
You can get all these information from the product view.
- Go to
Sales / Products / Products
- Select a Product
- Click on
Purchasesto get the history
If you want to compare different products, you can also use the reporting tools using the menu
Reporting / Accounting / Invoice Analysis.
This module can fulfill your need product_historical_pricet.
Change after comments
As i told youi n my last comment, there is something wrong with the access rights in this module, and now i can confirm it.
This imply some changes in two files:
First file - /security/group.xml
<?xml version="1.0" encoding="utf-8"?> <openerp> <data noupdate="1"> <record id="product_historical_user" model="res.groups"> <field name="name">Product Historical User</field> </record> <record id="product_historical_manager" model="res.groups"> <field name="name">Product Historical Manager</field> </record> </data> </openerp>
Second file - __openerp__.py
Lines to be changed:
"update_xml" : ["security/groups.xml", "security/ir.model.access.csv", "view/product_view.xml", "data/product_data.xml",
After those changes update your module, and go under Settings ----> Users ---> Users , edit the user you want, and under
Access Rights Tab you will see two new fields "Product Historical Manager " and "Product Historical User ".
It works for me.
Can you test and confirm if this works for you?
Thank you for this answer, it was helpful to me also. I'm new to openERP and still finding my way around. Do you know maybe what could be the reason for me not having any records in Purchases list of selected product? To be more precise, none of my products have no Purchase list records so I'm guessing I must be doing something wrong.
I see a complete list of Sales order lines for the same product just fine.
I also have Incoming shipment for products in status Received, as well as Supplier Invoice in status Paid.
Any idea would be helpful. Thanks.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 3/2/13, 10:23 AM|
|Seen: 5116 times|
|Last updated: 5/5/16, 5:36 AM|