{"id":21325,"date":"2020-12-19T10:00:19","date_gmt":"2020-12-19T10:00:19","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagex3\/?p=21325"},"modified":"2021-01-04T05:38:35","modified_gmt":"2021-01-04T05:38:35","slug":"how-to-setup-a-default-date-range-for-multiple-reports-and-inquiries-in-sage-x3","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2020\/12\/19\/how-to-setup-a-default-date-range-for-multiple-reports-and-inquiries-in-sage-x3\/","title":{"rendered":"How to Setup a Default Date Range for multiple reports and inquiries in Sage X3"},"content":{"rendered":"\n

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.<\/p>\n\n\n\n

Parameter Setup<\/span><\/strong><\/p>\n\n\n\n

1. Go to Setup > Users > Users<\/p>\n\n\n\n

2. Select the User Code<\/p>\n\n\n\n

3. Click on the \u2018Parameters\u2019 anchor or tab<\/p>\n\n\n\n

4. From the \u2018Parameters\u2019 section locate the Chapter = Supervisor and Group = DEF (Default Values)<\/p>\n\n\n\n

5. Click the dots or action box and select \u2018Detail\u2019<\/p>\n\n\n\n

\"User-Level-Setup<\/figure>\n\n\n\n

Update the following parameters to the desired start and end dates:<\/p>\n\n\n\n

DATEDEBDFT (Default Start Date)<\/p>\n\n\n\n

DATEFINDFT (Default End Date)<\/p>\n\n\n\n

DATSTADEB (Statistical start date)<\/p>\n\n\n\n

DATSTAFIN (Statistical end date)<\/p>\n\n\n\n

Click \u2018Ok\u2019 when finished and save.<\/p>\n\n\n\n

Folder Setup<\/span><\/strong><\/p>\n\n\n\n

Go to Setup > General Parameters > Parameter Values<\/p>\n\n\n\n

Expand the SUP Chapter and select the appropriate folder<\/p>\n\n\n\n

Click on the dots or action box for the DEF Group and select \u2018Detail\u2019<\/p>\n\n\n\n

Enter the default start and end dates<\/p>\n\n\n\n

Click \u2018OK\u2019 and save<\/p>\n\n\n\n

\"Parameter<\/figure>\n\n\n\n

When running a report the default date range will now automatically populate<\/p>\n\n\n\n

\"Enter<\/figure>\n\n\n\n
\"Account<\/figure>\n\n\n\n

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<\/strong>.<\/p>\n\n\n","protected":false},"excerpt":{"rendered":"

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\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,3162,8,9,2796],"tags":[919,924,929,930,1822,1839,1942,1945,2079],"class_list":["post-21325","post","type-post","status-publish","format-standard","hentry","category-configuration","category-greytrix","category-sage-erp-x3","category-sage-x3-consulting","category-technical","tag-greytrix-africa","tag-greytrix-blogs","tag-greytrix-kenya","tag-greytrix-sage-x3","tag-sage-x3","tag-sage-x3-blogs","tag-sage-x3-technical-assistance","tag-sage-x3-technical-blogs","tag-setup"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/21325","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=21325"}],"version-history":[{"count":10,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/21325\/revisions"}],"predecessor-version":[{"id":21545,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/21325\/revisions\/21545"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=21325"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=21325"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=21325"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}