Accounting ( Double Entry ) Account Balance - CSV

Using my Dolibarr
1

Version 10.0.0.2
Accounting ( Double Entry ) Accounting - Account Balance- CSV export does not work correctly. Currency comma separators causing issues.
See picture below:
Also is there a way to add headers.
Actual CSV
111201,Current Account KBank ,1,006,420.00,6,420.00,1,000,000.00,
111301,Savings Account ,500,000.00,642.00,499,358.00,
113001,Accounts Receivable Trade,14,284.50,6,420.00,7,864.50,
212001,Accounts Payable Trade,7,062.00,0.00,7,062.00,
213206,Sales VAT,0.00,934.50,-934.50,
410001,Sales GOODS ,0.00,12,000.00,-12,000.00,
410005,Service Revenue ,0.00,1,350.00,-1,350.00,
539004,Non Deductible Expenses,0.00,1,500,000.00,-1,500,000.00,

Thanks

accountbalanceexport.png
accountbalanceexport.png877×750 69.8 KB

2

Hi quid,
The reason your csv is not formatting correctly is because of the your csv separator which I’m suspecting is semicolon instead of comma. For Dolibarr the CSV separator is comma. You can check your separator in Windows from control panel regional settings. There is also an option of exporting to Excel why not use that?

3

I dont think this is reason. see csv raw data in above post also see screenshot there is no option to export to excel.
What you are pointing is export from import - export tool.

4

What happens if you do this?

Go to Accounting \ Setup \ Export Options.
Change “Column separator for export file” to something else.

5

yes, if I change separator to something else eg semicolon, it works ok.
But I think when exporting currency separator should not be included in the export. I think export is not loading data from database but it is loading from presented webpage.

6

The data cannot be from webpage only from the database!