These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Amount Fields on Adobe Form

ashagraw
Registered: Jan 13 2009
Posts: 23

Hi,

I have developed an interactive Adobe Form using Adobe LiveCycle Designer in SAP. I am facing a very strange issue in the same.

I have couple of Amount fields on the Form. Data type for these fields is CURRENCY. Whenever I am trying to put any decimal values in these fields, Adobe is throwing me a standard error message stating "Seperator between Thousands must be 3."

This message is appearing for any value like 10.12, 1000.12 and so on. Could you please help me with the inputs that why this error message is appearing.

Thanks,
Ashish

ashagraw
Registered: Jan 13 2009
Posts: 23
Hi Thom,

I would be greatful if could have some inputs from ur end.

Thanks,
Ashish
gkaiseril
Online
Expert
Registered: Feb 23 2006
Posts: 4307
Have you set any of the 'Display', 'Edit', 'Validation Pattern', or 'Data Pattern' field object options?

Are you using a sepcial locale value?

I have tried the decimal and numeric field type with currency and had no problems.

George Kaiser

ashagraw
Registered: Jan 13 2009
Posts: 23
No, I have not set any Validation or Display pattern. This is what I am also wondering about. I developed 4 forms, and for every field on every form I am getting this error message.

Any other clue?

Thanks,
Ashish
thomp
Expert
Registered: Feb 15 2006
Posts: 4411
ashagraw wrote:
I have couple of Amount fields on the Form. Data type for these fields is CURRENCY
How exactly are you doing this?

Thom Parker
The source for PDF Scripting Info
[url=http://www.pdfScripting.com]pdfscripting.com[/url]

The Acrobat JavaScript Reference, Use it Early and Often
[url=http://www.adobe.com/devnet/acrobat/javascript.php]http://www.adobe.com/devnet/acrobat/javascript.php[/url]

Thom Parker
The source for PDF Scripting Info
www.pdfscripting.com
Very Important - How to Debug Your Script

ashagraw
Registered: Jan 13 2009
Posts: 23
Hi Thom,

Nice to see you on the post!!

I have put 2 attributes in the context of WebDYnpro application in SAP ABAP. In webdynpro I am designing this Adobe Form.

These attributes' data type is CURR (This is a specific data type used in SAP ABAP).

I am dragging these fields and putting on the Adobe Form.
When I execute the Adobe Form, it looks nice but when I try to put any decimal value to these fields I am getting the error message that I have mentioned in the post.
This is a standard error message of Adobe Form.

Do you have any clue why is it behaving like this.?

If you want, I can provide you with some additional screen shots also.

Thanks,
Ashish
thomp
Expert
Registered: Feb 15 2006
Posts: 4411
Ok, So you are relying on column definitions in a DB to setup your form fields in LiveCycle. Very Bad, don't do this. Take a look on the Object Tab in Designer for one of these fields. Look through all the options that take a picture clause as input, remove all these settings.

Thom Parker
The source for PDF Scripting Info
[url=http://www.pdfScripting.com]pdfscripting.com[/url]

The Acrobat JavaScript Reference, Use it Early and Often
[url=http://www.adobe.com/devnet/acrobat/javascript.php]http://www.adobe.com/devnet/acrobat/javascript.php[/url]

Thom Parker
The source for PDF Scripting Info
www.pdfscripting.com
Very Important - How to Debug Your Script

ashagraw
Registered: Jan 13 2009
Posts: 23
Hi,

I have got the cause for the error. Actually the error was related to SAP's standard validation. In SAP system the format for Amount field was specified as 123.456.789,00.
That's why system was taking the '.' as a thousand seperator and throwing an error that "Distance between thousand seperator must be 3."

Thanks for all your help.

Thanks,
Ashish