Browse By Tags

  • Create Menu Item/Link to a specific SQL Query Tool Report

    I created a sql query tool report from (All - Setup - Usage - Reports - Sql Query Tool). Is there a way to link this specific report as a menu item? I've tried creating a new menu item and setting it as a query, but I'm getting an error stating that…
  • Ajuda Bloqueio de Função Modificar Tarifa

    Bom dia Caríssimos, Necessitava de implementar um bloqueio às minhas Tarifas saldadas de forma a que um determinado perfil de utilizadores não possa fazer a modificação das mesmas após o saldo... Por exemplo: Após a Tarifa Saldada só os Utilizadores com…
  • V12 2024 R1 Disponible

    Bonjour, La mise à jour 12.0.35 (2024 R1) est disponible sur la Base de Connaissance Sage . La release note est disponible ici .
  • 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