pbrilino Green Ribbon

Hi Nick, Thanks for the reply. Our bank also provides BAI2 and MT940 file formats, but not OFX. Do you know if there is any way to convert these formats, or would this be just as cumbersome as converting from CSV? -Patrick

Thanks Robert. Unfortunately, some of the preceding scripts are part of NetSuite's advanced EITF Rev Rec bundle (locked bundle) which means I can't even see the code to be able to put them in a library file and execute them. I guess I'll have to file a NetSuite support case.

I'm a little late in replying here, but addressid didn't work either, I get an invalid Search Criteria error. Any other suggestions?

I contacted NS Support, and they helped me get it working using a formula in the search filter. I wasn't even aware that this was possible, as it's not documented in the help, but here is my sample filter if anyone needs it: var filters = new Array(); filters[0] = new nlobjSearchFilter('formulatext', null, 'is', '1');…

Thanks Brett. I was hoping I wouldn't have to pull in all of the address results for a customer and compare the internal ID in the results, but it looks like this is the only way right now. -Patrick

Nevermind. I just tested this and it looks like the values in the sublist created from form.addSublist are available in the after submit event, even though they haven't been committed to the database. Cool! Patrick

Thanks Olivier, that worked. I had some trouble figuring this out, so maybe the steps I followed below will help someone out: 1. Create a JS file with your client functions. Mine looks like this: function ShowPopup(url) { var width = 600; var height = 650; var left = (screen.width - width)/2; var top = (screen.height -…

Would I need a client side deployment for this? I would rather have the button appear in a before load script, which is how this is currently deployed, so I can get the button in view mode. The funny thing is that when I use the code below and remove the windowProperties variable, the window opens correctly. ar…

I figured that was the case. I was hoping there was an easier way to do this without too much coding, but it looks like I'll have to write some extra code to pull the line item information and populate this into the body of the email. I'll have to figure out a way to incorporate a script parameter or email template so…

Hello, I'm not sure if NetSuite changed this in a recent release, but when splitting the serial numbers on a Sales Order, the following worked for me: arrSerialNos = stSerialNos.split(String.fromCharCode(5)); For some reason String.fromCharCode(10) didn't work. I hope someone finds this helpful. Thanks Patrick Brilino

Does JP Morgan have a solution that integrates with Netsuite? We use Netsuite's check issuance service but the problem is that it works with only one checking account. We need to issue checks from multiple accounts. Quite honestly, I'd love an interface with a bank that can take a payments file of ACH, wires and checks. As…

Thanks Richard. I can create a custom form, but I'm not aware of any way to restrict an employee so they can only enter PO's for certain departments. Can this be done with scripting perhaps? Sorry for the late reply here. Patrick

Thanks for the suggestion Daniel. Unfortunately, this didn't work, as I'm still getting the error. I would think that I should be able to run this search via web services, since I can run it through the UI. I have a case (# 1432856) filed for this as well - seems like a defect to me. Thanks for the help. Patrick

I have a solution for this - since our items are serialized, I was able to join to the inventory number table and pull the serial number for each quantity value on the invoice. This exploded out the line. This: Item Name | QTY | Price | Amount Item ABCD | 3 | $250 | $750 Turned into this: Item | Price | Serial Number Item…

Hi Yang, When I try nlapiGetFieldText, I get 'NJ' instead of 'New Jersey'. My custom state field has the text value of 'New Jersey', so I can't set it using this method. When I try nlapiGetFieldValue, I get 'NJ' also, instead of the internal ID of the state. I've also tried using nlobjSearchResult.GetValue and…

I figured this one out: I ended up using nlapiSearchRecord to do a search for the default shipping address and used the statedisplayname field to return the full state name. I was then able to use nlapiSetFieldText to set the custom state field with the full state name. Here's my address lookup function: function…

Yep, it is scheduled to run as admin. I resolved this by doing a Save As on the saved search and using that saved search in the script instead. I didn't make any changes to the saved search at all, so this seems to be some kind of bug. Very strange. Thanks for the help! Patrick

Hello, Thanks for the suggestion. It looks like this is for advanced HTML/PDF forms, not scriptable email templates. Would the same solution apply to scriptable email templates? The SuiteAnswers article I linked to above makes me think this is supported in scriptable email template without any custom SuiteScript. Is this…

Thanks for your very detailed suggestions, Kate. I'll try these and see what works for us.

Thanks Evan. I've filed case # 1233728 and Defect #189454 has been created.

Ok - I figured out how to use the return user error to give the user an alert (reading the documentation helps!), but I still can't find a way to trigger this alert when the transaction total changes. Patrick

Hi Evan, I tried the after field edit and after field sourcing, but it still didn't trigger. I'm not necessarily trying to prevent the amount from changing (although that could be useful), but I'd like to display a pop-up alert to the user when the amount changes. The use case for this is that when a user edits a PO that…