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, Context: Sage X3: v12 Patch 33 Application folder (symbolic link): C:\ -> UNC Path at Amazon FSx DB: SQL Server 2019 Std. DB Cluster: Active/Passive Availability Group (AG). Using AG listener name and port. Followed: https://www.sagecity…

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…

Hi. Sage X3: v12 Patch 30 Console version: CFG 2.54.0.5 SQL Server: 2019 Standard When I import a relatively small folder (about 20 GB). ``` Storage is not online Database filegroups check failed Error while creating database schema…

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…

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

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

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

How are subqueries performed in SEI without creating a custom DB view ? Creating an Order Shortage Report. I have a process that pull sinformation form the ITMMVT table in summary (Orders, Item info) but I need to join to the ORDERS table to find…