Hot topics
  • Exploring auto journals: a post update review

    Time for another thrilling adventure exploring the automatic journals!

    In our previous outings, we’ve explored small sections of the auto journals to better understand how they work. We’ve ventured into:

    In today’s adventure…

  • How to add a new report to a function?

    Occasionally, when the standard reports are not sufficient, we utilize an existing report and customize it according to our requirements.

    Once the report is ready, we need to make it available for the user to select the new report from the list.

    In this blog, we will use the standard report codes and have it available in the GESBIS (Supplier BP invoices) function as a selection list.

    Select the navigation menu and go…

  • How to change the status of multiple suggested work orders at once?

    After running MRP and viewing Enterprise planning, it is possible to see work-in-progress orders based on demand. Once work orders are suggested on Enterprise planning, there is a function in Sage X3 called Automatic release “FUNMAUTR” that can be used to change the status of suggested or planned work orders to planned or firm work orders. This function is found in Manufacturing, Batch processes

    Once the function…

  • Best Case Scenario

    Good day,

    Today we discuss submitting cases to the support team.

    We all have ways that we prefer to request help from support, that can be via a phone call, emailing, or logging into the portal and creating your own case.

    Whichever way you determine is best for you if you want a fast turn around and quick responses to your issues its wise to include the following information.

    Keep in mind most of this info is not mandatory…

  • Applying Hotfix Patches in Later Versions of X3 V12

    Hi Readers,

    This month’s topic is not a traditional blog but more of a reminder. Starting mid-December, we (me included) have had an influx of cases coming in for patch updating the 1099s. Every year we put out a 1099 Patch Update and post it. Normally people just download and apply to their Production Endpoint Folder and call it day. This time around though, V12’s cumulative patching process now plays a part in it. The…

  • Prepayment Invoices (GESPREPI) common questions

    Are you thinking of switching to Prepayment invoices (GESPREPI) to handle your prepayments? Have you even heard about it? Let’s take a look at Prepayment invoices and some common questions.

    What is the Prepayment invoice function?

    • This function was introduced in 2021 R3 (v12.0.27). The Release notes describe the new function as follows:

    Create and manage prepayments for sales orders

    You can create, manage, and…

  • What is required when closing the fiscal year in Fixed assets?

    Its that time of the year you might be planning or thinking about closing the fiscal year in fixed assets module and I thought of giving you some helpful hints on closing the fiscal year in fixed assets.

    • Period and Fiscal Year closing (FASCLOTURE) function is located under Fixed assets, Processes, Depreciations, and it’s used to close a selected company and the context.
    • Both Simulation and Actual closings will…
  • Linking Studio 3T with Sage X3

    I’m sure many of you are familiar with Robo3T, a tool used to query the MongoDB application components of Sage X3, however if you have not recently downloaded Robo3T you will learn that this tool has been replaced with Studio 3T.

    In this blog I will cover how to link this tool to Sage as the setup is slightly more complex than Robo3T.

    First let’s download studio 3T from the Robo mongo webpage.

  • What is the difference between the 'Order No.' and 'Entry' used for MRP results in Sage X3?

    When running MRP (Material Requirements Planning) and then checking the results on the MRP results inquiry, notice there is a column called Order no. and another column called Entry. They both have numbers, and the numbers might be the same or might be different. What is the difference between the 'Order No.' and 'Entry’?

    The ‘Order No.’ column stores the Material Requirement number. This is the number…

  • Where to locate the locales for languages

    In light on the holiday season, I have a come up with a shorter than usual blog to discuss. I figured most of us would be in the holiday mindset and wouldn’t have the proper time to review a complex topic. I am like most of you, I am trying to cram in all the work I can before the holidays start.

    Today we are going to take a brief look at Locales. Specifically, where to find them, how to see the details, and how…