Getting report writer reports to Excel has never been that easy. Usually it entails sending the report out to a CSV file and then cleaning up the mess. One thing that seems to help a bit is to put the following line in the dex.ini file.
If you then save the report to a tab delimited file and open it with Excel it seems to come over a little better. Try doing this.
- Put ExportOneLineBody=TRUE in your dex.ini file
- Open Dynamics and run a AR trial balance with options. Make the file destination Tab delimited
- Open the file with Excel and it should look something like this:
(Click on image to see a better shot of the report)
Instead of like this: