Sage X3

Is it possible to filter a left list so only records I want the user to see appear? i.e. Only show records that the user has access to, or only show records that have a creation date < 14 days etc? So we can have 'All requests', 'my requests' and…

Hi, Imagine I have a button called "FILTER" in GESITM and I want it to filter left list so that it shows all the products that have "TCLCOD = 'ST'". How should I do it? Best Regards

In my object, the main table is STOCK and under the environment tab, I linked the itmmaster table. When I write my code to get the itmmaster table linked, it will not link. Everything works when I use the STOCK table, but when I try to use the ITMMASTER…

Hi all, I'm trying to use the "AQUERY_CRITERIA_AFTER" event, in a mobile representation. My only problem here is that the property "THIS" is not available, and because of that i can't use values from the main screen. Do you know how can i solve…

Hi there, When I filter a left list in a specific with CRITERE, the filters imputed by the user are ignored. I'm trying to filter left list in a specific. This is my code: $CLE_GAUCHE Default File [YCRG] If currbox = "GAU_CHE1" CRITERE = …

Hi, I need to filter table a based on field values in table b how would I do this? I need to filter a table based on the site access a user has in their functional profile without setting it on the object site field. I have tried the below. ######################################################################################…

Hi, Could someone point me in the right direction. I need to filter the left list for the product master based on the users fictional profile site access. I am using the CLE_GAUCHE action and FUTERSUP. Using one condition is not a problem but…

Hi, I need to filter the products selection list when using itemref field in the POH2 screen. The table and field [F:ITM]CCE(0) contains the products linked to the order site. I want to show only products where [F:ITM]CCE(0) = [M:POH0]POHFCY Could…

Hi there, Im trying to filter a field based on CHOOSE as I read on greytrix ( http://www.greytrix.com/blogs/sagex3/2014/08/31/adding-selection-window-for-any-action/ ) My code is working but If I use the search (as highlited in the screenshot…

I would like to make a filter returning the record with me max value, is there a way to do that? In SQL I use this: select MAX(NUM_0) from PINVOICE Just a example, how I can do that in X3?