PSA had problem

[Former Member]

Hi experts,

I have CSV file to load example data as below. I changed QTY to QUAN with UNIT Q_UNIT type and S_PRICE to CURR with unit S_UNIT.

I activated it and go to next tab to read Preview Data as below. I don't know why S_PRICE loaded as below.  It has "," instead of "." for S_PRICE("1.21"  load to "1,21"). You can see the difference from the Screen shot above and below. Can anyone explain why? Much appriciate if you can give a answer.

[Former Member]

Hi Eric,

You can change this settings at Data Source level. We will have Setting for Thousand and Decimal Separator.

I think at present it will be like thousand separator -- . and decimal separator -- ,.

you change this to thousand separator -- , and decimal separator -- .

Hope it helps

Regards,

Venkatesh

[Former Member]

Hi Venkatesh,

Do you know where I can change the setting in Datasource level? I click all the tab for datasouce and can't find the place to change the setting.

Thank you very much for your reply.

Eric

[Former Member]

Hi Eric,

This can be done from T/A-SPRO

Better way is open SPRO and search with key FLAT. You will be guided to that. There settings can be changed accordingly.

Regards

Chandu

[Former Member]

Hi Chandu,

I got the place but the default setting for Dec. point separator is OK (".") and not ",".  I still don't understand it happen like that.

[Former Member]

Check the settings in Control Panel

Control Panel -> Regional and language settings -> Customize this format

Change the settings accordingly

[Former Member]

Hi Chandra,

This is default setting in my Control panel setting. The Decimal setting is ".". What should I change?

The