Excise Duty-Round up or Round down

[Former Member]

Dear All

The requirement is

For eg, if ED amount is Rs 100.49, then system should round down to Rs 100/- ( in Excise Invoice & commercial invoice)

If ED amount is Rs 100.51, then system should round up to Rs 101/-. ( in Excise Invoice & commercial invoice)

In other words, if the decimal is less than 50 paise, it should round down

if the decimal is more than 50 paise, it should round up.

Any clue, on how its acheived?

Thanking you.

Rgds

Sumanth.G

[eduardo_hinojosa · Accepted solution]

Hi

Check these notes to search possible causes:

SAP Note 886532 - Pricing: Displaying and rounding numbers

SAP Note 80183 - Rounding

In the other hand, check if your condition is ruled by formula VOFM 016 or 017 (check your entries in table T001R)

I hope this helps you

Regards

Eduardo

[Former Member · Accepted solution]

Routine 16 & 17, does not hold good in this case.

Rgds

Sumanth.G

[Lakshmipathi]

You may have a look at the following notes:-

a) Note 117891 - Rounding off not happening

b) Note 1005838 - Rounding of duties when get excise invoice is used in J1IIN

G. Lakshmipathi

[Former Member]

Dear Lakshmipathi

Do you mean to say that a routine need not be written for the ED C.Type?

Rgds

Sumanth.G

[former_member188076]

Hi,

You can write your own routine also for rounding off as per your requirement. I have done this for one of my project and its working fine.

Regards,

Amitesh Anand