RKL eSolutions Blog Trends and Insights

How to Change Default Stock History Days in Sage X3

There is a misconception that altering the default setting for Stock History Days within the Stock Transactions Inquiry screen is not feasible. The default duration, 8 days, may not be practical for all business cases. 

Some cases where you may need to change the stock history days:

  • You need to look back further to see the history of a product's movements
  • You want to export a large amount of movement data to Excel to look for trends

Picture1

Picture2

The below steps will show you how to change the number of days to something that makes more sense to you and your business processes.

  1.  Click "Setup," then go to "General Parameters," and click on "Parameter values."

    Picture3
  2. Choose the STO Inventory Chapter. In the example below, it is called "PILOT."

    Picture4
  3. Click on the three-dot icon on the Miscellaneous (MIS) option and click "Detail."

    Picture5
  4. In the parameter of INQMVSLTI with the description of Transaction inquiry history, you can change the numerical value. The default is 8, but change it to something that makes sense for your business. In the example below, I changed it to 365. Click "Ok" at the top of the screen to save the change.

    Picture6
  5. Click the Save icon on the parameters screen to save the change. Generally, you need to log out of X3 and back in for the changes to take effect.
    Picture7

Your stock inquiries will now default to the new number of days specified.


Want More Sage X3 Features & Functions?

For more Sage X3 videos, visit our YouTube page and subscribe to stay up-to-date with the latest insights and tutorials. Our channel is dedicated to providing valuable resources for businesses looking to optimize their financial management with Sage X3.

question-markCheck out these blogs to help get you started!

4 Functions to Use in the Preventive Maintenance Solution
How to Match Tolerances
How to Receive Notifications on a Batch Job Error
How to View Multiple Lines When Running an Inquiry

Tags: Sage X3, How-To
Amy Powell

Written by Amy Powell

Amy is based out of Florida working as a Senior Solution Architect on our Sage X3 team. With her 25+ years of experience, she specializes in process manufacturing and discrete manufacturing ERP implementations.