I want to calculate my selling price from the item card based upon Markup. Navision is calculating Margin. Is there a way to change this? If I have an item that costs me $100.00 and I want a 50% profit on it ($50.00), I need to sell it for $150.00. When I use the item card and put in 50% profit Navision tells me to sell it for $200.00. 20% Navision says sell for $125.00 I expect $120.00. 25% Navision says sell it for 133.33 I expect $125.00.
Hi, Unfortunately Navision is right: Profit % = (Price – Cost) / Price * 100 In your example if you sell 100 goods for 150 you will have: Profit % = (150 – 100) / 150 * 100 = 33.33 % If you want 50 % profit you have to sell for 200. Almost everybody ask this question. I think I would prefere they was wrong.
You could just adjust your response to fit Navision’s expectations. When you want 20% markup, tell Navision that you want 100/120 margin. When you want 50% markup, tell Navision you want 100/150 margin. When you want 42.5% markup, tell Navision you want 1000/1425 margin. And so forth.