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…

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

I am trying to execute a SQL stored procedure using the SQL query tool in X3. I am not getting a validation error but nothing returns when I run it. I do get results when executing the stored procedure in SSMS.

Anyone know how to format that so it displays MM/DD/YYYY HH/MM ? I've tried both data types D and A but just get MM/DD/YYYY.

Where's a good resource to learn more about this? I used SQL years ago but curious about the specifics for the X3 tool.

Hello all, Has anyone had a luck with using the UNION or UNION ALL join types when creating a new view within the X3? When I try to do it I get the message - [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near '0'. …