Sage X3

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…

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…

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

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

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…

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'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

I am trying to develop a query that involves aggregating invoice lines such that values for kits are the sum of their components. I can see there is a flag (LINTYP_0) to determine what is a kit and what isn't, however I am having a hard time figuring…

Hi there, Is there any way of passing a list of values (comma separated or equivalent) as a Criteria parameter in the printouts > SQL Query Tool Also, how to remove character limitation from that field... what i'm trying to achieve is something like this…

Hi everyone, I'm using representations to use the REST web services in sage x3 v12, and it's working fine, but some parameters it seems not to work. I want to do a pagination when I use the $details facet, but it's not working. looking this page…

I have a recurring task that exports invoices to our EDI system and I'm trying to implement a selection criteria to separate out invoices from selected customers. I have tried variations on the script below but it is constantly rejected by the formula…

We have set up the Purchasing dashboard for staff across the business to use and access orders. The issue we are facing is that the default gadget on the home page that displays the orders to receipt shows all available orders - this needs restricting…

In prior version, after a search, you could narrow the results with this box. I can't seem to get this to pop up in V12. In V11 it is toggled with the normal toggle panel keys like ESC+F11 but there is no right panel in V12 (see pin / unpin). Is there…

Hello Guru's, One of our customers noted that Sales Delivery Module doesn't have the standard capability of filtering the Sales Order Selection like the function currently available in Purchase Invoice where the module has a line menu for Purchase Order…

Hi, I would like to clone an invoice after posting, but the "Child" record will have few changes. Would anyone have a piece of script that clones one record to share, as an example? Just to learn the best way to do it. Thank you. Best regards…

Hi all, I am trying to build a SPE to capture a number (Field is a text), split the digits, multiply each one, sum all and validate the result. I have some questions: 1 - Now, I am working with STRING and I need convert this String to a Integer, so I…

Hello, I'm trying, on Sage X3 V11, to import a Task using the specific X3 Model with the help of AOWSIMPORT WebService. The X3 Model for Tasks defines the field separator as a new line (\010\013), but as soon as I put a newline inside the I_FILE in…

Hi, I need to create in Sage X3 V9 (patch 6) a new analitycal dimension (object CCE) on creating new Project (object OPP) with some data from the last one, my client request an automatic function on create so any new button are forbidden, in my specific…

Hello, I am trying to use a text data type in a class/representation, but I keep getting the following error message when I run my API: {"$diagnoses":[{"$severity":"error", "$message": "X3 engine error: [Microsoft][SQL Server Native Client 11.0]Invalid…

How would I filter a stock status selection based on another field. For example, I have one field that has A in the field. Then my second field possible selection will be filtered down to anything that is a substatus of A. Thanks.

We use the advanced selection and memo save capabilities quite a bit throughout the X3 system. Does anyone know of a way to also control the sort on the left list. Maybe through the expression field? Here is the scenario from the users perspective:…

On the object screen, there is a tab for views. Can somebody what does the view do to the object?