invioce date order on statements

[paul2014]

Hi

I'm new to this site and to reports generator (although I've been a sage user for longer than I care to admit to)

I'm trying to build a layout for customer statements, I've re-used the current plain paper default layout already in the Sage program but I cant work out how to show invoices in date order

I've read quite a few posts regarding Sorts and Groups and other stuff but I think I must live in a different world because I don't understand any of it

can anybody please tell me (step-by-step) how I do this

many thanks

P

[brucedenney]

It is not the sort, it is the grouping that is getting in the way.

You need to group by transaction date

[brucedenney]

In general of these types of reports the default is to sort by the account, then the date flag (to hide earlier transactions), and then the audit trail number. If you added a date sort onto the end then, it would be sorting by date where the audit trail number was the same, which is never going to happen.

You need to add the date field as a group, then add the header number as a group (so there are two of them)
hide the date group because we are not needing it, it is only there to sort
move the layout from the original header group into the new one,
remove the header group

The sort should then be account>date flag>date>transaction number and everything should be fine.

If you want to upload your report layout as an attachment I am happy to look at it for you.

[ManicMillie]

Hi

I've tried and failed numerous times, to sort my statement report into 'date' order, but I must be doing something wrong? I found an earlier dated forum with more information from you Bruce, but when I have tried to follow it and 'add in sections', something is definitely not right.

When Sage was initially set up for us, the IT Consultant that installed it, modified some reports etc specifically for us, when I've tried to follow your instructions, I can't seem to physically 'see' the added in sections and then I've had trouble copying the data from one field to another.

Any help would be much apprceiated. I'll upload a copy of the file also if that helps. Thanks in advance. Lisa

[ManicMillie]

Libra FMC Ltd Statement Grouped O.S Only.layout

Please find attached copy of the statement report that I use, but am unable to amend into date order, as per my message

[brucedenney]

Open the layout in the designer

Sections>Add Section>Group Header And Footer
In the Audit Header Table, pick the date field "AUDIT_HEADER.DATE"
OK

You now have your section, the only problem is that it is sorting inside the INV_REF so within each invoice reference it is sorting by date, so you need to move the footer section down by clicking on the down arrow button to the right on the AUDIT_HEADER.DATE Footer section just left of the x
Move it down so it is below the DATE_FLAG Footer.

We don't need to see the header or the footer so you can now hide them
Click on each of them in turn and in their properties you can set the "Visible" property to "False" or you can leave it visible and set the "Suppress Print" property to "true"