Current Release

SmartClient 2.2.2

Click here to get the latest version.

New Features:

  • Record types Project Task, Gift Certificate, Gift Certificate Item, Assembly Build, File and Entity Group have been added.
  • The SmartClient installer for Office 2007/2010 now deploys a Excel Template file (.XLTX) rather than a Excel Workbook file (.XLSX). The user is now able to create multiple SmartClient documents with ease.
  • Fields values in NetSuite can now be cleared (set to empty) when updating records.
  • Non-drop down columns can be associated with an Excel expression for calculating their field values.
  • Status message to display the progress during a lengthy search and download has been added.
  • Items > Price Matrix now supports the standard layout. This allows the user to select which columns and/or price levels,
    she wants to use, with the price matrix.
  • Items > Price Matrix will add Excel formula based on the discount field, ensure the discounted prices are auto calculated.
  • Cell context menu command to refresh the list of drop down items from NetSuite.
  • Now supports NetSuite SuiteTalk WSDL 2010.1. The SmartClient is now therefore, able to fully support Slaved fields.
  • Result Template associated with a NetSuite Saved Search can be changed using the Search Wizard.
  • Log Out feature added. Useful in ensuring changes to NetSuite permissions are propagated to the SmartClient without having to wait for the Web Services session to expire.
  • Excel 2010 32 bit and 64 bit editions are now fully supported.

Changes:

  • Optimized caching mechanism and UI tweaks to enable more control over the cache. The SmartClient no longer pull down the entire cache from NetSuite at once. Cache is created only on demand.
  • Seamlessly uploads records with large number of line items by breaking them up to smaller batches.
    • Added an option to turn off this feature if desired.

Key Bug Fixes

  • Deleting a standard worksheet, causes unexpected COM exceptions on Excel 2007 version of the SmartClient.
  • Supports protecting worksheets.
  • SC installer will detect whether the user is attempting to run the setup as a non-administrator and exit with a proper error message.
  • Updating non-keyed sub-lists resulted in duplicated lines.
  • “Database is Locked” error displayed during caching.
  • Minor changes and bug fixes.
  • Added a fix to prevent Excel from formatting Text fields (such as Item ID) as numbers.

Known Issues and Limitations

  • Item Options List is not supported.
  • Matrix Options List is not supported.
  • The SmartClient is only able to download drop down values for fields that appear on the default NetSuite form for the
    current login. If a field that is not on the default form needs to be used as either Free Text, Real-Time Lookup, Cached Lookup
    or a Drop Down, that field should be added to the NetSuite form first. ‘Free Text (Internal Id)’ and ‘Free Text (External Id)’
    type fields do not have this limitation.
  • Slaved fields cannot be updated using “Updated Selected cell(s)” feature unless the master field too is selected.
  • If you create a table with large number of rows (e.g. 200), but use only several rows to add records (e.g. add only 50 records) leaving the remainder of the table blank; pressing Update All will cause a “Out of Memory” error. In a situation like this, you need to select the specific records and use “Update Selected Rows” option.

Other Changes

  • If the submission of a bug fails due to network issues, the SmartClient will now save the contents of the report as a zip file on the user’s Desktop. The user may then email the report manually to Celigo Support.
  • The Options window now contains an Troubleshooting tab that allows the user to turn on Web Service Logging on the SmartClient. The user may turn on WS Logging before executing an operation that’s causing errors. Once logged, the WS operation data is automatically included when the user submits a bug report. WS Logging excludes user passwords at all times.
  • User can choose whether line level validation errors blocks the entire record from being sent back to NetSuite through the Options dialog box.
  • The SmartClient will now ignore lines marked with line IDs of -1 (as requiring a refresh), and attempt to update the record with lines that are newly added or those that didn’t upload due to validation errors. This allows the users to correct errors in data and update the records more easily.
  • Additional hooks added to resolve the InvalidCastException thrown by VSTO intermittently.
  • Fixed a bug that caused the “Starts With” operator to be ignored while retrieving data from the cache.
  • Added special validation for resolving numeric IDs (e.g. for Entity / Transaction IDs) on Free Text (Validate on Send) and Real-Time Lookup fields.