Sage X3

Hi, as the subject says, I am building a report to pull sales numbers per company by GLCode in sql server. I'm having a hard time getting data that looks correct. I have tried a few different ways of joining SORDER table to GACCOUNT table. I've tried…

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…

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…

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?

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

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?

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

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

I am trying to pull data from three tables but running into a relation issues. Table1: Customer Table. Table 2: Invoice Table Table 3: Invoice Detail Table On table 1 the customer number column is "BPCNUM_0" On Table 2: The customer number column is …

I guess most of us already needed to find a field on a table we sometimes found, but sometimes the result returned was empty. What most of the time occurs is that you are searching for the right field, but from the wrong place. To help you identify…