The Wizard of Oz

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!

Staying Connected During the Holidays

Season’s greetings to you and yours! As we head into the holidays (December 24 – January 4), we want to take a moment to celebrate the incredible strength and collaboration within our community. Even during the break, you can continue to benefit from connecting with peers, searching related threads, posting your questions, and marking helpful replies as “Accepted” in the Support Community.

Please note our dedicated team will be on reduced coverage during this time, and regular responsiveness will resume on January 5. Wishing you a joyful and restful holiday season!

-The NetSuite Support Community Team

Comments

You might be able to just add a custom check box on the sales order and you could then create a workflow to automatically tick that box based on something along the lines of sum of total items ordered minus sum of items fulfilable = 0 then check custom box to true.

in Tracking inventory availability at time of order Comment by The Wizard of Oz May 30, 2012 11:02PM
Cheers Brett - I'll have a look at that (after our upgrade in 13 days... 1 less script to re-check!)

in Insert Saved Item Search Results Into Order Comment by The Wizard of Oz Feb 26, 2012 8:55PM
I don't know the answer, but I'm hoping someone can say "yes" to this. I've just thought of so many benefits to this after reading your post.

in Insert Saved Item Search Results Into Order Comment by The Wizard of Oz Feb 26, 2012 8:21PM
Billing Status = Is Open

in Sales Orders that are Not Billed and Pending fulfillment Comment by The Wizard of Oz Jan 15, 2012 8:42PM
As I recall, this is on the roadmap, but not yet available. Last release they enhanced the way Cases and support emails worked, allowing you to have 1 return email per sub. I recall them saying multi-branded employees were eventually going to happen, but not yet. Cheers for that insight. I hope it's sooner rather than…

in Multiple Emails in One World for one user Comment by The Wizard of Oz Jun 26, 2012 6:22PM
I'd Netsuite to chime in with an answer to this. It's ridiculous to manually change it in Home>Set Preferences before sending an email.

in Multiple Emails in One World for one user Comment by The Wizard of Oz Jun 25, 2012 11:03PM
Awesome - well done!

in Product links in transaction html emails Comment by The Wizard of Oz Sep 19, 2011 8:22PM
Yeah completely lost on this. Thanks anyway.

in Product links in transaction html emails Comment by The Wizard of Oz Sep 21, 2011 12:57AM
Cheers for the info Brett. I'll see what I can concoct using it!

in Product links in transaction html emails Comment by The Wizard of Oz Sep 19, 2011 9:18PM
AAHHH! This is causing problems. The script runs every time we edit and save a product. So we can't manually override these set parameters. Any idea how to not have this happen?

in Trigger script on csv import Comment by The Wizard of Oz Aug 7, 2011 9:45PM
Yeah it triggers if I make it do something else. Damn you NS and your pricing ways! I see your point on using variables, but I'm able to read them better as tags. I'm the only one that has to debug it around here. Thanks for your help.

in Trigger script on csv import Comment by The Wizard of Oz Aug 7, 2011 6:54PM
Thanks for your help by the way Voltron - most appreciated!

in Trigger script on csv import Comment by The Wizard of Oz Aug 4, 2011 8:50PM
OK I got that working... BUT... there's a second part to my script that isn't working. Don't tell me I can't access the pricing fields on an import - that would defeat this completely! nlapiSelectLineItem('price', '7'); nlapiSetCurrentLineItemMatrixValue('price', 'price', 1,…

in Trigger script on csv import Comment by The Wizard of Oz Aug 4, 2011 8:49PM
I can't really explain it any better than I have already. Thanks anyway. I'll just remove the script and continue in the NS way....

in Trigger script on csv import Comment by The Wizard of Oz Aug 8, 2011 6:33PM
Ah brilliant! Thanks for the tip.

in Trigger script on csv import Comment by The Wizard of Oz Jul 22, 2011 3:57AM
Your script might be a client-side script. Please be advised that CSV Imports can only trigger Server Side Script and Workflows. You may want to consider moving your script from Client Script to User Event script so that it will be triggered when you performed a CSV Import. If you have the same process in the UI using…

in Trigger script on csv import Comment by The Wizard of Oz Aug 3, 2011 5:23PM
Hmm... It doesn't seem to trigger the script still. What am I missing here?

in Trigger script on csv import Comment by The Wizard of Oz Jul 24, 2011 7:39PM
On a quick read of the help, this is only used to set the header fields, not the price points themselves... "This API is used to set a header field in a matrix sublist. This API is supported in client and user event scripts. It is typically used in pageInit (client) and beforeLoad (user event) events. Also note that this…

in Pricing script won't do it's thing Comment by The Wizard of Oz Jul 4, 2011 6:53PM
Thanks Voltron function update_price() { if ((nlapiGetFieldValue('cost')) < 12) { nlapiSetFieldValue('custitemsellpricegst', (((nlapiGetFieldValue('cost'))*1)+1)*1.1); } }

in Trigger script on csv import Comment by The Wizard of Oz Aug 3, 2011 6:31PM
Got it! Thanks again for the pointer Olivier!

in Pricing script won't do it's thing Comment by The Wizard of Oz Jul 5, 2011 8:42PM
Thanks Voltron. I'll give that a try today. I'm not great at deployments and all that. I don't really understand it but I'll follow your steps and see how I go.

in Trigger script on csv import Comment by The Wizard of Oz Aug 4, 2011 7:40PM
Thanks for the redirection... I've read it quite a few times and it's not making sense to me. Anyone from NS care to comment on why we can't set pricing using the DOM?

in Pricing script won't do it's thing Comment by The Wizard of Oz Jul 5, 2011 8:26PM
Under Home>Set Preferences there is an option to show internal id's. Then the id will show when viewing a list of records.

in Custom Country Field, ID not as expected Comment by The Wizard of Oz Jul 7, 2011 11:36PM
Thanks Olivier Typical bl00dy NS... take away something easy and replace it with something difficult...

in Pricing script won't do it's thing Comment by The Wizard of Oz Jul 4, 2011 6:50PM
Are you talking about on your website? Is there something in common with the people you wish to show stock levels too? Would you want this on all items or just specific ones?

in Customer Centers Comment by The Wizard of Oz May 31, 2011 10:00PM
You can emulate this by putting the tags in the item drilldown and category templates.

in How can I move the sidebar to the right side? Comment by The Wizard of Oz Apr 17, 2011 6:46PM
Kinda like I said...

in How to add fields to forms (not new fields, but existing fields) Comment by The Wizard of Oz Feb 24, 2011 4:55PM
I'm pretty sure entity fields have to be separate from transaction fields so you would have to create a custom transaction fields that pulls data from the entity field. I may be wrong though.

in How to add fields to forms (not new fields, but existing fields) Comment by The Wizard of Oz Feb 23, 2011 9:38PM
Sounds fairly simply. Have you read the help guide? Have you at least attempted to create this so you can tell us what you've tried and what isn't working?

in Need a report that shows items ordered by customers. Comment by The Wizard of Oz Feb 22, 2011 9:47PM
It's because you used the word "bifurcated" - us simpletons prefer divided.

in 2 Customer Centers (for the price of one) Comment by The Wizard of Oz Feb 23, 2011 5:24PM

More Comments

The Wizard of Oz Red Ribbon

Comments