cancel
Showing results for 
Search instead for 
Did you mean: 

Rounding at Header Level in Sales order

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Lakshmipathi
Active Contributor
0 Kudos

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

Answers (0)