Sage X3

I am looking to join the two above tables, According to the data models, the join is supposed to happen like this: 1;ACCCOD. How is that supposed to work if STOJOU doesn't have any accounting code? Also what does the 1 mean in the data model? Any and…

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…

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

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…

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…

I made a new table (ZITEMECO) and a new screen (ZITF0) to use inside OITF window but i'm having trouble to read the table, it appears that $LIENS action not working at all, what am i doing wrong. Here is the code of the SPEITF: # Gestão da máscara…