mchen_26125

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

No Limits. Just possibilities.
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.

Celebrate Your 2025 Community Recap & Achievements!

We’re excited to announce that the 2025 Community Recap is now available! This special recap highlights the amazing contributions and achievements of our members over the year and celebrates the collective success of our community.
Check your personalized recap to see the impact you made in 2025 and how your efforts helped shape our community’s growth and success.

View Your 2025 Community Recap

Thank you to everyone for your passion, collaboration, and support. Here’s to building an even stronger community together in the year ahead!

Please note that on Friday, January 9, 2026, at 8:00 PM Pacific time, our Case Management System will undergo a scheduled maintenance for approximately 60 minutes. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.

Comments

I think I got it to work with Formula(Text) CASE WHEN to_char({trandate},'MM/DD/YYYY')=to_char({today},'MM/DD/YYYY') THEN to_char({today},'MM/DD/YYYY HH:MIpm') ELSE to_char({trandate},'MM/DD/YYYY') END

in Formula(date/time) Comment by mchen_26125 Dec 12, 2013 12:41PM
I used Formula(Date) Group {datecreated} but it's not grouping correctly I still see 12/5 12/5 12/5

in to_char({datecreated},'DD/MM/YYYY') Comment by mchen_26125 Dec 5, 2013 3:34PM
nevermind, i got it. i found that there is a formula(date) & formula(date/time)

in to_char({datecreated},'DD/MM/YYYY') Comment by mchen_26125 Dec 5, 2013 3:31PM
I need it in a formula, so I can add it as a column result. I'm not going to run a whole report just to find 1 value. The problem I have is I can't use group in the formula.

in SQL contains Comment by mchen_26125 Dec 9, 2013 1:50PM
i got it to work. i used formula(text) Group to_char({datecreated})

in to_char({datecreated},'DD/MM/YYYY') Comment by mchen_26125 Dec 5, 2013 3:39PM
i want to do the same, but i want a custom field where it tells me the employee that approved the purchase/order/rma, etc. but i don't know if it is possible to search system notes fields. so i can find this info.

in Help with CASE Expression Comment by mchen_26125 Oct 30, 2013 10:00PM
same here...settings got changed. i went to setup->company->printing&fax-> pdf -> changed it back down to single line spacing.

in line spaces are doubled on PDF forms Comment by mchen_26125 Jun 10, 2016 10:15AM
okay, i got it to work. i chose formula then type ''

in cannot set field value to null on workflow Comment by mchen_26125 May 27, 2016 11:20AM
confirm 'yes' will save the record. you still need an action that set field to 'yes'

in Ask a question thru a workflow? Comment by mchen_26125 Apr 8, 2016 6:15PM
that is a good idea. if all else fails, i might have to just hide the link. so ppl don't accidently approve something they aren't suppose to but seems like a lot of work.

in RMA pending approval Comment by mchen_26125 Aug 30, 2013 6:29PM
you can approve RMA using the Transaction->Customer->Approve Return Authorizations i don't think you can add a workflow on this page.

in RMA pending approval Comment by mchen_26125 Aug 26, 2013 3:33PM
removing a button causes an error after i submit the sales order

in Remove a standard Button Comment by mchen_26125 Oct 15, 2013 3:45PM
i want to do this too? so what's the solution?

in Remove a standard Button Comment by mchen_26125 Oct 9, 2013 3:21PM
anyone know how to change status using a script / button?

in Approval Button Set Field Value Comment by mchen_26125 Oct 30, 2013 10:39AM
I am also testing this feature. I don't have an answer to your question but I am curious about your thoughts. I am not sure it's going to be worth using given that I'm finding a lot of holes. I wouldn't recommend to use Inbound Shipment yet. There are so many bugs/glitches. It will cause too many issues if you use this…

in Inbound Shipment ETA not updating related PO Records Comment by mchen_26125 Nov 8, 2018 5:40PM

mchen_26125 Blue Ribbon

Comments