My Stuff
Comments
-
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.
-
This is currently being evaluated to confirm NetSuite for Outlook compatibility with Windows 10. Please have your Support case attached to Enhancement 351440 NetSuite for Outlook > Windows 10 Compatibility.
-
Defect 321848 should be fixed as of Client Build 1.0.15.21. What version of the client are you running?
-
A Google search returns a few hits surrounding CLR20r3 errors. It may be a local security policy issue or related to anti-virus.
-
Some feature areas are not available in sandbox accounts including Outlook Integration. A good reference for Administrators is available in SuiteAnswers Answer Id: 26883, NetSuite for Outlook Administrator's Guide. Thanks,