Versions Compared

Old Version 10

changes.mady.by.user Malcolm Mackay

Saved on

compared with

New Version 11

changes.mady.by.user Malcolm Mackay

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

7 March 2017

Implementation

This release incorporates changes a number of changes and enhancements to the Xero and MYOB integrations.  Where Xero or MYOB integration is operational, the following scripts should also be executed as part of the installation:

  • Install_WBInterface_Scripts.sql on the WBInterface database.
  • wb_Install_Workbench_WBI_Scripts.sql and wb_Install_Workbench_WBI_Exports.sql on the Workbench database.

These scripts can be found in the MYOB and Xero Integration folder in Resources.

New Features

Xero Integration

  • Profit Centre Analysis can now be provided in Xero by populating a Profit Centre Tracking Category when exporting. See Xero Profit Centre Analysis

MYOB Integration

Feature Revisions

Xero Integration

  • Where a Xero Contact is both a customer and supplier, a single Company record is now created in Workbench with the same AP and AR account codes. Previously separate Company records were created for the Contact's AR and AP accounts.
  • A problem with Xero customers being imported to Workbench as suppliers, and suppliers as customers, has been fixed.
  • On exporting AR and AP invoices, any zero line quantities are set as 1, as Xero does not allow zero line quantities.  Previously some contract claims could fail to export because they had zero quantities on lines.
  • Previously export batches could get stuck in a Processing state. Now exports go to Error status if they are not processed within 10 minutes.

MYOB Integration

  • The AR Invoice details are now populated with the Job description concatenated with the Invoice title.
  • On AP Invoice exports the Supplier name now populate into the Memo field.
  • Previously export batches could get stuck in a Processing state. Now exports go to Error status if they are not processed within 10 minutes.

Contract Claim Schedules

  • Previously claim schedules created from Web Workbench were not visible in the MDE. This has been amended.
  • Schedule lines now have a Section column which can be used for grouping lines when printing schedule reports.

Companies

  • The Address Name field that is visible when clicking “More…” is always defaulted with the company name, and if a different description is required then it must be edited.

Jobs

  • Creating a new job manually with the copy job Masterfile option now also copies the BudgetActivityGroupCode and ForecastActivityGroupCode fields.  This provides compatibility with MDE functionality.
  • The Contract Type is no longer mandatory in Job creation.

Service Logs

  • All data entry on a Service Log now has the Job on the Log Header applied - there is no longer any job selection at the line level.  Once transactions have been entered on a log, the job on the Log Header cannot be changed.

Purchase Orders

  • The Purchase Orders List now correctly filters according to Profit Centre Groups.

Emailing

  • If an email processed by the Email Engine fails, because of an invalid email address for example, the sender is sent an email notifying the error.

API

  • The logic around the processing of AP Invoices through the Workbench API has been changed.  Previously the Purchase Order Line, to which the AP Invoice Line is being applied, would be completed if the outstanding quantity OR outstanding value were zero.  Now the outstanding quantity is ignored and completion is based only only there being a zero outstanding value.
  • Processing of AP Invoice Lines against negative Purchase Order Lines has been enabled.
  • File attachments consisting of a URL link are now saved with the correct ObjectType so they can be opened correctly from the MDE.