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.
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…
Hi,
I need advice and pointers to identify the root cause of the import failure issue.
Sage X3: v12 Patch 31 (latest patch by time of writing) Database: SQL Server 2019 Standard All components are updated to match Sage X3 v12p31 requirements.
On…
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…
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…
Has anyone had to create a new V11 (or really any version) application server and connect it to an existing SQL Database server? Assume we don't have access to the old app server (although we might).
I have some ideas, but I'd like to know how others…
October 25th, 2020
Hello Teams,
Need your help. :)
BPSUPPLIER-->CONTACT-->CONTACTCRM
Where to find the field KCNTFLG - which is the Default Contact Flag in the MSSQL x3 database tables.
Goal - I am looking for where the CNTFLG field is stored…
Hi guys,
I need help!
My client wants me to achieve an automatic backup from her Production server to a Data recovery Server on a daily basis
Please how can this be achieved?
Hoping to get a positive response
Thanks
Dear Fellows,
As you may all know that when you delete a folder in X3 it will not be deleted from database with all its references which will eventually increase your database size, and therefore i created an sql procedure that safely delete the folder…
I made a new table (ZITEMECO) and a new screen (ZITF0) to use inside OITF window but i'm having trouble to read the table, it appears that $LIENS action not working at all, what am i doing wrong.
Here is the code of the SPEITF:
# Gestão da máscara…
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…
I have a stored procedure I would like to call to populate a work table as a preprocessor to an SQL client requester. Syntax would be helpful. Thanks
SQL stored procedure call from X3