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

@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…

No problem!

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…

@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…

@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 -…

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

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…

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…

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})…

@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 -…

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...

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…

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…

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

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…

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…

@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…

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

: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 :)

@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!

@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…

@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…

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…

@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…

@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…

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 :…

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"…

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

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...…