problem on menge field i.e. quantity field

[Former Member]

hi folks,

In CS01 i.e BOM creation if you put the quantity field at item level it gets stored with commas i.e. if you put 1000 then it gets save as 1,000 .

When i am fetching these from database in program and doing some calculation the program is giving me dump on that value .

Can any body suggest me what i should do .

[Former Member]

hi folks,

In CS01 i.e BOM creation if you put the quantity field at item level it gets stored with commas i.e. if you put 1000 then it gets save as 1,000 .

When i am fetching these from database in program and doing some calculation the program is giving me dump on that value .

Can any body suggest me what i should do .

[Former Member]

Hi,

Use REPLACE statement to replace ',' commas with space.

then use CONDENSE statement. so that u will get the value without commas.

[Former Member]

Use Conversion Exits.

Awrd POints if useful

Bhupal

[Former Member]

Hi Sandipan

1st answer - replace ',' commas with space.

2nd answer - Go to System -> userprofile -> own data then go to defaults over there and change the settings .

Reward points pls.

Regards

Deepanker