Skip to Content
0
Former Member
Sep 27, 2011 at 01:20 AM

Sales Order Discount Rounding Problem

113 Views

Hi Experts

When we use discount RA01 in our Sales Pricing / Orders it results in rounding issue that shows on Customer Invoice.

eg: Sales Order Conditions Tab

Product XXXX x 2 EACH

CnTy Amount (per ea)

PR00 $141.55 EA

RA01 10%

$14.16

Net Val $127.40EA

Total Condition Value (x Order qty)

PR00 $283.10

RA01 $28.31

Net Val $254.79

So what the Customer sees is the unit price of $127.40 and totol line cost of $254.79.

But $127.40 x 2 is obviously $254.80

It looks as though the discount is being calculated as 14.155, then the Net Value rounding from $127.395 to $127.40

Where as the TOTAL Net Value for the line is showing the $127.395 x 2 = $254.79.

The Requirements indicator for PR00 and RA01 is 2

The Calculation Type is PR00 = C (qty) and RA01 = A (%)

The Net Price, PR00 and RA01 are all set to Rounding = Commercial.

How do we get this scenario to result in the Net Value Amount, and Net Value Condition Value multiplying correctly by Qty on the Order??

Thanks

Hayley McDougal