Not all the countries will be facing this issue, it depends on which version of Office you use.
By uploading a Bank Statement via CSV Plugin Implementation, you might face the error regarding the wrong coding, although you save CSV file as a CSV UTF-8 (Comma delimited).
The reason why this is caused is by your settings in Excel file and in a System you use.
The following settings are done in a Format Profile used for the CSV import:
- Navigate to Setup > Accounting > Financial Institution List
- Select the one used for CSV import
- Navigate to Format Profile: Configuration tab
- Click Edit profile
- Navigate to Parser Configuration tab > Formatting Preferences subtab:
As you can see, we set to the system a number format with the used “decimal” as a Decimal separator. Nevertheless, reality, in your Excel file you need to set different separator.
If you have the following settings in your PC:
- Open Control Panel
- Click on Clock and Region > Region
- Click on Additional settings…
- See List separator: “,” (comma) then you cannot use the same in MS Excel.
To check the Separator in Excel, follow the steps below:
- Open Excel
- Navigate to File > Options
- Click on Advanced options
- See Decimal separator: “,” (comma) as well.
This will encounter the error with your wrong coding and system will use semicolons as a list separator. You would need to use “.” (Dot) in an Excel Options instead. This will resolve the error.
Was this helpful? Are you encountering the similar issues? Please, share them with us in our Community. ;-)