SSRS Report Directory: Orders Reports

You open these reports by going to Menu > Reports - SSRS > SSRS Report Viewer > Standard Reports > AMS SSRS Report Library > Orders. Reports are listed in the order they appear in the menu.

Run the reports

Open the report from the Orders list.
Complete the fields in the Options Panel.
Select Run Report.

Report fields

Where available, you can select the report name to see a sample of the report open in a new window.

Report Name	Description	Fields
Invalid Order Numbers	This report will give you a list of all of the orders that are in the Invalid Order Number database table. The Invalid Order Number table includes orders that were deleted, cancelled, or never used. The results can be grouped by Order Number, Order Type, Status, Shop, or User.	Group By Shop Date Range Order Type Status User Name
Job Codes	This report will return a list of job codes set up in TMT Fleet Maintenance. The codes can be grouped by shop, component, component and complaint, fleet, unit and unit type. The fields displayed are Shop, Unit, Fleet, Customer, Component, and Complaint.	Group By Shop Unit Number Fleet Customer Complaint Component
Job Codes by Component	The Job Codes by Component report reports job codes by component code. Within component code, the Job codes are sorted by Job Code name.	Group By Shop Unit Number Fleet Complaint Component
Job Codes by Shop	This report displays, by shop, the job code number, description, component, complaint, fleet, unit, unit type, if it is user changeable, if it was reviewed, the estimated time and the standard repair time. The report can be sorted by job code number, component code, unit type and complaint.	Shop Unit number Fleet Unit Type Component Complaint Sort By
Order Inquiries_Campaign	The Order Inquiries for Campaigns report allows you to review campaigns.	Group By Status Shop Campaign Type Campaign Number Component Date Range Report Layout
Order Inquiries_Fuel Ticket	The Order Inquiries for Fuel Tickets report allows you to review Fuel Tickets.	Group By Shop Vendor Unit Part Order Customer Component Batch Ticket Type Fuel Type Cost Center Make Unit Status Domicile Shop Division Unit Type Department Activity Unit Customer Unit Fleet Model Model Year Boom Serial Number Qualcomm Serial Number Chassis Brand Trailer Dimensions Trailer Door Type Unit User Defined Fields 6, 7, 8 Physical Location Physical Shop Location Date Range Currency Report Layout
Order Inquiries_Indirects	The Order Inquiries for Indirect Charges report lets you review indirect orders.	Status Shop Charge Category Line Type Employee Part Number Charge Code Component Date Range Currency Report Layout
Order Inquiries_Invoice Orders	The Order Inquiries for Invoice Orders allows you to review Invoices.	Group By Currency Order Status Shop Charge Category Line Type Employee Unit Number Part Number Component Order Customer Type Order Customer Active Status Order Customer Order Customer Name Payment Type Repair Order Number Check Number Reason For Delay Reason For Repair Complaint Invoice Type Unit VIN Number Unit Cost Center Make Unit Status Domicile Shop Division Unit Type Department Activity Unit Customer Type Unit Customer Active Status Unit Customer Fleet Model Model Year Boom Serial Number Qualcomm Serial Number Chassis Brand Trailer Dimensions Trailer Door Type Unit User Defined Fields 6, 7, 8 Physical Shop Location Date Range Report Layout
Order Inquiries_Purchase Orders	The Order Inquiries for Purchase Orders allows you to review Purchase Orders.	Group By Status Shop Charge Category Line Type Vendor Unit Part Component Invoice PO Account RO Ship Via PO Type Terms Payment Type PO UDF 1, 2, 3, 4 Date Range Check Currency Report Layout Report Type Created By Closed By Remit To Vendor
Order Inquiries_Repair Orders	The Order Inquiries for Repair Order allows you to review Repair Orders. The Group By heading appears on each page of the report.	Group By Line Type Shop Domicile Shop Unit Number Unit Type Unit Status Order Status Unit Customer Type Unit Customer Order Customer Type Order Customer Vendor Employee Repair Class Repair Type Reason For Repair Reason For Delay Repair Site Cost Center Complaint Charge Category Part Component Model Model Year Make Campaign Activity Department Division Fleet Boom Serial Number Qualcomm Serial Number Chassis Brand Trailer Dimensions Trailer Door Type Unit User Defined Fields 6, 7, 8 Physical Location Physical Shop Location Vendor RO PO Number Customer PO Number Date Range Currency Report Type Layout Remit to Vendor Associated Unit Number
Order Inquiries_Transfers	The Order Inquiries for Part Transfers allows you to review part transfers between shops.	Group By Status Shop Charge Category Part Number Transfer Type Date Range Component Currency Report Layout Source Shop Destination Shop Manufacturer Part Number Transfer Method
Order Inquiries_Warranty Claims	The Order Inquiries for Warranty Claims report allows you to review warranty claims.	Group By Status Shop Charge Category Line Type Employee Vendor Unit Part Order Customer Warranty Type Warranty Status Claim Type Component RO Check Cost Center Make Unit Status Domicile Shop Division Unit Type Department Activity Unit Customer Fleet Model Model Year Boom Serial Number Qualcomm Serial Number Chassis Brand Trailer Dimensions Trailer Door Type Unit User Defined Fields 6, 7, 8 Physical Location Physical Shop Location Date Range Currency Report Layout

Report Name

Description

Fields

Invalid Order Numbers

This report will give you a list of all of the orders that are in the Invalid Order Number database table. The Invalid Order Number table includes orders that were deleted, cancelled, or never used. The results can be grouped by Order Number, Order Type, Status, Shop, or User.

Group By
Shop
Date Range
Order Type
Status
User Name

Job Codes

This report will return a list of job codes set up in TMT Fleet Maintenance. The codes can be grouped by shop, component, component and complaint, fleet, unit and unit type. The fields displayed are Shop, Unit, Fleet, Customer, Component, and Complaint.

Group By
Shop
Unit Number
Fleet
Customer
Complaint
Component

Job Codes by Component

The Job Codes by Component report reports job codes by component code. Within component code, the Job codes are sorted by Job Code name.

Group By
Shop
Unit Number
Fleet
Complaint
Component

Job Codes by Shop

This report displays, by shop, the job code number, description, component, complaint, fleet, unit, unit type, if it is user changeable, if it was reviewed, the estimated time and the standard repair time. The report can be sorted by job code number, component code, unit type and complaint.