Design Goals
We designed Connectorly for WorkflowMax and Microsoft Power BI to make it easy to report across the full WorkflowMax financial data set. We had the following goals:
An easy-to-understand WorkflowMax data structure that provides full access to your data...
that works across multiple WorkflowMax Organisations so that you can report at the aggregate level...
and even if you wish to report on your WorkflowMax and Xero data together.
To achieve these goals we have both simplified and substantially enriched the raw data that comes from WorkflowMax, which are structured into Tables as described below.
Tables
Contacts
Contacts are the Individuals that are transacted with.
Customers
Customers are the Organisations that are transacted with. They may be Suppliers or Clients.
Invoices
Invoices that are related to the jobs.
Jobs
Provide details of the jobs.
Leads
Leads and lead activities.
Purchase Orders
This table provides details of the purchase orders.
Quotes
Quote details.
Tasks
Full details of the job-related tasks.
Times
This table provides details of the staff time entries.