Sage X3

$VERIF_MOD Local Char ZPRODCOD(30) Local Char ZPRODCODOLD(30) Local Integer YESNO YESNO =2 For i=0 To max([M:POH2]NBLIG -1) For [F:ITM] Where [F:ITM]ITMREF = [M:POH2]ITMREF(i) ZPRODCODOLD = [M:POH2]ZPRODCOD(i) ZPRODCOD=[ITM]ZPRODCOD if…

Dear all, I'm new in SAGE X3 and wanted to know if there is a possibility to change the default value for the field FMI in a Sales order line. I found in the entry points documentation that this can be done by using the entry point ALIFMI but not…

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 I created a new field and used the type AUS since i am using this to look up employees, once you select the employee and save you will notice the selected user code is present. The problem is when you go back into the function and…

I added a new column to an inquiry screen. Since the field is from a table not included in the inquiry, I used SPE code to populate the field in the inquiry. This works fine, but when I export it via Excel, that field isn't populated. Does anybody know…

The client would like to request for a change in the logic of the Line Description of the reversals In Journal entry function (GESGAS), while clicking reversal from the right side button, the system will create reversal journal. In that Journal the…

What I would like to accomplish is that ability to tunnel quickly to what a product looks like without sending our users to the Product screen. The screen I would like to implement changes is the Sales Order entry screen. Initially I was thinking that…

Good morning I have added a field to SORDER, and then added that to SOH0. I am then receiving a heap error, but not sure what to do next. Anyone have any advice?

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 All, We are using the CALLUI function to open the URL in the next browser. Buts as per the requirement, we need to open the network file path in the new browser: file:\\Sage\folder\Test\tmp We are able to open the http path, but when we implement…

Hi, I would like to create more representations using Views/Tables. Requestors are very quick to create in X3V12 using Views/Tables, but very limited functionality specially on Landing Pages. The goal is to give user far more interactive dashboards…

Good morning Everyone and Happy Monday! I'm attempting to add PTHNUM to screen POH2, but I am receiving this error "Fields PTHNUM: Undefined parameter OBJZON ( Type VCR)." Does anyone know what I'm doing wrong and how to resolve this? Thanks!

I there, I'm struggling to get a verification if a Variable is empty or not on creation of a sales order. The Variable is in each line of the sales order, i need to emmit a warning and block te creation if one of the lines has the var empty Here is my…

BOMs I am trying to add a custom long description field to our Manufacturing BOM screen (BOH0) and receiving this error - I've added a "Before Field" Action to the ITMREF field and added this as the script. Subprog AV_ITMREF(VALEUR) Variable…

Hello everyone Our customer wants to copy a plan by clicking on the corresponding right list entry. The copied plan should be shown afterwards. After clicking the right menu entry the following code is executed: This creates the new plan based…

Hello, Im looking for a way to modify a numer of columns( i would like to add field from [BOM] table) in window that shows up after I click the selection icon(first screenshot). Thanks for help

Hello everyone, For our customer we developed a specific screen to manage plans. In order to edit a plan the user has to press a check out button. The user who checked out the plan can modify the plan. In the FILTRE action we use the global Variable…

I have a custom field in the STOALL table that I would like to transfer to the STOJOU table when the transaction is validated/posted. I've been looking for an entry point to do this, but I can't seem to find it. Does anybody know if there is an entry…

when i click on the query cell to change it to yes it just jump for initial state, but for some others columns it's ok

Sage X3 allows a parameter to warn user for duplicate values in BPRVCR. How can this warning be change to an error?

Hello, I was manipulating the screens in the V12 (P24) and I have remarked that the # used in the beginning of formulas of the evaluated title is blocking the evaluation of the title in different languages. For example, in the screen BPR1, the evaluated…

Hello. How can I delete a specific row, from sales order rows list? Thanks. Regards. MS

I have 2 different reports one is a Statement of Financial Position while the other is an Income statement, how can I get calculated fields value from my Income Statement Into my Statement of Financial Position noting that the IS has it's Data Model just…

Hello, Before we installe the last Syracuse Version, when we are selecting a record in X3, the lign of the records were coloring on green. Now, it's very difficult to see when records are selected: It would be interesting to have a method which…

Hi everybody. I need import assembly doc, but now in X3 V12 this object hasn't active import check. I try to active and create import template, but all time system says that first line are not completed, and don't create doc. First, in BBY Object…