プロフィール
Avatar
ロック解除可能なバッジを表示 ロック解除可能なバッジを表示
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!

Tom Dalton · Owner · Silver Medal

コメント

  • I've got a custom field with the ID of {custbodyshipcarrier_cstm} The field applies to the fulfillment record. I want {custbodyshipcarrier_cstm} to hold the shipping carrier NAME based on the tracking number. The first three letters of the tracking number can be used to determine the shipper. For instance, our UPS…
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント Oct 27, 2011 4:09PM
  • I think the problem is in the field {trackingnumbers}. I reduced my custom field's formula to {trackingnumbers} and it still returns "ERROR: Field Not Found". My custom field, {custbodyshipcarrier_cstm}, is a custom body field. Is {trackingnumbers} a body field or a column field?
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント Oct 27, 2011 4:56PM
  • JMU, You're right. I posted in the wrong thread. My mistake ...I forgot to look at what thread I was in before posting. Is the NetSuite training you're referring to something that I travel to? I don't have time for travel & I'm not really a fan of traveling. I'm hoping that it is recorded training program (like lynda.com…
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント May 25, 2011 8:57PM
  • I found this earlier in this thread... I just realized it only gives the character limit warning when I click the "Set Formula" icon next to the field and paste into the pop up formula field. When I past directly into the field instead of the popup, I looks like it will work. How would I know that without reading this 28…
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント Feb 10, 2011 9:05PM
  • Now I've run into the "Formula too long" limitation. Is there any choice other than to break the formula up into two or three custom fields and then re-combine? -Tom
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント Feb 10, 2011 5:52PM
  • Kelly, thanks for the tip! I think it can work if I can get it to stop saying "invalid expression". I was wondering if NetSuite maybe had an unpublished field that already combines this information for each child item. I believe there is a possibility because many areas in NS already display the matrix choices in a column…
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント Feb 7, 2011 5:05PM
  • I need a workflow to set a custom field called "Packed By" to mandatory immediately after the fulfillment record is changed from picked to packed (before the save button is clicked). Any tips would be appreciated. -Tom PS: I read in the NS help that Workflows can be bundled and distributed for easy installation. NetSuite,…
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント May 23, 2011 5:47PM
  • We have about 100 different custom matrix options fields. So, I'm guessing that we'd have to list every one to make a formula that worked with every item. Since only a few are used on any given item, then we'd have and 100 commas in our results. Tom
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント Feb 5, 2011 3:06AM
  • use formula(text) and try to_char({today},'MONTH') , replace today with whatever field you have(in date format). that would give you JANUARY, FEBRUARY, etc... Thanks Mondray. I'm still not sure I can do what I was going to do. I needed the dynamic month field in our web store. EG: "Sale for the month of XXX" displayed in…
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント Dec 15, 2010 3:52PM
  • Thank you. I ended up exporting and doing some "find and replace" tweaks in excel and then importing. Does ANYONE have a formula to STRIP HTML from a field? I need a custom item field that = item detailed description WITHOUT any of the <b> or <p> or <br> type of commands. Thanks, Tom
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント Feb 15, 2011 6:41PM
  • I found this code to strip HTML from a text field (like the NetSuite {storedetaileddescription} field).... REGEXP_REPLACE({storedetaileddescription},'<[^<>]*>','') This is handy when creating a custom field that you can export to the various product data feeds. -Tom
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント Feb 15, 2011 6:52PM
  • (CASE WHEN {custitem_xxxxx} IS NOT NULL then 'ITEM OPTION:' else NULL end) || + (CASE WHEN {custitem1} IS NOT NULL then ', Color='||{custitem1} else NULL end) || + (CASE WHEN {custitem2} IS NOT NULL then ', Size='||{custitem2} else NULL end) || + (CASE WHEN {custitem3} IS NOT NULL then ', Shape='||{custitem3} else NULL…
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント Feb 12, 2011 1:05PM
  • Yes, I was just planning on doing a mass-update using a formula. I was mainly unsure of the variable names. Are those accurate? Would it be {var1} {var1_value} etc... Do they list them somewhere in NetSuite? Thanks, Tom
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント Feb 4, 2011 5:24PM
  • Does someone have an easy way to make a combined name for child items? So, lets say the variable I'm trying to populate is "complete_child_name". I want complete_child_name = "parent item web display name" + first variant name + first variant value + second variant + second variant value. I want it to work for all child…
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント Feb 4, 2011 3:52PM
  • Thank you Kelly, I got this to work...... {parent} || ',' || + (CASE WHEN {custitem1} IS NOT NULL then ' Color='||{custitem1} else NULL end) || + (CASE WHEN {custitem2} IS NOT NULL then ' Size='||{custitem2} else NULL end) || + (CASE WHEN {custitem3} IS NOT NULL then ' Shape='||{custitem3} else NULL end) || + (CASE WHEN…
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント Feb 9, 2011 12:25AM
  • Is there an easy formula that returns the current month (spelled out)? T
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント Dec 14, 2010 2:14PM
  • Oliver, I couldn't figure it out. It was way too complicated for me. I did find and vote for this enhancement: Enhancement #20052 - Display sum cost of member items in Kit/Package item record I'm surprised that the NetSuite developers made a button to get the sum of the weight of the kit members, but forgot to do the same…
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント Dec 14, 2009 5:51PM
  • We don't have sub-kits, but we do have multiple quantities of some members. We have a structure like this: Kit: - Member 1 in a quantity of 2 - Member 2 in a quantity of 2 - Member 3 in a quantity of 1 -T
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント Dec 14, 2009 1:30PM
  • I've been wondering if it would be possible to make a formula field that displays only in kits. It would display the combined cost of all members of the kit. In other words, it would calculate the wholesale cost of the entire kit. T
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント Dec 12, 2009 4:09PM
  • Farrago, I finally got around to making a blog post detailing what I described to you earlier. Let me know if you can get it to work now. Here's a link __________________ Olivier Gagnon IT-Ration Consulting Inc. THANK YOU!! It worked great. NS should make that customization a default setting. I'll definitely keep your…
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント Jan 7, 2010 4:06PM
  • We have also wanted the fulfillment number bar-coded on the pick-tickets (assuming that our pick-tickets are generated AFTER the fulfillment record). We generate a fulfillment and then print our pick-ticket (with a default status of picked). Then the warehouse person takes the pick-ticket and actually picks and packs it…
    で Display Barcode Field on Order Form Tom Daltonによるコメント Dec 21, 2007 5:39PM
  • When customizing the PDF form, you will adding "ship id" to get the fulfillment number on the Packing Slip. I don't believe that it is in the pull-down list. You have to add it manually. These are all identifiers for the Item Fulfillment Transaction Number... 1. When you go to an "Item fulfillment form", it is called "Ref.…
    で Display Barcode Field on Order Form Tom Daltonによるコメント May 29, 2008 5:03PM
  • Lists > Website > Category > Search Then add a formula text field sourcing from.... {storeDisplayThumbnailHtml-URL} ....Didn't work. {storedisplaythumbnailhtml} ....Didn't work. {categorythumbnailhtml} ....Didn't work. {storedisplayimagehtml} ....Didn't work. {storedisplayimage} ....Didn't work. {storedisplaythumbnail}…
    で How can we make a category feed? Tom Daltonによるコメント Mar 14, 2017 1:49PM
  • once you do it you can only update the prices is the QTY matches what's already there. Oh. That is the issue then. So, when we did the "25 Price", we locked in the pricing at two price levels as far as imports go. Is that right? My solution was that we just don't offer the 50pc discount that we were going to offer. So, the…
    で CSV importing quantity prices gives an ERROR on one price level Tom Daltonによるコメント Jan 8, 2014 1:14PM
  • Does m2e = http://m2epro.com It says Ebay integration = free It doesn't mention NetSuite.
    で eBay, Amazon, Magento - NetSuite Integration Tom Daltonによるコメント Feb 6, 2013 11:25AM
  • Bump... Has anyone tried Webbee... http://www.webbeeglobal.com/
    で eBay, Amazon, Magento - NetSuite Integration Tom Daltonによるコメント Nov 9, 2016 10:37AM
  • Found the answer. There is a field called "category" and one called "category (preferred)". They do the OPPOSITE of what I would expect them to do. In our case... category (preferred) field = output where every item has category data category field = output with data for only those items where a category has been marked as…
    で Bulk set preferred category? Tom Daltonによるコメント Feb 6, 2013 7:02PM
  • We used FarApp for many years without problems. We had no FarApp issues until we had a bad one 3 months ago and service was less than satisfactory. We switched to Celigo about 3 months ago. I'm about to go back to FarApp because so far Celigo has been less than competent. We're loosing Amazon sales every day due to a…
    で eBay, Amazon, Magento - NetSuite Integration Tom Daltonによるコメント Apr 12, 2017 11:47AM
  • Has anyone tried Webbee... http://www.webbeeglobal.com/
    で eBay, Amazon, Magento - NetSuite Integration Tom Daltonによるコメント Nov 17, 2014 7:41PM
  • We use FarApp for Amazon and it works pretty good. -Tom PS: FarApp does eBay, Amazon and Magento See THIS PAGE
    で eBay, Amazon, Magento - NetSuite Integration Tom Daltonによるコメント Jan 31, 2013 6:34PM