Blogger
Share this content
0
2
5674

Date sorting invoices on sage statements

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

Please login or register to join the discussion.

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)

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

Yvonne :)

 

Thanks (0)