Former Member

# Rounding at Header Level in Sales order

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

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

Total customer to pay = \$2.75

can someone help me?

TQ

Ezwardi

10|10000 characters needed characters exceeded

### Related questions

Posted on Jun 30, 2008 at 03:59 AM

Dear Tengku

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