JMUnderwood Green Ribbon

This would be great!

We have a area on our web site http://www.mindiq.com/elearning/dac/training/index.php that lets people register for a LM webinar. It then creates a Lead record and sends an autoresponder with the attending instructions. Works nicely. [EMAIL="louis@design-a-course.com"]louis@design-a-course.com[/EMAIL] Louis, Does your…

I'm new to all this. Would like help to see if this can be done and is it through web services? Frankey, I don't know if this applies in your case, but if your objective is to consolidate accounts (multi-org/subsidiaries), then you may be interested in the new Ver 2007 module for Multi-Org / Consolidation. See Info on Ver…

Wow, JMU. My rep is wonderful. He may not be able to get everything I have asked of him, but he certainly was always helpful in guiding me to someone who could. I think you are most fortunate and have a rare experience. I have worked with 3 or 4 NS sales reps and 2 sales managers -- all talked big but yielded little. :(

methinks this is the time to get your rep on the phone, and give him an earful.. Waste of time. NS Sales reps have very little influence on anything in my experience.

Doesn't internalId come back to you in the WriteResponse? When I do a delete, I see the following: John, We are having trouble getting this XML string out of the response. CAn you show me the exact code to get it? TIA, JMU

Just a thought... We are in a similar situation with a masive amount of lead record we'd like to purge. We tried using WS and it was a bit slow so we gave up. I think we calculated that it would take us months to delete a few hundred thousand records Our experience was about 5,000 rec/hr using sync delete with WS Ver 1.…

Thanks John, very helpful. Is there a way to have NetSuite return the Internal_ID (Customer_ID in this case) of the record along with the results? Best Regards, JMU

I got an offline comment that submitting change for all 13,000 would probably not be successful. Can anyone recommend a best practice on this? TIA. JMU

Many thanks John. We'll give this a shot. Best Regards, JMU

Have you tried sorting on Sales Rep and Number? If you are looking for Sub-Totals like on Reports, Searches can't do that.

If you are asking for the expandable lines like on reports. it can't be done in Searches. In Searches, all columns show on every line.

Can someone help explain why a transaction saved search on sales orders with the same filter criteria as a sales order report shows different results? Actually they should both provide identical results in terms of the Transaction Total on each SO, and the Total of all SO that meet your critera, provided that the critera…

You don't need to use "DISTINCT". If you do a COUNT of "Number", NetSuite will return the number of different transaction numbers in the search, regardless of whether Main Line is Yes or No. If you want a separate count of Invoices and Credit Memos, then the formula Raymond showed will work fine: Field = Formula (Numeric)…

I just need to figure out how to get them to work together. Chris Well, I'm not sure if this is what you are asking for or not, but you can combine the two formulas in ONE formula field like this: (CASE WHEN ... [your numerator formula] END) / NULLIF(CASE WHEN ... [your denominator formula] END, 0) Furthermore, you can…

To obtain the level of control and timing that you require, you probably will need to use NetSuite Web Services (SuiteTalk). This will allow you to poll for new Opportunities at whatever interval you would like, and take the desired action. It might also be done via Scheduled Script, but I'm not sure how the NetSuite…

Unfortunately you are stuck. :( You will need to use a script to accomplish joins more than one level deep. Allowing joins to deeper levels in searches has been an enhancement request for many, many years.

SUM(CASE WHEN {item} = 930 THEN 1 ELSE IF {item} IS NOT NULL THEN -1000 END) Evan, Does NetSuite now support Oracle/PL SQL? Please tell me it does. :cool:

. . . I want to find any invoice where item with internal ID = 930 was sold and nothing else was on the invoice. . . So if you mean you want transactions that have ONLY Item 930 and nothing else, I think you will need two separate criteria: MAX Item.InternalID = 930 MIN Item.InternalID = 930

I have a couple of locations setup in my account. For now lets call them location A, B, and C. When I look at an inventory valuation report for ALL locations I get a value. When I filter by a single location A, the value is more than what is reported by ALL locations. Does anyone know why this might be happening. Thanks in…

We've been exporting to Excel 2007 for over a year, generally without any problems. What is the error msg you are getting? Is it the same error with all Reports? Can you export Saved Searches to Excel 2007?

How does Tableau compare with Crystal Reports in price & capability?

Enhancement #121202, in case others are interested. Get the votes in! I'm not sure the exact name of this ER, but there has been a long-standing request to provide Reports with the same formula-building capability as Saved Searches. This is what we really need.

I don't have time to write the formula, but here's the basic approach. IF ASC(LastChar(SONumber)) >= 65 THEN IncludeRecord This is all pseudo code that you will have to translate to Oracle SQL. The ASC() function returns the ASCII Character code. Letters start at code 65. LastChar() is a made up function that returns…

Does anybody know how to set the column width on saved search output? This can't be done in NS. Virtually every other reporting tool in the world today allows control over the basic layout. NS does NOT provide this capabilty in either Saved Searches, Reports, using either HTML or PDF. The only control NS provides is column…

Hello, Perform Search=Full Publish Search=Full Thanks, Gracie Gracie, doesn't this give permission to delete ANY search, not just the ones that the user created? If so, is there a permission that will allow the user to delete ONLY those searches he/she has created?

I have created something similar. Check out the Criteria / Results here: https://spreadsheets.google.com/ccc?key=0AjpWx1X_EtB-dDJIM3dZMmhyTmRQVEotVGRBMXVnS1E&hl=en&authkey=CO6JvZ0E Start from a transaction search. Your results tab has {quantity}*nvl({item.cost},0) Cost of Goods I think that {item.cost} is NOT the COGS,…

I changed the cost in the forumale from item.cost to item.averagecost. Just keep in mind that this is the average cost of the units currently on hand of the item at the time the search is run, not at the time of the transaction. So if you run this search 6 mos later for transactions 6 months in the past you might not get…

I don't believe there is a report, but you can accomplish this with a Transaction saved search. I believe since last version there are even joins on COGS transactions. So you could pull an Invoice/Cash Sale seach and substract the value from the COGS. Olivier, Can you help with some details? :) I have a transaction saved…

Hello Jim, As per my tests, only Admins can delete searches created by other users. Thanks, Gracie Gracie, you are correct. My tests confirm the same thing. I guess this must be an inconsistency in NetSuite. For most other record types, when you give the user FULL permissions, this allows the user to DELETE any record of…