Sage X3

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…

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

As per title, I have received an order to prepare a cold storage purely for long-term archival purpose. I am interested in how everyone deals with cold storage order. As far as I know, Sage X3 have Archive/Purge folder (which I labbed here: https…

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…

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…

Hi At Sage Summit 2020 there was talk of the Sage x3 Data Management Suite being released. Does anyone have any information on Or experience with? thanks Stacey

I need a Visual Basic routine that would re-format a CSV file from one application to be imported into Sage X3 V11. The application is moving invoice and payment details from one system to another. The basic difference is that the source file has one…

I am new to sage and am stuck on how to resolve this issue. From what I am gathering this is related to a table error in the SQL database. I am green when it comes to both Sage and SQL. Any thoughts or ideas on how to resolve this? Thanks in advance…

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…