How to Setup a Default Date Range for Reports and Inquiries in Sage X3

When running reports or inquiries in Sage X3 the user may have to enter a start and end date each time they access this report. This can become especially frustrating when trying to compile data across multiple reports or when sharing information with various departments within the organization.  By setting up a default date range users can save time and minimize data entry mistakes when running reports and inquiries.

These steps will walk through how to setup default date ranges in Sage X3 at the user and folder level.

Setup at the User Level:

1. Go to Setup > Users > Users
2. Select the User Code
3. Click on the ‘Parameters’ anchor or tab
4. From the ‘Parameters’ section locate the Chapter = Supervisor and Group = DEF (Default Values)
5. Click the dots or action box and select ‘Detail’

6. Update the following parameters to the desired start and end dates:
   • DATEDEBDFT (Default Start Date)
   • DATEFINDFT (Default End Date)
   • DATSTADEB (Statistical start date)
   • DATSTAFIN (Statistical end date)
7. Click ‘Ok’ when finished and save.

Setup at the Folder Level:

1. Go to Setup > General Parameters > Parameter Values
2. Expand the SUP Chapter and select the appropriate folder
3. Click on the dots or action box for the DEF Group and select ‘Detail’
4. Enter the default start and end dates
5. Click ‘OK’ and save

When running a report the default date range will now automatically populate