Discussions
SuiteWorld is the largest annual gathering of the NetSuite community! It will be held in Las Vegas on October 6-9, 2025. Our customers and partners look forward to SuiteWorld every year as a place to hear the latest from NetSuite, get hands-on learning, and connect with each other. Register now!
Saved search shipping / billing address sourcing issues with created from transactions
Hello,
saved search is created to track all incoming and outgoing transactions in the location and one of the columns report addresses (incoming or outgoing). it seems that Vendor return authorizations and transfer order receipts have issues to source the address from created.from transactions. SO's PO's and RA's are working as they should.
please find formula and screenshot below:
CASE WHEN {type} = 'item Fulfillment' and {createdfrom.type} = 'Vendor Return authorization' THEN {createdfrom.billaddress} WHEN {type} = 'Item Fulfillment' THEN {createdfrom.shipaddress} WHEN {type} = 'Item Receipt' and {createdfrom.type} = 'Transfer order' THEN {createdfrom.shipaddress} ELSE {createdfrom.billaddress} END
thank you kindly!