MPN and please advice on your solution help need!!!!!
Requirement : If the Customer Request for Material belongs to a company, vendor may send the similar kind of Material but with different company where the cost is less, in this scenario customer wants to see the inventory overview for the similar materials with different company and they want to maintain the Moving average Price by company for the similar material and they should be fully
Example: Material (Filter) with material Number 1P229A belongs to Mercedes, cost of the material is RM 1000.
After sending the PO to Vendor, vendor may say that same material with china brand is RM 100 or may send similar material belongs to Toyota cost RM 200.
1. They should sell to their customer by Brand by marking up on cost.
2. As the Price difference between the brands is very high they need to maintain the Moving Average Price by Material Brand.
3. Customer wants to see the Available Quantity for all the Brands (in the above example by Mercedes, china, toyota) of the similar material( 1P229A)in one screen (MMBE).