Olivier Gagnon NC

Hi Michael, This is Defect 167700. This Defect is stopping Netsuite from correctly identifying Opened emails, so it constantly shows 0. This Defect is fixed by 2009.2.

in Email Campaign Response ...Received vs. Opened Comment by Olivier Gagnon NC Sep 10, 2009 11:43AM

Yep, here you go: https://system.na1.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2017_2/odbc/record/account.html

in Table with Record Types? Comment by Olivier Gagnon NC Jan 26, 2018 3:58PM

Ok, same one I saw. This is a "fake" ODBC connection to NS. This may or may not matter, but just FYI. This uses Web Services to connect to NS. To be honest, in all probability, it WON'T matter that this isn't true ODBC. The point of a connector like this is to plug into a 3rd party app that expects an ODBC connection. This…

in Non-NetSuite ODBC? Comment by Olivier Gagnon NC Sep 9, 2015 3:30PM

Out of curiosity, can you link some of those alternative connectors? Some that I have seen in the past are not actually ODBC connectors. They are web service connections that mimic ODBC Fundamentally, you CANNOT access NS with ODBC unless you buy the module, since the module enables ODBC connection. No module, no…

in Non-NetSuite ODBC? Comment by Olivier Gagnon NC Sep 9, 2015 1:00PM

Are you trying to create an actual SQL statement because you are wuerying NS through ODBC, or do you mean you have to create a NetSuite saved search?

in Customer fields / table to SQL Comment by Olivier Gagnon NC Nov 21, 2016 7:11AM

The ODBC module was never free. There has always been a cost. So if you want it, yes, you need to buy it. CData is ***NOT**** and ODBC connector. It uses web services to *simulate* an ODBC connection. Obviously, if you do not need true ODBC, CData's connector is a good deal and a good idea. You just need to be aware that…

in Getting ODBC Module Comment by Olivier Gagnon NC Oct 21, 2016 7:00AM

Configured how? What would you do when concurrency is exceeded? You'd have to redesign the integration code to include a job storage and queuing system.

in NetSuite for Outlook RESTlet limit exceded Comment by Olivier Gagnon NC Feb 14, 2018 7:46AM

No, that doesn't exist.

in NetSuite for Outlook RESTlet limit exceded Comment by Olivier Gagnon NC Feb 14, 2018 12:22PM

Well, I wouldn't say it falls into the "easy" category, but you could write your own Web Services call to manage the synching of Outlook or any other 3rd party app with Netsuite (provided they have a Web Services interface). Otherwise, if the 3rd party app can export to CSV, sure, you could do it that way too. Once you…

in Any alternative methods to sync Outlook to etsuite? Comment by Olivier Gagnon NC Jan 3, 2012 7:29AM

What kind of script did you create? Post it's code? Are you touching UI components or doing anything other than using the API?

in NetSuite Calendar (date field) affected by running script Comment by Olivier Gagnon NC Jun 21, 2016 7:19AM

Yes but what is the trigger? Field Change? Recalc? OnSave?

in NetSuite Calendar (date field) affected by running script Comment by Olivier Gagnon NC Jun 23, 2016 7:23AM

Hmm. What does this trigger on?

in NetSuite Calendar (date field) affected by running script Comment by Olivier Gagnon NC Jun 22, 2016 7:10AM

Only items with positive quantities can have accurate average costs.

in Item Average Cost Update Comment by Olivier Gagnon NC Aug 21, 2018 1:02PM

That information is on the item record

in inventory Comment by Olivier Gagnon NC May 25, 2018 12:05PM

That information is on the Customer Payment

in inventory Comment by Olivier Gagnon NC Jun 7, 2018 3:09PM

Yes, totally possible

in Create a Transfer order from a Quote Form Comment by Olivier Gagnon NC May 24, 2018 9:10AM

What do you mean by importing serialized item? The item records themselves? Importing transactions with these items? Importing orders with the items with the serial numbers specified?

