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!
Join our Ask An Expert Live session featuring Angela Bayliss , Senior Principal Consultant at Jade Global, on June 26, 2025, 2–3 PM ET. With 21 years of experience, Angela will answer all your questions. Learn from one of the best! RSVP now.
How to display Return Authorization Number when Applying Transaction is Credit Memo?
I wrote a transaction type saved search where the CRITERIA contains Type = Return Authorization (among other criteria). IN the RESULTS I created two formulas, one that should display the applying transaction if the TYPE = Credit Memo and the other should display the applying transaction if the TYPE = Item Receipt. The formulas have been tried using both Numeric and Text, but neither of them work, and I am wondering if it is because my criteria is filtered just to Return Authorization. Here are my formulas:
Formula (text): CASE WHEN {applyinglinktype}="Credit Memo" THEN {applyingtransaction} ELSE "NA" END
Formula (numeric): CASE WHEN {applyinglinktype}="Credit Memo" THEN {applyingtransaction} ELSE 0 END