Skip to Content
0
Aug 03, 2023 at 06:22 AM

Formatted Search to change document series in Purchase Request

128 Views Last edit Aug 03, 2023 at 08:44 AM 4 rev

Hi.

Currently the default series when we creates Purchase request is 'Primary'. But now I need to separate it if IT department then they need to use 'Indirect' series that I already created. Right now my user need to manually select the series and sometimes they forgot to choose 'Indirect'.

screenshot-3.jpg

can someone help me the formatted search query? i am using below query but its not working

SELECT T0.Series

FROM OPRQ T0

WHERE T0.DocEntry = $[OPRQ.DocEntry]

AND T0.department = '15'

Attachments

image.png (85.3 kB)
screenshot-3.jpg (48.7 kB)