CIN : decimal problem in export excise invoice

[Former Member]

Hi all,

I have issue, we are in export sales and we activated 5 decimal option for our customer.

issue is we made a export billing document with ref that export excise invoice.

- in my billing doc ED exchange rate is 47.4 and the unit price is 1.63 $

when i am converting to inr below difference is comming

qty inr price Asse val BED dif for assessable value

10224 77.26 789906.24 31,596.25 20.45

789926.69 31597 => it is calculated on 77.262 how to avoid the 3 decimal when system is calculating the Assessable value for duty calculation. ????

above is for one line item. like this i have multiple line item is the same invoice and the difference is huge.

Thanks in Advance

Raghava

[Lakshmipathi]

Dear Raghava

If I am correct, decimals for INR is two and I am not sure, how it is three in your case.

In your pricing procedure, have you assigned routine 355 to excise condition types ?? If not, try with that. Alternatively, you can also try with this Function Module J_1I6_ROUND_TO_NEAREST_AMT

thanks

G. Lakshmipathi

[Former Member]

Dear Lakshmipathi,

Thanks for your reply, If I am not wrong 355 is rounding off rountine of excise values. as i told you mines is export pricing procedure my BED also in USD, which i can't do. If i do that even the rounding decimals when we converting to INR give lot difference.

Second : Rounding nearest value function module

In the background calculation when the system is calculating the assessable value, there we need to incorporte this with our won peace of code, but later on SAP bringing the original values somehow.

in my case also INR 2 decimals only, system in the background it is considuring the 3rd decimal.

do you have any other solution. please let me know.

Regards,

Raghava.