Hi Nick, Thanks for the response. I had ODBC briefly but didn't renew because it was too slow. From your information it sounds likes the tables are setup like I thought they were. So if you have something like (pseudo SQL-like DDL) CREATE TABLE Transaction ( internalId int PK, amount double, balance double ) CREATE TABLE…

Can you write a script that also calculates upon update of the record via in-line editing? Is it a separate / different script or does the script work in each case based on the 'record being updated' type of event? Yes, you will find there is a type parameter passed to the event handlers. One of the possible values of this…

Thanks for the info Evan. I'm curious... what do you attribute the degradation to? Is NetSuite adding custom fields to the actual tables or using a separate table? (talking about built in records)

It can slow down both searches amd record viewing especially if you do it for more than a few fields. Evan, a couple questions: [LIST=1] [*]Does it affect performance differently than a built in field? In other words, is the performance hit from selecting more fields in general for the list or is there something special…

Fantastic!

Hi Sklett, We have created a custom field (with a list) on the sales order. When the order goes through a certain stage in the order process a member of the back office admin team who is handling the order will change this custom status to indicate exactly where the order is up to. Hi John, Thanks for getting back to me. I…

...I'm impressed. That's a tricky design to make easy to use (for the NetSuite devs I mean) (bravo, bravo)

System Notes: Old Value is Awaiting Credit Check Or System Notes: Old Value is Awaiting Stock Or System Notes: Old Value is Credit Check Passed Or System Notes: Old Value is Credit Check Failed Or System Notes: Old Value is In Despatch Or System Notes: Old Value is Order Cancelled Or System Notes: Old Value is Order…

So you remove the ","? concat(valueA || valueB || ValueC) ? Here is an example I have: '<a href="https://system.netsuite.com/app/common/entity/custjob.nl?id=' || {custrecord_claim_patient.internalid} || '">' || {custrecord_claim_patient.firstname} || ' ' || {custrecord_claim_patient.lastname} || '</a>' That creates a link…

Here is my reasoning that I entered in the case. Does this not seem logical to anyone here: Please provide detailed steps to reproduce the problem: 1. Create saved search 2. Add recipients (Email > Specific Recipients) Result: Contacts aren't listed Expected Result: Contacts would be listed. This is a defect. It is obvious…

So I should probably enter an ER for that. In the meantime I can add a formula(Text) column and build the link to the record. It's hacky and error prone, but just might give me what I need. I will try it and post back.

Steve, You're using Oracle PLSQL statements. I don't think that NetSuite supports PLSQL. I remember people asking about how to do IF-THEN constructs and someone pointed them to either the CASE or DECODE statements. Checkout this thread: IF/THEN/ELSE sytnax for formulas? Correct you are! I suppose... well, I assumed that…

Is this something that *could* be supported? I've noticed the past few years that when certain things aren't possible with the search system you will sometimes add them real quick. Like a missing join or filter, etc. Is there any chance that a simple change could deliver the functionality I need? I need to do several…

Try using CASE when IF {custrecord_physorder_due_date} IS NULL THEN 'it is null' ELSE 'it is not null' END Thanks, Yang Thanks, After reading Jim's post I started messing around in MySql Query Browser and came up with a working prototype: SELECT CASE 1 = 1 OR 0 = 0 WHEN TRUE THEN 'T' ELSE 'F' END This should approach…

Understood. Thank you for the additional clarification.

The remaining issue I'm having (and I think will be an issue with your solution as well) is how to handle null date and time fields. For example if a date and time isn't entered and I create a criteria using either of our approaches I will get an "UNEXPECTED ERROR" when I run the search. I've been trying to wrap the entire…

That's a nice feature, cool.

The idea of what I was trying to do was to join in call records but then filter to only the most recent. So I could get a column like that to display with 1 or 0, but then when I used it in a formula and compared to 1 I got an error. I think what you actually want to partition by is {internalid} i.e. the customer or…

Maybe I'm missing the point... or maybe I'm confusing things. I think I DO want to use the formula in the result field... don't I? When I use it in a result field I get "Error: Invalid Expression" The field type is Formula(Text) I have tried removing the case statement and I'm still getting the error. Any ideas?

You could maybe source your non-saved custom field from the standard field you want to search on?.... maybe?

The best bet is a summary search, in which both of those are possible. I think I may have a workaround that will hold for awhile, at least it should work for this specific use case. I've got the phone call count working but am not sure how to get the other requirement to work. If I add grouping to the Formula(Text) column…

It's a customer search. I've been able to get the result of dens_rank to display ("1") but I can't find a way to get it to show a field from the child record. I really am just guessing at this point anyway... If you can think of ANYTHING else I could try that would be great.

I have never been able to get that to work. You ARE human! :p Although really I'm :(

You can use LAST_DAY to negate the first of the month portion of the TimeOfDay object by using it on both SYSDATE and your custom TimeOfDay field and then calulating the difference. I have a use case where I store both the date and time of date as two seperate fields on an Issue Record and I calculate the age of the Issue…

You can use LAST_DAY to negate the first of the month portion of the TimeOfDay object by using it on both SYSDATE and your custom TimeOfDay field and then calulating the difference. I have a use case where I store both the date and time of date as two seperate fields on an Issue Record and I calculate the age of the Issue…

Just got off the phone with support (they called me) and was able to get some details about the error. A defect has been created: 151400 and the error on the backend was: "From keyword not found where expected" - sounds like the sql statement generator choked on the fieldId. What's odd is that this morning I tried the…

How did you create this sublist? Thanks, Yang All from the UI. [LIST] [*]Saved search [*]Sublist [*]SubTab[/LIST]

Does it seem like a bug that NetSuite thinks the PO/Check Number criteria field is an integer when it's actually a text field? I just tried to create a search with a footer filter on the PO/Check Number and I'm getting errors when entering a non-integer value (e.g. CT125746485765).

On the results tab, try Date Created, summary type = group, function=month Name, summary type=count sort by date created then make the output type graph. Works well if you have customers being created every month. Thanks, -e Thanks Evan, Although I encountered the same issue mentioned above, it still gives me a rough idea…

Thanks Evan, Sounds like otherrefnum is what I'm after.