in CSV Imports for Serialized Items within a Oneworld Account Comment by Olivier Gagnon NC Nov 28, 2017 2:02PM

Hmm. Expand Account List should do the trick. I'm looking at a demo account right now where I'm able to see every account type. Must be some other setting I can't think of that's affecting this. I'd suggest you try filing a Case with Support? Hopefully they can help you walk through the needed settings.

in Income Account on items Comment by Olivier Gagnon NC Aug 14, 2017 8:55AM

John - Run Unrestricted does not blow through Subsidiary restrictions. Just Class/Location/Department restrictions.

in Subsidiary restrictions but allow other locations to be seen? Comment by Olivier Gagnon NC Jun 2, 2017 12:34PM

Importing the items themselves is possible. Importing the On Hand Quantity at the same time as creating the item is not possible.

in CSV Imports for Serialized Items within a Oneworld Account Comment by Olivier Gagnon NC Dec 1, 2017 12:32PM

Locations are each tied to one and only one sub, so if you restrict a role to a specific sub(s), then you'll only see those specific locations tied to the specific sub(s). This is fundamental to NetSuite's silo approach to per-sub data. So long answer - there aren't any good workarounds, and this is by design.

in Subsidiary restrictions but allow other locations to be seen? Comment by Olivier Gagnon NC May 30, 2017 7:53AM

Hi Olivier, Can we restrict Departments to particular Subsidiary?? Yes that is standard functionality

in Subsidiary restrictions but allow other locations to be seen? Comment by Olivier Gagnon NC Dec 4, 2018 4:31PM

You need to recreate them. NS does not support conversion of inventory to non-inventory.

in Inventory to Non-Inventory Conversion? Comment by Olivier Gagnon NC Mar 28, 2017 11:56AM

It is not possible to customize.

in Customize the Inventory detail form Comment by Olivier Gagnon NC Aug 9, 2016 2:22PM

Best practice is indeed to create the item without setting any quantities, and then as a second step to create an adjustment to set quantities, specifically because this allows you to select the adjustment account. If you set the quantity straight on the item, NS creates 1 adjustment per item. You can still correct these…

in Opening Balance of Item Inventory Comment by Olivier Gagnon NC Aug 12, 2016 7:06AM

What do you mean? Both the Inventory Adjustment screen and the Inventory Adjustment Worksheet screen allow you to enter multiple items for adjustment.

in Opening Balance of Item Inventory Comment by Olivier Gagnon NC Sep 16, 2016 7:14AM

Ah, yes, a Rental process. Yeah rental processes in Netsuite are custom, NS does not handle it natively. All the pieces are there, but it requires customization to line them all up.

in Automatically populate data in transactions Comment by Olivier Gagnon NC Mar 15, 2016 3:21PM

Hello, No, NetSuite does not have this concept. Putting inventory into "forbidden" locations and training staff not to draw from them is the way to go. The process can of course overall be improved with scripting to enforce rules and such, but at it's base, this is the way to go.

in inventory status types in NetSuite? Comment by Olivier Gagnon NC Mar 22, 2016 2:36PM

You are talking about an inventory consignment system. Such a solution should be fully defined beforehand, with the full workflow fully defined and understood by stakeholders. Once that is done, yes, you would likely spawn off Transfers or Adjustemnts off of SOs, but to fully accomplish this, you will need fairly serious…

in Automatically populate data in transactions Comment by Olivier Gagnon NC Mar 15, 2016 1:13PM

Out of the box: You would need to create 1 custom form per Vendor. You would then be able to add Item List filtering so that user can only select valid items. The reason you need 1 form per vendor is that Item Filtering is not dynamic. So, if you have like 4-5 Vendors you want to do this for, this might work. If you go…

in Restrict Inventory Item by Vendor on PO Comment by Olivier Gagnon NC Jan 11, 2016 7:11AM

Olivier Gagnon NC Red Ribbon

Comments