I have tried to export TSV file out from General Ledger Transaction. The aim is to use the info in Excel and OpenOffice Calc.
Both Excel and Open Office Calc were unable to display the data correctly. And I found the reason is because the exported TSV file is shifted in the first place, hence causing the importing to shift and unusable.
1.) Every transaction is displayed in 1 line in Manager Software - General Ledger.
2.) But when exported, the TSV file shows the Order xxxxx is shifted to the line below.
3.) Hence when imported in Excel and Calc, both shows the Order xxx is on the next line, rather than within the same row. Further down in the data, the debit and credit figure also gets shifted, making the import poor, and unable to use the information for — analysis, addition as the figures are scattered in different columns.
So, I think there is a bug with the exporting of TSV file.