User_KC8S1

Argh! https://usergroup.netsuite.com/users/showthread.php?t=11626&highlight=CASE Bugs, bugs, bugs

in Why is this an invalid expression? Comment by User_KC8S1 Jun 3, 2008 9:39AM

On the phone with support. It's an enhancement!?!?!?!?!?!!?!?!?!!?!?!?!

in Displaying the COUNT of child records Comment by User_KC8S1 May 28, 2008 1:06PM

A much simpler example: TO_NUMBER({custrecord_pat_assess_due_time_seconds}) This also throws an Invalid Expression error?

in Why is this an invalid expression? Comment by User_KC8S1 Jun 3, 2008 9:30AM

This is addressed in 2008.2. When there is a standard child (either of a custom parent or a standard parent) we will add a search join. Note, however, we are architecturally limited to one search join per parent/child relationship, so we have to use the search which is the "least common ancestor" of the child standard…

in Displaying the COUNT of child records Comment by User_KC8S1 Aug 19, 2008 10:37PM

We are thinking about a way that even if you group columns the drill down can go straight to the record but we don't have a solution for that yet - it will probably be an option in the search. Thanks, -e That would be great. As it works right now I can't use it. My users will never understand why they click on a patient…

in Displaying the COUNT of child records Comment by User_KC8S1 Aug 28, 2008 1:21AM

It isn't in the release notes, however I believe it made it into the release. Did you try it on beta? Hi Evan, I just tried it with the Beta and I do see the Join listed - GOOD! However I'm wondering if you can help with one more thing... I want to display the COUNT of call records for each of my "Patient Assessment"…

in Displaying the COUNT of child records Comment by User_KC8S1 Aug 20, 2008 1:02PM

Ah good! I'm not sure, but isn't a phone call a "type" of activity? In other words, if I created an FK on Task and Phone Call for my parent it would result in a single join. If I wanted to work with them separately couldn't I just filter by Activity.Type? I will mess around with this tonight. When is .2 scheduled? I was…

in Displaying the COUNT of child records Comment by User_KC8S1 Jun 27, 2008 8:28PM

[snip...] I want to stay away from Grouping because we use direct list editing on the results... and grouping causes us to click away from the list too frequently. This is a highly interactive results list and direct list editing is essential. I currently receive a list that has multiple lines for the same Case because it…

in dense_rank & decode on list Comment by User_KC8S1 Sep 23, 2008 5:18PM

Enhancement 144009 - Search Result: Ability to have support added to the formula syntax to print the internal ID of the select value.

in trick to print the value instead of text of a select field Comment by User_KC8S1 May 5, 2008 5:25PM

Do you think that for non-joined fields it would be at all useful to pull the ID versus the lookup? I will an enhancment. For workflows like I've been creating lately it would be really helpful.

in trick to print the value instead of text of a select field Comment by User_KC8S1 Apr 28, 2008 8:16PM

Do we know if there is an ER# for this? I could use this often...

in Total summary in Save Search Comment by User_KC8S1 Apr 25, 2009 3:23PM

Good to know, thanks Rob.

in Total summary in Save Search Comment by User_KC8S1 Apr 27, 2009 12:14PM

Oracle has limitations?! :p I will enter the order grouping as a defect.

in Reason for the following error when grouping on a result Comment by User_KC8S1 Apr 22, 2008 1:39PM

In 2009.1 there is a "show totals" option on the results tab. I read your post and thought "oh cool" so I went and looked for it and sure enough, there it is! Set the field... save... click on Results link... OK...wait for it.... An unexpected error has occurred. Please click here to notify support and provide your contact…

in Total summary in Save Search Comment by User_KC8S1 Apr 27, 2009 11:47AM

Hi John, After deleting the search and starting over from scratch I can't reproduce it either. I was probably doing something wrong. Thanks for the help, Steve

in Saved Search with Inactive as a criteria Comment by User_KC8S1 Apr 19, 2008 4:43AM

I would get your Valium ready and put your ODBC hat on if I were you. I'm still not on Beta either, but from what I've been told (offline) serial number records aren't supported. How this is possible, how they have STILL left this off the supported record list is a mystery to me. I do have one workaround (in theory) but…

in Item Search and fulfilled serial numbers Comment by User_KC8S1 Mar 31, 2008 11:39PM

This may be a stupid suggestion. But if it's a one time export that you need, can you just login to beta and try the new search functionality in 2008.1? We added serial number searches in this release as you pointed out. Cheers! Tim Gale Sales Engineer It's not a stupid suggestion, but I don't have access to the Beta yet.…

