I have a saved search that lists sales orders that...
# general
s
I have a saved search that lists sales orders that have one or more DropShip lines. I want to be able to select based on the DropShip Vendor that the DSPO was assigned to but the only place that I have found that I can get that is the purchaseorder.billingaddress and use a contains to get the name of the vendor for comparison. That takes a Loooonnnnngggg time. I know that there is a povender field in the line item record but it does not seem to be exposed to saved search. Does anyone have a better way to do this? Thanks
d
so it's a transaction search filtered for sales order type that have an applying transaction : type of "Purchase Order" Have you tried adding an available filter for "applying transaction : name"? This works for me, although depending on how many entities you have, the drop down list will be quite slow to open
There's another trick you can do if you want a text filter: Criteria, formula(text)
{applyingtransaction.name}||'any'
(set to "contains 'any'") Add a formula(text) available filter Then you can use the available filter as 'vendor name contains' Caveat is that you can only have one formula(text) criteria, as they all get compared to whatever text you put in your available filter
s
I found that trying to get it from the line item did not work but chaining to the po was fairly quick... I set one field to pull only lines that NVL({purchaseorder.number}, 'None') and then another criteria that checked Purchase Order : Name against the Vendor name. For some reason the associate PO has its name set to the vendor.