3946830 Newbie

This is just Horrible.... the ODBC column names are tied directly to the GUI names for fields and not the IDs? We change the GUI labels as required to assist our users I guess we'll need to completely stop changing the Custom Field Labels and, instead, change the label as it is applied to forms instead. This is a…

I would love to know how to create either a Search or a Report listing both incoming and outgoing email actvity... but I'm at a loss of where to begin.

Great title, but you may not get the right people reading your question because of it.

Most browsers will now block local links unless you customize or use add-ons: example : https://addons.mozilla.org/en-Us/firefox/addon/local-filesystem-links/

sonufa..... thanks.. works perfectly now. -Brian

Having trouble getting a very similar script working... here is a dumbed-down version of it: function recalculateTransferPrice() { var productIdToUpdate = 999; var recItem = nlapiLoadRecord('inventoryitem',productIdToUpdate); // Calculate the new transfer price var itemNewTransferPrice = 39.99; // random amount // Set the…

Have you considered setting up a 'limbo' location that you do not ship from? Then all new orders could be set to this location and a saved search would be scoped only to that location. In either case, I'd love to get some more details on your search and function and how they work together

I have tried the following add-on which works in both Firefox and Chrome for me: http://userscripts.org/scripts/show/77090 In Firefox, it requires the GreaseMonkey add-on to be installed first... In Chrome, it just works. It makes the message area much wider and taller

We have the same issue... we end up writing our scripts to match the actual output of the web query instead of the NS GUI report. ... And sometimes, the columns swap around months later for no reason we can discern.... so keep an eye out!

We are currently building a solution to merge duplicate customer using iMacros with IE. Preparation [LIST=1] [*]We created a custom search to list all duplicates by descending order of last order (latest orders first) [*]What we really want/need from that list is the internal ID of the customer [/LIST] The iMacros script…

John, Currently, we modify our product data and inventory in both locations... not a big issue for us. Our orders start at 3dcart and get pushed into NetSuite via FarApp via the 3dcart api. Then, after the order has been fulfilled in NS, FarApp pushes that fulfillment data back to 3dcart (tracking #, etc.). 3dcart then…

some more updated 3DCart info for those interested... We fired up a new (and very small) 3DCart store last summer and have had good results so far... We currently integrate to NetSuite via FarApp (Steve is great) and it works as well as our other stores. They do have an optional faceted navigation module (sort of...). They…

That did the trick..... if my account number had been '012345', I set the variable to 'ACCT12345' and was able to log in nicely... thanks ! -Brian

... Just answered my own question I think... There is a separate ODBC View named TRANSACTION_ADDRESS that can be joined to the TRANSACTIONS View to get this data

Tableau is currently ~$2000 per seat We maintain a local data warehouse populated from NetSuite and use Tableau to analyze it

I just tried a different report range (20050101 - 20051231_ and it maxed out again at 75001 records without having data on the report for the entire year... Looks like 75000 may be the new maximum, although it's a soft-fail condition where the user is not notified

Thanks for confirming this! Is there any way from the GUI or from a downloaded report CSV to tell if NetSuite has truncated the results to 75000? Or should we count result rows every time to make sure we got everything and then adjust our date ranges accordingly?

We've had at least one 30+ column report for a looong time and we were not contacted about the change.... Our go-live date is 9/18, so it's a little late to start contacting customers now. To get around this problem, we will be splitting our 30+ column reports into halves and running each half sequentially. ~18 columns in…

Please vote on enhancement # 89790 to bump up the priority of this previously-proposed enhancement. details: 89790 Reporting/Search Please make Internal ID available as a search and report filter, as well as a report column. Open - Accepting Votes Under Review

I discovered that I can get this field in a custom saved search as "Customer : Internal ID" , but still no luck finding a way to get this in a report...

Please vote on enhancement # 89790 to bump up the priority of this previously-proposed enhancement. details: 89790 Reporting/Search Please make Internal ID available as a search and report filter, as well as a report column. Open - Accepting Votes Under Review

I would also be interested in any way to get some finer detail on where our storage space is allocated... [LIST] [*]system notes / history [*]log files [*]records [*]etc... [/LIST]

Probably should have posted this in the workflow area...

Any chance you could share your case # so that I can have my support rep cross-reference it? (mine is above)

great news!...

This feature has stopped working for us also after our 2010 upgrade (3 days ago)... From the evidence so far, sometimes the emails either go to the NetSuite user's email address (and NOT the "from" email address which would be correct) or the emails appear not to get sent back to the NS user at all... Already filed support…

I'd like to know about the web services question above.... is there any mechanism for allowing web services access with a method other than passwords? (i.e. certificates, api keys, etc.)?

--bump-- Does anyone believe that storing NS account usernames and passwords at your WS integration points is an acceptable practice? I know of no other web services interface (that we use, anyway) that works like this... All others let us create a unique token to be used by web services. These tokens can be handed out and…

Thanks for the confirmation Only took about 2 hours.... helps to prepare a spreadsheet that you can copy and paste from for filling out Label, ID, Description, Help, etc. ... Can't believe there's not an 'Import CSV of Custom Field Definitions' function.

Transactions > Management > View Audit Trail you can get a list of transactions created/changed/deleted