Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Bill Saved Search > Display the Requestor from the Purchase Order
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
Tagged:
0