I am trying to execute a SQL stored procedure using the SQL query tool in X3.  I am not getting a validation error but nothing returns when I run it.  I do get results when executing the stored procedure in SSMS.

In old VXABP function, there is an entry point allow you sort picking ticket by location first. Is there any thing similar that we can sort picking ticket line by location in new ADC function?

SORT_PREP: Used to sort the table containing the lines to…

Hi,

In the past, I remember adding custom header lines to an export file when using export templates via specific script processing. I believe it was done using wrseq once the file was opened in the background by Sage to write to the export file. I no…

I am trying to populate a field on an intersite sales order when created automatically from an intersite purchase order.

I have identified the ALIMSKSOH entry point in TRTVENISOC which should allow me to do this. Unfortunately the field that I wish to populate…

We are at V11- Is there a way where we can create a new field that uses the local menu but can allow multiple selections from the local menu?   We have a list of 14 items that we need on the product but instead of creating 14 different fields with check…

Is there a standard Sage report that would display customer details (name/ quantity/ that was shipped from a given PO?  I need to create such report and I'm just looking for a simple way to go about.  Basically all the customer details for what PO's…

I am wondering if anyone out here has had any experience with the trolley build features with Datalinx? We are thinking of exploring "picking to slot", "Trolley Build", "picking to Carton" functions in our warehouse. Would love to pick someone's brain…

Good morning,

Does anyone know if the background image can be modified when entering Sage X3 with the latest version of Syracuse?

Before this update we could do it by following these steps:

https://www.sagecity.com/support_communities/sage_erp_x3/f…

Is there a way to have the Invoice field pull from the Source Document vs the Sage-assigned Order No?

By the time I know the Order No, I'm already sitting on the invoice I'm looking for.

Dear Sage Community,

After searching one price for a combination SKU/Customer (click on Apply and it works), I was trying to search a second price for another SKU for the same customer (SKU2/Customer).

But the APPLY button does nothing for the second search…

Hi, in a custom selection script like this:

GSELFAC = 1 : # campo che deve ritornare

Filter [F:YPROD]
CRITERE = "[F:YPROD]YITMREF='"+[M:POH2]ITMREF(nolign-1)+"'"

NBCOL = 0
NBCOL +=1 : COL(NBCOL) = "[F:YPROD]YCODPROD" : TIT(NBCOL…

Hi Guys,

X3 - V12 2022 R2

Currently the page authoring is quite powerful in that it allows a power user to hide/enable field on screens to suit their process and make it easier for users generally. Another useful technique is to hid sensitive information…

Hi, 

We are planning on upgrading our system from V11 to V12 P29. One thing I noticed is that sage is not able to detect a new line when reading the trace file. When I read the trace file, sage thinks that everything is in 1 line when it is not. Is anybody…

Hi everyone,

I have a customer that is planning to go live with X3 Version 12. They make tech modules and have complex BOMs which require version management (Major Versions Only). They have many historical BOMs that they need to have in the system and…

Hello everyone,

I have a few custom fields on the SIH0 screen.  If these fields are not set by the user I would like to add a message box (Yes / No) when they post the invoice.  Basically to inform the user that they are empty and if they continue to post…

In Sage X3, PU9, Common data Module>Products>Products(GESITM)

whenever I create a new product or modify the existing product, the data in description 2 and description 3 disappeared. ironically, the previous data in the same field for certain products…

Hello everyone,

I have a custom field on the SINVOICEV table.  I've added this field to the SIH0 screen and put a default to "2" (it is a yes/no).  If I create an invoice directly from the SIH0 screen the default works fine.  When I generate…

I want to invoke the "+" (new) button programmatically so I can star a new page when I call a window through code.

Can somebody help me?

I need to be able to reduce the width of the columns of a grid, through 4gl programming

Thanks !!

Today for some unknown reason the Invoices module is not displaying on anyone's menu today.  There was no issue yesterday but would anyone know how to correct?  

Hi Everyone,

I have 3 custom fields on the sales header (SORDER) and sales lines (SORDERP).  I also have the same fields on the invoice tables.  When the order is invoiced I would like to transfer the values of these fields from the order to the corresponding…

Is there a way to dynamically set column titles for a grid on a screen?  I can do this: 

But I want to make it more dynamic, like this, but X3 doesn't like it.

Good afternoon

I am trying to move data from one field to another.  Basically we have a free text field that we used to use and now we are using one linked to AUTILIS and I want those user codes we were using to now populate my new field.  I believe I…

I've tried a couple of different ways of opening the IPREP window (Preparation Plan) from another screen - via code using SAISIE_CHAR subprog, and also via a custom Action. Both launch the window, but it doesn't behave the same as when you open it…