Import CSV file issue

dabba23

Hey there,

I have come across a problem regarding importing a CSV file into General Journal.

First the file is standard excel and the third column contains amounts with decimals.
When I save the excel file to CSV, comma seperated, it rounds up some of the amounts in the third column.
If I put the cursor on the amount it shows the decimal.

When importing the CSV file it then imports the rounded amount which in the end gives me a difference in the totaling when adding the amounts together, which is not good.

Does anyone know why when saving as CSV file it rounds it up?
I am using a codeunit to do the import.
Would it make a difference if the import is done through a dataport or should I be looking at a completely different solution to the import?

Thanks
Ann

Miklos_Hollender

Excel, Format Cells, give it a large decimalplaces before saving.

dabba23

Miklos Hollender wrote:

Excel, Format Cells, give it a large decimalplaces before saving.

It seems to have worked, but do you know why?