Amount format error for JPY currency

[Former Member]

Hello,

I have a big problem because of JPY currency. The reason is that this currency has no decimals defined.

I have a screen with amount and currency.

The currency field GD_WAERS is type WAERS

The amount field GD_WRBTR is type WRBTR with reference to GD_WAERS.

The problem is like this:

Input:

Amount: 1190

Currency: JPY

Hit enter

result:

Amount: 119000

The only way it works is like this:

Input:

Currency: JPY

Hit enter

Amount: 1190

After this trick, it works ok.

What can I do in order to have the correct formatting even in the first case?

Thank you!

[Former Member]

Hello,

I have a big problem because of JPY currency. The reason is that this currency has no decimals defined.

I have a screen with amount and currency.

The currency field GD_WAERS is type WAERS

The amount field GD_WRBTR is type WRBTR with reference to GD_WAERS.

The problem is like this:

Input:

Amount: 1190

Currency: JPY

Hit enter

result:

Amount: 119000

The only way it works is like this:

Input:

Currency: JPY

Hit enter

Amount: 1190

After this trick, it works ok.

What can I do in order to have the correct formatting even in the first case?

Thank you!

[Former Member]

Hi,

there is a table called TCURX. IN this table, the decimal places for each currency (particularly for South east asian countries) is maintained. Pls make use of this table and modify your calculations accordingly.

for e.g.

*/ 1 Yen to be converted into Euro

*/ Divide 1 / 100 = 0.01

*/ Now convert yen to Euro.

*/ Example : 1 Euro to be converted in to Yen.

*/ Multiply 1 * 100 = 100

*/ Now convert into Yen

*/ All this because Yen & Alike does not have decimals.

*/ so if EURO & Yen have same currency conversion rate then

*/ 1.00 Euro = 100 Yen. .

Hope this helps. Reward points if useful.

Regards,

JLN

[Former Member]

This issue has nothing related to converting to euro. I just want to enter some amounts in JPY and when pressing enter to be formated correctly .

[Former Member]

Try entering the amount as 11.90 in the first case.

Hope this helps.

Thanks,

Balaji

[Former Member]

Try telling this to a user who is recording invoices...