• Is there a documentation for useful standard x3 functions?

    Hello Slight smile

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

  • What is EOQ?

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

  • Adding Field to Screen

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

  • Trying to read the products of Magento from X3 using rest api integration and Node JS Error

    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…

  • How can I go about joining the SINVOICED table to the STOJOU table?

    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…

  • Previous record loaded after refresh

    Hello everyone Smiley

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

  • Sage X3 How to modify window that shows up when i click selection icon?

    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

  • Switching between edit and read only Mode with global variable GCONSULT

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

  • How to change Screen Input type from "Enter" to "Display" via 4GL?

    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…

  • ADC location override

    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…

  • Unable to Autoprint the Crystal Report in Sage X3 from web application

     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…

  • why i can't set query of VACITM facet to yes in ITMMASTER representation

    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

  • # in the screens evaluated titles

    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…

  • How import assembly doc?

    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…

  • Change Report Name when printing

    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…

  • C# web service wrapper on new net core/standard frame

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

  • Connect Existing DB Server to Brand New App Server

    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…

  • Script editor V12 & debug

    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

    Barak

  • Workflow Action Update fields

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

  • OGGSTD - Button

    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't make…
  • Customize standard operation of standard process

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

  • BPSUPPLIER SCREEN (X3) - CONTACT default field KCNTFLG not in MSSQL database tables - CONTACT or CONTRACTCRM

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

  • X3, Errors after Update to X3 v12.0.23

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

  • Writing X3 code? Let's check for errors!

    Today I want to take a quick look at a function that is useful for development, Source Verification.  This tool can be useful to check for common programming errors and anomalies that could outright stop the code from working or could lead to other issues…

  • Sage X3 PU11 - SOAP Call in C# Language - Is there a common library DLL which we. can attached as a reference.

    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