How to Setup a Default Date Range for multiple reports and inquiries in Sage X3

By | December 19, 2020

While generating multiple reports in order to compile data across various departments in the organization every time the end user has to enter the date range in the report parameters every time they generate the report which becomes a quiet task and can be error prone too.

Parameter Setup

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 in Sage X3

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)

Click ‘Ok’ when finished and save.

Folder Setup

Go to Setup > General Parameters > Parameter Values

Expand the SUP Chapter and select the appropriate folder

Click on the dots or action box for the DEF Group and select ‘Detail’

Enter the default start and end dates

Click ‘OK’ and save

Parameter Values Settings

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

Enter Report Parameters Values
Account Balance Inquiry Screen

Thus by following and applying the above stated steps and process the end user shall be able to generate multiple reports and multiple inquiries within the same date range in Sage X3.

About Us

Greytrix Africa is a leading Implementation, Reselling and Consulting partner for Sage X3, Sage 300, Sage 300 People & Sage CRM based out of Nairobi, Kenya in Africa region catering to Tanzania, Ethiopia, Middle East, Australia and Asia business sectors.

Greytrix Africa offers professional services such as Implementation & configurationBusiness Process AnalysisProject Management, Customization, Integrations & Migrations, Technical support and Onsite resource augmentation along with enhancements within Sage X3, Sage 300 PeopleSage CRM and Sage 300 (Accpac) across various industry verticals like Process Manufacturing (Food & BeveragesChemical), Discrete manufacturing (AutomotiveTextile & Apparel), Non ProfitHealth-care Industry and Service Industry (Financial , Software & Engineering).

For more information on Sage X3 Consulting Services, please contact us at sales@greytrix.com. We will like to hear from you.