Cost problem for Product database
I'm creating a new product database but I have encountered a problem. The problem that I am facing is a cost of the product because most of our products may have multiple costs due to different venders (manufacturers).
In this case, what is my best option to solve this? For example, when I create a PO to my vender, the items could lookup the cost automatically by themselves for each specific vender.