Sage X3

Has anyone ever done that? Looking to bring in the descriptions for the stat groups in ITMMASTER. And other places.

Hi Everyone, I am working with Sage X3 People U9 patch 8. A miscellaneous table called Bank branch was created with Bank On the Employee bank screen, When a bank is selected, all bank branch corresponding to the bank should be filtered automatically…

Does anyone know how to pull the description column for an ADI field instead of the code in a query? I know I can do this in a sql query or view but it seems like it should be easier than that.

Hello, I am not having any luck retrieving the allergen description (misc table 4100) for finished products that have >1 allergen listed. When I bring in the ATEXTRA table through a query, it returns values for products with 1 allergen listed, but if…

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…