Printing Amounts in Smartforms

[Former Member]

Smartform Experts,

I am doing Invoice smartform for all countries. I am having problem with Japanese one. While displaying amounts, the amounts in smartform are divided by 100 and on Order or Billing documents are correct. If I lookup at the data in tables the amount is also divided by 100. Any idea why this is so? Amounts for US or other countries is OK. I am in CRM 4.0. For eg. Amount in Ord is 360,000 JPY or 18,000 JPY and in Output/Tables is 3,600.00 or 180.00. Any idea why?

Prasad Sheth

[Former Member]

Smartform Experts,

I am doing Invoice smartform for all countries. I am having problem with Japanese one. While displaying amounts, the amounts in smartform are divided by 100 and on Order or Billing documents are correct. If I lookup at the data in tables the amount is also divided by 100. Any idea why this is so? Amounts for US or other countries is OK. I am in CRM 4.0. For eg. Amount in Ord is 360,000 JPY or 18,000 JPY and in Output/Tables is 3,600.00 or 180.00. Any idea why?

Prasad Sheth

[former_member181966]

I am just guessing , but most of the time in configuration we have one factor called "Exchange rate factor " , you’ll find this field on invoice document and the table is VBRP Field "KURSK" .if its in the table you’ll get the same . Its related to IMG setting ..

Check out T-CODE "OC47"....

Hope this’ll give you some hint.

Thanks

Message was edited by: Saquib Khan

[vinod_gunaware2]

Hi

There are two ways to maintain format of Currency,

1. Transaction : OY01 Customize: set up countries

2. Menu->System->User profile-> Own data -> Defualt

Just check the country seeting as well as user setting

before run the smart form.

U can use SET COUNTRY command to set country format which is specified into OY01.

Use Write stament to convert into required currency format.

... CURRENCY w

Effect

Correct format for currency specified in the field w.

Treats the contents of f as a currency amount. The currency specified in w determines how many decimal places this amount should have.

The contents of w are used as a currency key for the table TCURX; if there is no entry for w, the system assumes that the currency amount has 2 decimal places.

Regard ,

Vinod

[FredericGirod]

Hi,

Like Vinod said, put your amount in a type char variable with the syntax :

write w_amount to w_amount_c currencty w_waers.

that will correct the no decimals amount.

Rgd

Frédéric