Decimal formatting issue in Adobe Forms

[former_member206394]

Dear Experts,

Greetings!

I have created a Remuneration Statement (Payslip) for Indonesia (country grouping 34) using HRFORMS.  Data is as follows

TO BE:

Earnings:
1. E1   - 50000.00

Cumulative earning - 50000.00

Deductions:

1. D1  - 2974.95

2. D2 - 1236.25

3. D3 - 3445.00

Cumulative deductions - 7656.20

When i check (in debugging) in the internal tables (STAR_EARNINGS, STAR_DEDUCTIONS), the data is correct & matching as given above.  But the issue is when this data is displayed in the payslip

Issue: (AS IS)

When the earnings and deductions are printed in the payslip, it is displayed as below.  (field is 'DECIMAL FIELD'; locale - Default)

Earnings:
1. E1   - 5000000

Cumulative earning - 5000000

Deductions:

1. D1  - 297495

2. D2 - 123625

3. D3 - 344500

Cumulative deductions - 765620

then i have changed the pattern from 'Default locale' to 'Indonesia, Numeric field pattern', it is displayed as below.

Earnings:
1. E1   - Rp5.000.000,00

Cumulative earning - Rp5.000.000,00

Deductions:

1. D1  - Rp297.495,00

2. D2 - Rp123.625,00

3. D3 - Rp344.500,00

Cumulative deductions - Rp765.620,00

Both of this displays are wrong.  Correct display should be as given in TO BE condition. Please help me in displaying the data correctly in the payslip.

tried according to these posts, but no help.

1.

2.

3.

thanks in advance for your earliest reply.

Regards,

Shankar.

[Former Member · Accepted solution]

Hi,

You should put the default language to "English (US)", this will make the point your decimal seperator.

Then you can define your display pattern in the "Pattern" option of your TextField.

Ex: zzzzzz.99

"Z" is used for a not necessary character where "9" is used for a necessary character.

Kind regards,

Niels De Greef

[former_member206394 · Accepted solution]

Dear Niels,

Thanks for your prompt reply.

Changing it to 'ENGLISH (US)' also didnt help.  it helps only in making ',' to '. (point)'.

[Former Member · Accepted solution]

Hi,

Did you define a custom pattern after changing the locale to "English (USA)"?

When looking at the TO BE scenario the pattern should look like "zzzzzzzzzzz.99".

The amount of z should correspond to the length of the field.

Kind regards,

Niels De Greef

[Former Member]

Let us know if the issue is resolved? You can also try SU3 parameter for the same.

[former_member206394]

Hi All,

Found that the issue is not because of the pattern.  As suggested by Niels, pattern display is working good.

the actual issue is different. So opening a new post and closing this.

Regards,

Shankar.

[varun_vadnala3]

Please change the field to Decimal Field and later click on Pattern Button and choose the pattern as mentioned by Niels.