andy_13423

None that I'm aware of Dave - but I'll bet someone could write one for you pretty easy using Web Service calls :)

in iPhone application to write transactions and cases Comment by andy_13423 Jun 9, 2011 7:49AM

@JPatterson - To the best of my knowledge there's not anything that does it right out of the box with a "connector" - all of them require some form of integration - but different degrees of integration. For example - I know that Boomi (integration component) has a hook built already for ExactTarget that works well. I know…

in Campaign Domains, DKIM and Alloted Emails Comment by andy_13423 Apr 6, 2011 10:46AM

No problem!

in Campaign Domains, DKIM and Alloted Emails Comment by andy_13423 Apr 7, 2011 7:29AM

Mr. X - I might suggest you look at an integration option if you are sending THAT volume of email and an email platform that really lets you dig into the behaviors of your customers in relation to what their emails are doing. NetSuite is great for bulk blasts and general high level response statistics... but I looked at…

in Campaign Domains, DKIM and Alloted Emails Comment by andy_13423 Apr 6, 2011 7:50AM

@jguarico - that really stinks. We all tested it for you guys... would have been nice to know that INSIDE the preview release... then I wouldn't have wasted time on it... or gotten customers excited about these "great new features" - only to have to tell them now - well, NetSuite decided you need to pay for them... My…

in Can't find Demand Planning in production account Comment by andy_13423 Apr 27, 2011 7:22AM

@efagone, Kinda... yes... and no. That works "sometimes". But if I have a search where I'm looking at, ohh, let's say Transactions. And my results are summary. If I want to include in that summary "Maximum" dated User Note... it appears you just can't. Because even though the summary might only DISPLAY the max user note -…

in Fixed value in a summary search Comment by andy_13423 Aug 15, 2012 11:09AM

Mmm yeah. I am pretty sure this search can be done... Me too... I'll race ya :p

in (UNIQUE / DISTINCT) first event Transaction Search Comment by andy_13423 Jun 28, 2011 9:51AM

I can't put the date as a footer filter because if you do - it acts as CRITERIA - and in the example shown in my first post (date range of 7/2-7/5) - it would never see the transaction on 7/1 - and would incorrectly return Invoice 4 as well. So the date has to be hardcoded in the criteria... I'm actually using criteria…

in (UNIQUE / DISTINCT) first event Transaction Search Comment by andy_13423 Jun 28, 2011 9:39AM

Oliver - I'm pretty sure date filters are out completely as they act as criteria - so if I put a filter on the search it will return the cust_thing with the lowest date in the filter range - even though it's not the lowest in the system... So I have already resolved myself to the fact the date range has to be set inside…

in (UNIQUE / DISTINCT) first event Transaction Search Comment by andy_13423 Jun 28, 2011 8:17AM

Anyone have any other thoughts on this - I have been trying to make dense_rank and keep work for this... and although I get close - it's just not happening for me. In the results I have tried the following SQL statements as a Numeric Formula in the results: dense_rank () OVER (PARTITION BY {trandate} ORDER BY {number})…

in (UNIQUE / DISTINCT) first event Transaction Search Comment by andy_13423 Jul 27, 2011 2:20PM

@capitoladmin - I have a support case open - by removing the "*" from the results - the report will go from 2000 lines in the PDF to 3000... they are looking for another way to expand beyond 3000 results. I thought about breaking the results up, as you are doing, but the output (and need for PDF) is an audit requirement -…

in SAved Search - Export to PDF truncated? Comment by andy_13423 Jun 6, 2011 8:13AM

Second part - is there a maximum number of "Elements" you can place on top of other "elements"... cause it sure seems like after about 4 NetSuite arbitrarily decides to place them on top or under other elements...

in Custom Transaction PDF and layers? Comment by andy_13423 May 6, 2011 12:04PM

You "could" create a custom record to hold each blog entry, then have a page that displays those records in chronological order. You could then reference by URL the images for any post in the file cabinet. Not very elegant - but would work. You are WAY better off using WordPRess, TypePad or Blogger with it's own subdomain…

in Blog add-on / plug-in needed Comment by andy_13423 Apr 5, 2011 8:05AM

Not sure exactly what your plan is - but you can certainly link to any web store from WP... and you can build a web store template that matches your WP template. If you are looking at having the items and the add to cart inside WP - with the cart ONLY outside - it can be done (and your posting in the WSDK section suggests…

in Integrating NetSuite store with Wordpress Website Comment by andy_13423 May 26, 2011 7:33AM

ahumphrey - that's not an option... and I can't find a magic layout solution to make that work either... Good thoughts tho.

in Assistant (nlobjAssistant) - adding field AFTER sublist Comment by andy_13423 Dec 10, 2015 10:44AM

There's now an "Enhancement" to vote on to allow the same User-Agent strings that can GET to POST... 264690 The abstract isn't overly clear either - so... Externally Available Suitelet > Sending a POST request to the external URL with User-Agent header "PECL::HTTP/1.7.4 (PHP/5.4.8--pl0-gentoo)" returns 405 Method Not…

in Suitelet responding "This request is missing a required parameter." Comment by andy_13423 Jun 26, 2014 8:18AM

Yeah, I had bad forum etiquette and never updated this a week or so back... I have an open case on this... "any User-Agent" is apparently allowed for GET operations... only selected ones they have tested (apparently anything starting with "Mozilla/" has been tested :/) can POST... It's really crummy since there are SO many…

in Suitelet responding "This request is missing a required parameter." Comment by andy_13423 Jun 25, 2014 10:41AM

@frederic - thanks for the reply... I thought that too about the role - but it's the SAME role that the Employee is using (and I looked at the parameter itself and there's nothing under Access restricting anything special.). And I had already added the output - the issue here is NS doesn't "not" see the parameter... it…

