ExcelReportLink v2017.11.2.213

ExcelReportLink v2017.11.2.213 was released on 15/11/2017.

Enhancements

Reports

Streamlined ExcelReportLink reports to all have fields selection.
Enhanced ExcelReportLink GL Pivot to have separate Budget Analysis and Trial Balance report.
Optimised ExcelReportLink GL Pivot Profit and Loss Report and Balance Sheet Report.
Added Monthly Trial Balance report to GL Pivot.
Added Cash and Cash CD CR version to GL Pivot.
Enhanced saving reports to be clearer about creating custom reports.
Enhanced upgrade process to also pull XLSB workbooks.

Get Data

Enhanced get data log to always show blank values.
Fixed issue with skipping mechanism and removing unwanted data being incorrect.
Enhanced get data process to show most/all messages in task bar for easy activation.
Updated get data to display XERO error messages during get data process
Updated get data with XERO to ensure the access granted lasts the full 30 minutes to minimise the need to authorise multiple times.

MYOB AccountRight Live

Fixed issue with XERO and MYOB Live with UNC path causing get data to fail when processing scripts.
Enhanced get data for MYOB AccountRight Live to detect server hosting file on the cloud and using it to improve performance.

Xero

Fixed issue with XERO and MYOB Live with UNC path causing get data to fail when processing scripts.
Updated get data with XERO to ensure the access granted lasts the full 30 minutes to minimise the need to authorise multiple times.

Miscellaneous

Updated Menu to default to close workbooks when navigating.
Enhanced licensing prompts to include product name or edition name and version number.
Added prompt to default company name when testing data file connection.
Enhanced licensing to identify custom report.