I contacted NetSuite and they confirmed this is a defect (albeit minor) Defect 143466. The "workaround" is, of course, to export to Excel/CSV and do your own filtering.

The only other change I have made to the default report is to "ungroup" (Group checkbox is unchecked) the "Account" column. Even when this column is "Grouped" though, I still see a couple entries which are 0/0 for credit/debite (and the filter is credit/debit != 0). Thanks for the replies, I will ask NetSuite for help.

Thanks for the suggestion but it was not checked to begin with. Also, I tried checking "Activity only" and that hides many of the zero lines but still not all. It seems like I must be missing something because what I'm trying to do seems like such a simple customization of a basic Report Template. Is this behavior at least…

NetSuite replied and informed me that there "is no out of the box feature to dynamically run assignment processing." That is understandable (although it would be a nice enhancement), so I will proceed with using SuiteScript to achieve what we want (on-demand updating of any and all Support Case assignments when a Support…

Or you can script this through the After Submit User Event - deployed to Case along with the After Submit User Event - deployed to Message. The former is for any GUI changes and the latter is for e-mail responses sent directly to a case-specific or message-specific coded netsuite.com domain. You will need to have logic…

Has anyone ever considered/attempted using scripting to perform assignments completely separate from the built-in NetSuite territories? Using After Submit to do this seems like it would let you account for virtually anything, including days of the week, when assigning new Cases.

Hi Olivier, I am looking to expand the logic of the Sales Team subtab and am both happy and I guess unhappy to see that you already came to the same conclusions I did: "You'd have to create a sublist object using scripting, which would allow you to filter the Employee list any way you like. Then, using more scripting,…

"Try setting the option to Run Unrestricted = T under the Results tab of the search." While we seem to observe the same restriction in terms of a Message Saved Search returning 0 results for non-Administrator roles (but hundreds of Messages for Admins), this checkbox does not seem to solve the problem. Is it necessary to…

JCirocco: Still not sure I fully understand the request of this thread or if your request is the same thing. "Drill down"/"Drilling" implies a predefined hierarchical relationship or connection whereas nested Saved Searches does not imply anything like that. Programmatically speaking, you could run a Saved Search for…

What exactly do you mean? I understand the general concept of what you are asking but not the specifics. With SuiteScript/programming you can generate Saved Searches and then do more Saved Searches with the results of the first Saved Search. Do you mean linking Saved Searches together into the GUI somehow so that clicking…

Hi, Thank you very much for the response. I watched the video from KB Answer ID: 3758(https://netsuite.custhelp.com/app/answers/detail/a_id/3758/kw/custom%20search%20form) which is the one I believe you were referring to. I think that this is useful, but doesn't directly address our needs (although it is entirely possible…

khultquist: Thanks, this was extremely helpful. I suppose your formula is basically telling us that a Customer is by default a "Sub of" itself even if there are no other Customers in a hierarchy above it. This would explain why both the Parents Customers and the ACTUAL Subcustomers show up together if you just use a "Sub…

Yes, I believe I am using it correctly...when you say that you haven't had any problems, are you explicitly saying you are using it in a Client Script?

I also am explicitly using nlobjSearchFilter.setOr() in several Server Side User Event Scripts/Suitelets but seem to get an undefined error when using setOr() in Client Script. Is this an instance-specific problem that requires a new Case or is this a known issue/problem that will be fixed? Thanks!

Hi Errol, Thanks, I believe you have confirmed that this is more of a NetSuite feature not being rolled out than it is an individual ticket-worthy issue (I assume NOBODY can use this function in Client Script). You are correct though, I have resorted to using a formula with CASE WHEN ... THEN ... ELSE ... END instead, just…

This is up and running. I have combined a User Events script which triggers on Edit/Create of Check and Vendor Payment records (check and vendpymt) with a Scheduled Script that loops through all such records as well. The Scheduled Scripts runs each half hour but I believe if you wanted you could do one of those tricks such…

Hi, This is an important feature for us as well. I am a bit surprised that everyone here seems satisfied with nightly updates to their bank. We may end up resorting to this if necessary, but has anyone ever tried sending updates (in a fully automated fashion) to their bank on an instant check by check basis (our bank can…

I just had the same question, but don't yet have an answer (although I'm guessing it's possible to use hacky client script to set the View dropdown)...I would have expected this to be an option around the same place as where you set "Parent Subtab" for a Custom Child Record, but I don't see anything in the GUI.

I have indirectly solved this (strange) problem by directly invoking the NetSuite code for attaching Solutions to Cases (hacky non-official API). This gives me more flexibility anyway so it's actually better than just a "fix". I'm using a Client Script function loadXMLJSDoc() which is normally available in the Case Form…

Hi rmercene_ns, Thanks for the response. In case it wasn't clear, I don't mean the generic English word "solution", I mean the NetSuite record of type "Solution". The SuiteScript which is running on my Case Form does not produce any errors on its own and it does not attempt to interact with the "Solution" box, yet it is…

Thanks Evan! A quick search of the help seems to indicate this is PRECISELY what I needed. I will definitely have to try this out. More API is ALWAYS a good thing!

If that is true, then that is fantastic! I will look into this. Is there an obvious reason why when I click on SuiteScript API in File Cabinet, and then do CTRL+F for 2012 I get no results? Shouldn't such functionality be noted somewhere as '2012.1'? My apologies if this is a newbie question.

Hi, Unfortunately for me, it seems like the OP asked a question I wanted the answer to but his solution ended up not really answering that question. Frédéric, you say: It might be a wiser choice to create your filters using the API (nlobjSearchFilter) and use the API nlapiSearchRecord to obtain your results. You could then…

Hi, So if I understand correctly, there is no way to make "Item" a child of a Custom Record (i.e. add an Item Subtab to an arbitrary custom record)? I would need to create a SECOND custom record type to mimic "Item" and make my FIRST custom record type the parent of the SECOND? I need to take a "snapshot" of the EXACT Item…

Hi Evan, Sorry, I should have been more precise. You are correct that it is simple enough to make Item a child of Custom Record. However, what I was getting at/trying to understand is whether the Sales Record type Item Subtab (which includes INSTANCES of Items, not direct links to Item records) is possible. I don't even…

+1 I had a similar experience in terms of learning how to code and customize (and how hacky it has to be). However, to be fair to NetSuite, their actual product goes far far beyond anything that could be done with any CMS I am aware of out of the box for managing a company. Also, I have found that their support is decent…

I am getting this exact problem, but for me it is only in Edit Mode. In other words, customizing a Sublist which is based purely on Parent/Child linkage works fine in Edit Mode, but the *exact* same "getField" lines which work in Edit Mode return 'null' in View Mode. Similarly, the *exact* same "addField()" calls throw the…

Also interested in doing this...I assume nobody has figured this out?

I had this exact same problem and also could not find any official answer. I tried every variant of "pricing" and "pricelist" and "pricinglist" and "itempricing" etc. etc. that I could think of and nothing seemed to work for me (all gave me that same error). However, I realized that (at least in my case) it appears doing…

Just purely based on your posted code, it does not appear logical that you go from searchCols[0] then [1] then [3]. Are those the right indices? You might want to post more code for a better context.