- 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
- 253 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

Jonathan2708
Member Posts: **552**

Hi,

I have a customer who for marketing reasons wants to have the line discount % applied to the unit price instead of the line value. I have suggested I just show this as the 'Net Price' using a formula field on the sales order report to give an indicative price but they insist on having it shown, calculated and posted using 2 decimal places. For example :

__Current Method (Standard Navision)__

__New Method__

Here the Net Price is actually 54.495 rounded to 2 decimal places which has the effect of increasing the line value.

Unless I'm missing something it seems to me that to do this I would have to re-write all the unit price/discount/VAT line value calculations in Navision to work under this method which I'm really not keen to do.

Has anybody else done this as a modification or has any suggestions?

Any help appreciated,

Jonathan

I have a customer who for marketing reasons wants to have the line discount % applied to the unit price instead of the line value. I have suggested I just show this as the 'Net Price' using a formula field on the sales order report to give an indicative price but they insist on having it shown, calculated and posted using 2 decimal places. For example :

Qty Price Disc % Line Value After Disc 6 72.66 25 326.97

Qty Disc % Net Price Line Value 6 25 54.50 327.00

Here the Net Price is actually 54.495 rounded to 2 decimal places which has the effect of increasing the line value.

Unless I'm missing something it seems to me that to do this I would have to re-write all the unit price/discount/VAT line value calculations in Navision to work under this method which I'm really not keen to do.

Has anybody else done this as a modification or has any suggestions?

Any help appreciated,

Jonathan

0

## Comments

7,142how about something like this

if Qty = 0

then "Net Price" := 0

else "Net Price" := "Line Value" / Qty

**edit**

I see you mentioned a formula already..where do they want this shown?

Harry Ruizhttp://www.BiloBeauty.comhttp://www.autismspeaks.org34495552Thanks for the replies, I've decided to add code to recalculate the Unit Price column to 4/5 decimal places so that it gives the same line value when the discount is applied to the line as it does if the discount is applied to the unit price.

Jonathan

95In my country we are using for the discount calculation exactly the same logic as you want to implement. In the beginning I was tempted to change the logic, but after looking in more depth at the possible consequences, I have decided the safest way is to avoid changing the logic.

34495344235We have added far too many fixed 'Sales Prices' to counteract this calculation.

What I have done is increase the decimal places so that the calculation of the line value will be consistant with that of the (virtual) 'Unit Price'.

I am ready to make the changes in our production database but I have one remaining problem ... is Navision rounding down??

For example:

Why is this not $5.40 ?? ](*,)

(2 * 4.15) * ((100-35)/100) = 5.395

8.30 * 0.65 = 5.395

Thanks for your help,

headley27