ExcelReportLink v2016.1.4.163
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.