Date sorting invoices on sage statements

Date sorting invoices on sage statements

Didn't find your answer?

Does anyone know how to reorder the invoice list on Sage 50 statements to show by date order.

I have put a data sort item into the report of audit_split.date, but these seems to have no affect.

It is my  own template I am using, but this is copied from a Sage standard template and if I go into any of the Sage standard reports and they also do not list the invoices in date order and putting the same sort on the report also has no affect.

Replies (2)

Please login or register to join the discussion.

avatar
By johndon68
11th May 2012 11:37

Sorting

I've not tried it but, what I think you need to do is go into the Report Designer and add a group for Invoice Date to the statement.  You don't need to show or print it, just add the group section for "AUDIT_SPLIT.DATE" and suppress Header and Footer.

John

 

Thanks (1)
avatar
By tukans
11th May 2012 12:03

Thanks John, this worked. I had to move it into the right order within the other the groups.

Yvonne :)

 

Thanks (0)