Applying Discount To The Unit Price, Not Line Value

Comments

• Savatage Member Posts: 7,142

  2007-05-23

  they want this to show on the sales line or in some report?
  
  how 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 Ruiz
  http://www.BiloBeauty.com
  http://www.autismspeaks.org

  0
• Mbad Member Posts: 344

  2007-05-23

  The rounding should not have impact on the line amount. Then you can keep standard functionality and you can update your net price field in the end of the updateamounts function.

  0
• Stardust77 Member Posts: 95

  2007-05-24

  Why not using 3 decimal places for the Unit Price, and only 2 decimals for the line amount? That way, you are going to have the same amount in both cases.

  0
• Jonathan2708 Member Posts: 552

  2007-05-24

  Hi,
  
  Thanks 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

  0
• Stardust77 Member Posts: 95

  2007-05-25

  Please be very careful if you intend to change the Unit Price calculation on the Sales Line. You are going to change Navision logic. I would recomend you to leave it as is, only changing the number of decimals, and to change the Unit Price calculation only on the reports (Order Confirmation, Invoice, Credit Memo).
  
  In 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.

  0
• Mbad Member Posts: 344

  2007-05-25

  Nothing wrong with changing the logic of the codeunit if you do it right.

  0
• Stardust77 Member Posts: 95

  2007-05-25

  Right Mbad. But, if I have to choose between making a major change in the logic of Navision (and it is not only one codeunit to change), and making some minor changes in three reports, I would always choose the latest option. Which is also the safest solution. Or maybe I am a lazy person.

  0
• Mbad Member Posts: 344

  2007-05-25

  Yup i would just change the reports too. Guess your not lazy after all :-)

  0
• headley27 Member Posts: 188

  2007-06-11

  This has caused us many, many problems in the past as well.
  
  We 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:

  Qty      Price       Disc %     Line Value After Disc 
  2         4.15        35            5.39
  

  
  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

  0