Sage X3

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…

is it estimated order quantity? Does anyone know the name of the column in sql? As always, your responses are greatly appreciated!

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!

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…

As seen in the subject, I am looking to join the STOJOU table to the SINVOICED table without the use of the ITMREF column. Data models show a one way arrow from STOJOU to SINVOICED with VCRNUM;VCRLIN. I am unsure of what to do with that, with VCRNUM only…

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 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…

We are creating Sales delivery from web application(Source code Java) into Sage X3 using Soap web services which is succesful. At the same time We are trying to autoprint the delivery crystal report after creating delivery in Sage X3 for which code was…

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

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…

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…

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…

I’m trying to develop a c# wrapper to communicate with x3 SOAP web services with the new frameworks NET CORE, NET STANDARD 2.0 (on Xamarin). With this wrapper: https://www.rklesolutions.com/blog/x3-soap-web-services I can easily connect with…

Has anyone had to create a new V11 (or really any version) application server and connect it to an existing SQL Database server? Assume we don't have access to the old app server (although we might). I have some ideas, but I'd like to know how others…

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 need assistance developing this workflow. What I'm trying to accomplish: When a customer return is created, I need the workflow to look at a TSICOD(1) and if it = 003, I need to update the lines of that return. The trigger works, so I can…

Hello I have issue with a Button on Windows OGGSTD (Accounting Object GAS). Validated Windows OGGSTD, also all the Transactions. When I click on Button, my spe is not firing. I don't understand. I tried to put $SETBOUT chmen+="7" but it doesn…

Hello. I'd like to customize a standard operation into CNSSPRSTD standard process, called by the specific processing CNSSPRSPE, about projected stock inventory. It's possible to: - copy the standard process CNSSPRSTD - create a new one, called…

October 25th, 2020 Hello Teams, Need your help. :) BPSUPPLIER-->CONTACT-->CONTACTCRM Where to find the field KCNTFLG - which is the Default Contact Flag in the MSSQL x3 database tables. Goal - I am looking for where the CNTFLG field is stored…

Hello Everyone we updated a X3 system from v12.0.21 to v12.0.23 , but just the X3 folder was updated (not the other live folder)! and now we get these errors like this (and the .src files are not in the TRT folder) is it that we should just select…

Hello Teams, We are creating an Interface to Sage X3 PU11 and would like to know if Sage or any other provider has created a common DLL library for the C# programming language. Will be used to call SOAP or REST in Sage X3. Thank you, Dennis