Decimal notation issue in Adobe Forms

[Former Member]

Hi All,

I'm trying to display a quantity field in adobe form. Its working fine in English (Ex. 5,000)

But when I run the same in Spanish(ES), its displaying (5.000) even the user profile decimal notation is (1,234.56).

I want to print the quantity based on user profile settings.

I have gone through the other threads in SCN, but most of them suggest to use pattern (1,234) like that - but if I change user profile settings then pattern only work.

Any one please help on this.

Thanks,

Chandra.

[former_member76372]

Instead of using a QUANTITY type field, use a character field to write in your adobe forms.

1. Transfer your quantity to a string/character type field.

2. Next thing you do, you get the information of the user's Decimal point format via USR01 - Then try to format it that way. A little coding will do.

3. Before you even pass it to the interface, initialize your quantity to a your desired decimal point format and pass a character-type field. OR You can also do it inside the interface code initialization, just add global variable you can use in your form.

[Former Member]

Hi Chandra,

I will presume that you are trying to print the same example in both languages. One way this issue would have been replicated is that if there are two documents with two different currencies.

In the initialization part of the form write the statement

SET COUNTRY.

This would override all decimal and date formats and use the ones mentioned in the user profile.

Regards,

Prem