RE: Export to csv change order in columns
You're actually running into a documented issue we have, which I re-created in GP 18.3 as well.
The issue is the 'Debit column in Page Header of Dynamics GP is misplaced when the Trial Balance Summary report is exported to .CSV'.
The first page shows the columns in the correct order: Inactive / Account/ Description/ Beginning Balance/ Debit / Credit/ Net Change/ Ending Balance
The second page changes the columns to be in the order: Inactive / Account/ Description/ Beginning Balance / Credit/ Net Change/ Ending Balance/ Debit.
What we've found in most cases with this issue, is that the 'Debit' text field in the report is a pixel lower than the rest of the column headers, thus causing the file to export with the 'Debit' column last instead of the intended position.
We have seen where, in Report Writer, the report can be modified so that the 'Debit' text field is vertically aligned with the other columns on the Page Header section of the report.
Right now, there aren't any planned fix to this issue in upcoming releases of Dynamics GP.
Thanks