3959410

SUM(SELECT DISTINCT No. of items in group) perhaps? SELECT DISTINCT is a SQL function that should work for pulling out those individual values.

The Pareto Principle! Unfortunately there is no easy way to do this EXACTLY in Netsuite. Saved searches nor reporting allow you to calculate this running total in a column while also looking for your item sales. Reporting does have a nifty feature that allows you to add a % of Total Column as pictured here. This will allow…

I think its definitely a useful feature, and we do the same thing with <donotreply@ourcompany.com>, but it just seemed odd to me that they would allow you to do this. I've been testing with a few different email severs, and I've yet to find a server and email address combination that bounces the email out as spam. I've…

Hey Alex, Sorry I missed you at Suiteworld as well. The whole thing was kind of a whirlwind. I'm actually in a similar predicament trying to show sales orders total quantity or amount ($) committed while only keeping one line per transaction in the results. (Note: I'm also trying to avoid summary search results due to…

I've gone through and read Marty Zigman 's blog. It is one heck of a resource for new ideas and some really cool tips and tricks! I'll start passing some new analytic functions today and see what I can get. This feels like a giant door of possibilities for other functionality as well.

Thanks for clarifying k_dunc. I've been toying around with the idea of using a saved search to actually perform the entire part here. Perhaps michoel could provide some more info about how he used this formula from a blog: See this article:…

When I used summary results, I couldn't figure out how to get the links to show up to print pick tickets. What summary should I apply to those?

Alright, I got some variation of what I was looking for working. I just was confusing the meaning of {mainline} = '*' previously. However I still would like to find a way to remove the items altogether and roll up the quantity committed into a sum if possible.

Sorry about that. Friday afternoon; brain must be slipping. Also, after typing that I thought about trying the criteria route nesting a CASE WHEN. Something like: CASE WHEN {mainline} = 'No" THEN (CASE WHEN {quantitycommitted} > 0 .... Does this seem feasible?

Interesting. It appears I don't have the option to attach a sublist to the sales team tab then. Thanks for the help!

I seemed to have solved the issue of pulling the search for the item cards. I used the link: /app/common/search/searchresults.nl?searchid=XXX&Transaction_ITEM={internalid}&submitter=Submit&whence= Where XXX is the search. Now to further my question, now I want to put this link into a purchase order as either a body or…

Did anyone ever find a solution to this? It has confused some of our customers as well.

After some research, it looks like nlapiSelectValue(pdfResponseXML,'//PdfDocument') should be the way to go, but it keeps returning an undefined variable.

Server back up. Using var response = nlapiRequestURL(URL+truckLoadId, null, headers); nlapiLogExecution('debug','Details','response = '+response); I get reponse = nlobjServerResponse But the actual body looks like: response.getBody() =…

So I think I finally figured it out. The server actually isn't done responding before the JSON.parse line tries to grab the variable and parse it. Hence why it doesn't think it is a a valid object. I verified this by writing in the responseBody variable manually from a call within my console and sure enough, it parsed out…

Just my luck, the host server just went down. My headers have the content-type and accept set to application JSON though: var headers = {}; headers['Content-Type'] = 'application/json'; headers['Accept'] = 'application/json'; headers['Authorization'] = 'Basic ' + "YXBpdXNlcxxxxxxxxxjb206ZnJlaWdodDE=" ; var URL =…

Interesting. The name is debugging 3 times on the page load. Debugcontainerbillcount2/1/20171:29 pmDanny Mashburn RemoveViewDebugname2/1/20171:29 pmDanny Mashburnlandedcostsource5RemoveViewDebugDetails2/1/20171:29 pmDanny MashburnTest1RemoveViewDebugcontainerbillcount2/1/20171:29 pmDanny Mashburn…

Also tried removing the second qualifier : nlapiGetFieldValue('custbody_containerbillcount') != '' Same result

Thanks David! Now all those samples I looked at make sense. I just needed someone to put it in some context.

I do this for custom print jobs on custom records. Looks like you could probably get away with using the nlapiPrintRecord() At the end of your suitelet, you could call something like this perhaps? var file = nlapiPrintRecord(<a target="_blank" href="javascript:">type , id , format , properties </a>); response.write(…

Now my script actually isn't doing any of my actions. It can't seem to get past the if statement. function onFieldChange(name){ nlapiLogExecution('debug','Details','Test1'); if (name == 'custbody_containerbillcount' && nlapiGetFieldValue('custbody_containerbillcount') != ''){ nlapiLogExecution('debug','Details','Test2');…

Disregard. In trying to add the sublist to the tab I created I just needed to add it not using the variable. var itemList = form.addSubList('custpage_projectitemlist','list','Item List','custpage_projectschedule');

Could it be centered around having this set up as a scheduled script? Would that be a problem? I'm trying to think of any other context that could be causing it. Drawing blanks.

That took me back to square one:

I tried this line earlier (and just tried again with the setOption commented out) and got this result: SSS_INVALID_CSV_CONTENT - Input string is not valid CSV content. I don't know why it wouldn't accept fileId, but would accept the nlapiLoadFile(fileId). It seems like they would be the same thing?

That really felt like it was going to be it. Same thing though.

That did it!!! How did you find that warning?!?! Interesting that you set the mapping first in the script and then the file, but in the UI its the file and then the mapping. Thanks so much!

Oh, strange, I thoughts that is what I was doing with the field: import.setMapping('CUSTIMPORTImportItemMapping'); That is the name of the import that I saved. Should I be calling it differently?

Also, just to be more clear, the fileId is coming back correct, and the script is executing and says "Complete", but the execution log shows: importId = UNEXPECTED ERROR during CSV Import process

Wow, that XML trick is a nice one to have ready! You just saved me hours out of my scripting future. Thanks!