Sage X3

Hi When I use the following line of code Affzo [M]ITMDES2(NLIG) I get the following exception According to the documentation at https://online-help.sageerpx3.com/erp/12/staticpost/affzo/ this should be working If I check the value of the…

Hi folks I'm looking for a possibility to get information about how many items are selected in a picking left list on action $PICKE and $DEPICK. My goal is to allow the user to only select one item and show an exception message if he tries to select…

Is there any easy way to exclude the weekend from my date calculations in X3? For example, my delivery is suppose to arrive on Monday. It takes 3 business days to get to the customer. If I do Monday - 3, I would get ship date of Friday when I actually…

I'm getting the following message on some web services responses. Just in some times. "Process[ZWS_NAME] - No return code (status[6]) " The web services its a Subprogram web service. Has anyone known what is it? And how to fix it?

Hello As a Sage X3 developer, I have found that there are many useful standard X3 methods. One example is closing a purchase order with 4GL code via script. https://www.greytrix.com/blogs/sagex3/2020/12/29/how-to-close-po-programmatically-using-4gl…

Hi All, We are trying to read the product of Magento from Sage X3 using integration methods such as Rest webservices, Node.Js for one of our client. The Magento API endpoints uses 'OAUTH1' type of authorization for authentication of the Rest API requests…

I want to build a few subprograms to be executed through web services. Basically, from a given picklist in GESPRH2, I want to click the buttons for 'Deliverable' and then 'Delivery' to create the delivery, and then in GESSDH I want to click the 'Invoice…

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…

I am trying to do a simple calculation where I need to multiply two fields and the total is displayed in another field. I believe this can be easily done through 4GL programming, but have some questions. My thinking is I would add an action to the screen…

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 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 need to set the format of fields on a screen to "Display" when a certain value is detected in a field. I know how I could suppress it conditionally, but that's not what I want to do. Basically... if I were writing the suppress for it I would…

So I have been presented with an interesting challenge. In our company we've set X3 to batch allocate all available stock to meet all demand in the system. We also heavily leverage X3's ADC functionality. Our warehouse users are able to override the…

Hi, How do you subtract time with the 4GL language? Thanks, Chris

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…

Good morning, We are experiencing an issue where users are locking during creation of a document (quotation, order, invoice etc..). We have tested this across other areas of the system and we have the same problem. I report an example: We had 5 users…

Since yesterday, I get the following exception every time I open eclipse editor to script code for x3: Does anyone else have the same issue? Regards, Benjamin

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…

I trying to validate my deliveries using the VALIDATION() subprogram in the TRTVENLIVV file. Whenever, I successfully validate a delivery, the record is locked up. I added the Unlock = "SDH"+delivery_number command, but the record is still locked…

Hi Guys I've implemented create report functionality. The following part is calling report creator: Call ETAT("ZLETTREVIRR", "FILEPDF", "", 0, PROP, TPAR, TVAL) From AIMP3 Where "FILEPDF" destination - output file type pdf. I also added FICHER for saving…

Hi There For Sage X3 V12 I am trying to get Sage to print/save with different file name than the Crystal Report name Have added entry point AIMP3 custom script ZAIMP3 Here is my code $ ACTION Case ACTION When "PARAM" : Gosub PARAM Endcase…

Good Morning, We are getting an error message when we try to set the reversal date to 01/01/2021. (The accounting date is 12/31/2020). This is only happening to some of our journal entries. Would anybody be able to tell me why this error message…

hi all how do you write & debug code in V12 ? I was told that I can only use eclipse and it is very slow to debug + performance is bad + weird to attach eclipse to a process. eclipse also disconnect from unknown reason during debug. thx B…

I have a very strange issue. I have a custom sequence definition defined in X3. In my 4GL, I am calling NUMERO to get the next sequence number. This worked in our test environment, but it just hangs indefinitely in our pilot environment. I have confirmed…

Hi. I want to activate a control on a field, during the "AFTER FIELD" event: if user insert a not valid character into the field, when user leave from this field, the program has to show a message and disable the save operation (not only the button…