3940390 Green Ribbon

What columns are you including? Some columns will increase the number of results, if, for example, you're asking for a line level field and not just body fields. Can you include more details?

We have that exact same issue. We were so excited to have WiP as an option - we have items that take about 3 days to process when getting a new, in-house finish. These items are either 1) marked as done too soon, before they have actually been finished, or 2) left as plain brass for too long, thus giving us an inaccurately…

Oh, how we _wish_ there was a way to nest a search inside a search! We've been asking for it for years, at SuiteWorld, every time we manage to talk to a NS person... It might be possible to do through scripting (nesting searches, I mean), but we haven't had the time to test it, and NS support didn't know. I'm eager to hear…

Searching on searches is, as far as I know, not possible, but is something we've been requesting for years. We would be _thrilled_ to hear there's a way to do it...

Hi Cloud, If you want to do it by department, just add that requirement to the saved searches, and then duplicate them for each department - it's a bit of a hassle to set up, but that way you can have one set for Sales, one set for Service, or whatever, and then you just set them up in the KPI Scorecard the same way.…

We have a KPI scorecard that looks at, among other things, Average Order Value. We did it like this: 1 search for "Total Sales Dollars": Criteria: Type is Sales Order Main line is True Results: Amount (Transaction Total) (maximum) Available Filter: Date (very important - you can't do a scorecard without it) 1 search for…

Thanks for the insight, Roberth - do you try to charge the credit card when you transform the record as well? We get authorization on the card when the order is first placed, but don't charge it until the order is fulfilled, which is often several days later. We want to make sure that if the card is suddenly declined for…

I haven't tried useing HasKeyWords, but you might be able to do a regex expression instead, like: var textField; if (textField.search(/keyWord/) !== -1) { do whatever; } You do need to be sure your regex expressions are correct, but I've had a lot of success using them in suitescript so far.

Ok, support figured it out: Apparently I need to load the record again in order to get the orderstatus and transid fields, even though this is after submit and the same record. I don't understand why, but I'll take it. Now the only problem is that the avsstreetmatch, avszipmatch, and ccsecuritycode fields still won't…

Thanks, Devg! I've gone back and rewritten the code so it's properly a user event script, and uses salesorderRecord.getFieldValue and the like, and made the changes you suggest. Everything is working great except for the credit card security checks (ccavsstreetmatch, ccavszipmatch, and ccsecuritycodematch), which are all…

Thank you all so much! Brett, that script will be a _huge_ help, and is just what we need. Thank you!

I had that problem recently, which was due to a set of double quotes in my headers (which I couldn't see unless I opened the file in something like Notebook).

Try this: CASE WHEN ({systemnotes.newvalue} = 'Pending Credit') THEN WHEN (to_number (to_date(2/13/2012) – to_date({systemnotes.date}) )) > 45 THEN 1 ELSE 0 END

We dropped PayPal for this reason as well. We were able to get them to extend the window up to about a week, but that still wasn't enough time for some of our backordered and dropship items. The answer we got from both NS and PP was that we should just bill immediately, which we can't do - we simply won't bill someone…

Any further information on Tmargot's questions? I'd like to know how to use parenthesis and "and" and "or" in my scripted searches.

Check the date range in your search - since KPIs use 'date' as a filter, if your search results are looking at a different date range, you'll get a different number.

Is it throwing an error because it is possible for the formula to attempt to divide by zero?

Us too, which seems to be new with the new release.

Oh, thank goodness! That's a relief. Thanks, Corey!

Apparently there's no alternative to the Work in Progress issue - NS just closed the defect case because it's "working as designed." What a disappointment. I guess we'll cross our fingers for an enhancement to come through in a few more years...

Using the "Work in Progress" feature requires us to enable Multiple Locations? Why on earth does it need that? We were super excited about the Work In Progress feature - we have some finishes that are done in-house, and so right now our item counts are off one way or another when we take a base item and apply this finish -…

We're having an issue with promo codes as well - when it is $X off of an order (such as $15 off an order of 150 or more), and that order is split into two shipments, then NS tries to apply the $15 discount to both shipments, thus doubling (or worse) the discount. This is new with the new release. Case #1456583.

Be careful - NetSuite for Outlook 2.0 keeps this huge hidden file - it quickly grows to several GBs, even if you're not actually using the plugin. I don't recall for certain, but I think it's kept under either Netsuite for Outlook or Outlook, under, iirc, program files. We had certain users' profiles just balloon to huge…

Our UPS shipping (only UPS - USPS has been fine) has been slow and occasionally thrown errors for the last week or two. Yesterday was better, so hopefully it's on the mend?

Seconded. Plus 100-ed.

No one here seems to be able to save ANY transactions (defect 229550) Further, we cannot print anything that is a PDF - which, most notably, means no picking tickets. Between the two of these, we are just sitting on our thumbs until NS fixes them.

THANK YOU!! That worked. I'm not 100% clear on the difference between nlapiLookupField and nlapiGetFieldValue, but I won't complain, because that works! Thank you so much. When in doubt, ask the user group. Thank you!

What field are you using, khultquist? Ours fires off of the Item Fulfillment as well, but the only place I've been able to find the tracking number is the Sales Order, where I have the above problem with the order. I've tried using nlapiGetFieldValue('trackingnumbers') but it shows up as blank. I have no problem linking…

Hi Sensen, Thank you for the help. Can you walk us through how to do that? When I spoke to NS support on the phone, they told me there was nothing that could be done, and it was not possible to remove the case sufficiently. How do we inactivate or delete a case completely, such that another spam email would not order it…

Firefox does it as well (with two dropdown menus instead of 1, no less), but just now logging in on my own computer with that account it was fine. How strange.