Sage X3

Dear Support, I would like to enquiry on what are the SQL version is compatible with PU9? as now we can not get SQL 2014 version which installed for PU9 previously. Regards Jeff

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…

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…

Hi everyone, I'm looking for the description of this field: Table - FXDASSETS field ACGGRP_0 Example: ACGGRP_0 CM The description must be similar, but I have not been found a table yet with this description, please someone has an…

Is it possible to import multiple companies and sites?

Hi all, as you can read i'm trying to import an invoice in my Sage X3 V9 PATCH 6 using Web Services, in my specific script(SPESIH) there is an action that i don't want to perform if i'm importing using web services. I wonder if there is a method to…

I need to purge some old records from the audit tables and was hoping to get some of the best known methods for this task.