Sage X3

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 ?

Hello! I'm attempting to read a query in Excel, but the query is level 5. Currently when I set the level of the query to 5 via the menu item screen, it comes back as level 1. I can't find any way to effect the end result of what data comes out other…

I tried with all possible keys, but I still have a problem with the connections in between the table. Please, can anyone help me? I intend to create a query that presents all shipments and all production follow-ups made on a date and the respective accumulated…

When I try to get all the records in a single query, I got an error from X3 folder. And also tried with $next/$last links, however, we need to call these links synchronously until we get all the records from a table. Is there any chance to get all…

I am running the following Query, however when I run it, it does not output the delivery number. What am I missing.

Hi, I've made a request using the standard query tool and I woul like to display this chart in an home page. It works fine within the requester - I could see the bar chart. I've successfully created the corresponding menu items (based on one provided…

Hi, I am trying to run a query to pull fields from the screen Miscellaneous Receipts. The three things I need to pull are Quantity/Product/Receipt Date/Supplier Lot Number. I looked at the screen level and did not find a table from which I can pull…

I'm trying to pull the customer notes into a spreadsheet along with delivery text information for a migration. Whenever I bring over this field , it spills over onto other lines and as a result when I export the data it is all choppy and screwy. I'm assuming…

Does anyone know how to join tables through code (with one table being ATABDIV (misc tables))? I am trying to link TSICOD (statistical group ) (dim=0) to the table on the ATABDIV table (it's table 20), but I can't do it through code. Can anyone help me…

When you are in a query and you scroll down, you lose your headings. any way around this other than showing less lines and using the right and left arrows?

Hello, I have created the following query, but am getting an annoying message saying "the conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value." (see below screenshot). SELECT S.ITMREF_0, I.ITMDES1_0, S.STOFCY_0…