The Wizard of Oz Red Ribbon

I find that a little odd. I have looked at other NS webstores and loads of them have a left sidebar and a right sidebar. Anyone else?

Thanks everyone for all you help (or lack thereof) No need to add anything else as I've worked it out myself.

Ever so sorry...

UPDATE! It DOES display the right sidebar I created but it ONLY shows it in the "My Account" tab. Nowhere else. Now I know you people out there have these things... Let me in on your secret! Tell me thy password lest revenge be mine!!! Please. Wiz

I am happy to write my own customisation, but it just strikes me as odd that it won't let you display left and right... pointless!

Thanks Bill I have already figured it out. www.wineboxwarehouse.com.au Amazing that in the configs NS offers an area for rightside columns that don't actually do anything... Mat

At the risk of incurring your wrath, I think you'd get a lot more mileage out of this post in the Customization or Dashboard forums. This Web Services area is more about programmatic access to NetSuite via their Web Services interface (WSDL, SOAP, Java, .NET topics). Cheers, Derek. Thank you ever so much Derek... If anyone…

Go into the image file by clicking "edit" Magically, the file path will appear! Make sure that image is "available without login" Wiz

Does item fields : description not work?

Nope. We got Netsuited.

scheduled update?

I got around this using a custom field "internal id for reports" and grabbed the value from the actual internal id. Just in case you want it now.

Yeah, put another CASE WHEN inside your original one. Try something like CASE WHEN {custrecord_tran_customer.custrecord_tran_date} != ‘within last month’ THEN ({custrecord_tran_customer.custrecord_tran_est_gp} * 0) ELSE CASE WHEN {custrecord_tran_customer.custrecord_tran_type} = 'Credit Memo' THEN…

My searches no longer trigger an automated email on field update. Fantastic!

Wiz, you have my empathy...... That's not enough! Nah, ta...

I didn't know you could use AND in a CASE statement. Maybe that's the problem? Or maybe I just learned something. Try something like this: CASE WHEN ({debitamount} IS NOT NULL) THEN (CASE WHEN ({account.custrecord_house_account} = 'T') THEN '0.00' ELSE to_char({debitamount},'9999999.99') END) END That may not quite be…

You could edit the search and have the filter parameters as a results column too couldn't you? The sales rep definitely you could.

I write all my own SQL - it's not that hard. About an hour of googling and I worked out most of what I need to write it. I'd be interested to hear if there are any good tools out there though.

Are the ones with the mumbo-jumbo names in a different part of the file cabinet from the normal named ones?

OK here is one that Netsuite support cannot figure out so I am opening it up to the Netsuite community, hopefully someone can help? I usually do this the other way around...

Yep. On the email tab of the saved search go to the Recipients from Results subtab. Pick the Vendor:Email Address field (or Supplier:Email Address, depending on what terminology you use). This will send only the item records that belong to the vendor when you schedule this to automatically email.

I guess if it just showed as text in list view you could add <a href... etc and that may do the trick. Would be interested to hear!

Could you make a custom field that gets the internal id of the sales order and appends it to this "https://system.netsuite.com/app/accounting/transactions/salesord.nl?id=" ?

You can create a custom field that pulls the values of the multi-select field (do not store value) and use that as a filter in a search. Just did it :)

Make the type free form text. Source from the multi-select field.

Posthumous answer.

Not sure about pc, but on mac I just emailed my self a report as an html attachment, right clicked on it and opened in excel no problems.

You can specify a template for search results. Just use the tag for that price level in your search template.

Setup>Website>Setup Website Go to the Search tab. In the Global Search portlet you can specify the templates to use for search results.

Ahh.. .got it. Thanks. {customermain.email} should be {customer.email}