on 03-27-2009 8:49 AM
Hi Experts,
We got complain from our customer with regards to RM 0.01 issue. Upon
checking the pricing calculation in the sales order pricing procedure
maybe it was due to rounding to 2 decimal places for each condition type.
How can I correct this issue?
Example:
Condition type as per below:
Fixed Price: 1.5528 x 16380 = 25434.86
Premium: 0.0750 x 16380 = 1228.50
Duty Recovery: 0.1933 x 16380 = 3166.25
Rounded to 2 decimal points for each condition type
Total: 25434.86 + 1228.50 + 3166.25 = 29829.61
Question:
1.Can the amount at Fixed Price, Premium, and Duty Recovery not to be rounded to 2 decimal points?
Example:
Fixed Price: 1.5528 x 16380 = 25434.864
Premium: 0.0750 x 16380 = 1228.50
Duty Recovery: 0.1933 x 16380 = 3166.254
The amount is not rounded to 2 decimal points
2.Can it be round only at the final amount which is the net price?
Total = 25434.864 + 1228.50 + 3166.25 = 29829.618
= 29829.62
Thank you.
Halida
Hi,
Question 1: If you don't want the Rounding, you simply have to remove the Rounding condition type from your Pricing Procedure (V/08) where it is used.
Question 2: Yes, if you want it to be applied only after a total, you simply need to specify in your Pricing Procedure (V/08) where this Rounding condition type is used, and indicated in the "Step" after your Net Price condition type. Thereafter, in the "To" and "From" column, indicate the step where you want the Rounding condition type to apply to the previous steps, and so it will calculate and round up base on the basis of the total.
Hope this helps.
Best rgds.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
you have to modify the Indicator: Currency Translation after Multiplication in the price condition, transaction v/06.
Indicator: Currency Translation after Multiplication
Controls the currency conversion where the currency in the condition record varies with the document currency.
Use
To calculate a condition value in a document, the system multiplies the amount that results from the condition record by the item quantity. This indicator controls whether the system carries out currency conversion before or after the multiplication takes place.
Procedure
If you mark the field, the system converts the condition value into the document currency after multiplication. If you leave the field blank, the system converts the condition value into the document currency before multiplication.
Best Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.