Browse By Tags

  • Graphical Query tool - selection criteria based on Expression

    Trying to create a query based on items that are out on loan to customers. My query includes an Expression calculation based on what has been delivered to a customer minus what has been returned. So using two tables QTY on SORDERQ-RETURND, therefore…
  • Floor stock items

    How to categorize floor stock items in X3? Items that we issue in bulk like screws - we don't want them to be issued on the Pick Lists. Please advise
  • Difference of Table Fields and Screen Field

    Hi All, I have been using table fields to upload and connect it to its respective screens while working on an import template. But in address tab it uses "Screen fields" Does anyone understand the purpose or difference between the following fields…
  • Connexion between Sage X3 V5 and Sql Server

    I want to establish a connection between Sage X3 and SQL server but I can't do it. Can anyone help me or should I go another way?
  • Syracuse impossible to read the passphrase

    Hello I've installed the Syracuse package on Red Hat Linux and configured it to run as the user 'sagex3'. Now, I need to modify all Syracuse service files to run as the 'root' user. However, upon attempting to start the Syracuse service, I encountered…
  • Error in Mobile gadgets

    Hi! I try to entry in any standard application of SageX3 mobile view, and all options return error : ERROR : endpoint application is not a function. Any idea? it's necessary a basic configuration to woks fine? Thanks a lot.
  • Slow Performance during Report Phase Job Started in X3 V12

    I did open debug mod on print server. I printed the same invoice to different destination. The following is part of log information from trace file. Is there anyone who know what highlight part means? any idea how could I make printing faster? …
  • "Entry impossible: the preparation code for this site has not been set up!"

    Hello, I have a need to explore the usage of "preparation codes", however, when I try to set one up, I get an error: How do I bypass this, or set up a preparation code at the site as mentioned? I cannot click in the preparation code box. A site…
  • FUNBENCHR - What is the best way to return an item consumed 3 levels under the current Work Order?

    Hi everybody! I Have in the most of the cases, semi-finished goods inside other semi-finished goods and then the finish good. Imagine a scenario that i have this kind of BOM: Product A : Finished good 1 x Product B : Semi finished good 1…
  • Error (Application server time)<4076 when running FUNSTKACC

    The error happened when running FUNSTKACC (Sage ERP X3 V12 P33). It's hard to replicate the error. The error happened when system tried to update records in STOJOU table. Is there anyone who know meaning of the error? I suspect It might be related…
  • VIREBOUT DON'T DISABLE NEW BUTTON

    Hi. I have v12 (2023 R2 (12.0.34)) and I create new window type Miscelaneus and Display = Full screen. I add two new buttons with code z an i , one validating and another no validating. In SETBOUT ACTION, I add this lines: Call VIREBOUT(CHAINE…
  • DateTime Created 2 hours behind server datetime created

    Good day SQL and Application server date/time is correct, but in the transactional tables the date/time is 2 hours behind. End user PC datetime is also correct. How is this possible?
  • SAGE X3 UP 9

    Hello Hello to all the Sage Community, I introduce myself i m from TUNISIA and i work on Sage Solutions since 1998 so about 26 years and i wonder if in this Community of philantrop and experience is there a Virtualmachine or Plateform to access to…
  • Modulo configurador de producto

    Buenos dias. Alguien me sabria decir si el módulo Configurador de productos, es un apartado que va ya por defecto en X3 como los otros standards? o son unas funcionalidades que se deben de activar/contratar a parte en la licencia? Gracias!
  • Product is in stock with 0 quantity, location shows a quantity with no product

    Hi there. There seems to be a de-synchronization between the product and its location. The product shows null quantity in the location. The location shows a quantity (59) but a null product and is "empty" Misc. issue and receipt is also messed…
  • Automate SSL certificate import

    Is anyone automating the installation of a SSL cert for X3? For years we have been using the cert import via X3 UI but this becomes tedious. Most of our apache, tomcat, and IIS web servers are getting lets encrypt certs via win-acme on an automated…
  • Set replenishment rule

    Hi all, I'm trying to set a replenishment rule on a location from another one. We have raw materials in let's say Site: S01, loc type: MAN, location: RM00. We would like to set replenishment rules on this location from another one from the same site…
  • Limitar cambio de estado de proyecto

    Hola comunidad! Me han planteado esta duda y me gustaría consultaros sobre cuanto se pueden parametrizar los permisos a la hora de cambiar el estado de proyecto. La pregunta mas importante seria, es posible limitar los permisos a la hora de cambiar…
  • Encounter error when running Stock Accounting Interface

    Upon running the Stock Accounting Interface interface, I consistently encounter the following error: SOOCKSE22006354 Nonexistent dimension value (STKIS Line 3) Miscellaneous issue VCRNUM=MIOCKSE23003691 Upon thorough investigation, it has come to my…
  • REQUETE ERP X3

    Bonsoir a tous j'aimerais extraire ces champs ou faire un état de sage x3 STOVALWRK.ITMREF_0 | STOCK.LOC_0 | STOVALWRK.CST_0 | ITMMASTER.TCLCOD_0 cela fais intervenir trois tables STOVALWRK,STOCK,ITMMASTER mais le problèmes c'est que la table STOVALWRK…
  • Default Locations within Product-Site

    All, We have default locations setup using product-site within our system. However, there are times when we need more than one location to store products because of space & their replenishment levels. My question, can you add more default locations…
  • Finding Lot numbers on Unconfirmed Deliveries

    Our business would like to print packing slips before delivery confirmation. In most cases, I can see the lot numbers from screen WK4STD1 but I cannot find the table where that lot is stored. SDELIVERYD seems to only have a lot number for some records…
  • Setting up ZPL Printer (Private Network) with Sage X3 (Cloud)

    Hello Everyone, We are trying to setup ZPL printer on Sage X3 but the problem we are facing is: a. ZPL printer is on a private (LAN) network - not accessible outside b. Sage X3 is on the cloud (Accessible only by a secured SSL URL) c. Sage X3…
  • Bank Reconciliation add supplier name

    Within the screen BNR0 Bank reconciliation has these reference tables which is OTB GACCENTRY Accounting entries GACCENTRYD Accounting entry lines BANREC Bank Reconciliation Statement BANRECD …
  • Sagex3 v12 linux services systemctl

    Hello, after installation of sagex3 in redhat i noticed all services in /etc/systemd/system not working so i need to lunch for exemple adonix from management console in windows have you any exemple of files to start / stop all services sgaesx3 ? …