Create an Unformatted Work Order report which displays when a work order is assigned to a crew The ability to assign WO's has already been complete you just need to create the report that displays the information.
Add a button to the assign work order form to display the report mentioned above when you click on it.
Create a report that displays the information already displayed in the open work order form. This report should be called the open work order report.
New order Entry form
-WO
-Property ID
-Address
-Client
-Zipcode
-Assigned date from Client
-Entered Date (auto)
-Original client request (attachment)
-Client Comments
-(if it is an initial create a -1 WO and a -2)
[saves to a temporary file for review before posting to database, no posting double entries, auto produce report on contradicting entries]
Unassigned Work Order Form
-WO(static)
-Property ID (static)
-Address (Static)
-Zipcode (static)
Crew(pull-down)
Account Manager's comments
Account manager's Activities request
Assigned Date (auto)
Estimated completion date
Add Activity types
Client
Type
Rate
Unit of measure
Adjust Property ID form
Property ID (static)
Address
Zipcode
Zipcode to City table
Open Work Order Report
WO
Property ID
Address
Client
Work Order Status
Date
Due Date
Comments
Account Manager
Work Order Processing Form
-WO(static)
-Property ID (static)
-Address (Static)
-Zipcode (static)
Assigned Crew (Static)
AM requested Activities (static)
AM Comments (static)
Estimated completion date (static)
Assigned by
Actual Activities
Field Comments
Inventory Items Used
Due Date extension (y/n)
Due date extension (date)
Arrival time (time)
Completion time (time)
Photos taken
Link to photos taken
Cubic Yards Removed (on trashouts)
Dumpster ordered (on trashouts)
Photos for each activity (server location)
Length x with (if grasscuts)
Type of Trip charge(if trip charge)
[track trip charges by property id]
Update Crews Form
Employee
Supervisior
Crew
Work Order Completion Report
Work Order
Activities Performed
Due Date
Field Comments
Date Completed
Post completion comments
Admin Processing Form
Work Order
Property ID
Address
Due Date
Date Completed in the field
Photos Uploaded By
Do photos support work?
Location of scanned backup (server location)
Post Completion comments
Work Order Revenue Estimate Report
Work Order
Property ID
Actual Activities
Revenue
Total Revenue
Daily Revenue Estimate
Assigned date
Completion date
WO
Total Revenue
Daily revenue
Daily rev goal
Weekly Revenue Report
Assigned date
Completion date
WO
Total revenue
Weekly revenue
YTD revenue
MTD revenue
Annual Revenue Goal
Monthly Revenue goal
Weekly Revenue goal
Daily revenue goal
Amount over the goal
Amount over x 3%
Bid form
Activities
Cost per activity
Date of initial bid
Date assigned to 180
Estimated completion date
Sub estimate
Estimated revenue
Upload Monthly Janitorial
Upload Triweekly addresses
Monthly Work orders by type
Monthly zipcodes
Vehicle Maintenance report
Inventory Usage Report
Estimated Net Income Report
Invoicing Form
WO
Property ID
Invoice Number