Can't you just change the tax rate percentage and then it will recalculate the tax at that new % rate.

Hey Steve. The link gives error.

Evan, what is confusing here, is that the sourcing & filtering is running a brand new sql select on the entire contact table, instead of running the sql select on just the much smaller subset of contacts linked to that customer. If it behaved as the latter, then the field could dynamically adjust according to the max # of…

This is what we use on a Transaction that works: Type: List/Record List/Record: Contact Source List: Entity Source Filter By: Parent However the "source: Entity" on a transaction is the transaction's parent, which is the customer record. So on a customer record itself I'm not sure that will work. Maybe someone else on this…

Thanks for the clarification Evan. So this isn't really a bug, it is a necessary design since you can't change the field on-the-fly (well, you could, but that would be some intense Javascript!)

We do this exact thing on our Sales Order so the sales rep can choose the Contact, and the Contact's info is displayed on the SO. We use Sourcing and Filtering. There is a UI bug, however, and it does not provide a drop-down, instead you get a type-in field like you've exceeded your max number of items allowed in a…

Why don't you just flag the one contact as "Primary Contact" and then you can pick the primary contact with script. Only 1 contact can be the primary contact. Only 1 contact can be the secondary contact. Those two are special hard-coded types.

Customer service tested the defect and found that it only occurs if you have your max set to > (greater than) 20

Thanks for the wildcard tip, Miguel. That is a great tidbit timesaver until they get the UI bug fixed. (Miguel, are you experiencing the UI bug, too?--I have a ticket open maybe you can ask to be added to it: Case #951383 Update : Custom Body field sourcing from Contact not respecting 'Maximum list in Drop Down' preference)

Jamie, if you edit a record. At the top of the screen in the URL, you will see "e=T" in the URL string, which flags NS to put it into edit mode. There is a trick to change that to "xml=T" and that will show you the XML which is all the field names you need for Javascripting!

Isn't the Residental Address? checkbox also on the address record in the address book? Script the address book instead when you create/save the address, then that address record will copy over to the Sales Order as the default shipping address.

There is an nlapi function to read the parameters from a GET string on the URL. Search this user group. I just saw it in the past 2 weeks. The post was something about passing information to the suitelet or portlet. Here it is. Scroll to post #2 from yang: https://usergroup.netsuite.com/users/showthread.php?t=19802

I would like to know this, too, hopefully someone from NS will give us a trick. Maybe the other thing you could do, is use the OnLoad event and just disable "Save As" so it's not even available to accidentally click it.

Or you can do it via the DOM. But direct DOM access is not sanctioned by NS so it is subject to breakage at anytime. (Do it at your own risk).

yang, can flav remove the 'save as' button through the DOM? Or is there a sanctioned way to do it via nlapi ?

Matt, to amplify on Evan's question. There is an option you can set to "Allow Line-Level Class" (and Department too). This is different than turning-on class in general. Normally, if you enable classes in general in NS, you set the Class once in the header and then NS copies that class down to all the lines automatically.…

Here is another I post I added with code to mass update Department, along with some tips and gotcha's to watch out for. I updated about 5000 txns without limit. https://usergroup.netsuite.com/users/showthread.php?t=14841

Hi Evan. I tried this new ns_concat() function at it works pretty neet!! Thank you. I did notice, however, that the elements are not sorted/ordered, even if the underlying rows had a sort criteria set. Also the delimiter appears to be hard-coded as a comma. What happens for string values that contain commas in the strings?…

Here is VBA code for MSAccess for a user-defined function which will return a pipe delimited string of values. Reference: http://www.tek-tips.com/faqs.cfm?fid=4233 How to concatenate multiple child records into a single value faq701-4233 Posted: 28 Sep 03 (Edited 7 Aug 07) To use any function like this, open a new module.…

Hey Oliver, a related question. I need to change the Subsidiary on a ton of Item records. When doing the Saved Search-Item to get the data out so I can modify it for reimport back in, is there a way to have NS give me the multiselect list of Subsidiaries in a single field with a delimiter, instead of returning a separate…

Evan, do you have any cool Oracle SQL formulae to get this output?

Awesome. Thank Evan for getting this added so quickly. We really appreciate a request from the top!!!

Thanks Evan. Do you have an enhancement ticket # that I could attach myself to so I can be notified when/if a solution is implemented?

Evan, here is a link for several Oracle-specific solutions to this problem! http://www.oracle-base.com/articles/10g/StringAggregationTechniques.php Would you look these over and tell me if any will work? Hopefully the built-in function WM_CONCAT is present in our instance as that is the easiest solution! (If not, then this…

Evan, you are a genius. I did get this to work!! You left-out 1 thing, which is you have to pick a summary command for the item...I chose Maximum...doesn't really matter which one, just has to be a summary function so it's included with the Group. I did some research on the web, and I found a best-practice of using…

I think you can now hide by country in 2009.2

Thanks Shawn. We actually needed to extract the DDA# and Routing# that was stored in NetSuite so we could do some external processing.

Nope. EFT fields are not exposed anywhere in NS. We asked for an enhancement like 3-4 years ago. Still nothing. So don't hold your breath!!!

Ed, what you are trying to do violates all the PCI rules regarding credit card security. NS is already PCI-compliant with their integrated CC processing, and they already support CyberSource. So you really should try to use NS's existing CyberSource integration instead of trying to re-invent the wheel. The fact that clear…

Hi Ed. V/MC allow the authorization amount to vary by up to 10% from the final settlement amount to allow for freight cost. As long as settlement amount is within 90%-110% of authorization amount, the transaction will not downgrade. This buffer is usually enough to cover the shipping. Your method of doing 2 auths…