Hi,
We have Sage 50 Accounts Professional 2010 Version: 16.0.4.113
When running certain reports (such as Audit Trails) the Criteria Value 'Transaction Date', end date defaults to 31/12/2019, is it possible to change this using the reports designer, I have had a dig around bit cannot see how or where this date is prepopulated from.
Thanks
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
Prefilled 'to' Date in criteria defaults to 2019
- brucedenney
- Site Admin
- Posts: 4643
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Setting default range in Sage 50 Report Designer (dates or any other value)
To set the default criteria in any report.
Open the report in the report designer.
Got to Report>Criteria Select the range you want to alter the default for and press modify.
Now change the Status from Enabled to Preset and press ok
It will now prompt you to enter the Preset values, these are going to become the defaults so enter the date you want and press ok
Now change the Status from Preset back to Enabled and press ok
Save the report and try it out.
Open the report in the report designer.
Got to Report>Criteria Select the range you want to alter the default for and press modify.
Now change the Status from Enabled to Preset and press ok
It will now prompt you to enter the Preset values, these are going to become the defaults so enter the date you want and press ok
Now change the Status from Preset back to Enabled and press ok
Save the report and try it out.
Login to access the files attached to this post.
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.
Re: Prefilled 'to' Date in criteria defaults to 2019
Thanks, thats very helpful, setting a YE date works a treat.
To set the date range to include all trans. up to the current date, as with the 'From' Date being preset to 1980', the 'to' could be any date in say 2030. Back in 2010 Sage must have assumed we would all be living on Mars by 2019.
To set the date range to include all trans. up to the current date, as with the 'From' Date being preset to 1980', the 'to' could be any date in say 2030. Back in 2010 Sage must have assumed we would all be living on Mars by 2019.
- brucedenney
- Site Admin
- Posts: 4643
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: Prefilled 'to' Date in criteria defaults to 2019
You can go as late as the version of sage you use supports.
31/12/2999 would be good
31/12/2999 would be good
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.
Who is online
Users browsing this forum: No registered users and 1 guest