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…
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…
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…
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…
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…
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…
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…
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…
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…
