Hi
When I export a bespoke report to 'Data to excel' the data columns are not in the correct order:
IE.
Column G - PaymentAnalysis.Desc2
Column H - PaymentAnalysis.Desc4
Column I - PaymentAnalysis.Desc6
Column J - PaymentAnalysis.Desc10
…
I'm trying to find out how to add a filter expression on a report for Sage 50 Accounts, such that the report only looks at GDN_ITEM_DATE that is from the last 12 months from the CRITERIA.GDN_ITEM_DATE_TO specified when the report is run. I then need to…