Page 1 of 1

BOM Document export Decimals are commas

Posted: Mon Nov 16, 2015 4:26 pm
by eric14779
I have my Region & Language set to USA
I have decimal to use "." (period)

but in a BOM Document decimals show as a "." (period), in the draft BOM table they show as a "," (comma)
and in a export to a CSV file they are also a "," (comma)

It should ALL be periods, I have switched my region and then switched it back, I have changed the decimal and changed it back.
no change...

anybody else have this problem, and maybe found a solution ??

Re: BOM Document export Decimals are commas

Posted: Tue Jan 12, 2016 2:15 am
by d.k.liu
Have you solved your problem?

While I don't have the problem. It would be good to post your solutions to let others know.
Perhaps it's to do with Language setting under Options->General->Language. It seems this can be set independently for different documents so you might want to check your templates.

Re: BOM Document export Decimals are commas

Posted: Wed Jan 13, 2016 6:51 pm
by eric14779
Draft language setting under Settings>General has been/is set to English USA

Problem remains 7.9.302.170

Re: BOM Document export Decimals are commas

Posted: Tue Jan 10, 2017 9:08 pm
by eric14779
My work around is to export with semi-colon separator.

Then edit in notepad...........replace all semicolon with comma..... save.

Then open in Excel.... good to go...

Re: BOM Document export Decimals are commas

Posted: Thu Feb 09, 2017 7:45 pm
by eric14779
They fixed it !!! in ver 7.10.301.186 maybe a couple of SP back... I did not try until this one.