Sage X3

Good morning I am trying to link ITMBPS to ITMMASTER in the object ITM. However there doesn't seem to be any link that works with any of the indexes. I tried this [F:ITM]ITMREF;"", and of course it did not work. Does anyone have any ideas?

Hello, I am trying to write a query that will show all of the access a given user has and what level of access. I am trying to determine where the option codes are defined but have not been able to do so. Any help in figuring this out would be much…

Trying to create a query based on items that are out on loan to customers. My query includes an Expression calculation based on what has been delivered to a customer minus what has been returned. So using two tables QTY on SORDERQ-RETURND, therefore…

Hi team, I am running function CONSCPT (Account inquiry) but am getting fewer results compared to date range I have set e.g. am inquiring data between 01st Jan 2023 - 31st Dec 2023 but only 50 results are displayed of Jan - Feb and output capacity is…

Hello, I would like to be able to rename a file in [TMP]. I know I can do it with renameFile(PATH,PATH1) Except the file name is random, let's say : IMPORTME2024 and I want to rename it IMPORTME I tried a lot of stuff like this for exemple but it…

Looking for an explanation on what "Last Receipt" field means in detailed stock?

Hello, I am trying to include empty locations in my location count but it doesn't seem to work. I have tried using a 'Locations' count formula of "[F:STC]OCPCOD = 1" but it still doesn't work. Is there a way to include empty locations in an annual stock…

Hello, I am building and SQL query with itm ref and standard cost. We use simple manual standard cost (FY, dates and cost). I can join ITMFACILIT and ITMMVT, but what is the ITMMVT register applied to the aricle-site?

Good Afternoon, I need to know if it's possible to export the BOM structure massively and with a connection to the my Sales Products for consulting the consumption history of components, and if possible, also export the Operations for consulting the…

Hi Guys, We are trying to use the DMT V2 templates (we have also applied the October Hotfix) . When we try and validate the XADMTAUD query (for the audit check/logs) this validates ok, however when we click on Search we get the following errors …

Hello, Im trying to filter invoices left list based on two entry transactions. Here is what I came up with: $ACTION #************************************************************************************************************** Case ACTION When…

Hello, I have some questions about stock queries: Is it possible query all the stock in a site (and not always filter by an article reference) ? And the other question Is it possible to query the stock with separate lines for each serial number…

Hi there. I've created a custom Funprog that returns an integer value between 0 and 4, when an item reference is passed into it. The intended use is as a filter for the stock count 'Product' Formula, to only generate a count with items where this Func…

Hi, Is it possible to create an specific script, in model export, in order to filter by code some registres to be exported? I need it to check a value from a table that is not linked to the model's object Thnkx

Hello community, i'm trying to modify a bom object using web service object bom ( bomp : transaction ) but it's always returnig "fiche inexistant : record not exist "

I need to create inbound(expose) rest api in sage x3. one of the property related to joing table can not filter in rest api url? How to filter the joining table proprties

Hello everyone I try to implement the entry point https://online-help.sageerpx3.com/erp/12/wp-static-content/static-pages/en_US/OBJ/ADC_SERVEUR.htm#APE_30_10 with action REQUETE. I created the entry point and the processing script in the X3 folder…

Hello everyone We sometimes have problems when a batch job runs more than once. In order to prevent this we want to use the entry point SERVEUR with action REQUETE https://online-help.sageerpx3.com/erp/12/wp-static-content/static-pages/en_US/OBJ/ADC_SERVEUR…

Hi! In the new 2023R2 release of SAGE X3 we can find information about the new GRAPHQL capabilities for customation or extensability, like: Add-on packages for Sage X3 API dictionary You can create new add-on packages in the dictionary for customizing…

Hello, My question is simple. We do cycle counts based on location ranges. However, when you select Location, the ABC selection becomes unavailable, and I've been unable to figure out a "Locations" Count formula to include the ABC class. Likewise…

If There are lots of purchase order (Example: 20 Purchase Order) against a site & supplier, how it can be search Purchase order to choose multiple lines in Purchase Receipt Function?

Hello Community! My company has a large database of raw materials, currently the purchasing plan is done manually using MRP results along with checking Projected for each raw material , one at a time. As such it's a very tedious and inefficient process…

Hello, I am trying to put a "location" field in the query for stock movements by items so that it can filter the movements it shows. I have modified the screen and added the field then in criteria I created a formula to get the ones that matched…

Hi folks We have the problem that in certain cases an IC purchase invoice is not automatically created for a customer when the corresponding IC sales invoice is released. Most of the time it works but not always. We have set up the intercompany…

We have a query that is primarily filtered by GACTX.USER, so that the user who is logged in can see only their orders on this query. However, for some users I would like them to be able to see the entire report. I was wondering if there was a way to filter…