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…

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…

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

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…

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,…

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

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…

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

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

(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…

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

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…

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…

Is there an easy formula that returns the current month (spelled out)? T

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…

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

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

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…

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…

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.…

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}…

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…

Does m2e = http://m2epro.com It says Ebay integration = free It doesn't mention NetSuite.

Bump... Has anyone tried Webbee... http://www.webbeeglobal.com/

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…

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…

Has anyone tried Webbee... http://www.webbeeglobal.com/

We use FarApp for Amazon and it works pretty good. -Tom PS: FarApp does eBay, Amazon and Magento See THIS PAGE

Importing CSV Category list to add thumbnails. I set key as "Category Internal ID = Category Internal ID" Then, I've tried... thumbnail = URL to NetSuite hosted image. Result = Invalid storedisplaythumbnail reference key I've tried... thumbnail = external URL to thumbnail image hosted elsewhere Result = Invalid…

Never mind. I figured it out. I discovered this pitfall back in 2011 and posted the answer in this User's group and someone else just brought that answer to my attention. Apparently you still can't import image that are hosted elsewhere and you ALSO can't import images that are hosted in NetSuite's "Live Hosting Files"…