Actually, it looks like there is no way to round the overall average of a numeric value, even if you use the round functions. If you use formula (currency) it rounds to 2 decimal places. But if you don't even want to use that function, I definitely don't see any way to do it. I suppose we could always round all averages to…

2008.2 is currently scheduled to roll out sept/oct. This is very good news. When can we see a sneak preview?

Lorna, Here is one idea that might work for you: Add custom field on the Customer record to track "Customer Type", being "Wholesale" or "Retail". This can be sourced to either NetSuite Classes, or a custom list. Then on the SO form, either add a custom field for "Customer Type", or show the "Class" field. In either case,…

I just solved this problem in a different situation. You use the CASE to simulate a boolean. CASE WHEN ((dense_rank() over (partition by {internalid} order by {activity.completeddate} desc) = 1) THEN 1 ELSE 0 END Then use "Formula (numeric) is equal to 1" to filter Nick, As Evan says, this looks very cool! :cool: But I'm…

Yes that would be great. Like some of the MS products (Exchange Server for example), you can create friendly filters using menus, and then click a tab and it will show you the underlying SQL. If would be great if we could pass full SQL statements to NS's Oracle db and let them execute. If we could do that then we truely…

This won't affect the item pick list on the order. We are looking to add that capability in an upcoming release. This will be most welcomed by one of our clients. They have over 200 customers, each with a unique item list and prices. Is there an ER we can vote for? It would be really great if this could make the 2008.2…

inventorynumber records are not yet supported. We added support for serializedinventoryitem and lotnumberedinventoryitem records in 2008 release 1. Yang, Could you possibly share with us the roadmap for serial number and lot number records (both Inventory and Assembly items)? I'm particularly interested in Lot Number…

In the shorter term we have a SuiteBundle that will allow you to run a saved search nightly and store the results in custom records, which you can then use as the basis of another search. The Bundle is called "TRAK-IT" and is being used very successfully internally. Thanks, -e Evan, Just checked the SuiteBundle Install…

That is unfortunate, as this calc is an excellent metric to display on all Case forms. I hope Q1 is closed to Jan 1 than to Mar 31. :) I guess I'm surprised that the same fields aren't exposed for formulas in saved searches, custom fields, and forms. Is it possible to make this consistent across all of these for all record…

Try {startdate} for incident date.. Thanks for the suggestion, but it didn't help. Only one formula uses the incident date anyway. Both custom fields still show "ERROR" on the form. I think there a bug similar to the other bug I uncovered with the Task Status Flag formula. I believe that bug is fixed in 2007.1. Will that…

The fields you are looking for are available in the Customer Service reports, not in searches. Thanks for the quick response aliu. At least I know where to look now. :) But why are these key fields not available in saved searches: [LIST] [*]Average Time Elapsed Average Time On Hold Average Time Open Avg. Initial Response…

Here's another approach using the NumToDSInterval() function: SUBSTR( numtodsinterval( {today} - {createddate}, 'day' ), 8, 9) This will return the interval in the format "DDD HH:MM". For example: "045 10:09" It does truncate seconds, so it might off by 30 seconds. Also, it assumes that both D/T fields are in the same time…

The Company Name field in a search will produce just the company name with no parent hierarchy. However, in a formula field on the same search, {companyname} produces the full name with parent hierarchy such as, "Parent Name : Child Name". I have seen this behavior as well. What I would like to see for all entities is a…

Here's a better formulation that accounts for case closure. So these formulas work for BOTH "Open" and "Closed" Cases. Also, there are two separate formulas: [LIST=1] [*]Based on when the incident OCCURRED [*]Based on when the incident was REPORTED[/LIST] OPEN TIME -- SINCE INCIDENT OCCURRED NVL2( {closed}, SUBSTR(…

Here is a related thread you might find of interest: How To Calc Case Open Time with ON HOLD?

Sean, Thanks for the reply. I understand that "averages" could not be a native field per case, because, as you said, they require data from all cases that meet the criteria. But what about the underlying time data? Surely much, if not all, of that could be exposed as native fields? IOW, doesn't NetSuite currently track the…

This sounds good -- thanks for the very quick fix. Can you please make sure that they update the formula dialog box for both searches and custom fields to select these new case fields? Thanks.

I really DO NOT understand NetSuite's idea about admin permissions. It's a mystery to me! :confused: Admin can see everyone's activities, but not saved searches?? I'm going to file an enhancement on this. When an employee leaves, the Administrator may need to review and/or change searches the employee had marked as…

Ben, the proposed solution is to only show the indentation when viewing the tasks on the project record. Let me know if you have a different opinion. Thanks, Sean Sean, Have you considered indenting ONLY when the Parent/Summary Task is shown on the same list? This makes the most sense to me. I think this will solve Ben's…

I am trying to create a saved search which shows all the resulting rows, i also want the average of each field/column to be displayed at the end as a summary line in the same search. I am able to get the required records any suggestions as to how can i display the average of the fields in the same view You can do this in…

That's probably more than you wanted to know but just explaining why it is not a slam dunk! Evan, Actually, I appreacite your sharing this information. You're right, it is more difficult that might appear on the surface. In particular, the indentation doesn't make sense if the tasks are sorted in any order other than the…

JMU- do you have advanced analytics? This is possible to do within CR, or even excel, if you do. I was assuming that you did not....:o Yep, we've got AA and ODBC access. Do you use CR much? If so, how do you like it?

Hey JMU, how handy are you in excel? I can walk you through this relatively easily, if you like, but it is essentially done in excel.. Angela, Thanks for the offer. I'm pretty handy in Excel, but I don't want to download thousands of customers. :) But if I was going to download, I would actually do it in MS Access. Anyway,…

Evan, Thanks for the suggestion -- it counts the number of line items perfectly! Just one problem: When I click on the grouped sales Order # to display the SO for that line, I get an unexpected error.

I'm just speculating on this since I have no experience using ODBC connections. Could you view your customers in Access, import the other list into Access, and join them in a query? Great idea Steve! I need to see if I can use Access to establish "linked" DB connection to NetSuite using ODBC.

We have typically used JavaScript to calculate and populate a custom field on the Sales Order that prints on the Picking Ticket and Invoice. This field can contain the number of lines/items and/or the total quantity of items. Robert, that sounds like a useful script -- do you mind sharing? Although that was not my…

Thanks JM but I need something that will work in a Saved Search.

Go to the results page. Group by Number first and then group by whatever else you want to show up in the results. Add Item: Item Name and summarize it by count and you should be ready to go. Long Lam, thanks for the suggestion, but as I said in my opening post this won't work. It counts the number of distinct items, not…

Looks like this is now fixed, based on my limited testing. Thanks NetSuite. JMU

Here's the Issue info: Issue Number 114952 Issue Type Problem Product NetSuite Severity S3 - Important Reported In Version Live Site - Kessler - 10/24/06 Status Pending Investigation Target Version Under Review Please contact Support and add your name to this issue. Thanks, JMU