Browse By Tags

  • Who or What is the user "External" in the SYSUSR_0 column in the gacentryd table in Sage X3

    In Sage X3, the user "External" appearing in the SYSUSR_0 column of the GACENTRYD table serves a specific purpose related to system operations. This user is used to denote transactions or actions that originate from external sources or automated processes…
  • Sage X3 training schedule for May 2024!

    Ignite your journey and invest in your growth - cultivate more knowledge, hone more skills, and embrace more confidence. Whether you are new to Sage X3, need a refresher, or want to expand your skills, SageU has the courses to support your continual learning…
  • If we clear the AUDITH will that sort out the high count of indexes as well on the tables

    Clearing the AUDITH table in Sage X3 will not directly address the high count of indexes on other tables, including the issue you're experiencing with the IDX file group. The AUDITH table stores audit trail information, such as changes made to data within…
  • How to fix [master_not_discovered_exception] error in Sage X3

    The [master_not_discovered_exception] error in Sage X3 typically indicates an issue with the Elasticsearch configuration or connectivity. Elasticsearch is a distributed search and analytics engine that Sage X3 uses for indexing and searching data. Here…
  • Why does the IDX file group grow so rapidly in Sage X3

    If the IDX file group in Sage X3 is growing rapidly, it indicates that there may be underlying issues contributing to excessive index growth. Here are several potential reasons why the IDX file group could be growing rapidly in Sage X3: Fragmented…
  • What is a IDX file group in Sage X3

    In Sage X3, the IDX file group is a set of files used by the database management system (DBMS) to store index data for tables within the Sage X3 database. These index files are used to facilitate efficient retrieval of data when executing queries against…
  • How do I stop my IDX database file growing massively with Sage X3

    To prevent the IDX database file from growing massively with Sage X3, you can take several steps to manage and optimize your database usage. Here's a guide on what you can do: 1. Regular Database Maintenance: Perform regular maintenance tasks on your…
  • Report with list of Users,roles,group and badges

    Hi all, I am currently looking into a report or some sort of information where i can see a report with list of Users,roles,group and badges and their function profile and menu all on one report. Perhaps is it a SQL query, any idea and tip welcomed.
  • Disponibilidad del parche: X3 2024R1 (12.035)

    Producto: Sage X3 Versión: V12 Fecha: Abril 2024 Disponibilidad del parche: X3 2024 R1 (12.0.35) Los parches contienen las últimas actualizaciones para mejoras, estabilidad y rendimiento de su sistema, y se recomiendan para todos los clientes…
  • Where does a cash requirement table TMPCSRQ get populated?

    Does anyone know where or how a cash requirement table TMPCSRQ gets populated? The report code that is used is NA-CSHREQ.
  • Back-to-Back order function grey out in Sales Order Screen

    Hi everyone, I got an issue where I was unable to create B2B order in sales order screen as the option is grey out I have checked my product setup and It has the 'back-to-back order' ticked However, I am able to use the Back-to-Back order function…
  • Maximum stock setup in product site

    Hello, can anyone tell me how can I setup the maximum stock quantity for a product site. I tried adding it in product site but don't know how it works, the system still allows me to receive more stock. I need such a setup that once the maximum quantity…
  • Maximum stock limit in Sage X3

    Hello, can anyone tell me how can I setup the maximum stock quantity for a product site. I tried adding it in product site but don't know how it works, the system still allows me to receive more stock. I need such a setup that once the maximum quantity…
  • Deactivate Test Environment

    Hi There, We have a test environment called TEST 2024, does anyone have the steps to deactivate it? It's interfering with another connection that we have. Thanks, Julie
  • Is it possible create new keyboard shortcuts in Sage?

    I was asked about a shortcut to print a screen array to an Excel export, instead of the user having to click "Excel Export". Thanks, Zoey
  • New Syracuse Server Updates For Sage X3 2023 R1 & 2023 R2 (Syracuse Server 12.18.20.3 & 12.19.18.4) Are Available For Download

    To access this download, visit our Sage Knowledgebase Site HERE , then scroll down to locate the Download Sage X3 Version 2023R1 (12.0.33) then look for Download Sage X3 Syracuse Server 12.18.20.3 (2023R1) OR Download Sage X3 Version 2023 R2 (12.0.34…
  • Gráficos

    Bom dia, Será possível criar um gráfico em um ecrã clássico "normal", ou seja, que não seja apresentado em uma home page? J.Roberto
  • Printing a Zero Check

    Hello, I need to create a zero "0" check in accounts payable to clear open credits and debits on a Supplier/Vendor. Can this be done?
  • ZONSUI no works

    Hi I try to use zonsui to move cursor in a grid. In After modif subprog field, I added zonsui = "NAMEFIELD", about another field from grid. This optioon no works. I try too zonsui = "NAMEFIELD("+num$(nolign-1)+")" , but no works too. Version…
  • Reopen a sales order that was closed by accident

    We have a sales order that was closed by accident. Partly delivered, partially invoiced. Is it possible to reopen this somehow?
  • Invoicing a REC in X3

    I have just started doing A/P after employee left. I have very little notes and no training. Does anyone have a step by step instructions for this process. I am stuck that I am unable to get a REC to 'post'. Thank you, cheryl
  • Unknown warning upon login - Access to the ERPMAN badge(s) has not been granted

    Hello, One of our user groups randomly started experiencing this warning upon logging in. Does anyone know a fix? Thank you, Zoey
  • Sage Enterprise Intelligence Version 2024 Release 3 and related templates are now available for download from Nectari

    The latest version of Sage Enterprise Intelligence (SEI), 2024 Release 3 and related templates are now available for download directly from Nectari. SEI and templates are no longer available through the Sage Knowledgebase. You must be registered to…
  • @X3.TRT/GOBJET1$adx (163) Erro 76 : Erro SQL server (Microsoft) [ODBC Driver 17 for SQL Server[SQL Server] Invalid object name

    Hello, After updating to p34, when trying to create a client (GESBPC) the following error appears: Checking the database, the table in question does not exist: What do we need to do to adjust this information, is it on the X3 or SEI?
  • How to call action flags in "Standard Processing" types of functions - FUNCLEAR (Close & Reopen Purchase Orders)

    Hello! I've added a field, ZMNSTA, to the CLE2 (Close & Reopen Purchase Orders) screen, in order to display a custom field from ITMMASTER for each product. However, upon entering my code into SPECLE2, it seems that no actions are being called at all…