RKL eSolutions Blog Trends and Insights

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’

 User-Level-Setup

  1. 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)
  2. 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

 Parameter values

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

Report parameters

Acct-balance-inquiry

Tags: Sage X3, How-To
LeeAnn Segan

Written by LeeAnn Segan

LeeAnn Segan is an ERP Support Specialist with RKL eSolutions LLP. She supports Sage 500 ERP and Sage X3. LeeAnn specializes in the financial and distribution modules. Her background includes managing distribution and warehousing for ecommerce based companies. When not working, LeeAnn enjoys working out, volunteering with groups that support special needs, and spending time at the beach with family and friends.