Produces a query:
(historyflag = 0 and siteid = 'BEDFORD') and (exists (select 1 from dbo.poline where ((upper(gldebitacct) like '%300%')) and (ponum=po.ponum and revisionnum=po.revisionnum and siteid=po.siteid)))
and it finds p.o.'s with lines where the gldebit account contains 300.
Is yours not working?
Wildcards and operator help is here
------------------------------
Christopher Winston
Projetech Inc.
------------------------------
Original Message:
Sent: 02-13-2023 09:56
From: Wade Redd
Subject: Listing Purchase Orders for multiple projects (general ledger accounts)
You would think you could use a wild card in that field.
------------------------------
Wade Redd
3rd Coast Consulting
------------------------------
Original Message:
Sent: 02-09-2023 21:48
From: Christopher Winston
Subject: Listing Purchase Orders for multiple projects (general ledger accounts)
GL Debit and Credit fields live at line level on purchase orders, so 1 purchase order could have more than one present. Your best bet would be a custom report of polines referencing the gl('s) you are searching for to be consistent.
------------------------------
Christopher Winston
Projetech Inc.