Sage X3

How can I manage multiple folders in Sage X3, where I need to add users, adjust permissions globally, but ensure that data (such as products and orders) remains distinct for each folder?

Hi, Question: Can I import Sage X3 folder which was taken from a server using newer version of SQL Server to an older version SQL Server? Second question: Can I import Sage X3 folder which was taken from Oracle database to a SQL Server database? …

Upon running the Stock Accounting Interface interface, I consistently encounter the following error: SOOCKSE22006354 Nonexistent dimension value (STKIS Line 3) Miscellaneous issue VCRNUM=MIOCKSE23003691 Upon thorough investigation, it has come to my…

Good afternoon, Does anyone have experience importing sales invoices that come from a delivery? We need the delivery data to be transferred to the invoice. I am using STD import models.t Thanks!

Hi All, I am trying to export data of supplier using xml in Http Request in .Net with direct credentials not SSO One On calling the below xml i am getting response of Cannot read property 'GRP' of undefined Can anyone kindly guide how to get…

Hi, I need to convert a string from base64, I use the function YLEN=b64Decode(YB64RES, YBLOB). Then I would have to convert the BlbFile back to a ClbFile or Char (I need to parse it) but I wouldn't want to have to write YBLOB to the filesystem and then…

Looking to see if anyone can direct me to a table that houses the details from Product Line entries on ITMMASTER.

Hello, The usual data model in SEI PINVOICE (PIH) does not pick up any invoices created via AP/AR module in Sage and so I'm trying to create a new data model for these. I can get data from the lines using BPSINVLIG and *A tables, but does anyone know…

Hi! I have searched multiple blogs and sites for this answer (along with the online help center) and can't find a clear document that states which characters are restricted in Imports/Exports per table. I've been told by Consultants that certain characters…

Hello Sage Community, I hope everyone is doing well. I'm reaching out to discuss and seek advice on an issue we've been facing related to Excel exports, specifically for account extracts, from Sage X3. I am working on the v12 implementation in a company…

We're working on a remittance import template for our client and are looking for a way to link the PAYFRM and PAYMENTH tables. Currently when adding FRMNUM to the link column, we encounter a warning stating that the link does not appear coherent. The…

We currently run Sage X3- multiple Versions including V12. SQL Server 2019 and X3 running on the same machine SQL database Collation is Latin1_General_BIN VMWARE 7.0.3n Starwind vSAN Two servers for failover We have noticed that we are getting…

I would like to add additional costing components to existing product BOMs in Sage X3 (v11). When using the import template BOMPD, it requires a field for the BOM component sequence (BOMSEQ), however, each BOM has a different number of existing components…

Hi Sage X3 V 12 pu 24 Patch. We have recently had a SQL corruption that was repaired on the client. Long story short restoring to a valid backup was not an option. Not ideal and measures have been taken to avoid this in the future. The SQL is…

I want to delete product-site records that they do not have transactions in that site. when I use transaction mass update, it dose not check it has transaction or not and delete it directly and it is wrong because I want to delete the same record from…

Hello Community. We have a Sage X3 implementation whereby we have different entities / companies. Does anyone know if its possible to backup the different entities separately or is it a all or nothing exercise. For instance if one group of accountants…

Is there no field on the sale order tables that displays the total value of the line? I see the field on the line but I cannot find in either the SORDERQ / SORDERP tables. As is now I do a calculation on reports to get the value but wondering if I'm just…

Hi, When trying to update a product using the import Web Service AOWSIMPORT with a template containing the UPC code field EANCOD, I always get the error Field EANCOD (12345) : Value already exists. Bu the only product with UPC code 12345 is the one…

Your data is vulnerable to various risks, such as hardware failures, cyberattacks, and natural disasters. Backing up your data and having those backups easily accessible is often the quickest, most affordable way to recover. In fact, backups may be your…

Hi, I am trying to import different sales invoices (Credit memo, Standard Entry) using SIH template. Template is creating the invoice starting with invoice number as INV but for credit Memo, it has to be SCM. The template is not recognizing the Type…

Hi Sage X3 v12p30 When using Sage X3 Console, when I try to import a new folder, this loading of folders is taking a very long time.

SEI: 2021 R1.1, License server. Reading: https://onlinehelp.sageenterpriseintelligence.com/Latest/en/Installation/packages/bi-license.htm and: https://support1.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=77158&sliceId=1&isLoadPublishedVer…

Hi, I am trying to Import Supplier information using a Text file. But I keep getting errors for suppliers with Canadian Postal codes. I checked the Postal Codes table and they do exist in the table. I am getting below incorrect format error. …

Case: I have a client who have accidentally deleted some records. The client forgot where it is deleted but the client knows around a period only today. No audit on delete has been set (it was a freshly created folder and masterdata was imported…

We are new to X3 and I watched the process of getting all the stuff installed. Our partner called in experts from each vendor to install their parts. We have x3, Datalinx, SEI with MSSQL. The total install time we were billed for exceeded 20 hours…