I have tested the code below, it works perfectly in Native Nav database but will not work in SQL. In fact, I get a total blank for all records instead of a filter of just some. I need to exclude some of the Purchase Orders for some of the users. Can anyone help with a fix for this please?
IF UserSetup.“Confirm Req. Line Insert” THEN BEGIN
SETFILTER(“No.”, ‘<%1’, ‘P-SNET*’);
SETFILTER(“No.”, ‘<%1’, ‘PO-RMA*’);