in User Event Script not reading parameter when run by Vendor Comment by andy_13423 Dec 6, 2013 9:13AM

Just found this - THANK YOU! NS Support -you should really add this to SuiteAnswers.

in Assistant - sublist problem Comment by andy_13423 Oct 5, 2015 10:49AM

:eek: (moderately embarrassed) - I tried that and it failed (like so many other functions in VIEW mode... but it was a typo!!!) Thanks - that will work - I oped for the more generic: nlapiLookupField('transaction',s_id, 'entity'); since all I need is the entity ID for everything else I'm doing... But - thanks :)

in Determine Record Type (Record Internal ID) Comment by andy_13423 Nov 18, 2011 8:32AM

@Bonnie - Thanks for the input (and good info) but the function names are already different :( I just can't figure out why it's fine on every browser EXCEPT IE8... And I'm refraining from making IE jokes all together. There's gotta be something!

in Multiple Scripts / Same Event / IE issue? Comment by andy_13423 Aug 12, 2011 8:02AM

@pog2000 - Good question - kinda important ;) - Direct UI edit or InLine (so edit or xedit) @Olivier Gagnon - yup, and I have also done a "nlapiGetRecordId" and loaded the record in an after submit - same result... I can't see any field on the darn thing! Script OR workflow... except - once and a while - the workflow will…

in Script can't see custom record fields? Comment by andy_13423 Jun 21, 2011 7:38AM

@Olivier Gagnon - you are a genius! :cool: So - I still can't explain why a script can't read values for some fields even in an afterSubmit and record load... BUT - your post got me thinking - so I changed the trigger on the workflow to always and only be after submit- and for some magical reason - it now works! Gotta test…

in Script can't see custom record fields? Comment by andy_13423 Jun 21, 2011 7:57AM

To close the loop on this there's a bit of disconnect (and support even had to stretch to get the answers - but they came through!) - from the scripting perspective there's the obvious different behaviors between: nlapiGetNewRecord(), nlapiGetOldRecord() and nlapiLoadRecord() From the workflow side - the behavior of a…

in Script can't see custom record fields? Comment by andy_13423 Jun 23, 2011 11:38AM

@vsantos - I guess I wasn't clear enough... yes, I know you need to use a line number (thanks for pointing it out though - the code I posted was incomplete - it was from my "try everything" phase) - what I'm really asking is - on a Non-Inventory Item form... Is there are a way to update the Vendor sublist? There's nothing…

in Script access to Vendor sublist on Item Comment by andy_13423 Jun 1, 2011 8:58AM

@mbouchard - Well - good to know it "can" be done... but - I can't call nlapiSubmitRecord() as the vendor is being updated off data from another field and at that point the other mandatory fields on the form may or may not be completed... but - knowing it CAN be done helps in the investigation... off to the debugger to see…

in Script access to Vendor sublist on Item Comment by andy_13423 Jun 1, 2011 9:19AM

Got it! Here's how to use a client script to dynamically update the Vendor sublist on an Item. 2 things to consider... 1 - nlapiSelectNewLineItem('itemvendor'); is the handle on the sublist 2 - because of how the list loads, it needs to be a synchronous call - so the code needs to look like this :…

in Script access to Vendor sublist on Item Comment by andy_13423 Jun 1, 2011 10:13AM

Not to dredge up an old thread here - but - var a_options = []; a_options.openonly = 'T'; a_options.startdate = '6/1/2017'; a_options.statementdate = '6/30/2017'; will give me a statement using the default preferred form for the company... But if I try and specify a form ID - it throws the awesome "UNEXPECTED_ERROR"…

in Custom Statement Form Comment by andy_13423 Jul 12, 2017 9:45AM

I'd like to know how to do this too :)

in Billing for single Fulfillment but not combined multiple Fulfillments Comment by andy_13423 Aug 31, 2011 4:10PM

Several folks have seen the same thing with Chrome. It's brutal - like sometimes inline editing will just "not work" - sometimes changes "appear" and then they "disappear" - clearing the cache fixes it. A NS support person had me got to Home > Set Prefs and remove the check mark in "Delay Loading of Sublists" - and save...…

in Cache Problems Comment by andy_13423 Apr 15, 2011 8:43AM

andy_13423 Blue Ribbon

Comments