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