topic Re: problem on menge field i.e. quantity field in Application Development and Automation Discussions

problem on menge field i.e. quantity field

Former Member — Fri, 28 Dec 2007 04:34:06 GMT

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 — Fri, 28 Dec 2007 04:37:55 GMT

Hi,

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

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

Former Member — Fri, 28 Dec 2007 04:52:17 GMT

Use Conversion Exits.

Awrd POints if useful

Bhupal

Former Member — Fri, 28 Dec 2007 05:10:33 GMT

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