ExcelReportLink v2016.1.4.163

From ExcelReportLink Wiki
Jump to navigation Jump to search

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