Work orders - standard reports |
Location ID and Equipment ID Columns Expanded in the Database: Effective with Release 6.0.x, location ID columns were expanded from 6 to 10 characters and equipment ID columns were expanded from 12 characters to 20 characters.
Although the location ID and equipment ID fields throughout the GUI were expanded, standard reports in the Query/Report Generator were not changed to accommodate the expansion. If you use more than 6 characters for a location ID or 12 characters for an equipment ID, you will need to modify your reports to ensure that they display the full number of characters.
Note: Using a longer location ID may increase the size of part bar codes. If a part bar code is too long, it may run off the right side of the label and become unusable.
Tip: Before you run the conversion against your production data, make sure that you run a test conversion from your current version to 6.0.x. The conversion could take a long time to complete as these expansions affect several large tables. You will need to plan how much time to set aside for your production conversion.
The following work order reports are available from the Reports list box in the Standard toolbar. For a sample of these reports, refer to the Directory of Standard Reports.
PR:WO-WAR WO SUMMARY: Lists all work orders for equipment units under warranty.
PR:WO-WO CLOSED-EQ DATE: Lists all task IDs and all associated charges for all closed work orders, by equipment ID, in a specified range of dates.
PR:WO-WO CLOSED-EQ MN: Lists all task IDs and all associated charges for all closed work orders for a range of equipment units within a specified month and year.
PR:WO—WO DETAIL: Lists, by equipment ID, all work orders opened for a range of equipment units within a specified range of dates. Some shops give this report to departments as an invoice or bill
PR:WO-WO DETAIL INT RBLD: Provides details of internal rebuild work orders, including the open and close dates, all applicable internal and commercial charges, and tasks performed.
PR:WO—WO DETAIL OVHD: Lists work order open and close dates; tasks performed; internal and commercial charges; overhead; and small parts markup charges. The work order total on this report reflects these charges. To print this report, there must be at least one posting of internal labor or parts, or commercial labor and/or parts charges to the work order.
PR:WO-WORK LOAD REPORT: Provides details of work orders, including open and close date, all applicable internal and commercial charges, and tasks. performed on internal rebuilt work orders
PR:WO-WORK LOAD REPORT: Lists work orders still open on or after a specific date.