User_S3PB4

My Stuff

See All the Unlockable Badges See All the Unlockable Badges

Nominate Your Peers for NetSuite Support Community's Choice of the Quarter! Submit your nomination today.

Intelligent Payment Automation version 1.0.3 is now available in the SuiteApp Marketplace. The SuiteApp, powered by BILL, lets you automate payments, manage vendor details, and bank account information within NetSuite. Learn more

Comments

@Jervin Nicholas Teopengco-Oracle when i update the query without spaces, it returns an empty value for this field CASE WHEN {custbody_pacejet_shipped_method} = 'FedEx Ground' THEN 'FedExGround' WHEN {custbody_pacejet_shipped_method} = 'FedEx SmartPost' THEN 'Smartpost' WHEN {custbody_pacejet_shipped_method} = 'FedEx Home…

in Manipulate output data in a saved search based on a Transaction Body Field Comment by User_S3PB4 Oct 16, 2025 8:00PM
@Jervin Nicholas Teopengco-Oracle The query returns the desired results after i go into edit mode, change back the symbols and run. but it keeps reverting back everytime it runs without editing CASE WHEN {custbody_pacejet_shipped_method} = 'FedEx Ground' THEN 'FedExGround' WHEN {custbody_pacejet_shipped_method} = 'FedEx…

in Manipulate output data in a saved search based on a Transaction Body Field Comment by User_S3PB4 Oct 13, 2025 2:25PM
hi @Jervin Nicholas Teopengco-Oracle i know based on the results. As you can see in the below screenshot, the field is empty. then i go into edit mode and see it reverted back. Also when i remove the space as you suggested, it doesnt return the results.

in Manipulate output data in a saved search based on a Transaction Body Field Comment by User_S3PB4 Oct 10, 2025 2:18PM
hi @Jervin Nicholas Teopengco-Oracle i didnt edit the save search, simply refreshed the results and it still reverted

in Manipulate output data in a saved search based on a Transaction Body Field Comment by User_S3PB4 Oct 9, 2025 7:43PM
hi @Jervin Nicholas Teopengco-Oracle yes, i re-ran it and the values were empty so i looked at the query and see that it changed back to > or <

in Manipulate output data in a saved search based on a Transaction Body Field Comment by User_S3PB4 Oct 9, 2025 5:42PM
hi @Ivy Lopez-Oracle yes, it worked but it reverted back even though i didnt make any changes.

in Manipulate output data in a saved search based on a Transaction Body Field Comment by User_S3PB4 Oct 3, 2025 4:24PM
Hi @Ivy Lopez-Oracle, Thank you so much! That worked for the most part! Just one value isnt returning the results im looking for - "UPS SurePost >1LB", its returning blank. Why would that be happening? Here is my formula CASE WHEN {custbody_pacejet_shipped_method} = 'FedEx Ground' THEN 'FedExGround' WHEN…

in Manipulate output data in a saved search based on a Transaction Body Field Comment by User_S3PB4 Oct 1, 2025 2:51PM

User_S3PB4 Newbie

Comments