We had a similar issue, where the tracking number links directly in NetSuite were not being generated correctly. We ended up creating a script that read the "Ship Via" and depending on the shipping courier, we would generate a direct link ourselves to their tracking site.

It is likely for inclusion in 2010.1. Thanks, -e Good stuff, thanks for the info Evan! I'll keep my fingers crossed.

A client just asked us to move items between subtabs of their transaction forms so I voted for the enhancement request. I can't seem to find the number mentioned earlier, so I voted on #86187: Add the move items between subtabs option to transaction forms. It's got a decent 75 votes so far.

Looks like the correct number for this enhancement is now 68919 "Add an ability to place a transaction body field in the body of a statement instead of as a column."

Yeah, sounds like you would need a custom scripted PDF solution in this case. A User Event script to add a button, a Client script to call a Suitelet, and a Suitelet to gather the data and generate the PDF.

Hi, Could you give a bit more detail on how your custom record is set up and how it counts "active" customers?

I think what you're asking for would be possible by using CASE statements. You could check the month of the date of the transaction and if it's not in the range you want for that column, return 0, otherwise return the amount. You could then add a summary filter to remove "0" values. The Count summary type is a unique…

One option is to set the Employee Restrictions on your sales rep Role. Here are the possible values: [LIST] [*]none - no default – there is no restriction on what can be selected and a default selection does not appear. All transactions and records are accessible. [*]none - default to self – there is no restriction on what…

Looks to me like the third example is missing some code.

Hi Nathan, I went through your code and nothing jumped out to me as the potential problem. If you're having issues with locations matching, I would recommend adding logging or debugging of all variables that represent a location, to make sure they're pulling the right info. Particularly on line 42, where you're comparing…

Hi Nathan, Looks like NetSuite simply doesn't update the sublist after the record object's been created, even in dynamic mode. Although it's not documented, this might work. Try passing the location as an initialization value: var binsheet = nlapiCreateRecord('binworksheet', {recordmode : 'dynamic', location : '2'}); and…

Great, I'm happy to hear it's working :)

Hi Corey, As you mentioned, there are many different ways of getting the same result you're looking for. It all depends on how much effort it takes to deploy and maintain the solution. I may have misunderstood your underlying need. I thought that you needed a Group. If your need is simply to give a script access to a…

As far as I know groups cannot be searched. You could always work around that by creating a Saved Search to select all your contacts, and create a Dynamic Group using that search instead of a Static group. You could then call your Saved Search in your script.

There is an issue open (#187589) for this behavior. Evan, if you can do anything to get the ball rolling on this one, it would be great.

Hi Patrick, It does indeed happen that you must split using char code 10. It all depends on the situation, i.e. where you're getting the serial numbers from and how they were initially entered. To be safe, we now check for multiple characters: String.fromCharCode(5), String.fromCharCode(10), ',', '\n', '\r', ''

Are you saying that if the record was created in Dynamic Mode a different User Event script could then call nlapiGetNewRecord() and it would return the record in dynamic mode? Yes, as long as the User Event is called in a chain of events that were initiated by a nlapiCopyRecord(), nlapiCreateRecord(), nlapiLoadRecord() or…

Hi Richard, As you mentioned, Serial Numbers are separated by a line feed (ASCII character 10) when retrieving them through a script. Try using this: serial = serialtxt.split(String.fromCharCode(10));

My understanding is that you can only "enable" dynamic mode when you're using either nlapiCopyRecord(), nlapiCreateRecord(), nlapiLoadRecord() or nlapiTransformRecord(). As long as you called the above functions with the dynamic mode parameter, Dynamic Mode will be enabled if you make changes to the record object that is…

Can we use the Javascript command, window.SetTimeout()? I doubt that would work, since Scheduled Scripts run server-side, outside the DOM context.

How about a User Event that flags the record and queues the scheduled script using nlapiScheduleScript()? Using two deployments and checking whether the first one is already processing, you can make sure the record will always be caught in the next run of the script.

Here's what worked for us in Javascript: nlapiSetRedirectURL('TASKLINK','LIST_SEARCHRESULTS','84',null,{'searchid':'84'}); 'searchid' definitely has to be in quotes, otherwise the javascript interpreter will think it's a variable and it will be null.

It's an object literal that is defining a property called searchid. It works fine for us without the quotes. I just tested in a standalone interpreter and both methods work fine. var a = { 'foo' : 'bar' }; alert(a.foo) a = { foo : 'bar' }; alert(a.foo) Ah, thanks that's good to know. I assumed that was the problem because…

Thank you very much for your help so far. I am stilling getting this error thou Something wrong with this line filters[0] = new nlobjSearchFilter('phone', null, 'startswith', 'A'); TypeError: Cannot set property "0.0" of undefined to "nlobjSearchFilter" (testemail2.js#16) This might not be related to your error, but how…

The following line would give you the value of your handling cost variable: nlapiLogExecution('debug', 'handling cost', hand);

Try this: function calculateShippingOnApprove(type) { //This will generate an execution log in the Execution Log tab of the script nlapiLogExecution('debug', 'calculateShippingOnApprove', 'Function Start'); var record = nlapiLoadRecord(nlapiGetRecordType(), nlapiGetRecordId()); var hand =…

Yes, that's definitely possible. You could create a User Event script, and on After Submit, compare the Ship Via on the Fulfillment to the one on the corresponding Sales Order, and if they're different, automatically edit the Ship Via on the Sales Order.

This is just a hunch, but nlapiSubmitField only allows submitting fields that are available in Direct List Editing, and I'm pretty sure the Password fields are not available in Direct List Editing. Try loading the record, setting the fields and submitting the record instead.

- In the Audience tab of the Script Deployment, did you check the "All Roles" checkbox? - Do you have more than 5 beforeSubmit scripts on Sales Orders? If those two things check out, I would suggest adding a log line in your script and then check the deployment Execution Log tab to see if the script is executed or not.…

It seems that if you load and submit a record, even if you do nothing to it, it will reset the Shipping Carrier to your default Shipping Carrier found under Setup > Accounting > Shipping. For example, I had a Sales Order with a Shipping Carrier of FedEx/More and a Ship Via of FedEx Ground. For any of the following code…