3950432

I know that you can run a CSV update on the customer/lead records and set the Global Subscription Status to Soft Opt-Out. So you could probably export a list of your customers, match the email addresses in your exported data to the internal id in netsuite using a vlookup, and then reimport. Just use the Internal ID of the…

The only thing I would add is that you should probably turn on the option to see all internal IDs in NetSuite. Then when you export your customer list you can see their actual record IDs to reimport by. Reduces the chances of error. What I would do is export your two lists (mailchimp and netsuite). Load them into different…

That's fine, since we haven't used the items in the PO system yet. The problem is that even after I set the new expense account and make a brand new purchase or bill, it's still using the wrong (old) account.

Ok so the basic setup here:[LIST=1] [*]Firefox setup with the iMacros addon [*]You have a CSV with the item SKU and the quantity to transfer. My CSV file had only those two columns and in that order.[/LIST] Put your CSV file into My DocumentsiMacrosDatasources. I named my CSV invxfer.csv (you'll see that filename in the…

Not possible. I wound up creating a recorded macro to transfer inventory based upon data in a CSV. I can share details if you'd like.

Transactions - Management - Print Checks and Forms - Item Labels That screen lets you pick different forms to use when generating labels.

I never got it automated until this moment - Something must have changed to let me script the location box successfully on a Page Init function. I wrote a tiny code for that page: function pageInit() { nlapiSetFieldValue('location',1); } The number you put in there (1) is your location's internal id. Following the…

Update: Thought I had fixed the location box. Not yet...

I wrote a post about automating the inventory worksheet process, if it will provide any value.

Search around these forums for info about physical counts. You'll soon find that there are no ways to import a physical count and very few ways to get your information back in manually.

We've got 17000+ active SKUs. Is there seriously no way what so ever to import updated inventory counts? We've got the counts stored in an Access DB and it could easily be transformed into whatever source this required.

I believe the Owner drop down appears only after the saved search has been created and you have returned to edit the criteria. I don't think it lets you set the owner while you are building it because there is a chance for an error where you define someone else as the owner and you with no rights to it when you are…

One other question - on our invoices sometimes our sales reps will modify the description field for a special note, etc about the item they are selling. Is there a way in this search I can pull that individualized description in? All the fields I'm trying take it from the item record, not the transaction itself.

Those are the filters I needed. Thanks for your quick help!

It's a transaction search that I built by going to Reports - Saved Searches - New. The filters I have are Main Line = False and Type = Invoice. The result columns have Date, Number, Name, Line ID, Item, Quantity, Amount, Price Level, Item : Class, and a custom field from the Transaction form.

That was it. Thanks again!

Thanks - I have filed case 1333280 for us.

Nope putting in {id} also causes the page to return the "An unexpected error has occurred. Please click here to notify support and provide your contact information."

So removing formula and using {id} works. Thank you for your help.

I've been using it and it's working nice so far. I'm running into an issue though. Whenever I try to print to a sales order that has been attached to a project record, I'm getting the error "Problem saving template: The entity name must immediately follow the '&' in the entity reference." when it prints out. When I print a…

The mail merge, when performed from the custom record itself, works fine. What I'm trying to do is run the merge from the parent record in a way that iterates the details from the child custom record into a section of the word document. Essentially I want to produce a document that has the parent record details up top with…

Would you be willing to share those scripts? I have a similar situation right now where I have a child record listing that I need to pull into a section of a document merged from the parent record, and what you've done sounds like the only way to get it to work (unless the enhancement has been implemented). Let me know and…

All three of those points resonate with us. We wound up cancelling our support subscription at the last renewal because we get better quality support from the User Group here for free than the paid support lines. I've also experienced issues from hot-fixes and I doubly wish there was a subscription I could sign up for. At…

Couldn't you setup a wordpress blog that runs on blog.filtersolution.com and tie in your tabs, etc with your current site? Wordpress is flexible enough that you could make it seamless from the customer's point of interaction, even though they would technically be running on two different servers.

I think he meant macros, for use in Excel. FWIW I don't think there is a way to import redirects. Or perhaps he meant recording iMacros to fill out the forms on that page from a CSV. iMacros is a great Firefox extension and sadly a common tool for workarounds when working with NS when they won't let you import half the…

Hrm that didn't quite work. It looks like when the PO page loads, it initializes the first expense line meaning that there's technically no memo (yet). So the validateField function is firing on every field change and there's technically no memo data yet, so it errors. I think the validate line function is going to be more…

I was a complete Java newb and took the week long SuiteScript programming course offered by NS online. It was a great class and I learned a ton. You might want to look into something like that.

I've often run into issues with caching js. If you install the addon firebug to firefox, when you load the page with the script on it, you can look and see if it's pulling in the new js or not.

This is what I have so far that's functional. I'd love to hear opinions if this is the best way to do this or not? function fieldChanged(type, name){ if (type=='item' && name=='units'){ var orderType = nlapiGetFieldValue('custbody2'); if (orderType == '6' || orderType == '7'){ if (orderType == '6'){…

Nope I'm still having a problem with it running on more than two fields. I'm guessing there is something extra I have to do for it to run right. My code: if (name=='custentity153'||name=='custentity154'||name=='custentity155') { var mdlabor = nlapiGetFieldValue('custentity153'); var unionlabor =…