Hot topics
  • Sage X3 Support: How to convert an active simulation journal into an actual one?

    Occasionally when closing a fiscal period, we get an error "HAE Temporary Journal: GENAJ GEN000019 On the Journal: GENAJ Active simulation". Until you set the active simulation journal to actual or cancelled the period cannot be closed. Active simulation journals can be converted into real journal or deactivated to become an inactive simulation journal (not visible in inquiries and reports). We can use the activation…

    • 27 Jul 2021
  • Sage X3 Support: Moving a custom auto journal to a new home

    Have a custom auto journal that you would like to move over from your Test environment to your Production environment? Dreading the time-consuming task of manually keying it in Production plus the fear of making a mistake? There is an easier way! Let’s take a look at how we can move that custom auto journal into Production.

    This process is similar to the previous “moving/copying” tasks that we’ve looked at in…

    • 23 Jul 2021
  • Sage X3 Support: How do you Update the Search Indexes?

    Hey, Hey Readers,

    Today we are going to cover how to update search indexes in Sage X3. Search index is one of those things no one really looks into much. It controls the search bar and its criteria on the top right of the screen. This search bar can be used to look up just about anything in the system, as long as the index is up to date. The index is controlled by the Elasticsearch component install (in v12 its just a…

    • 20 Jul 2021
  • Sage X3 Support: SQL Server Topic - Max Degree of Parallelism

    Last month in June, I wrote about capping SQL Server's memory so that it does not use up all available memory. You can read about it here. In this blog, I want to look at another setting in SQL Server, and that setting is the Max Degree of Parallelism. We will also look at another setting, Cost Threshold for Parallelism, which affects the Max Degree of Parallelism option.  Let's take a look at these options and what…

    • 12 Jul 2021
  • Sage X3 Support: What are ISO files and why would I need them?

    First, let's start with a quick introduction into what is an ISO file? An ISO file, is an archive file that contains an identical copy (or image) of data found on an optical disc, like a CD or DVD.  ISO files today are used primarily for distributing large programs and operating systems, mainly because all the files are contained in one easily downloaded file. Ok, so now that we've got that out the way, how does this…

    • 12 Jul 2021
  • Sage X3 Support: Do I need to check the Accounting date on the Stock valuation report?

    In Stock, Period processing, Valuation, Stock valuation report, when running the report with the Accounting date box is checked and without the Accounting date checked, the results are different why?

    The FUNSTVA report is used to print STK quantity, Unit price, and the Amount based on the costing method used. If more than one costing method is used on the products, it is possible to print the report using the "Primary…

    • 7 Jul 2021
  • Sage X3 Support: What is the location field in work centers are for?

    We can assign a default location at the work center level and use that location as a default location in stock transactions.

    For example, WO material tracking transactions.

    To issue out material from a work center location we need to first, assign a location to the work center, then this work center will be used when a material is attached to an operation and its allocation rule filters on a local location.

     1.  In Man…

    • 19 Jun 2021
  • Sage X3 Support: Stop! Back away from AMIEXE, GMAINT and SQL data changes! Avoid the headaches they generate!

    Stop! Back away from AMIEXE, GMAINT and SQL data changes! Avoid the headaches they generate! The AMIEXE (Database mass update) screen looks so simple, so innocuous. Don’t be fooled! Along with its friends, SQL Update/Delete/Insert and GMAINT (Table maintenance) Data Changes, they can lead you down a road that requires spending massive amounts of time troubleshooting followed by cleaning up the changes or even restoring…
    • 18 Jun 2021
  • Sage X3 Support: How to use the Performance Measurement Tool.

    Hi readers,

    Before we start, I have a short story for you all…

    A colleague of mine and I were discussing a Case one day. He was explaining to me how he was having trouble getting the performance tool to run to analyze a Performance case for a client. I told him I can show you how it works, as I was thinking to myself, “It shouldn’t be that hard to run. I mean, there is a whole set of Knowledgebase Articles on how…

    • 16 Jun 2021
  • Sage X3 Support: SQL Server Topic - SQL Server has to know its limitations

    The main objective in this blog is to draw your attention to SQL Server and the min/max memory setting. Why is this setting important? Well, SQL Server is a memory hog. It would take all the memory if you let it. SQL Server has got to know its limitations! (Movie quote from an old Clint Eastwood movie, except he wasn't referring to SQL Server of course)   Let's take a look at this setting in SQL Server and explain a…

    • 14 Jun 2021