Nic: Created page with "ExcelReportLink v2020.1.1.277 was released on 10/01/2020. == Enhancements == '''MYOB AccountRight Live''' * When browsing for MYOB AccountRight Live file, it now uses a web ..."

2020-01-10T04:29:22Z

Created page with "ExcelReportLink v2020.1.1.277 was released on 10/01/2020. == Enhancements == '''MYOB AccountRight Live''' * When browsing for MYOB AccountRight Live file, it now uses a web ..."

New page

ExcelReportLink v2020.1.1.277 was released on 10/01/2020.

== Enhancements ==

'''MYOB AccountRight Live'''
* When browsing for MYOB AccountRight Live file, it now uses a web control instead of internet explorer.

'''Xero'''
* Fixed issue with xero signatures for private applications.

'''Get Data'''
* Enhanced software to default the current financial year to this year (based on system clock).
* Enhanced software to get historical journal records for MYOB Live when the data file has not been rolled over.

'''Ribbon'''
* Enhanced ribbon to be customisable.
* Enhanced publish to refresh excel ribbon.

'''Menu'''
* Updated RefreshMenu code to ensure Menu.ini file is deleted at all times.
* Updated menu to open workbook if it finds tags are missing.

'''GL Reports'''
* Devised fix for GL Pivot to ensure account user defined fields are correctly licensed.

'''Sales Reports'''
* Updated queries to fix sales person name on margin reports for MYOB live.

'''Miscellaneous'''
* Enhanced licensing to have additional warning message if choosing an edition with less functionality than required.
* Enhanced licensing dialogue to have Help button.
* Enhanced licensing dialogue to layout.
* Enhanced data file selection screen to warn when serial number is different instead of error.
* Added Send Get Data Log button to the ribbon.
* Resolved focus issues with new dialogues.
* Enhanced additional module keys to support count values.
* Enhanced refresh to relink power query data.
* Enhanced security to close all workbooks when loging out.
* Enhanced refresh to display error message if query fails.
* Enhanced refresh to display error message if data warehouse is missing.
* Fixed issue with query failing to refresh if power query not installed on older version of Excel.
* Enhanced user options to allow user to enter any number of years for historical and future count to run a get data.
* Update copyright details.

== Related Topics ==

* [[ExcelReportLink version archive]]

ExcelReportLink v2020.1.1.277 - Revision history

Nic: Created page with "ExcelReportLink v2020.1.1.277 was released on 10/01/2020. == Enhancements == '''MYOB AccountRight Live''' * When browsing for MYOB AccountRight Live file, it now uses a web ..."