Double currency conversion => rounding error

[Former Member]

Hi, guys.

First time poster, long time reader.

I have a problem with postings to FI. Would appreciate any input.

When we issue the goods we have special postings of the goods cost to a special account, i.e. 'goods dispatched'. When we receive confirmation from the customer we bill him and the cost of goods is credited from the 'goods dispatched' to 'goods sold' - this is done according to national and company accounting standards. This is done thru the billing procedure which includes apart from the pricing itself also two conditions (shadow copies of VPRS) - one is positive, the other negative, so in terms of the overall billing sum the cancel each other out.

The problem is that the VPRS condition is calculated in company currency (RUB in our case) and it's amount is converted to the billing currency (USD or EUR). During billing this amount is converted to company currency (RUB) since postings are only allowed in that currency. Naturally this leads to rounding errors on a constant basis - 0.01 - 0.09 RUB usually.

Is there a way to avoid this issue? Either thru standard means or thru ABAP/User-exits?

[Former Member]

Such Rounding Difference should ideally be captured in Condition Type DIFF. Probably a new routine with the desired logic reduired to be coded by providing the input to Abaper for coding.

This might resolve the isue.

Regards,

Rajesh Banka

[Former Member]

Interesting idea.

The problem is that DIFF will still be calculated in USD (since that is the billing doc currency) and, during posting, will be reconverted back to RUB. So that still has the possibility of rounding mistake. Second, it is not applicable to very small differences such as 0.01 RUB - with the currency rate of 1 USD = 24 RUB, the smallest difference we could use is 0.24 RUB and usually our differences are way smaller.