Hi, I want to get the Requestor value that is on the PO in Vendor Bill saved search.
My criteria for SS :
Type = is Bill
Main Line = is false
Applied to Transaction: Type = is any of Purchase Order, Item Receipt
RESULTS:
Document Number - Invoice Number
Formula(HTML) = CASE WHEN {appliedtotransaction.type}= 'Purchase Order' THEN '<a href="/app/accounting/transactions/purchord.nl?id=' || {appliedtotransaction.internalid} || '">' || {appliedtotransaction.number} || '</a>' ELSE NULL END - PO Number
Amount - Invoice Amount
Formula(Currency) = case when {appliedtotransaction.type}= 'Purchase Order' then {appliedtotransaction.amount} else 0 end - PO Amount
Formula(Text) = CASE WHEN {appliedtotransaction.type} = 'Purchase Order' THEN {appliedtotransaction.employee.entityid} ELSE NULL END - PO Requestor
The results for PO Requestor comes back as "ERROR: Field not found"
I've tried to use {appliedtotransaction.employee}, still the same result.
REQUESTOR is a field on PO form that has been renamed from employee field.
Thanks in advance,
Preethi