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.
You'll need something like lot tracking for this purpose. See for example: https://www.erponline.vn/en/documentation/user-manuals/92-warehouse-management/260-managing-lots-and-traceability
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: 1/26/16, 1:51 AM|
|Seen: 387 times|
|Last updated: 1/26/16, 9:28 PM|