Updated Oct 12: Fixed links to Buyer and Provider Activity Report Samples at the bottom
In our upcoming v4.3 release (scheduled for mid-October), we’re making some significant changes in buyer and provider Activity Reports. These reports are used by many buyers and providers for offline tracking of both open and closed work orders, and some of these users have even built Excel macros that use the data in these reports.
*The nature of these changes will break most macros, and will require all buyers and providers to review their reports to ensure that they contain all of the data they depend upon.*
h1. Information Groups
One of the big changes to Activity Reports is that we are consolidating the selection of columns that can be displayed in a report into “Information Groups”. The purpose of Information Groups is to collect all related information together, while simplifying the Activity Reports interface.
!http://blog.onforce.com/wp-content/uploads/2007/09/activity-report-screenshot.jpg!
When you select an Information Group, all columns contained in that Information Group will appear in the Activity Report. For example, if you select the Feedback Information Group, the columns Buyer Rating, Provider Rating, Buyer Comments, and Provider Comments will all appear in the Activity Report.
The Information Groups displayed in the screenshot above contain the following columns, in the listed order:
*Work Order ID*
Work Order ID
*Buyer Information*
Created By (_buyer only_)
Closed By (_buyer only_)
Buyer Company Name (_provider only_)
*Provider Information*
Provider ID
Provider Name
Provider Company Name (_buyer only_)
*Work Order Status*
Status
Sub-Status
*Work Order Dates*
Service Date
Appointment Date
Date Created (_buyer only_)
Date First Routed (_buyer only_)
Date Accepted
Date Completed
Date Closed
Date Cancelled
*Work Order Description (pre-v4)*
Title
Service Category
Service Subcategory
Model #
Operating System
Serial #
Manufacturer
*Work Order Description (v4)*
Title
Tasks
*Work Order Pricing*
Pricing Method
Spend Limit (US$)
Initial Spend Limit (US$)
Hourly Rate (US$)
Parts Included
*Work Order Location*
End User Name
End User Phone (_buyer only_)
Location Name
Location City
Location State/Province
Location Zip/Postal Code
Location Country
*Work Order Custom Fields*
Custom Fields (_buyer only_)
Custom Fields for Provider (_buyer only_)
Custom Fields (_provider only_)
Buyer Custom Fields (_provider only_)
*Work Order Completion Information*
Resolution Notes
On-Site Dates
Total Hours On Site (calc.)
Hours Worked
*Work Order Service Fee*
Access Fee (US$) (_buyer only_)
OnForce Commission (US$) (_provider only_)
Parts Total (US$)
Labor Total (US$)
Other Total (US$)
*Taxes (US)*
Access Fee GST (US$) (_buyer only_)
Sales Tax (US$)
Service Tax (US$)
*Taxes (Canada)*
Access Fee GST (US$) (_buyer only_)
Service Fee GST (US$) (_provider only_)
Nova Scotia HST (US$)
New Brunswick HST (US$)
Newfoundland/Labrador HST (US$)
British Columbia PST (US$)
Alberta PST (US$)
Saskatchewan PST (US$)
Manitoba PST (US$)
Ontario PST (US$)
Quebec PST (US$)
Prince Edward Island PST (US$)
OnForce GST Number
Provider GST Number (_buyer only_)
*Feedback*
Buyer Rating
Provider Rating
Buyer Comments
Provider Comments
We’ve also removed the following columns, since they are easily calculated in Excel using the expanded information columns available in the new reports.
*Buyer Activity Reports*
Total Charges
Total Credits
Time Frame
*Provider Activity Reports*
Closing Charges
Amount Paid
Time Frame
h1. Re-ordered Columns
To ensure that the columns in each Information Group appear properly, we’ve re-ordered the columns in the Activity Report so that all of the columns in a given Information Group appear together.
h1. Sample Excel Export Spreadsheets
You can download sample Excel spreadsheets that show all of the columns in the buyer and provider Activity Reports:
“Buyer Activity Report Sample Excel Spreadsheet”:1
“Provider Activity Report Sample Excel Spreadsheet”:2
h1. Saved Activity Reports
We will upgrade all saved Activity Reports to be compatible with our new Activity Report format. Once upgraded, a saved Activity Report will contain any Information Group that contains the columns that were in the old saved Activity Report. If you have any saved Activity Reports, please check them when v4.3 is released to ensure that they contain all of the information you need.
_*If you use Excel macros on any saved Activity Reports, or you depend upon the particular columns and column order in a saved Activity Report, you will have to update your macros or other systems to handle the new formats.*_ The sample Excel Export spreadsheets provided above should assist you in updating any systems.
[1]http://blog.onforce.com/wp-content/uploads/2007/10/buyer-activity-report-sample.xls
[2]http://blog.onforce.com/wp-content/uploads/2007/09/provider-activity-report-sample.xls