on 06-30-2008 4:38 AM
Hi all SD Expert,
Question:
Can rounding mechanism be applied at Header level in Sales Order?
Summary:
The government of Malaysia have implemented the rounding mechanism to the nearest multiple of 5 cents over the counter transaction. This mechanism shall apply to the total amount of a bill.
Example:
- $1.01 or $1.02 will be rounded down to $1.00
- $1.03 or $1.04 will be rounded up to $1.05
- $1.06 or $1.07 will be rounded down to $1.05
- $1.08 or $1.09 will be rounded up to $1.10
refer http://www.bnm.gov.my/index.php?ch=209&pg=657&ac=567 for more info
My Problem:
SAP Note 1165950 suits well enough for 1 item per sales order.
Example:
Total Bill = $1.38 (posted to a dedicated G/L account)
Rounding Adjustment = +0.02 (posted to a dedicated G/L account)
Total customer to pay = $1.40
But, if I have 2 or more item per sales order, my rounding mechanism does not meet the requirement. Example:
Item 1:
Total Bill = $1.38 (posted to a dedicated G/L account)
Rounding Adjustment = +0.02 (posted to a dedicated G/L account)
Total customer to pay = $1.40
Item 2:
Total Bill = $1.38 (posted to a dedicated G/L account)
Rounding Adjustment = +0.02 (posted to a dedicated G/L account)
Total customer to pay = $1.40
Total Item 1 + Item 2 shown in header level = $2.80
In Header Level, the rounding figure shows +0.04 (rounding adjustment item 1 + item 2). I dont want my sales order to round the value at item level.
The correct calculation to suit the regulation is:
Item 1 + Item 2: $1.38 + $1.38 = $2.76
Rounding Adjustment at Header: -0.01
Total customer to pay = $2.75
can someone help me?
TQ
Ezwardi
Dear Tengku
Please try with this.
Go to V/08, for the net value field, maintain Routine 16 in the Alt. Cal. Type. Also add Routine 17 to Netvalue.
As you know Condition types are assigned at each item level. So rounding off is calculated at each item level. But by assigning a tick in the Group Condition while defining Rounding off Condition, you can do rounding off at invoice level. The difference is automatically adjusted at each item.
thanks
G. Lakshmipathi
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.