topic Re: Amount format error for JPY currency in Application Development and Automation Discussions

Amount format error for JPY currency

Former Member — Thu, 28 Feb 2008 11:57:21 GMT

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!

Re: Amount format error for JPY currency

Former Member — Thu, 28 Feb 2008 12:05:10 GMT

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

Re: Amount format error for JPY currency

Former Member — Thu, 28 Feb 2008 12:10:21 GMT

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 .

Re: Amount format error for JPY currency

Former Member — Thu, 28 Feb 2008 13:27:07 GMT

Try entering the amount as 11.90 in the first case.

Hope this helps.

Thanks,

Balaji

Re: Amount format error for JPY currency

Former Member — Thu, 28 Feb 2008 13:39:50 GMT

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