Skip to Content
author's profile photo Former Member
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

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jun 30, 2008 at 03:59 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.