Love this! Thank you very helpful!

very well done thank you

Joahnna thanks for the response. However, that's incorrect. The syntax {total} is the bill total. I need to pull the related record Purchase order total. In the example picture above your solution will pull the amount $352.72. I need to pull the amount Circled $406.22 from the related record purchase order.

Joahnna that didnt quite work for me because I need to store the values for a saved search we use to approve bill payments from a workflow state. However, with your help with the formula. I created a workflow that works for my needs. I'll share below for anyone else who needs.

oh great ill give it a try!

Thanks See below. I have nothing setup in validation and defaulting, souring & filtering, or access tabs.

Job is not in the results or criteria.

You da man! thanks! Works perfect.

i dont get that on my end.

Yes this is great. I dont have a yes button to click btw

no that's incorrect. I want to lock the NetSuite user from creating a purchase order in any way without a Customer deposit attached to the sales order.

Who is Arcana? Again you are not addressing my concern to make the report for a single customer. Hint: Criteria name doesn't work. I'm waiting on a response from ACS ill let you know what they come up with.

Thanks Shamaine. However, the copy and paste from suite answers doesn't solve my concern with making the report customer specific.

John no sir your incorrect on your observation. I am using Name.

Thanks @Jeff Pineda-Oracle I was thinking like Adobe Dreamweaver. @Michelle Jabanes-Oracle what do you think? Thanks

thank you

@Jeff Pineda-Oracle Thanks for the quick comment. Is their a resource I can use to copy easy scripts similar to this and modify them as needed?

@Jeff Pineda-Oracle How can i customize the results of the item search API from netsuite. is it using a saved search? if so, how can i add the value of the custom checkbox (boolean) on the item as a result to use on the frontend JS script?

Jeff thanks for the quick response I'm going to run this by my team. I think your on to something with this solution. Ill update the thread when we test it.

Thanks Jeff for the comment. I am aware of PCV and use this for now. However, this doesn't allow me to draw in and market to anonymous users to the site by showing them what they have the potential to buy if they open a account. I can't shut off everything to login for pricing because I have many items I want to market to…

Have you tried add a state to the workflow for the email and put it between the transitions.