Robert Nedelkow-Oracle · Oracle NetSuite Community Manager · Admin

You can view how recipients respond to your campaign events with the Campaign Response Summary and Detail reports.The following standard marketing reports are available in NetSuite: Campaign ROI Analysis Summary Report Campaign ROI Analysis Detail Report Campaign Response Summary Report Campaign Response Detail Report Lead…

You can also perform a mass update on global subscription status. This requires adding criteria in order to identify the records for update. 1. Go to List > Mass Updates > Mass Updates. 2. Under General Updates, click Company, Contact, Customer, Partner, or Vendor. 3. Set criteria for the users you want to update. 4. On…

The Help topic "Working With Google AdWords" includes an example on how to insert AdWords Conversion Tracking code into your Web site. Thanks, Rob

Does anyone know where I can find more information about setting up Marketing? You can find marketing related tutorials in NetSuite Central from the Support tab in your NetSuite account. From NetSuite Central, click on Self-Paced Training > SFA & CRM tab. Thanks, Rob

There is a topic in SuiteAnswer ID: 72890 that may help you get started - Determine the date when the payment was applied via ODBC. Scenario: Payment Received: 3/10/2015 Invoice Date: 3/15/2015 Payment applied by Accounting on 3/30/2015 In the scenario above we can easily say that the payment has been applied on the 30th…

Support filed Defect 485587 ODBC > Production > Error getting the literal value of right operand. An alternate solution to modify you query like this example may work: TO_DATE('2018-03-08 00:00:00', 'YYYY-MM-DD HH24:MI:SS')

Support filed Defect 476178: ODBC error > Transport layer security handshake failure, and Operations addressed the problem. It should now be resolved.

According to SuiteAnswers Answer Id: 13939 - https://netsuite.custhelp.com/app/answers/detail/a_id/13939/kw/odbc%20php, these also need to be installed first in the Web Server where you will be running the PHP Application connecting to ODBC. [LIST] [*]1. Visual C++ 2008 Redistributables -…

This is mentioned in SuiteAnswers Answer Id: 24833. The answer suggests using to_char to get around this: Example: Given linked server NETSUITE_LS and custom long text field CUSTOM_DESCRIPTION in transactions table OPENQUERY(NETSUITE_LS,'SELECT to_char(i.[CUSTOM_DESCRIPTION]) AS "CUSTOM_DESCRIPTION" FROM TRANSACTIONS')

There is a Currency Rates view that has the exchange rate. Thanks,

We are tracking this request in Enhancement 110513 ODBC > Mac version of the ODBC driver. Please feel free to vote for this enhancement via the NetSuite Support Center, or file a case with support. Thank you,

I use the HEX color value to display the font in green, '<div style="color:#00FF00">' || '<div align="right">' || to_char(({total}*1.1),'$99,999,999.99') || '</div>' || '</div>' Thanks,

Here's the Enhancement # for those interested in voting: Enhancement 110513 ODBC > Mac version of the ODBC driver. Thanks,

It now formats as "left justified" - is there a way to make it revert to right justified? It should work with something like, '<div align="right">' || to_char(({total}*1.1),'$99,999,999.99') || '</div>' Cheers,

You could try a Formula (Text) like to_char(({total}*1.1),'$99,999,999.99'). Thanks,

Hi Chris, The current driver is not 64 bit compatible. We are tracking this in Enhancement 116231. Thanks, Rob

Hi deeyon, The current odbc driver supports Windows only, however you can vote for Enhancement 110513 for a Mac compatible driver via the NetSuite Support Center. Thanks, Rob

You can vote for Enhancement 112864 and receive notification when it becomes available. Currently, this is a future release candidate with no eta. Thanks, Rob

The fix has been released to Defect 492686. Please download the new client and sync data to confirm.

Rek, thank you for the case number. Support is reviewing your last update. For those affected by this, please submit a case to Support and attach the outlook log files using the steps below: 1. Installation Logs a. From Windows > Run > Type in %temp% b. Look for NetSuite_for_Outlook .logs files 2. Client Logs a. In Windows…

Developers are currently reviewing the fix. Support will provide an update as soon as testing is completed and a target date is available.

Support filed Defect 465051 for this. Please submit a case and reference the defect#.

The fix has been released to Defect 492686 - download the new client and sync data to confirm. Please update your Support case if you continue to experience any issues with the new client.

I'll try to confirm the status of that version.

Check the Marketplace forum for similar offerings - https://usergroup.netsuite.com/users/forum/general/netsuite-marketplace

I'm not sure if this is related but a similar error was reported in Defect 479882 : NetSuite for Outlook > Login Credentials Window Keep Popping Up. The Sync Manager logs contains errors while retrieving records. On the Save Email Messages Pane, the following message is displayed: There was a problem searching NetSuite.…

I saw something similar recently that was resolved using the steps below. It requires a clean re-installation of NetSuite for Outlook plug-in with the latest version of the setup file: 1. Close Microsoft Outlook application. 2. Exit the NetSuite for Outlook Client add-in from the system tray. 3. Uninstall NetSuite for…

Support filed Defect 492686 : NetSuite for Outlook Client Add-in 1.0.17.11 > Outlook 2016 crashes and unresponsive. Please have your case attached and you will be notified once a fix is available.

NetSuite for Outlook is compatible with Office 365 but requires that you have a supported Microsoft Outlook version installed on your local machine. See Answer Id: 46186 for details - https://netsuite.custhelp.com/app/an...w/office%20365

Please file a case with Support and reference Defect 308471.