Problem with DDIC type QUAN

[Former Member]

Hi,

I have a field with the DDIC type QUAN size 13 decimals 3.

When I set the field to 1000 in the screen and save, it insert in database the value 1,000. And if I put 1 in the screen field and save, it insert 0,001 in the table.

I think the problem is with the separator, but I can't realize how to solve this.

Somebody can help me?

Regards,

Charles

[Former Member]

check reference table and reference field for that field in Currency/Quantity fields tab.

Ex: If you are creating a field for Quantity

Field: Menge

Data type: menge.

Ref table: Ekpo

Ref Field: meins.

Built-in type:

Field: Menge

Data type : Quan leng 13 Dec 3

Ref table: Ekpo

Ref Field: meins.

It will work.

[Former Member]

Hi,

Just do like this to solve your problem,

select 'system' menu option,

->user profile,

->own data,

->select Defaults tab

->here u can define your decimal ponits as for your requirement under the decimal notation input then save.

it solves your problem,

reward points if useful,

seshu.