Sage X3

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.

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…

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.

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…

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, Sage X3 version: X3 v12 Patch 33, hotfixed with Syracuse latest version. Was doing a folder data integration through batch, got canceled. Checking the logs: 06-14-23 13:38:19 (Application server time) Query terminated with error (Who is…

Hi Have any Business Partners in Australia been able to successfully setup and import using the Advanced Bank Statement Import function in V12. I can not seem to get any assistance on this as Sage mainly deal with the MT940 files. Do clients actually…

Hi I'd like to import email contacts under this contact function for about 1000 BP's. I have my list of BP's and the email address. I will flag them all with code being their BPCNUM followed by _STA. All fields will be the same such as language, country…

Hello please should be informed that when i tried to import SEED Folder to console management all steps pass OK unless the last step it give error the impacted envirenement WIndows 2019 server SQL SERVER 2014 SAGE X3 V11 can you help plea…

hi, I am importing a file from another system into X3 and getting an error as in subject line and screenshot below. I checked the template configurations in Setup and go into BPAPAY line and couldnt find anything really to change so I have not clue…