Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
Sort order of invoices on statement
-
- User
- Posts: 3
- Joined: 10 Apr 2009, 18:41
Sort order of invoices on statement
Is there a way to sort the order that the invoices are listed in a statement?
When I print a statement the invoices don't seem to be in any particular order. I would like them to be listed according to the date of the invoice.
When I print a statement the invoices don't seem to be in any particular order. I would like them to be listed according to the date of the invoice.
- brucedenney
- Site Admin
- Posts: 4631
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
You can set the sort order in the report layout.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
-
- User
- Posts: 3
- Joined: 10 Apr 2009, 18:41
Re: Sort order of invoices on statement
I tried applying a sort to the date field but it didnt make any difference.
- brucedenney
- Site Admin
- Posts: 4631
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: Sort order of invoices on statement
What version of Sage 50 are you using?
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.
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.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
-
- User
- Posts: 24
- Joined: 10 Jan 2011, 16:37
- Sage Version: v2013 19 UK/Europe/Africa
Re: Sort order of invoices on statement
Thank God I found this site. I've been trying to sort my statements in date Order and had tried adding that Audit Header Date section but didn't realise that I needed to create a second Header Number Section and delete the older one. This worked perfectly for me . Thanks !
Re: Sort order of invoices on statement
HELLPPPPP
you ahve all solved my problem but i am at a complete loss as to what exactly youa re talking about ie audit headers date range groups!!
arrrgghghhh help me i 'm a sage designer newbie
you ahve all solved my problem but i am at a complete loss as to what exactly youa re talking about ie audit headers date range groups!!
arrrgghghhh help me i 'm a sage designer newbie
-
- User
- Posts: 24
- Joined: 10 Jan 2011, 16:37
- Sage Version: v2013 19 UK/Europe/Africa
Re: Sort order of invoices on statement
Credit to brucedenney . I followed the instructions posted and got it sorted . If you're a newbie to Sage reporting then you may not find it easy. This is what I did .
To Create a Sage Statement in Date order:
Select the statement that you want to edit and open the report designer.
Add Section Audit Header Date
Add Section Audit Header Header Number
You will now have duplicated - Audit Header Header Number
Copy the Existing fields from the original Audit Header Header Number Footer and copy to the new Audit Header –Header Number Footer Section.
Now delete the old Audit Header Number Section.
Make the Audit Header Date Section and any other sections not required.– Not visible .
Click on the Amounts fields in the Audit Header Footer.
On the properties Tab , reset section to Audit Header Header Number Footer.
Click on the Audit Header Header Number Footer Section (The Heading) and Make sure that the following Filter applies. AUDIT_SPLIT.DATE_FLAG <> 1
If you're still in trouble , there are plenty of companies who can help you. email or request the template that you want sorted and it can be returned in the correct format .
To Create a Sage Statement in Date order:
Select the statement that you want to edit and open the report designer.
Add Section Audit Header Date
Add Section Audit Header Header Number
You will now have duplicated - Audit Header Header Number
Copy the Existing fields from the original Audit Header Header Number Footer and copy to the new Audit Header –Header Number Footer Section.
Now delete the old Audit Header Number Section.
Make the Audit Header Date Section and any other sections not required.– Not visible .
Click on the Amounts fields in the Audit Header Footer.
On the properties Tab , reset section to Audit Header Header Number Footer.
Click on the Audit Header Header Number Footer Section (The Heading) and Make sure that the following Filter applies. AUDIT_SPLIT.DATE_FLAG <> 1
If you're still in trouble , there are plenty of companies who can help you. email or request the template that you want sorted and it can be returned in the correct format .
Who is online
Users browsing this forum: No registered users and 17 guests