Customer statement in date order - problem.
Posted: 28 Sep 2012, 08:44
Customer statements tweak in Report Desginer - help
I am attempting to produce a customer statement in ascending date order.
I have set the sort field to Audit_Header.Account_Ref followed by Audit_Split.Date in that order. No other 'Sorts' apply.
The customer statement still fails to come in date order. Somehow Sage Report Desginer is still sorting on transaction number instead, even though Trans_Number is not in the listed sorts or indeed even in the HEADER NUMBER Footer list; I have Date, Inv Ref and Details fields, but no Transaction number field.
Advice gratefully received.
I am attempting to produce a customer statement in ascending date order.
I have set the sort field to Audit_Header.Account_Ref followed by Audit_Split.Date in that order. No other 'Sorts' apply.
The customer statement still fails to come in date order. Somehow Sage Report Desginer is still sorting on transaction number instead, even though Trans_Number is not in the listed sorts or indeed even in the HEADER NUMBER Footer list; I have Date, Inv Ref and Details fields, but no Transaction number field.
Advice gratefully received.