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…

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…

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…

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…