Hmm, well, how do you tie a User Event script record to a suitelet? You cannot deploy a User Event record to a suitelet, as it doesn't appear in the list of record types. You cannot specifiy a User Event script on the Suitelet Record. You cannot specify a User Event record when doing nlobjForm.setScript()... So how do tie…

I don't see why you would ever be forced to enter online price. Did you make it mandatory? I'm not even sure if it's possible to make Online Price mandatory... In any case, if that is the problem, going with nlapiSubmitRecord(SalesOrder,true,true) should have solved the problem, since ignoremandatoryfields is true in…

Yang, any idea?

Yang, 1- This code is failing on POs, Bills, Time Entry, Expense Report, Credit Memos and Checks. It runs on item, timeitem and expense sublists (all the same behaviour). It tries to set values in the "customer" field. 2- nlapiSetCurrentLineItemValue() results in an endless loop no matter what. The value DOES correctly…

That might be difficult because of the many-to-many relationship between Contacts and Customers. I'm not sure you'd be able to source info from the customer down to that contact in order to compare because, due to the data model, Netsuite wouldn't know who to source down from. But before continuing down this road, would…

Hi, we are NS Partners and can help you with all of the above. I have sent you an email.

Account is 2008.1 First problem code function onPostSourcing(type, name) { try{ if(type!=null && name=='customer') { if(!validateJob(type)){ //clear the customer field, since the customer is not a job var li = nlapiGetCurrentLineItemIndex(type); <strong>nlapiSetLineItemValue(type, 'customer', li, '', false, true);</strong>…

Hi, Tooting my own horn here, but we are NS Partners with Suitescript/Customization expertise. We also do that other stuff you mentioned (implementation, etc) but we do extensive scripting. Please drop me a line or give me call if you'd like to interview me more in depth. I can tell you what I know about NS Professional…

I recently wanted to access Tax Schedules as well, and found no way to do so. If anyone knows of a way, I'd be interested too...

Ok, so here's what it looks like is happening. If in a User Event script you define functions in the style of - String.prototype.removeLast=function(suffix) { ... } And then of course use those functions in your code, when a Scheduled Script comes by and triggers your USer Event script (probably by calling…

The Packing Slip is not like, say, a Sales Order or Invoice printout. On either of these two examples, the layout of the printout is set at the Custom Form level - meaning, if you change the custom form, you can change the look of the printout. The Packing Slip works differently - you set ONE to be the accoutn default, and…

Unfortunatly not - a quick test seemed to indicate Image fields on PDF layouts do not actually work.

1. Freeze the Bill To and Ship To addresses so that the customer cannot change them 2. From the Shipping Method, remove all options (e.g., Fed Ex, UPS, etc.) except for the option "Delivery". 3. from the Payment Method, remove the Credit Card option leaving only the "Invoice" option. 1. Can't be done 2. Go into your…

What do you want to get, the current date? If so, use the javascript Date object. There is no "system table" to work with in Netsuite.

Well, I can't refer myself, but if you contact me by email or phone I can direct you towards some of our many satisfied customers. :)

Sort by date. This can be the date of creation or the transaction date, whatever makes more sense for you. If you want *only* the latest, GROUP by Customer and make a MAX of Date.

Edit: Sorry, misread

I don't believe this is possible, but I haven't really tried. I suggest opening drilldowns as new tabs or new windows to circumvent the whole issue.

We have a customer that sells VoIP, if that helps. They use Merge Template & Email functionality a lot to get their various contracts out. We have added and continue to add custom functionality to keep tayloring Netsuite to their needs. The first thing we did, which was most critical for them, was to modify/reinforce their…

Hi Dustin, Take it from me, you're better off not thinking of Netsuite in terms of "Tables" in a SQL , you'll get headaches. Better to think of records as objects. "Entity" is a non-instanciable super class. You cannot make an "entity", but the other records you mention are "entities". Customers are the basic record used…

Are you talking specifically about nlapiSendEmail? If so, you can write whatever you like as the body. Use a function to get field values with nlapiGetFieldValue() and such.

You can set entity default statuses under Setup->Sales->Sales Preferences

Hi, We at IT-Ration are Netsuite Partners and we're up for anything. Drop me a line and we can discuss your needs in greater detail. Cheers

You'll need to use nlapiSearcRecord, searching for all the custom records belonging to the item. As column value put the field with the fabric quantity, and then iterate through your resultset to total all fabric, and write it in the custom field on the item. You have a couple of choices as far as triggers go. You could…

Hi, We offer customized training courses, and can handle the areas you have mentioned. We are located in Montreal, but most of our training has been performed via the Web for non local customers. I will email you with further information including our rates.

If it's purely for exporting, you don't necessarely need to store it on the record. You could simply export the last invoice date in the saved search, and then in Excel quickly add that logic. It might even be possible to code the logic in the saved search... Basically, the problem with storing it on the record is that the…

Depends what you mean by Dashboard... if you mean just looking at the Customer record, then yes, that is extremely easy. If you mean when you actually press the yellow View Dashboard button on a customer record, then that would be much trickier.

Qty Available is 'On Hand' minus 'Committed'. So you can't have anything Available without is first being On Hand. It's true that as a broker, your best bet is to use Drop Ship items. But then, as you have deduced, you have no Quantity tracker. Maybe you can build your own quantity tracker? Thinking out loud here, you…

Hi, You should probably start out by reading the Developper's Guide. This guide can be found by going into the Help and then clicking on User Guides. The guide is called "SuiteScript Developer Guide". What you are asking for can indeed be done, but you will need a solid understanding of scripting to accomplish it.

Nevermind, I tested it out and have my answer.