Odoo Help


How to define product sold from which supplier?

on 1/26/16, 1:51 AM 839 views

Hi everyone, 

I'm looking for the idea how to define total sales generated based on product supplier.

For example, when customer buy some products, I want to know that product come from which supplier and total up that sales.

But the problem is how about that product sold come from many supplier?

Lets says customer bought 7 quantities of the same t-shirt, in the stock there are only have 2 t-shirt left from 'Supplier A', stock manager already ordered new stock from 'Supplier B' of same t-shirts before this.

How do I know 2 come from Supplier A, then 5 come from 'Supplier B'?

Need some ideas, thank you.

In each product, there is 'Supplier' for that product. Are you talking about that?

Samantha Cruz
on 1/26/16, 2:30 AM

You're right, in each product has table called as Suppliers, I try to find out how it works but cannot find the way out. By default supplier can tile with the product when we do Purchase Order. But in my case, I'm looking on supplier performance by calculate total sales generated of that product that had supplied by that supplier. (for Reporting) I have problem when there are many suppliers tile with one product. So, how do I calculate total sales in Sales Order if customer buying 7 quantities of same T-shirts while in the product record I must take out 2 quantities from 'Supplier A' and another 5 from 'Supplier B'?

on 1/26/16, 3:30 AM

Ermin Trevisan

--Ermin Trevisan--
| 6 5 7
Walchwil, Switzerland
--Ermin Trevisan--

Ermin Trevisan
On 1/26/16, 6:19 AM

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.


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)


Asked: 1/26/16, 1:51 AM
Seen: 839 times
Last updated: 1/26/16, 9:28 PM