3954995 Newbie

Any chance you would be willing to share those scripts? We are very new to NetSuite and we pay our sales reps the same way as you do. Thanks for any help you can give. Matt

Try CASE WHEN to_char({item.custitem_refurbished}) = 'T' THEN 'Refurbished' ELSE 'New' END Thanks, rnedelkow. You are a genuis. Thank you for the help. I appreciate this community and the "flame-free" environment. Thanks, Matt

I've had a case open since 3/11 and they (Netsuite support) just now say they know what the problem is and support is getting my case over to the team that handles these issues. It's very frustrating. :h_a_w: Matt

I guess I don't understand the differences between saved reports and saved searches. I can make the report EXACTLY how I want it and it exports 4419 items. When I make this a saved search, it gives me a list of 5515 items??? Why would a saved search pull different results than a saved report? This is not the first time…

Started with a Saved Item Search with "On Hand" greater than 0. Location TS001 and TS007. Results: Name, Product Description(Custom), On Hand, Refurbished(Custom). On the Report: Columns: Name, Product Description(Custom), On Hand, Refurbished(Custom). Filters: Quantity on Hand filtering TODAY, Location filtering TS001 and…

Thank you for the help! I'm working on creating this as a saved search and am very close to getting this just like the report. I appreciate the input! Matt Armfield

Olivier Gagnon: Powersource can accept FTP but they also accept a simple email to inv@powersourceonline.com with a CSV attachment. I was happy that I can schedule my saved search and email it but they don't parse HTML attachments. khultquist: Where is the XLS attachment option? All I get is an HTML file when I try it that…

I'm using the same criteria and filters from the report. :h_a_w: That is what makes me scratch my head on this. Matt

Argh! I'm so brain dead today. This is on a saved report, not search. My brain is fried today. Sorry for the confusion.

We just went live with NetSuite on 10/15 so we didn't import any inactives from our old system. We are using "Location" as our Warehouse locations in the same building and I'm returning "On Hand". Matt

I have a saved search that auto-emails the customer once the "Item Fulfillment" status changes to "shipped". It pulls the tracking number, serial # and MAC address of the first line item or at least it did until the 2013.1 update. After the update, the search will work but it will not email out any notifications. Netsuite…

A script or can this be accomplished with a workflow? Matt

Are any of you using the "File Drag & Drop" bundle? Just curious. Matt

Actually, I found out that this is a custom item field and can assign the permissions at that level. Matt

Got it! I had to add: "fieldChanged" function to the form. Thank you all for your fantastic advice, Court What do you mean by this statement? Under customizing the form, you had to what? Thanks for the help in advance! Matt

Well, that is what I thought. We have changed out PO field to a custom one that flows through all of our forms. My next question would be if I need the full field name of the replacement PO field? It currently reads in the script "custbody_pofield" or should I shorten it to just "pofield" Thanks, Matt

Nevermind again! This statement needed the following to get rid of the JS_EXCEPTION error. if (strThisPO == strPO){ alert('This PO number is already on another SO for this customer' + '\n' + 'You may continue but make sure this is not a duplicate order'); } return true; Thanks for all the help! Matt

Nevermind, I figured it out. I got the script to run but here is the error message I get when I click on OK. "An unexpected error occurred in a script running on this page fieldChanged (fieldChange) customform JS_EXCEPTION TypeError searchResult.getValue is not a function" Any thoughts? Matt

I use a Saved search to send a CSV file export of our inventory to Powersource online each night. You don't necessarily need a workflow to do this. Matt Armfield