Discussions
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Join us
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