I would like to know if this is possible in ERPNext.
When we buy product from our vendors through distribution the price the customer will receive if they are a large customer can be different for different customers for the same product.
So if I purchase item1 for customer1 at the same time as I would item1 for customer2 the cost of the items can be different.
This is not usually an issue but if customer1 has salesperson1 and customer2 has salesperson2 I have found that depending of which customer gets preferential pricing that salesperson is loosing commission cause our sales rate is normally based on % of cost.
eg: I can buy item1 for customer1 for 1000 and I add 10% markup which eventually is sold to customer1 for 1100,
I can buy item1 for customer2 for 1500 and again sold for 10% markup which eventually is sold to customer2 for 1650.
if I buy these items at the same time I see in ERPNext the valuation is placed at 1250.
salesperson 1 now makes a loss on the sale while salesperson2 is make more then is deserving…how do I manage this correctly in ERPNext?
Awaiting your feedback…thanking you in advance.