Sage X3

We have a scenario where we direct ship product from a supplier to a customer. Because of this and because we want to see accurate sales margins on the sales order, we have a need to change the cost of goods on our sales order entry screen so that it…

Hello, does anyone know of a way to automate closing multiple sales orders? I was trying to look at API or Import options but seems that closing a sales order requires execution of an action (TRTCLESOH) and I'm not finding the easiest way to access…

Hi, 4GL Development question. Not sure the keyword to find for these. In 4GL, I know I can just manually put in the hardcode filepath to open through SYSTEME2 raw OS cmd call but it is very annoying to maintain (about 5+ scripts to update) every time…

Hello, I don't understand what does the keyword "setmode" do, there is no help available on eclipse or on the internet. Can someone please explain it to me?

After reviewing the product status options under product setup (Active, Obsolete, not usable, on shortage.. etc), we have decided that certain options are not applicable to our business process. To avoid confusion to our users, we'd like to hide some…

Hey Everyone, About a year ago, someone had set up a "Fuel Surcharge" invoicing element that applies a $5.00 charge to every order. However, it was supposed to have tax excluded. To this day, the $5.00 charge is actually $5.60 because it is being charge…

Hello! I'm Sage X3 developer and I having issues with Grid development. Does someone have a documentation about NBLIG, nolign, counters and grid screen? Thanks.

Hello! I have created a simple workflow and script to display fields that have been modified in a PO where the cost is over $10,000. This works by checking the [M] field against the base [F:POH] field, and using RETVAL to display the changed information…

Hello everyone I built a generic screen "ZTRANSPORTCO" for a customer. The screen is used in multiple windows. The problem is when I try to "Jump to" another window which also has a tab with the generic screen "ZTRANSPORTCO" I get the following…

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?

$VERIF_MOD Local Char ZPRODCOD(30) Local Char ZPRODCODOLD(30) Local Integer YESNO YESNO =2 For i=0 To max([M:POH2]NBLIG -1) For [F:ITM] Where [F:ITM]ITMREF = [M:POH2]ITMREF(i) ZPRODCODOLD = [M:POH2]ZPRODCOD(i) ZPRODCOD=[ITM]ZPRODCOD if…

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…

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…

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…

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…

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…

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

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…

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

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…

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

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…

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…

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…

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…