Browse By Tags

  • Left Join with is null check

    Hello I want to write the following SQL Query as 4 GL Link instruction: As seen in above screenshot this returns a record. With the following Link statement I try to make this SQL in 4GL. In 4 GL I make a left outer join and check with [F:YCFPJOB…
  • Variable to show the transaction code used to enter screen

    I would like to take action in a screen based on which transaction code was use to enter the screen. Is there a variable available that will show which transaction was chosen when launching the function?
  • How to store Blob image's type in a table ? / Comment stocker le type d'image Blob dans une table ?

    I created a custom screen where I am displaying images related to drivers. I am using a datatype of ABB, Graphic object of Photo.I have an issue on how to store those images. I know that it is stored in the CBLOB table. In the screen ITM1 there is the…
  • How to store Blob image's type in a table ?

    I created a custom screen where I am displaying images related to a driver. I am using a datatype of ABB, input of Display, and Graphic object of Photo.I have an issue on how to store those images. I know that it is stored in the CBLOB table. In the screen…
  • 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/" where PROD…
  • 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…
  • 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…
  • 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
  • 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…
  • 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 B…
  • Cannot acces local file

    Hi, from Sage X3 v12 web, i use the editor ADOTRT. Open my src program and run. local char zfile(255), CURLINE(20) zfile = "e:\temp\mb\test.txt" openi zfile Using [TST] Repeat Rdseq CURLINE Using [TST] infbox CURLINE until fstat <> 0…
  • Is there an entry point or built in function to view an attachment?

    On X3 V12, I want to add a button or menu item that opens an attachment on an object without opening the attachments popup window. I know all of the parameters of the attachment and want to know what the code is for viewing the attachment. I see GOBJTXT…