Channels
#general
- s
sethcall
10/06/2016, 8:33 PMoh.. well maybe they group by the transaction. idk good q - l
louis
10/06/2016, 8:34 PMthe mass update search returns no results. the same critera in a SS works fine, so it would seem to only search main line, which TBH doesn’t make sense to me - s
sethcall
10/06/2016, 8:37 PMoh, that’s … huge bummer - s
sethcall
10/06/2016, 8:37 PMunless of course they are secretly adding mainline = T - s
sethcall
10/06/2016, 10:25 PMI’m trying to do a saved search of
, by a certain status. (say… ‘complete’ for sake of argument).scheduledscriptinstance - s
sethcall
10/06/2016, 10:25 PMThe status as returned by a search column is ‘Complete' - s
sethcall
10/06/2016, 10:26 PMbut that does not match when I set a search filter - s
sethcall
10/06/2016, 10:26 PMhow in the world do I figure out valid search filter values? - s
- s
sethcall
10/06/2016, 10:26 PMI’m trynig to search on Search Column = ‘status' - s
sethcall
10/06/2016, 10:28 PMthis list shows a ton of statuses for transactions: https://netsuite.custhelp.com/app/answers/detail/a_id/50165/kw/salesord%3Ab - s
sethcall
10/06/2016, 10:28 PMbut not this type - s
sethcall
10/06/2016, 10:32 PMoh. at bottom: - s
sethcall
10/06/2016, 10:32 PMCopy codeThe way how to find out the correct transaction status is to create Saved Search in UI, in criteria select 'Status' and select status you are supposed to use in SuiteScript. Now in SuiteScript debugger load the Saved Search and getFilters. You can see the correct syntax for status field. You can use sample script for it: - m
michoel
10/06/2016, 10:32 PM@sethcall It looks like the valid values are "CANCELED","COMPLETE","FAILED","PENDING","PROCESSING","RETRY" - s
sethcall
10/06/2016, 10:33 PMahhhh - s
sethcall
10/06/2016, 10:33 PMyes ur right - s
sethcall
10/06/2016, 10:33 PMwhat showed it for you? - s
sethcall
10/06/2016, 10:33 PM@michoel - m
michoel
10/06/2016, 10:34 PMI did basically this, but used this excellent chrome plugin as a shortcut instead of using the debugger / developer console:https://chrome.google.com/webstore/detail/netsuite-search-export/gglbgdfbkaelbjpjkiepdmfaihdokglp - s
sethcall
10/06/2016, 10:35 PMalirght, installed, and thanks! - b
bednar
10/07/2016, 12:05 PMNetSuite briefly broke SAML authentication last night in their Thursday night patch cycle. That's a fun midnight text to get from someone. - e
erictgrubaugh
10/07/2016, 2:03 PM@louis Just confirming your findings on Mass Updates, there's this in NetSuite Help:Also note that if multiple rows are returned for the same transaction, the custom mass update will still run only once per transaction.
- l
louis
10/07/2016, 2:07 PM@erictgrubaugh yeah, but I can’t for the life of me figure out how to get it to search the individual lines. the search critera operate as if main line = T, even though it isnt and even thoguh i explicitly set it to F or either - e
erictgrubaugh
10/07/2016, 2:19 PMThat statement from Help makes me believe you can't search for individual lines. Your search will only return the matching transactions, and your Mass Update code will have to scan the transaction for appropriate lines - l
louis
10/07/2016, 2:20 PMwhen doing a summary roll up on a search is there any way to tell it not to total the column? - l
louis
10/07/2016, 2:20 PM@erictgrubaugh Like much of NetSuite docs, I don’t read it that way but the reality surely makes me lean towards your interpretation of the ambiguity 😄 - b
bednar
10/07/2016, 2:41 PMLooking at that one line, I'd agree with eric's interpretation - b
bednar
10/07/2016, 2:42 PMYou'll snag the record when the MU runs, and you can have your custom script dig through the sublist. - l
louis
10/07/2016, 2:43 PMdoesn’t help if you want to run the MU on transactions selected by only data on the line