Sage X3

is it estimated order quantity? Does anyone know the name of the column in sql? As always, your responses are greatly appreciated!

As seen above, I am looking for received/delivered qty from a Purchase Order. Is it the Received STK or PUR in the PORDERQ table? so far I have been using received stk, but am unsure if that is correct

As seen in the subject, I am looking to join the STOJOU table to the SINVOICED table without the use of the ITMREF column. Data models show a one way arrow from STOJOU to SINVOICED with VCRNUM;VCRLIN. I am unsure of what to do with that, with VCRNUM only…

Good morning Sage City, I am creating an invoices tables with the base table SINVOICED, I need to JOIN PORDER table to my base table but am unsure of how to do so. How can I go about doing this?

Hi there, I have made 3 different upgrades from Mongodb 3.4 to 4.2 and now when I restart Windows, the mongodb service doesn't autostart. I have to start it manually. The update path was the following: Mongodb 3.4 -> 3.6 Mongodb 3.6 -> 4.0 …

Dear Fellows, As you may all know that when you delete a folder in X3 it will not be deleted from database with all its references which will eventually increase your database size, and therefore i created an sql procedure that safely delete the folder…

Anyone know how to format that so it displays MM/DD/YYYY HH/MM ? I've tried both data types D and A but just get MM/DD/YYYY.

why i can't post or put in ITMMASTER *i changed edit in representations/properties to yes -for put the ITMREF is alreay exist

You can manage Employees at: Common Data > Manufacturing tables > Employees But I can't find the corresponding table. Does anybody know what's the table name?

October 25th, 2020 Hello Teams, Need your help. :) BPSUPPLIER-->CONTACT-->CONTACTCRM Where to find the field KCNTFLG - which is the Default Contact Flag in the MSSQL x3 database tables. Goal - I am looking for where the CNTFLG field is stored…

Hi, Sqlserver2018 Sage database, who used the “notification query” function? does it create problems for Sage's normal work? Sage X3 Version 11.12 ALTER DATABASE NAME_DATABASE SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE; CREATE QUEUE PortalNotificationQueue…

Hi All, I am moving the SQL database from C: drive to D: drive for existing client (Installed and configured Console 2 yrs back) because the C: drive was fully occupied. If I move the SQL database, do I need to change the path on the Safe X3 management…

What table stores these values? It's the status on a work order header.

has anyone else had issue with Portugal or US postal code format in V11 that the table doesn't display the dash that is part of the formatting? We noticed this on the SO form which pulls the field from the SORDER table. I then looked at the BPADDRESS…

Hello everyone: the goal is to apply a recodification of the articles on the ITMMASTER table and all the zones to which it is linked To access all the zones linked directly to our ITMMASTER I used the ATABZON tables zone, the SQL query used is: …

I am looking to see if anyone is running X3 on Oracle 19c. If so, were there any caveats to this? For example, did database compatibility settings come into play?

How does one join the ITMMASTER and ITMCATEG tables in the graphical query?

Hi everyone someone has successfully installed the latest V12 update ( V12.0.21 - 2020 R1) with SQL SERVER 2014 (not R2) I receive this message while configuring the database by the console any help please

Hello, I would like to draw links between tables (automatically). But I didn't find any foreign key in INFORMATION_SCHEMA.TABLE_CONSTRAINTS. I checked other tables without success. Could you please help me? Best regards, Nicolas

How do we manage the MongoDB log file. Mongodb has just one giant log file where all the logs get updated. Is there a way for mongodb to create multiple log files instead of just one giant file? What is the best way of purging the logs? In our…

An accounting cancellation was done on a payment with 3 purchase invoices. Two of the PI's are still showing as paid but the first one isn't. The gaccdudate table is showing the FLGCLE flag as 2 with the value in the PAYCUR/PAYLOC field for those two…

Hi All, I installed the Oracle RDS database instead of MS SQL Server. The database is on diff. server and location and the challenge are – how to config. this in the below screenshots in Sage X3 Console? What are the inputs required to provide here…

Hello We share same infrastructure with another company. They got IT, not my company. Their IT refuse me to use crystal report and access database for security. So we do Microsoft Word for all Invoices, Orders, etc. Like t min per Word to do all…

I have sage EM v11 with oracle 12c db. After creating a view when i try to validate I have oracle error : ORA-00933 and ORA-06512. Can any one help me plz.

This error comes up anytime I try to validate any table. Please has anyone encountered this before?