Welcome to the Sage X3 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros from around the globe.
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,
Version: X3 v12p33
Microsoft SQL Server: 2022 Standard
Full error message from Sage X3: Connection to server failed : X3 engine error: [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: The wait operation timed out. : ini_com:Variable dimension…
Hi,
This is a question for Sage X3 v12 onwards X3 console. Older console versions I know were inevitable to use `sa` account only.
Link reference: online-help.sageerpx3.com/.../prerequisites_windows-sql-server.html
Is `sysadmin` role level required…
Important alert: Do not use SQL Server module version 22.x with Sage X3 until further notice. Use SQL Server 21.1.18256 only.
PowerShell 7.2+ is a prerequisite for Sage X3, along with the SQL Server module for PowerShell. SQL Server module version 22…
In my previous post, I explained how to deploy a SQL Elastic Pool in Azure Portal. In this post, I am going to show how to perform a Sage X3 Solution configuration using the deployed Database, so let's dive right in.
To create a solution, open the Solutions…
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…
Hello,
When i'm trying to access the X3 reference folder and the pilot folder i get below error.
Create session error : X3 engine error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'ADOVAL'. : SQL Server ErrorDeta …
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.
I am creating an invoicing table that has Item, Lot and QtyOrdered. Is it possible to see per lot allocation by sales order number? I know you are able to see the qty on hand/lot. For example, if I have an item that exists in multiple lots, I only want…
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!
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
How are suppliers set up? I see in the ITMBPS table, there is a flag for default supplier which makes me think that if it is not a default supplier, is it the last supplier that updates anytime an item is received from a new supplier?
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…
When we try to create an index in table GACCENTRYA including field CCE_1, SAGE X3 gives error. For now solution is to add the index manually directly in the SQL Server, any solution to make this solution permanent? Thanks.
Good day everyone, I am looking for the sales FOB field in sage x3. If there is no field in x3, is there a column in sql? So far I have been unsuccessful in finding said field. Any guidance would be greatly appreciated. Thank you in advance!
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?
