Tom Dalton · Owner · Silver Medal

Any formula with {parent.internalid} doesn't pull the parent internal ID. For example, we're using it in a custom field and it is used in matrix children to show their parent's internal ID. Is there a workaround? Trying to do this: NVL2({parent},{parent.internalid},{internalid}) ...so that in both children and the parent…

There is something very WRONG with NetSuite. This works... CASE WHEN {parent.imageurl} IS NOT NULL then 'child item' else 'not child item' end Assuming that all items have images It returns 'child item' on matrix child items. It returns 'not child item' on all other types of items. Also, if I make a custom field =…

So, are you saying that this formula works in you child items??... NVL2({parent}, {parent.storedisplayimage} , {storedisplayimage}) I use the above formula in my account and I get "ERROR: Field Not Found" in ALL child items. Ask support to look at the custom item filed named "Mondray" in our NS account. It identical to…

Tom - That definitely seems to defy logic. Perhaps you can report to support and get an issue (not case) #, and post it here - then I can take a look. Evan, We still really need a formula field that shows the URL of the item image. I challenge you to make one. The formula for making one is fairly simple, but for some…

Mondray, Skip the Item search screen shot. Show me the "default Value" field in a screen shot as it displays in each item type (Not just matrix-child). So, show it for matrix parent, matrix child and non-matrix. In our case we've tried that formula in your screen shot and about a dozen variations including using shadow…

Actually Mondray, I emailed support on this. The found that there was an issue. They created a S3 issue. I worded it different, but the concept was similar. I'll see if I can get the issue number.

Disregard.. found issue

This is from the case 1627762: This formula works on Matrix Child items. Custom Item Field = {parent.storedisplayimage} This formula works on Matrix Parent items and on NON-matrix items. Custom Item Field = {storedisplayimage} Yet this formula (that uses the two fields above) works on matrix parent and NON-matrix items,…

OK, using the following formula (in a custom transaction body field) works... CASE WHEN {trackingnumbers} like '1ZY%' THEN 'UPS' END What confuses me is that the field shows "ERROR: Field Not Found" when viewed in the item fulfillment record. The same filed shows "UPS" when used in an email template based on an item…

Never mind. {trackingnumbers} is fine and was not causing the problem. It is weird. Overnight I left the formula so that {custbodyshipcarrier_cstm} = {trackingnumbers}. This morning... On the fulfillment record, it still has "ERROR: Field Not Found", yet on a 4am automated email generated from a saved search; it had a…

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…

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?

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…