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

Rounding at Header Level in Sales order

256 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

refer http://www.bnm.gov.my/index.php?ch=209&pg=657∾=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