- All Categories
- 73 General
- 73 Announcements
- 66.4K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 250 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions

sabzam
Member Posts: **1,149**

Hi Everybody this is certainly a navie question but to which I don't have an answer. Let's say the unit cost of an item (in the item card) is 10. The Price/Profit Calculation type is Price = Cost + Profit while the profit% is 10.

How is it possible that the calculated price is 11.111 or when profit% is changed to 20 it is 12.50?

How is it possible that the calculated price is 11.111 or when profit% is changed to 20 it is 12.50?

0

## Comments

1,283Navision works this out from the price, therefore if the selling price is £12.50 and the cost is £10.00 the margin is £2.50. £2.50 is 20% of £12.50 if you see what I mean.

184Example:

cost 200€

margin 20%=> 200 / 0.8 = 250€

mark-up 20% => 200 * 1,2 = 240€

If you have a margin of 20%, it's no problem to give a discount of 18%, because still 2 % margin is left. (Not that I would prefer a discount like this, but just as an example).

Discount of 18% on 250€ => 250 * 0,82 = 205€ (the 5€ profit is 2% of 250€)

Discount of 18% on 240€ => 240 * 0,82 = 196,80€

If you think that you have a margin of 20 %, but do calculate that as a mark-up, then you can not give 18% discount, because you will lose money on this deal. So, margin MUST allways be calculated from point of sales price.

So people be very carefully when you talk about margins, and for sure if you give discounts!!!!!!

Consultant-Developper

http://www.CreaChain.com

5,063AP Commerce, Inc. = where I work

Getting Started with Dynamics NAV 2013 Application Development = my book

Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book