Sage X3

Sage X3 v12p34, SQL Server 2022 Standard edition. Full error as follows: `Connection to server failed : X3 engine error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The SELECT permission was denied on the object 'APLLCK', database 'x3v12'…

Hi, Console: CFG.2.54.0.5 (from v12p30 ISO disc) I have noticed latest version and newer patch level of Sage X3 v12p30 now can set the Db login. It was previously impossible to edit and must use sa. Will there be any issue if I change…

I am trying to join one of the following tables to GACCOUNT. PORDERQ or ITMMASTER. There doesn't seem to be many ways to get from GACCOUNT to an ITMREF_0 or POHNUM. I have tried a few different options but none seem to be working. Your help, as always…

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…

I am building out existing access report in sagex3. Where can I find GLcode and descriptions? I've looked at the accounting data model tab and am just not really sure what I am looking for. Thank you in advance!

I am looking to get the sql column name for total requirements qty located in available stock. If anyone could point me in the right direction, it would be greatly appreciated.

Good Morning! I am currently working on swapping from Process Pro To Sagex3 and one of the columns in PP is Usage qty which is total qty used for the year. Is there a field in sagex3 for this? As always, your responses are greatly appreciated!

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