Odoo Help

Welcome!

This community 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.

0

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

By
Fanha Giang
on 6/19/14, 1:50 AM 482 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

--Prakash--
3173
| 5 4 7
Bikaner, India
--Prakash--

OpenERP Devloper at SunARC Technology

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

Your Answer

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

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

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