Sales Order Line Item Discount

[Gina]

When applying line item discounts on sales orders, AX calculates the
discount AFTER the total line item price extension is made. As a result, a
rounding error occurs when backing into a per unit price.

Example:
Unit List Price = 20.35
Line item % Discount = 33.45%
Line item Quantity = 10

The Net Amount on the line item calculates $135.43

Net Amount = (20.35 - 20.35 * 33.45%)) * 10 = 135.43

The rounding to 2 decimals does not happen until AFTER the price/qty
extension has been made.

We want to print a "discounted" unit price on the invoice, so we created a
field called "Customer Price" which basically takes the NET AMOUNT and
divides by the Qty.

In this case, we would take 135.43 / 10 = 13.54

So on the invoice the unit price shows 13.54 and the Net price shows 135.43.

When the customer calculates a unit price of 13.54 for a qty of 10, you get
135.40.

A rounding error of 3 cents.

We do not want to show the line item discounts on the invoice, which is why
we added this custom field called "customer price" - which is basically the
discounted unit price.

Does anyone have any experience getting around this or have any suggestions
on how to change the Net Amount calculation (ie, AX standard calculation)?