Odoo Help

0

how to check that product A was sold to which customers and when?

By
Fanha Giang
on 6/19/14, 1:50 AM 677 views

as the title.

can I get the list like below

product A:

Sell order / sell date / customer / quantity / price

SO... / 2003/11/11  / A / 10  / 2

SO... / 2003/12/11 / B / 11 / 1.9

and I want to click on the SO line, then the system will send me to view that sell order.

can I do that?

hi prakash, thanks for the answer. I don't know why I couldn't comment on your answer, so I comment here. I need some kind of report like this: product A: Sell order sell date customer quantity price SO... 2003/11/11 A 10 2 SO... 2003/12/11 B 11 1.9 and I want to click on the SO line, then the system will send me to view that sell order.

Fanha Giang
on 6/19/14, 2:24 AM
0
Vũ Quốc Hoàng
On 6/19/14, 5:49 AM

I think you can do it.

1. Create a new field 'transaction_ids' (one2many) which contains some info that you need.

2. When create SO.  update the field. (you can update by compare the person in SO and person in transaction).

3. When click on SO Line, actually we should click on Product to show the Product Form, then we will get the info.

0
Fanha Giang
On 6/19/14, 2:56 AM

in the warehouse --> products --> products, after select a product, I can click more than choice sales order lines. it will show almost the infomation that I need. but it is not show the date. how can I show the date in this list?

beside, I can click on the list, then I can view the sale order line, than track back to the sale order. But in this sale order page, I couldn't view deliver order, which I can by view the sale order from Sales --> Sales --> Sale orders.

0
Prakash
On 6/19/14, 2:11 AM

In the Reporting --> Sales --> Sales Analysis

can you view  Various Filter and Group by options.

Sales Analysis search box select Filter "Sales" and Group by "Product" and "Partner" can view list of Product and Customer Sales. You can also add custom filter based on your requirement.

Refer:- https://doc.openerp.com/7.0/fr/book/2/3_CRM_Contacts/reporting/

           http://www.zbeanztech.com/blog/sales-analysis-report

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

Question tools

1 follower(s)

Stats

Asked: 6/19/14, 1:50 AM
Seen: 677 times
Last updated: 3/16/15, 8:10 AM