0
Former Member
Jun 30, 2008 at 03:38 AM

# Rounding at Header Level in Sales order

397 Views

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