Sage X3

Hello everyone I try to implement the entry point https://online-help.sageerpx3.com/erp/12/wp-static-content/static-pages/en_US/OBJ/ADC_SERVEUR.htm#APE_30_10 with action REQUETE. I created the entry point and the processing script in the X3 folder…

Hello everyone We sometimes have problems when a batch job runs more than once. In order to prevent this we want to use the entry point SERVEUR with action REQUETE https://online-help.sageerpx3.com/erp/12/wp-static-content/static-pages/en_US/OBJ/ADC_SERVEUR…

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…

Hello I get the error Error 26 : Internal error Inconsistent reference value (11026) at @X3.TRT/REQUETES$adx (153) when trying to read a custom table in a custom batch job script. Part of the key from the custom table is a counter variable which is…

We have a scenario where we direct ship product from a supplier to a customer. Because of this and because we want to see accurate sales margins on the sales order, we have a need to change the cost of goods on our sales order entry screen so that it…

I need to create a generic function to read an object in X3. I'm thinking some of the standard object functionality could be used, or maybe even a dynamic query, but I'm not completely sure how to approach it. For example, I want to pass a table name…

Hi I'm iterating trough a list of objects using a repeat statement. If a specific criteria matches, I want to skip the code for the current object in the loop. How do I achieve this? The "break" statement ends the whole repeat statement, I just want…

Hi there, Im trying to filter a field based on CHOOSE as I read on greytrix ( http://www.greytrix.com/blogs/sagex3/2014/08/31/adding-selection-window-for-any-action/ ) My code is working but If I use the search (as highlited in the screenshot…

I'm trying to return data for an array of parent/child items in a custom X3 web service (Version 12). Specifically, I'm trying to get invoice data. Normally, I would just publish the appropriate object as a web service, and I could make a call to get…

I have a recurring task that exports invoices to our EDI system and I'm trying to implement a selection criteria to separate out invoices from selected customers. I have tried variations on the script below but it is constantly rejected by the formula…

Hello Guru's, One of our customers noted that Sales Delivery Module doesn't have the standard capability of filtering the Sales Order Selection like the function currently available in Purchase Invoice where the module has a line menu for Purchase Order…

Hi, I would like to clone an invoice after posting, but the "Child" record will have few changes. Would anyone have a piece of script that clones one record to share, as an example? Just to learn the best way to do it. Thank you. Best regards…

Hi all, I am trying to build a SPE to capture a number (Field is a text), split the digits, multiply each one, sum all and validate the result. I have some questions: 1 - Now, I am working with STRING and I need convert this String to a Integer, so I…

Hi, I need to create in Sage X3 V9 (patch 6) a new analitycal dimension (object CCE) on creating new Project (object OPP) with some data from the last one, my client request an automatic function on create so any new button are forbidden, in my specific…

How would I filter a stock status selection based on another field. For example, I have one field that has A in the field. Then my second field possible selection will be filtered down to anything that is a substatus of A. Thanks.

In my object, the main table is STOCK and under the environment tab, I linked the itmmaster table. When I write my code to get the itmmaster table linked, it will not link. Everything works when I use the STOCK table, but when I try to use the ITMMASTER…

Hi, We have a string returned into an XML format the we store as Local Clbfile variable. What is the best way to get a string out of this variable? Kind Regards

Good day everyone, I am Manuel a rookie in the use of Sage X3. Fortunately over time have gotten myself familiar with the Interface and workings of the ERP system but on the development part have been stuck with a few challenge and hoping get it it…

Hello, I am looking for a way to add a filter statment to filgausup in the FILGAUCHE action? I ave this but it doesn't work. Thanks, $FILGAUCHE Case currbox When GBOXZ : If [M:SMO0]ZDUMP = 2 Filter [F:STO] Where (left$([F:STO]ITMREF,1)='N' or left…

So I am trying to add a filter to the selection criteria during entry point AUTALLFIL for sales order automatic allocations My code is as follows: If [M:DIA]ORDDAT <> [0/0/0] CRITERE -= ' & ORDDAT >= "' + [M:DIA]ORDDAT + '" & ORDDAT <= "' + [M:DIA…

Is there a way in X3 that you can filter the left list by picking individual records within code, and adding them to the left list as they are found in code? An example is you start out with an essentially blank left list. Then, you find a sales order…

Hi, I am trying to filter certain products from showing on the order line screen that is on the sales order. How can I do this? I created a fitler statement in 4gl to show only products that begin with F, but it is still show those products that begin…

Hi Everyone, I am working with Sage X3 People U9 patch 8. A miscellaneous table called Bank branch was created with Bank On the Employee bank screen, When a bank is selected, all bank branch corresponding to the bank should be filtered automatically…

[M:SMX1]15-20 What does the 15-20 mean?

I am seeking assistance in creating a formula with the formula wizard that will make this certain criteria true: If the product starts with an R, then this field is mandatory.