Sage X3

Hello, My question is simple. We do cycle counts based on location ranges. However, when you select Location, the ABC selection becomes unavailable, and I've been unable to figure out a "Locations" Count formula to include the ABC class. Likewise…

I want to pass the sales order qty field to the delivery to compare and control the delivery qty(control table ) i see the control table work on the same screen.

I have a integration service do so a series integration. If there is any error, when create quote SQH, it will give error: @X3.TRT/SUBSFIT$adx (149) Error 7 : Class Non-existent [M:SFIT] 0 : Sage X3 errors After restart the X3 SOAP Web Service then…

Hello, Im looking for solution to add default component value in function GESDBY Disassembly. I tried to use something like this: $APRES_CRE For i=0 To max([M:DBY1]NBLIG -1) if [M:DBY1]ITMREF(i) = "X" [M:DBY1]PRIORD(i) = 17 Affzo [M:DBY1]PRIORD…

Hello everyone, When trying to create a sales invoice in a custom development we get the application error 162: Target entity not found[D,A,A2,464]. Error code is 102. Unfortunately the error message not helps me to identify the cause of the problem…

Hello, I'm trying to use the color-picker bundle but it does not seem to work following this tutorial . Has anyone been able to install it correctly? Thanks in advance.

Hi All I'm facing an issue while trying to create an Order using SOAP Webservice. In my SALES ORDER Table, I do have custom field that I want to send through SOAP. Unfortunately, it's not working when I pass the custom fields in the SOAP object. But…

If There are lots of purchase order (Example: 20 Purchase Order) against a site & supplier, how it can be search Purchase order to choose multiple lines in Purchase Receipt Function?

Hello, am wondering if someone can explain the logic behind Product Site Default Location setup? Problem: Snap shot above is how we are picking our apparel for replenish to work, but I don't think it's setup right 100%. Does anyone have any expierence…

Hi, We try to call the function in the node.js/java script file as suggested in the link below, but face an error message as below when we call the function from Sage X3. https://www.greytrix.com/blogs/sagex3/2021/09/21/how-to-write-encode-function…

Hello, In some cases I need to modify the "GROPRI" field on my sales quote's lines via SPESQH. In order to automatically recalculate the "NETPRI" field, I understand that I need to use the following function: Call AM_GROPRI(VALUE) From W1SQH2 …

Hi everyone! Is there anyway to add an ITMMASTER field into the Buyers Planning screen PPI2 ? I have some custom fields from ITM table to help me select some items to order that I would like to had into PPI2 screen. I tried the SPE for that, but…

Hello Community! My company has a large database of raw materials, currently the purchasing plan is done manually using MRP results along with checking Projected for each raw material , one at a time. As such it's a very tedious and inefficient process…

Hi, 4GL question. I have a custom import template. There are two identifiers, Header and Lines. For Header identifier, it will always be one row in the import file. For Lines identifier, it can have multiple dimensions (translated: it can have…

Hi, For context: - There are two custom scripts each using own custom import template. -- The only difference between the two custom script is just the custom import template used. Both opens same tables for import. - Both are scheduled in Recurring…

Hello, I am trying to put a "location" field in the query for stock movements by items so that it can filter the movements it shows. I have modified the screen and added the field then in criteria I created a formula to get the ones that matched…

Hello, I want to change the workflow sender depending on the workflow code [F:AWA]CODE. The workflow code in question is ZTEST However, in a custom ZAWRKMEL script, the [F:AWA]CODE value does not seem to pass through. The result is an email sent by…

Hi, I tried updating the field CRITERE on the screen EXPOBJ from 120 to 250 but something is still truncating my criteria to 120 characters. Any suggestion?

Hello, I want to make a simple specific script modification for the manual matching screen (SPELTR) however, it seems that actions do not work on the screen. The code is as follows: $ACTION Case ACTION When "AVANTBOUT" : gosub ZSOLCPT When default…

Hi folks We have the problem that in certain cases an IC purchase invoice is not automatically created for a customer when the corresponding IC sales invoice is released. Most of the time it works but not always. We have set up the intercompany…

Hi Everyone, I need to add a couple of fields to the criteria window. The fields in question, are the SOHNUM and CUSORDREF fields from the SORDER Table. The screen in question is the SCRITSRH screen. Adding them to the Screen was pretty easy and they…

We have a query that is primarily filtered by GACTX.USER, so that the user who is logged in can see only their orders on this query. However, for some users I would like them to be able to see the entire report. I was wondering if there was a way to filter…

Hello I want to delete database entries which are older than 15 minutes. datetime$ returns the date in GMT time zone. But the database entries are stored in CET time zone (CREDATTIM column). The comparison not work as intended because of the 2 hours…

Hi, Would like to know the significance of the W* prefix files in TRT folder of each Sage X3 folders. [1] Is it safe to delete W* prefix files in TRT folder on folders that is not named X3? [2] What are the W* prefix files in TRT folder? [3] How…

In the object function, the system does not allow us to add views in the environment tab, which bar us from using fields from a view on the left list. I understand that we can use field expression to call a function on the selection tab to add a customized…