AFAIK this is not available out of the box in NS, however it can be scripted using the 'Email Capture Plug-in' https://system.netsuite.com/app/help/helpcenter.nl?fid=chapter_4235218166.html

Setup > Company > General Preferences > Show Display Name With Item Codes BTW, a handy trick for finding settings is to navigate to Setup > Setup Manager and use the search box on the top left.

Furthermore, while I can't say specifically by how much, I can say that SCS is going to be noticeably cheaper than SCA, making it an attractive competitor to SiteBuilder, in terms of cost. - https://developers.suitecommerce.com/welcome-suitecommerce-standard-to-the-netsuite-family

Maybe you can do this the opposite way, i.e. create a new Shipping Item called "Electronic Download" with $0 flat fee, and set that as the shipping method for all those items.

We also use Google Apps and are very happy. I believe there are some integrations available for Netsuite. Although you won't have an assigned rep per say, on the few occasions where we needed some help their support was very easy to get hold off and quite knowledgeable. If you use Outlook as your mail client, I would…

There is a login audit trail available under Setup > Users/Roles > View Login Audit Trail. You will be able to see there if the user is being used and by what.

NetSuite has some sample applications available for download at http://www.netsuite.com/portal/developers/resources/suitetalk-sample-applications.shtml This is their sample code for fulfilling an order /// <summary> Fulfill a SalesOrder record using the initialize() and add() operations. Users /// are required to…

Thanks for sharing, looks great.. though to be pedantic it's SuiteScript 2.0 not SuiteTalk.. Have you tried using TBA rather than hardcoding the password in the script? I managed to get that working in PHP (http://stackoverflow.com/a/32983952/3230114), but when I tried translating the logic to Perl I just couldn't get it…

thanks michoel, but i want to be able to create these searches via the API as each search will be different. is it possible to create a saved search via the webservices API? i can't seem to find any docs on how to. As I said, I haven't used Web Services at all. However, I had a quick look at SuiteIdeas and it is listed as…

I haven't used SuiteTalk, but this should be possible by creating a Saved Search in the UI, and executing it with SuiteTalk https://system.netsuite.com/app/help/helpcenter.nl?fid=section_N3516862.html#bridgehead_N3517038 To use OR in a Saved Search, you need to check 'Use Expressions'…

You should enable the option to 'Show Internal IDs' by navigating to Home > Set Preferences and select the checkbox next to Show Internal IDs. This will add an Internal ID column to all your lists. For more information see the help topic 'Enabling the Show Internal IDs Preference'.

Another option for a GUI querying program is SQuirrel SQL, which is open source and pretty fully featured.

QweryBuilder has been my tool of choice. Looks as though it's now discontinued. http://werysoft.com/qwerybuilder.aspx

Nic - I am looking into using SQuirrel SQL, but I do not have any Java experience, but it looks like I can query data using pure SQL through GUI. So I am would like to give it a try. Correct, no need to write any Java code. Now I am bit lost with creating the driver. I don't suppose you know the 'Example URL' and the…

[Sorry misread the question]

Sorry, I did not come across that error, and am not sure what that means. Perhaps Netsuite support could assist you? As far as I can recall I did not need to touch any environmental variables. You could try using the JDBC ODBC bridge instead, I have also managed to get that working in SQuirrel SQL.

Keep in mind that RANK will work as long as each {name} is unique, but if there are two rows with the same value they will get the same value. I'm not sure how to get it working in a Summary Search. I played around a little and just got Unexpected Errors.

Oracle has a ROW_NUMBER() function that should work. ROW_NUMBER() OVER (ORDER BY {name})

You can do this using a Saved Search and an Advanced Template https://system.netsuite.com/app/help/helpcenter.nl?fid=section_4823423235.html

We haven't, I think you would have to script that.

For MTD and YTD, you can use formulas like YTD - CASE WHEN {trandate} BETWEEN TO_DATE(TRUNC({today}, 'YEAR'), 'MM/DD/YYYY') AND TO_DATE({today}) THEN {quantity} ELSE 0 END MTD - CASE WHEN {trandate} BETWEEN TO_DATE(TRUNC({today}, 'MONTH'), 'MM/DD/YYYY') AND TO_DATE({today}) THEN {quantity} ELSE 0 END

For the heck of it, I've opened a case to be added to the defect, but yeah I'm still trying to convince them that some bigger issues are "Defects" not "Enhancements"

NetSuite support has now filed this as a Defect #172743. Seems strange that our organisation appears to be the only NetSuite customer in the entire world who has ever been affected by this defect. We are experiencing this same behaviour, unfortunately with Netsuite support we have to pick our battles so we haven't raised…

I am having a similar problem, and I can't seem to shake it. I have the following criteria set in in a customer search: Date of First Saleis within last month Transaction : Typeis any of Cash Sale, Invoice Transaction : Main Lineis true Transaction : Tax Lineis false Transaction : Shipping Lineis false Transaction : COGS…

You can create a Saved Search for all Sales Orders for the customer. In the results tab, group by Document Number, and add columns for Min Date, Max Date, and Count Document Number. Your averages days between orders would be something like Max Date - Min Date / Count Document Number. I think you would need to use some…

Theoretically could be done by using a barcode font; you can inject whatever HTML you want into a Saved Search result using a text formula. Proof of concept: '<style>@font-face{font-family:Code39AzaleaFont;src:url("//azalea.com/web-fonts/Code39Azalea.eot")…

Maybe you can do this with the Google Analytics Real Time Reporting API https://developers.google.com/analyt...g/realtime/v3/

How can I create a script to achieve the same thing? The basic idea would be to have a "Before Load" User Event script deployed to the Customer record. The script would execute the Saved Search I described, calculate the average and display it on the form. Another option which might give better performance is to create a…

You should be able to do this with a Customer Saved Search. In the Criteria subtab, select only 'Custom Checkbox' is checked. In the Results tab, group by Customer ID, and create a currency formula field with Summary Type = SUM and the formula something like (untested!): CASE WHEN {transaction.mainline} = 'T' AND…

Is "1 of 10" the page number? Are you using standard or Advanced PDF/HTML templates?