in Item Search and fulfilled serial numbers Comment by User_KC8S1 Mar 10, 2008 10:16AM

One thing you could try doing is performing an item (or any item subtype) search and joining in inventorynumber fields. The search join to use would be inventoryNumber. This would give you access to all the inventory number fields for inventory number records associated with an inventory item. Hi Yang, I've tried this and…

in Item Search and fulfilled serial numbers Comment by User_KC8S1 Apr 1, 2008 12:07AM

I know how you feel man, I know how you feel...

in Item Search and fulfilled serial numbers Comment by User_KC8S1 Mar 31, 2008 11:57PM

I've gotten closer, but the item name still isn't coming over for some reason. Criteria[LIST] [*]MainLine = T [*]Customer : Internal ID = 907 [*]Type = Sales Order[/LIST]Results[LIST] [*]Customer : Name [*]Customer : Phone [*]Item : Name [*]Ship Via [*]Ship Date [*]Tracking Numbers[/LIST]When I run this from the UI it…

in A simpler search question Comment by User_KC8S1 Feb 5, 2008 8:18PM

Yes, I get the same results in the UI.

in A simpler search question Comment by User_KC8S1 Feb 5, 2008 11:22AM

I think what you want is custom sublists. Set the available filter to the field ont he record which is the customer. Let me know if this helps or if I can provide more information. Evan that looks very promising, I think that will be exactly what I want. Thanks for the tip. Update: This is EXACTLY what I wanted, thanks so…

in Displaying a custom list view on a Customer record filtered by the customer Comment by User_KC8S1 Feb 12, 2008 12:21AM

Yes, the OR operator would be very useful and would cut back on the many, many saved searches I have created! ;) I voted for Enhancement 130832

in Search Newb: Some basic questions Comment by User_KC8S1 Feb 13, 2008 2:44PM

Two things: [LIST] [*]"for 99% of NS users the search builder UI is great" - this isn't a good way to get things my way, is it? :p [*]Yang, not just the existing enterprise views but the ability to create our own Views in our respective schemas/catalogs[/LIST]I'll log the enhancement and post here.

in Search Newb: Some basic questions Comment by User_KC8S1 Feb 5, 2008 10:59PM

response.writeLine('testing saved search...'); var filters = new Array(new nlobjSearchFilter('name', null, 'is', '907')); var results = nlapiSearchRecord(REC_IDS.SO, 'customsearch52', filters); if(results == null || results.length < 1) { response.writeLine('null search result returned'); return; }…

in A simpler search question Comment by User_KC8S1 Feb 5, 2008 11:09PM

To be honest Evan, I'm a bit lost now. Is the Main Line just the first line? What is the Main Line? If I remove Main Line I have three results:[LIST] [*]-None- [*]Duet (one of our products) [*]Field Dispensed (a shipping item)[/LIST]When I drill down on each result this is what I see:[LIST] [*]-None- > "No results match…

in A simpler search question Comment by User_KC8S1 Feb 5, 2008 8:05PM

Done. Here are the results testing saved search... Columns: 7 shipdate: Value: 1/27/2008 itemid: Value: null shipmethod: Value: 525 entityid: Value: George, Johnson - ****5589 trackingnumbers: Value: null phone: Value: (124) 444-7854 name: Value: null number of results: 1 Thanks for sticking with this :o

in A simpler search question Comment by User_KC8S1 Feb 6, 2008 2:48AM

Actually.... what I'd REALLY like is to be able to create custom Views (DB Views), define the SQL myself so I know exactly what I'm getting. I appreciate how complex a query building UI is to make and I'm sure that for 99% of NS users the search builder UI is great, but for me it would be much more comfortable to edit the…

in Search Newb: Some basic questions Comment by User_KC8S1 Feb 5, 2008 4:24PM

Steve, Excellent idea! Expose enterprise views in SuiteScript. Please enter an enhancement for this so that it's priority gets bumped up. Thanks, Yang Enhancement 139316 - Expose Enterprise Views to Suitescript and to the Saved Search UI Editor Enhancement 139318 - ODBC > Ability to define custom Enterprise Views

in Search Newb: Some basic questions Comment by User_KC8S1 Feb 8, 2008 12:56PM

[LIST=1] [*]OK, I suspected that. I will fish around the help and the UG for some expression samples. If anyone out there has a dead simple example of an expression for a criteria I would appreciate it. [*]This is a bummer. Of course my next question is "when will this be supported?" (hoping you say it's coming in 2008.1)…

in Search Newb: Some basic questions Comment by User_KC8S1 Feb 5, 2008 4:16PM

MFA for Oracle Community

User_KC8S1 Red Ribbon

Comments