Screen-specific 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 screen-specific reports are available from the Reports list box in the Standard toolbar.
To refine the data items that appear in the report, use the Queries/Reports -> Query/Report Generator screen. You can print these reports when you click the Printer button on the appropriate screen. If the report specifies restrictions, type the restricting value (or values) in the filter (see How to filter data).
For a sample of these reports, refer to the Directory of Standard Reports. See Appendix B of that document for information about assigning users to report groups.
RG:AUTOMATED FUEL TICKET: Data -> Equipment Activity -> Fueling -> Automated Fuel Tickets screen. Provides details of automated fuel tickets, including all accepted and rejected tickets and the actual data uploaded.
RG:EQ PM/INSPECTION: Data -> Equipment Management -> Equipment Due for PM/Inspection - by Equipment or Equipment Due for PM/Inspection - by Location screen. Lists, by department ID, equipment units that display on the screen, based on filter specifications, at the time you run the report.
RG:EQ PRIMARY: Data -> Equipment Units -> Fleet Equipment screen. Lists equipment IDs that do not have a check (ü) in the Exclude from inventory lists field on the Authorization tab of the Data -> Equipment Units -> Fleet Equipment screen.
RG:PARTS LOCATION: Data -> Parts Items -> Location Information screen. Lists all parts at a specified location. This report is designed for organizations that specify BY LOCATION in the Manage parts ordering and Economic Order Quantity (EOQ) values field on the General tab of the Data -> Parts Items -> Setup -> Options screen.
RG:PARTS ORDER MGMT CEN: Data -> Purchasing -> Parts Order Management screen. Provides a requisition order form for a specified purchase order to a vendor. This report is designed for organizations that specify CENTRALLY in the Manage parts ordering and Economic Order Quantity (EOQ) values field on the General tab of the Data -> Parts Items -> Setup -> Options screen.
RG:PARTS ORDER MGMT LOC: Data -> Purchasing -> Parts Order Management screen. Provides a requisition order form for a specified purchase order to a vendor. This report is designed for organizations that specify BY LOCATION in the Manage parts ordering and Economic Order Quantity (EOQ) values field on the General tab of the Data -> Parts Items -> Setup -> Options screen.
RG:PARTS PRIMARY: Data -> Parts Items -> Primary Information screen. Lists parts and their suffixes; short descriptions; quantities on hand and on order; and values on hand and on order. To run the report, specify one or more of the following in the filter: part ID, part suffix, inventory months, product category, parts classification, or keyword
RG:WORK ORDER CENTER: Data -> Shop Activity -> Work Order Center screen. Provides details of work orders, including the open and close dates; all applicable internal and commercial charges; and tasks performed.
RG:WORK ORDER SHORT: Data -> Shop Activity -> Work Order - Short Form screen. Lists all work orders, including their open and close dates; all appropriate internal and commercial charges; and tasks performed.