Nic: Created page with "ExcelReportLink v2016.1.4.163 was released on 27/01/2016. This released was focused on Sales Pivot, Purchases Pivot and Payroll Pivot. == Enhancements == '''Get Data''' * Fi..."

2016-01-27T03:40:27Z

Created page with "ExcelReportLink v2016.1.4.163 was released on 27/01/2016. This released was focused on Sales Pivot, Purchases Pivot and Payroll Pivot. == Enhancements == '''Get Data''' * Fi..."

New page

ExcelReportLink v2016.1.4.163 was released on 27/01/2016. This released was focused on Sales Pivot, Purchases Pivot and Payroll Pivot.

== Enhancements ==

'''Get Data'''
* Fixed get data issue where it removed tables beginning with LINKED_ if the name turned out to match one existing endpoint.
* Enhanced get data process to add aditional times during get data logging.
* Added new table type called ""Standard Journals Data"" and ""Standard Totals Data"" to further control get data queries.

'''Meta Data'''
* Added new STANDARD_Employees table.

'''Sales Pivot'''
* Re-engineered STANDARD_SalesTransactions queries to use STANDARD META DATA for MYOB Classic.
* Added STANDARD_SalesOrders, STANDARD_SalesOrderJournalRecords.
* Fixed YTD columns on the Last Year Analysis report.
* Fixed cost of sales calculation on the Sales Margin Reports.

'''Purchase Pivot'''
* Re-engineered STANDARD_PurchasesTransactions queries to use STANDARD META DATA for MYOB Classic.
* Added STANDARD_PurchaseOrders, STANDARD_PurchaseOrderJournalRecords.

'''Payroll Pivot'''
* Added EmployeeCardID, EmployeeCustomList1, EmployeeCustomList2, EmployeeCustomList3, EmployeeCustomField1, EmployeeCustomField2, EmployeeCustomField3, EmployeeIdentifiers to STANDARD_PayrollTransactions table and STANDARD_PayrollJournalRecords table.
* Added WeekIndex, WeekName, WeekFYear, WeekNameDisplay to STANDARD_PayrollTransactions and STANDARD_PayrollJournalRecords table.
* Removed CardID and CardName from STANDARD_PayrollTransactions and STANDARD_PayrollJournalRecords table.
* Updated ExcelReportLink Payroll Pivot Solution reports to use new fields.

== Related Topics ==

* [[ExcelReportLink version archive]]

ExcelReportLink v2016.1.4.163 - Revision history

Nic: Created page with "ExcelReportLink v2016.1.4.163 was released on 27/01/2016. This released was focused on Sales Pivot, Purchases Pivot and Payroll Pivot. == Enhancements == '''Get Data''' * Fi..."