As a customer, I'd estimate that I'm using about 75% of features. I haven't counted, though. Just a gut feeling.

Kirk - you can indeed create an Assembly Build without a work order. Your assumption on the location is correct - all components will need to be in a single common location that you will then "build" from. Creating a location for Manufacturing is a good idea, you'll probably want to build a process around transferring the…

I see this error via our retail (POS) import of invoices when there is a gift certificate used as payment method on the order. Sorry I don't have more info on it, but NSPOS seems to be aware of the problem.

Who is your account rep? I asked ours yesterday for a quote for the payflow pro module, so the timing is kind of a big coincidence.

Sounds like you want a Customer search, actually - criteria being that the Transaction : Item = x and Transaction : Date range = whatever you specify, then in the results tab be sure to include Contact Fields : Name and Contact Fields : Email. Also, you'll want to group all your result columns, so you don't get duplicate…

I think that did it. Thank you al3xicon! My pleasure, glad it worked out!

From the first look we got this year at SuiteWorld, it seems as though the next generation of SuiteAnalytics will really go a long way to solving many issues - multi-level joins, pivot tables, a better interface, and finally bringing searches and reports together. No idea when we'll see a working beta of this in our…

Ah, that is a fairly small data set, then. ODBC for realtime reporting is probably a fairly viable option for you, though as you mention it's not great speed-wise. IDK, if they could speed up the connection for ODBC, it would make it a *much* more attractive candidate. Of course, they are likely going to roll out their…

@ J2 - thanks, that did the trick! Couldn't get myself outside of the box that time, cheers.

Thanks for your input savethepennies - I don't know much about SSRS or SSIS, but it sounds like you have some specific needs. How much data are you working with out of curiosity? I'm glad to have more input on this, thanks!

Thanks Evan - If you'd like to bounce any thoughts or questions re: Sisense off of me when you get to that point, feel free. Look forward to hearing your thoughts.

[Deleted]

Thanks stephen.gray - I didn't mean to imply that "size" meant revenue necessarily, or number of users. Of course the amount of data is key. "Size of business" in this instance does translate to "size of data". And if Excel works for you, that's great. We are pretty happy with our choice. Considering what my CEO and CFO…

trimblee - Thanks so much for the detailed response. We ended up going with Sisense. I evaluated 11 total different software options. Tableau was one of the finalists, but since we were using the ODBC connector and Tableau doesn't really support that connector, I decided against it. The visualization side of Tableau is…

Gotcha - that definitely explains why it is so much cheaper then! Thanks for the insight Olivier Gagnon NC , it is much appreciated.

http://www.cdata.com/drivers/netsuite/order/odbc/?mkt_tok=2xUAKZjCekFVtER%2F%2F%2FO5KazqiDrScYvmuLNwY52MuKVUsyIUGIalUgA%3D%EF%BF%BD

jdelaney - I ended up created a custom record, and then using a scheduled script to log the results of an AR Aging by Sales Rep search I created, into the custom record once per week. I then pull that custom record table into my BI Application via ODBC/SuiteAnalytics, and I'm able to model the data that way. This gives me…

Yeah I feel the same savethepennies - I'm signed up to attend the "future look" session re: SuiteAnalytics at SW2016 so hopefully I'll learn what they're planning there.

A year and a half later and still no solid word on the next generation of SuiteAnalytics. We are just now embarking on a data warehouse effort for our Netsuite data. We will most likely be using PowerBI as the end user tool, and either Azure or Redshift for the data warehouse itself. We will start small and build from…

stephen.gray with respect, I've tried using Excel with our ODBC connection and it simply doesn't have the power we need. I imagine it would be OK for very small-sized businesses. FWIW, when I pull data out of the ODBC connector via Sisense I can specify my query as well, meaning I don't have to pull full tables if I do not…

kthoppae - when you start an inventory count, NetSuite automatically saves a snapshot of the counts of a given item. It doesn't show you the numbers until you complete the count, but when you enter the counted amounts in the form and complete it, NetSuite uses the snapshot numbers to compare against the count numbers and…

In the Mass Updates section, there is an "Update Prices" mass update that will allow you to select your criteria for which items you want to update, as well as how specifically to mark them up or down. You mention marking down items only in certain locations...as far as I know this is not possible without customization -…

dansteg - there is an accounting preference called "REQUIRE BINS ON ALL TRANSACTIONS EXCEPT ITEM RECEIPTS" that you could turn on. then you'd only have to worry about enforcing it via script on Item Receipts.

michoel - is there a way to have this group the results by day? I tried a couple things but could not get it to do this.

Right on, thanks michoel - still useful even as such!

pfung thank you so much for your help here. I had suspected that in order to leverage demand/supply from TOs, that we would need DRP. Do you happen to know if it is being planned at all for the Demand Planning module to allow Actual Sales demand to be considered from multiple locations while still keeping purchasing…

No responses yet, jtrejo@feeneyinc.com. At this point I would not recommend getting this feature.

Sounds like you may need to rename your functions?

I just integrated this script into a portlet of my own. Works like a charm, and saved us hours of labor switching things manually. Thank you so much!

Sure - here is my portlet script: function replaceComponentPortlet(portletObj, column) { portletObj.setTitle('Replace Assembly Components') var oldCompFld = portletObj.addField('custpage_oldid', 'integer', 'Old Component (Internal ID)'); var newCompFld = portletObj.addField('custpage_newid', 'integer', 'New Component…