ExcelReportLink v2020.1.1.277
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.