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 define product sold from which supplier?

By
Interfave
on 1/26/16, 1:51 AM 383 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'?

Interfave
on 1/26/16, 3:30 AM
0

Ermin Trevisan

--Ermin Trevisan--
3524
| 6 3 7
Walchwil, Switzerland
--Ermin Trevisan--


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

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: 1/26/16, 1:51 AM
Seen: 383 times
Last updated: 1/26/16, 9:28 PM