• BIS import/export template from Sage passed on SEED but failed on Production

    Hi,

    I need advice and pointers to identify the root cause of the import failure issue.

    Sage X3: v12 Patch 31 (latest patch by time of writing)
    Database: SQL Server 2019 Standard
    All components are updated to match Sage X3 v12p31 requirements.

    On SEED folder…

  • Graphql Onpremise setup

    Hello everyone,

    I'm developing a middleware to integrate Sage X3 with a 3PL and I want to use GraphQL services but I'm not able to connect because I haven't found the correct Endpoint,

    I already try with "{{server}}/v1/service/PROD/api…

  • Trolley Build Function Sage

    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…

  • SageX3 - Left List Personalization

    Hi, how can I add custom  view fields into standard (browser) object Left List ?

    It's easy to add other tables but , what about views ?

    Example:this is a standard object 

    I've added my custom view into Viste tab:

    But in Selezione tab (Selection…

  • Force to open [M:ENM] to modify stock movement through code or configuration

    Is there a way to force the popup screen on a qty line modification of a purchase receipt?

  • WEB SCHEDULING

    hello team, I have two questions about exploiting web scheduling:

    +when I make a quantity modification on a production order in the web scheduling: will the modified quantity be changed in sage x3 during the data export.

    + in the new version of web…

  • Implementation problems with specific inquiry

    Hello everyone Slight smile

    We have programmed a specific inquiry for our client. There should be a back and next button.

    Only a part of the data records should be displayed. When you click on next other records should be loaded.

    In the function GESGTC (Inquiry screens…

  • macOS / M1 / aarch64 / arm64/ Plugin Eclipse Sage X3

    Hi Everyone,

    Anyone had success running Eclipse arm64 binary version on Mac M1 

    I got the latest stable build of Eclipse for arm64 : eclipse-SDK-4.24M1-macosx-cocoa-aarch64.dmg 

     Runs fine

     Was able to install the Eclipse plugin

    However. Connecting to X3…

  • Generic Object Read

    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…

  • To open a new browser with file path

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

  • How do I join STOJOU to GACCCODE?

    I am looking to join the two above tables, According to the data models, the join is supposed to happen like this: 1;ACCCOD. How is that supposed to work if STOJOU doesn't have any accounting code? Also what does the 1 mean in the data model? Any and…

  • Looking to build a report for Sales by GLCode by month

    Hi, as the subject says, I am building a report to pull sales numbers per company by GLCode in sql server. I'm having a hard time getting data that looks correct. I have tried a few different ways of joining SORDER table to GACCOUNT table. I've tried…

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