megaphone
Update your Profile with your Support type to get your Support Type badge.
Nominate Your Peers for NetSuite Support Community's Choice of the Quarter! Submit your nomination today.
Stay in the know of how NetSuite can help grow your business with our guides, webinars, and events. Subscribe Here
What Topic Should We Cover Next? Your idea could be our next feature—drop your suggestion now!
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. Discover what's next at SuiteConnect Tour 2026.
Try Intelligent Payment Automation – Fee Free For Your First Month For more information, visit this thread.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Expand your NetSuite knowledge by joining our Ask A Guru Live sessions. RSVP on this event now.
Don't miss out on our Question of the Week! You only have until tomorrow, April 2, 2026, 2:00PM ET to comment your answers.

My Stuff
Default Avatar
See All the Unlockable Badges See All the Unlockable Badges
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.

3949720 Newbie

Comments

  • If I get this right, simply add Preferred Vendor in the Available Filters list
    in Items submist in vendor record contains only items where vendor is preferred Comment by 3949720 Jul 7, 2011 9:28AM
  • I'm glad to hear it worked like you wanted. As for where to find those, you can't actually find them in any documentation... sorry. I found this one in the user group a while ago, thanks to Evan. Basically, ns_concat is a derivation of an Oracle function that NS implemented in the back end. Best regards,
    in Concat Multiple User Note Memos into a single Saved Search Column? Comment by 3949720 Mar 2, 2011 9:44AM
  • Hi, Try using in a formula (text) : ns_concat({usernotes.note}) and set that line Summary Type to Maximum. You should have all your memo on the same line separated by a coma Regards,
    in Concat Multiple User Note Memos into a single Saved Search Column? Comment by 3949720 Mar 1, 2011 4:56PM
  • Hi, Do you have the Divided by 0 Error? try changing your formula to something like if(nvl({preferredstocklevel,'0')=0)then 'A value' else ( nvl({quantityonhand},'0') + nvl({quantityonorder},'0') - nvl({quantitybackordered},'0') ) / ( {preferredstocklevel} ) endif I haven't tested it but basically the idea is to make sure…
    in SQL help Comment by 3949720 Jan 21, 2011 9:33AM
  • Hi Ravi, I'm not sure I understand the question properly. I guess you want to attach some information to an opportunity from an online form. How would that link be made? How do you know which opportunity you need to link the form to? Overall with the information you provided at the moment, I would think a custom record…
    in web form to be attached to opportunity after submit Comment by 3949720 Jul 8, 2013 11:23AM
  • Hi, you could try using DECODE or Case When in your search : decode({custitem_weekavailable},0,'Now',to_date({custitem_weekavailable}*7-6,'DDD')) Case [INDENT]when {custitem_weekavailable}= 0 then 'Now'[/INDENT] [INDENT]else to_date({custitem_weekavailable}*7-6,'DDD')[/INDENT] end I haven't tested those two but this should…
    in Could Someone Please Tell Me What Is Wrong With This Formula?? Comment by 3949720 Aug 23, 2010 9:26AM
  • Hi, When creating your pdf document using BFO, all you have to do is to use a <img src="your custom image field value" /> to display the image on the pdf. Regards,
    in Custom Images on a PDF for a custom form Comment by 3949720 Sep 2, 2010 9:33AM
  • Actually the difference is something else. Assembly items are a grouping of different items that you assemble to create a new item. To make it simple, the Matrix Item is an item that is typically the same but with some difference like color which you sell for a different price. So in your example, the red jumper would be…
    in Customer Kits? Comment by 3949720 Dec 14, 2011 11:41AM
  • Hi Paul, Yes it is something that can be done and there is different way to get there. If I get this right, all items are independent and are not Matrix Items or Item Options but simple inventory items or assembly items. Assuming this is true you could do something like this. On the client side, you would create your…
    in Customer Kits? Comment by 3949720 Dec 14, 2011 11:06AM
  • Hi Felipe, Like Bonnie said, scriptable cart might be a good option if you want to process things on the sales order directly. If for any reason, you want to display information that is not related to the sales order then you might have to use the DOM and/or Ajax to get your item informations. i.e. You want to pop an alert…
    in Get Items field values on shopping cart page Comment by 3949720 Dec 16, 2011 9:22AM
  • As far as I know it is not feasible... NS did announce that they would offer this feature in the future but I do not have a date... Sorry.
    in One Page Checkout Comment by 3949720 Dec 29, 2011 10:17AM
  • You can't change NLPORTLETCONTENTS. You might want to create your own portlet.
    in Anyone have idea of how to put title="" into the a href within <NLPORTLETCONTENTS> Comment by 3949720 Dec 15, 2011 11:14AM
  • Using a suitelet and an Ajax call would do the trick. Simply create a suitelet to which you send the internal id of your item. In the suitelet do a search to get his child item. From the web page, call the suitelet to receive the information Finally use the information you received to construct your multi add to cart call.…
    in Possible to return an array of child items? Comment by 3949720 Dec 27, 2011 9:22AM
  • If you are not using an HTML template there is no easy way of doing this. If you are using an HTML template then simply use CSS to move it to the center If you don't want to use an HTML Template, you can always use javascript to add style to your for to move it to the center using DOM manipulation. I would not use that…
    in Online Form - Center the Form Comment by 3949720 Dec 20, 2011 9:07AM
  • What do you mean by modifying the shopping cart?
    in Checkbox at checkout that adds to the total Comment by 3949720 Nov 22, 2011 9:15AM
  • To enter "<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">", simply go to "Set Up Web Site" Under the Advanced Tab, you can put a Document Type in the Document Type box. Place your DOCTYPE there As for the html, I don,t know any way to do this yet but…
    in Put <html xmlns="http://www.w3.org/1999/xhtml">on page Comment by 3949720 Oct 28, 2011 9:30AM
  • As far as I know, you can't actually raise the total from the checkout other than by adding an item. One way to do this would be to add an item using the following url : /app/site/backend/additemtocart.nl?buyid=[internal id of the item]&qty=1&showcart=F I haven't tested it and you may have to change the url a little.…
    in Checkbox at checkout that adds to the total Comment by 3949720 Nov 17, 2011 10:38AM
  • So far the way I've customize all these NS tags is by hiding them using css and creating my own in order "portlet" which use the logic of the ones generated by NS. I think it gives me more flexibility even if it makes the page a little heavier.
    in How do you customise the "Currency Selector" Comment by 3949720 Nov 17, 2011 10:51AM
  • You are right... it is too bad IE doesn't allow to do this. But if we can't inject attribute in the html tag then you will need to discuss with NS directly... Another thing you might want to look into is adding some attribute in the dtd. I could make it work this morning but maybe you might have more luck than me. Here is…
    in Facebook Social Plugins / Open Graph Protocol Comment by 3949720 Sep 22, 2011 9:34AM
  • Hi Bill, I'm not (yet) familiar with the whole process of the Facebook "like" and "send" button but I know how you could add the attribute you need in the html tag. By using jquery, you could run the following script in the head tag. $('html').attr('xmlns:og','http://ogp.me/ns#')…
    in Facebook Social Plugins / Open Graph Protocol Comment by 3949720 Sep 21, 2011 4:55PM
  • Create two templates for your categories and your item drilldown. They will basically be the same but change the css for your colouring. Apply the right template to the polo category and to the t-shirt categories as well as on all your item and you should have your different color. Regards,
    in color for items Comment by 3949720 Oct 31, 2011 9:19AM
  • Hi, If you do not need to sort your search in a particular way, you could use ROWNUM to determine the row number and add an Highlighting filter formula(numeric) that would look like this : MOD(ROWNUM,2) is 1 The only problem with this is that the search need to be sorted by ROWNUM and doesn't reflect any particular logic…
    in Published Search Highlighting Comment by 3949720 Jan 25, 2011 9:27AM
  • Hi, if I get this right you do not need to use <NLITEMLIST> twice. In order to have a two columns layout you need to set it up in the Item /Category Layout you are using. There is an option there (Number of Columns) that will let you choose how many columns you need to display. Best regards,
    in Layout/Item Template Question Comment by 3949720 Apr 19, 2011 9:21AM
  • Hi, depending on the layout you are looking for and on the purpose you want to achieve, there are different solution. If you simply want to list the item, you could use a publish saved search and display it on the webstore. If you want it to be a little more like related items behavior and design, you will need to put more…
    in Automated Display Comment by 3949720 Dec 13, 2010 2:56PM
  • As I mentioned I never had the chance to test it. So indeed I do not have a code sample but I usually use this to create my custom buttons. https://netsuite.custhelp.com/app/answers/detail/a_id/11410/kw/additemtocart.nl Let me know if the javascript approach worked. Happy Holidays,
    in Add to Cart <form> Tags Break My Page Comment by 3949720 Dec 21, 2011 9:15AM
  • Hi Toby, You might want to try this in javascript and send all your parameters though a window.location that uses the same parameters and the same action you have on your form. I haven't tested this but it is definitely something I would try :) Best of luck,
    in Add to Cart <form> Tags Break My Page Comment by 3949720 Dec 16, 2011 9:29AM
  • If you legally have access to the file, you should simply attach it to your script on the Script Record itself. Best regards,
    in Library files Comment by 3949720 Mar 24, 2014 9:51AM
  • There is no easy way to do this even with customization. You could put in place a script that changes dynamically the form used based on the currency but this could be annoying due to a page refresh. Otherwise, the is the solution where you set a script in before load which would hide the columns based on the customer (and…
    in Dynamically hide a transaction column Comment by 3949720 Jul 8, 2013 11:13AM
  • USER_ERROR usually occurs when you submit the record not during the transformation. Basically what the error is telling us is that their are some serial numbers that are missing. You might want to make sure you set all your serial numbers in your Inventory details in the newly created item fulfillment record. I hope this…
    in Error in TransformRecord Comment by 3949720 Feb 7, 2013 10:05AM
  • Hi, the filters always ADD TO the current filters. We usually try to create a saved search specially for scripts to avoid that problem. Best regards,
    in Script Filters vs Saved Search Filters Comment by 3949720 Aug 11, 2011 1:38PM