Sage X3

Hello I want to delete database entries which are older than 15 minutes. datetime$ returns the date in GMT time zone. But the database entries are stored in CET time zone (CREDATTIM column). The comparison not work as intended because of the 2 hours…

In the object function, the system does not allow us to add views in the environment tab, which bar us from using fields from a view on the left list. I understand that we can use field expression to call a function on the selection tab to add a customized…

Good morning, I'd like to filter a query for a landing page on my X3 v11. I see on X3 online help that you can add a "where" parameter to a menu item and add sdata conditions, but the help says: Only simple conditions using "le", "ge", "eq", "lt"…

Hi, I have SAGEX3 release/12.17.0 build 33 and i'm trying to run the following graphql query: { xtremX3Manufacturing { workOrderProductionReporting{ query{ edges{ node{ workOrderProductionReportingLines{ query{ edges{ node{ lot } } }…

We have the need to query a list of products using the new GraphQL API. The filter in specific is a list of product IDs. We already took the graphql training and this is not addressed anywhere. Could you please help? This is the query that we are trying…

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…

Hello I get the error Error 26 : Internal error Inconsistent reference value (11026) at @X3.TRT/REQUETES$adx (153) when trying to read a custom table in a custom batch job script. Part of the key from the custom table is a counter variable which is…

Hello everyone When I create a SQL trigger on a table in SQL management studio the trigger will be deleted when the table is validated or a new release is patched. Is there any way to create SQL triggers so that they are protected? Like activity codes…

Hi there, I successfully added the "internal reference" field from the purchase order to the "Order lines inquiry" screen. Now we want to add the field to the filter. I already added and "linked" the header and cirteria fields in the "CPP" inquiry…

Hello, I'm currently looking into closing reasons for Sales Order lines. We would like to capture more information when we short a customer shipment. I've located the code field CCLREN on SORDERQ. I've also found the table with all the closing reason…

Hi there, I'm having a "problem" in my Statistical inquiry , the year -N it's creating another line instead of being in the same line has the rest of the information, i have 2 lines for each month. How do i Solve this? Example

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…

Does Sage X3 support the query via modify date?

The title says it all. Only happens in some folders, v12 Patch 31. The work around is to take a patch of the graphical query from Problem Folder, integrated it into a Known Good Folder, and after validating, copy the JSON file shown in the error from…

Hi, im querying an object via webservice but it does not return data on the fields that are not from the main table even though those tables are linked to the object. Is this a limitation or am i doing something wrong ?

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…

When using the Product selection icon in any of the STOCK inquiries (Stock by site used for example), the fields in the pop-up window for selection are not those defined by the Product ITM object selection. Where can I find the field definitions used…

Hi, How to read the .adx binary file content? There were no .src equivalent in both X3/TRT and the endpoint's TRT folder. Checked backup, it was not stored as well.

Created a SNX webservice for SNX object and calling actionObjectKeys method with Action Code: b and key: CUNSSSNUM and value: SCS0007969 (a valid stock count session). Running the generation button manually generates the list successfully but on the…

Hi - I am having a hard time creating a representation that has columns for address lines. I am using the BPADDRESS representation as a template, and I am trying to add columns for the individual address fields (BPADDLIG1, etc.) without success. I have…

Hello, I have written a simple SQL query that returns info about sales returns. I am trying to get the return code description to show up, from the ATABDIV table (Miscellaneous Tables) but it's throwing this notice that the column name, LNGDES_0,…

Hello, Is there a way to retrieve a clob/blob text from sage x3 by using the REST api1? If that is not possible, which workarounds exist to still get the text? Thank you,

Hi guys, We are trying to return the clob text using a representation. Some time ago we saw this website How to add a clob text to a representation class @ L.V. Expertise X3 (lvexpertisex3.com) that explains how to add a clob text to a representation…

Hi, I'm trying to make various queries in X3 using graphql, and I'd like to retrieve, say, items from the 300th to the 400th. I know I can use "first:100" and "after: sometag" to get 100 items starting from sometag, but I have to know the tag. Meaning…

Hello all, Is there a way to get the components that are shown on the Production Tracking to be sorted by the BOMSEQ #, as it is shown on the Work Orders/Production BOMs instead of being sorted alphabetically? Thank you, Steve