Welcome to the Sage X3 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros from around the globe.
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…
When creating a chart of accounts, our client have some GL accounts which are inactive (not usable, for information or classification only) and every time client wants to update their Account pyramid to include new GL accounts, they have to go through…
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?
