Formatted Search to change document series in Purchase Request

[shikin]

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'.

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'

[SonTran · Accepted solution]

Hi,

Try this

select case when 
(select T0.Department from OUSR T0 where T0.USER_CODE=$[OPRQ.Requester]) ='15' 
then 'Indirect'
else 'Primary' 
end

Hope this helps,

Son Tran

[shikin · Accepted solution]

Hi sontran , seems like it working just that why it not auto update ya? cause i need to click on the magnifying icon only it updated to 'Indirect'.

[SonTran · Accepted solution]

FMS trigger whenever a specific value change but Purchase Request form open, user's value is already filled. I suggest to add remarks / required date for the trigger.

Hope this helps,