Hello,
Is there a way to execute a dv filter with multple criteria to filter the criteria in a certain order?
I would like to run a dv on SLMatltrans with the following filter:(TransType = 'R' AND ItemPMTCode = 'P' AND ItemMatlType = 'M') AND TransNum = (select max(trans_num) from matltran where matltran.item = Item).
I need the filter to run in the order I typed. (i.e: I would like the Material Transactions to be filtered for receipts of Purchaseed Items with Materal Type of Material first and then grab the most recent transaction).
Is there a way to make a DV do just that or do I have to create an ido method?
