A CSV file is being imported into Great Plains. The numbers in the CSV file are not showing all the decimal places. i.e. 1000.00 is being displayed as 1000. You would like all these to come in with 2 decimal places.
Create calculated fields for your amounts. The script looks like this: return Convert.ToDouble(_mystring).tostring(“0.00”) replace mystring with the actual value from your source file. So if your column is called Credits, then your script will look like this: return Convert.ToDouble(_Credits).tostring(“0.00”)
