Canned Reports Directory

Inventory Reports

W/H List - (to be verified)
Inventory List – A basic Inventory List shows the Part Number information including the Outbound, Inbound and Physical Stock Quantities. It also includes the Manufacturer, Category, Type and Sell Price.
Shelf Life Analysis

Shelf Life Expiration – This reports the Part Number and Locations for Expired Inventory. It lists Received and Good Till Dates, the Part Number Condition, Quantity and Cost Value.
Ref 13 – Reports the Part Number and Locations for Expired Inventory. It lists Received and Good Till Dates, the Part Number Condition, Quantity and Cost Value and is filtered by the Warehouse Reference #13 Field.
Ref 14 – Reports the Part Number and Locations for Expired Inventory. It lists Received and Good Till Dates, the Part Number Condition, Quantity and Cost Value and is filtered by the Warehouse Reference #14 Field.
Ref 15 – Reports the Part Number and Locations for Expired Inventory. It lists Received and Good Till Dates, the Part Number Condition, Quantity and Cost Value and is filtered by the Warehouse Reference #15 Field.
Parts Requite Test/Maint - (to be verified)

Inventory Aging

Weekly Aging – This report is aged from 0+, 1+, 2+ and 3+ weeks. It lists the Inventory Aged by Part number and Quantity based on the Received Dates.
Monthly Aging – This report is aged from 0+, 1+, 2+ and 3+ months. It lists the Inventory Aged by Part number and Quantity based on the Received Dates.
Quarterly Aging - (to be verified)
Yearly Aging – This report is aged from 0+, 1+, 2+ and 3+ years. It lists the Inventory Aged by Part number and Quantity based on the Received Dates.

Inventory Aging as of

Weekly Aging as of – (to be verified)
Monthly Aging as of – (to be verified)
Quarterly Aging as of - (to be verified)
Yearly Aging as of – (to be verified)

Inventory Analysis (Physical W/H) – This reports Part Numbers with their inventory information including the Serial Number, Location, Quantity, Received Dates and Costs for a specified Physical Warehouse.
Inventory Analysis (Virtual W/H) – This reports Part Numbers with their inventory information including the Serial Number, Location, Quantity, Received Dates and Costs for a specified Virtual Warehouse.
Inventory Analysis (W/O Cost) – (to be verified)
Inventory Activity – This Inventory Activity report records the last activity for a Specified Part Number. It includes the Quantity and associated Cost Value details.
Restocking Levels

Up to Min Qty – This Restocking Level report by Part Number lists its Recommended Vendor and Minimum Quantity as per the setup in the Part Number File and the Quantity and Cost Value.
Up to Max Qty – This Restocking Level report by Part Number lists its Recommended Vendor and Maximum Quantity as per the setup in the Part Number File and the Quantity and Cost Value.
Up to Opt Qty – This Restocking Level report by Part Number lists its Recommended Vendor and Optimum Quantity as per the setup in the Part NumberFile and the Quantity and Cost Value.
By Warehouse

Up to Min Qty – Lists the P/N set up for Min Qty by Warehouse.
Up to Max Qty - Lists the P/N set up for Max Qty by Warehouse.
Up to Opt Qty - Lists the P/N set up for Opt Qty by Warehouse.

Inventory Updates

Inventory Qty Updates – This report records the Inventory adjustments From Quantity Updates and lists the Warehouse, Location, Quantity, Cost and Reason & Responsibility for The change.
Inventory Cost Updates – This report records the Inventory adjustments from Cost Updates and lists the Warehouse, Location, Quantity, Cost and Reason & Responsibility.

Physical Count

Physical Count – The Physical Inventory Count report includes Part Numbers, Warehouse & Location without the Serial Numbers.
Physical Count Set 2 – This Physical Count report includes Part Numbers, Warehouse & Location with the Manufacturer Names and Serial Numbers.
Physical Count By W/H – This Physical Count report includes the Part Numbers & Quantities and filters by Warehouse and Location without Serial Number.
Physical Count By W/H Set 2 – This Physical Count report includes the Part Numbers, Quantities, Manufacturer Name and Serial Numbers and is filtered By Warehouse & Location.
Physical Inventory Value – The Physical Inventory Value report includes the Part Number, Warehouse, and Location & Quantities. It also lists the Cost Value Of the part – without Serial Numbers.
Physical Inventory Value Set 2 – The Physical Inventory Value Set 2 report Includes the Part Number, Warehouse, Location, and Manufacturer Name & Quantities. It also lists the Cost Value of the part – with Serial Numbers.
Physical Discrepancies Value – The Physical Discrepancies Value report Includes the Part Number, Warehouse and Location & Quantities. It also Lists the Cost Value as well as any discrepancy value pertaining to that Part Number.
Physical Count Invalid Entries - (to be verified)
Physical Inventory Blank Format 1 – This Physical Inventory Blank format Report can be printed with the Bar Code. This report does not list the Serial Number information.
Physical Inventory Blank Format 1 Set 2 – This Physical Inventory Blank Format report can be printed with the Bar Code. This report includes the Manufacturer Name & Serial Number information.
Physical Inventory Blank Format 2 – This Physical Inventory Blank 2 format Report includes the Part Number, Warehouse, Location and Quantities. It also Includes the Warehouse Reference Numbers.
Physical Count History - (to be verified)

Global Inventory Value:

Cost Value – The Global Inventory Cost Value Report lists each Part Number with its Warehouse, Location, Quantities and the Cost Value of the Part.
Sell Value – The Global Inventory Cost Value Report lists each Part Number With its Warehouse, Location, Quantities and the Sell Price of the Part.
Inventory Values as of (not activated is Work Orders are involved) - (to be verified)
Complete Inventory Values as of - (to be verified)

Global Inventory Value (Short Version)

Cost Value - (to be verified)
Sell Value - (to be verified)

Warehouse Transfers:

Warehouse Transfer Register In – This reports the Warehouse Transfer Document Number with the corresponding information pertaining to where The Part Number(s) were transferred in to.
Warehouse Transfer Register Out – This reports the Warehouse Transfer Document Number with the corresponding information pertaining to where The Part Number(s) were transferred from.
Warehouse Transfer Journal In – This reports the Warehouse Transfer Document Number with the corresponding information pertaining to where The Part Number(s) were transferred in to as well as its associated Costs.
Warehouse Transfer Journal Out – This reports the Warehouse Transfer Document Number with the corresponding information pertaining to where The Part Number(s) were transferred from as well as its associated Costs.

Capability List – This reports the In-House Capability and Type by Part Numbers. It Also includes the P/N Description, Delivery Days & Preferred Vendor Name as per the Part Number Set up.
Bill Of Materials – This report lists the Part Numbers Bill of Materials as per the Setup in the Part Numbers File.
Parts X-Reference – This report lists the Part Number X-Reference Parts as per the Setup in the Part Numbers File. It includes X-Reference Type & Quantity in Stock.
Inventory Management

ABC Analysis – The ABC Analysis reports the basic information on the Part Number, Descriptions & Class with Consumption Rate & Percentages.
Inventory Cycle Count – The Inventory Cycle reports all Part Numbers with The option of printing Bar Codes running on an As Of date Basis.
Min/Max Analysis - Last 12 Months – This Min/Max Analysis reports the Minimum, Maximum And Optimum Quantities for a given Part Number as well as the Average Demand of the part.
Demand Forecasting

Forecasting - Simple Average - This report can be run by part number and lists the simple average demand of that part in different modules by monthly periods.
Forecasting - Moving Average - This report can be run by part number and lists the moving demand of that part in different modules by monthly periods.
Forecasting - Exponential Smoothing - This report can be run by part number and the period weight percentage as well as the project increase in demand Percentage. It lists the average demand for a part by monthly periods and the Forward forecast of this part.

Booked Parts – This report lists the current Booked Part Numbers in the system Along with the Document and Customer the booking is allocated for. It also includes the Warehouse and/or Location and Quantity of Booked Parts.
Expired Manuals – This reports the parts Manual information as far as its Last Reviewed, Revised and Current Till Dates sorted by Part Number.

Sales Reports

Customers

Customers List – This is a basic report listing the Customer Accounts Name, Address, Account Number and Phone Numbers.
Invalid VAT Registration – This reports the Customer Account(s) VAT Registration Number, Status and Valid Till Date as per the setup in the Customer File.
Account Credit Limit – This report breaks down the Credit Limit for the Selected Customer Account(s) by the open documents in the system for the Account and lists the Open Credit, Used Credit and Credit Balance.
Non Active Customer – This report will lists the Customer Accounts which are Currently inactive or not being used.

Quotes

Quote Statistics – This reports the Quote line(s) statistics by the Quote Lines Quoted Value and the actual lines sold value.
Quote Line Statistics - (to be verified)
Quote Line Status – This reports the Quote line statistics and the line Status.
Quote Journal - (to be verified)
Quote From Customers \ Vendors – This Quote report can be run by date, Quote No. or Account No. It lists the Quote lines, statistics and Value Quoted & Sold.
Quote \ Sold To Customers –This Quote report lists in detail the Quote Lines And its Value Sold percentage by line statistics.
$ Quotes Vs. $ Sold – This report breaks down the percentage of Quoted Value versus Sold Value.
Quote Worksheet – The Quote Worksheet report shows the total breakdown Of the line(s) and the information pertaining to the Part Number. Also the Customer and Contact information.

Sales Orders

S.O. Register – The Sales Order Register can be filtered by Date, Orders or Customers. It lists the Sales Order Header details.
S.O. Register (Not Acknowledged) – This report is identical to the S.O. Register with the exception that it only lists those Sales Orders that were not Acknowledged, shipped and closed.
S.O. Journal – The Sales Order Journal is similar to the Register being that It can be filtered by Date, Customer or Sales Order among others yet it Focuses more on the Sales Order Line details.
S.O. Analysis – This Sales Order Analysis report shows the detailed Information pertaining to the Sales Order and the Part Number Stock info.
Open S.O. Expedite – This report focuses on the Sales Order Lines and the Quantity open not shipped to the Customer.
Open S.O. – Sales Vs. Cost By Salesperson –This report is broken down by Sales Person and lists the Sales Order Lines cost and gross profit.
Blanket Order Expedite –This report focuses on the Blanket Sales Order Lines details and can be run by date, Customer Account or by Sales Order.
Blanket Order Analysis – This report focuses on the Blanket Sales Order Header, Lines, and Part Numbers and costs details.
Open SO Profit – The Open Sales Order Profit report lists the Breakdown of each Open Sales Order Line and its Gross Profit according to Its Cost and Sell Price.
SO Profit by Line Cost - (to be verified)
Summary Sales By Salesperson (1) – This reports by Salesperson, their Number of sales and sales totals in summary format.
S.O. Cross P.O. Profit – This reports the Sales Orders and their converted Purchase Orders details including the cost, sell price and gross Profit as well as the average profit.
S.O. Worksheet – The Sales Order Worksheet report shows the total Breakdown of the line(s) and the information pertaining to the Part Number. Also the Customer and Contact information.
Shortage – The Shortage Report lists the Sales Order lines Quantity On back order. This report is sorted by part number.
Shortage By Sales Order – The Shortage Report lists the Sales Order lines Quantity on back order. This report is sorted by Sales Order.
Merchandise Gross Profit By SO – This report is a full detailed Gross Profit report which lists in detail the Sales Order lines, Purchase Order Lines with the Merchandise Price and Cost Gross Profit breakdown.
Sales Order Project Analysis – This detailed report is sorted by Sales Order And lists the estimated and actual costs and gross profit percentage of each Order.
Sales Order Project Summary – This is a summarized report of the Sales Order Project Analysis.
SO Changes - (to be verified)
Customer X-Ref List - (to be verified)

Sales Receiving

Receiving Register – The Sales Receiving Register reports the Sales Receivers And its Customer Account, Warehouse and status information.

Shipping

Shipping Register – The Pick Ticket Register is a list of Pick Tickets by Customer Account No. listing the Sales Order Header Details.
Shipping Journal – The Pick Ticket Journal focuses more on the Pick Ticket Line details and Part Number information.
Parts Ready To Ship

Complete Qty Only – Reports the details of a Pick Ticket where the Total quantity of parts on the order is available in stock.
Parts Ready to Ship - (to be verified)
Parts Ready to Ship Ver Two - (to be verified)
Available Parts Ready to be Reserved - (to be verified)

Pick Ticket Manifest – The Pick Ticket Manifest report includes the bar Codes and UID numbers for the Pick Tickets.

Invoicing

Invoice Register – The Invoice Register can be filtered by date, Customer, Sales Invoice among others. It lists the Sales Invoice Header details.
Invoice Register - Currency Discrepancy - (to be verified)
Invoice Journal – The Invoice Journal is similar to the Register being that it Can be filtered by date, Customer, Sales Invoice among others. It lists the Sales Invoice Line details.
Sales Invoice Misc. Charges - This report lists the details of the Sales Invoice Miscellaneous Charges i.e. Freight, Shipping and Packaging.
Invoice Tax \ Misc. Register – This report lists the details of the Sales Invoice Miscellaneous Charges and the Tax Charges breakdown.
Invoice Tax \ Misc. Journal – This report lists the details of the Sales Invoice Line Miscellaneous Charges i.e. Freight, Shipping and Packaging.
Invoice Profit

These reports print out the Gross Profit Breakdown according to the Sell Price Of the part and the original Cost Value. The Invoice Profit Report has multiple formats for viewing the details pertaining to the part and Invoice as listed below.

The Gross Profit Formula is as follows:

Mdse Total x 100% / Total Cost = Gross Profit %

By Sales Order Line Cost – This report lists the Sales Order Line Details converted to the Invoice and the part number details.
By Invoice Line Cost – This report lists the Sales Invoice Line details And the part number information.
By Warehouse Bin Location Cost – This report can be run to get the Sales Invoice Gross Profit Breakdown by Warehouse and Location.
By Cross PO – This report lists the Sales Order and converted Purchase Order details.
Period Profit (Invoice/RMA/Line Type) –This report summarizes the Invoice Details and lists any pertaining R.M.A. information.
Invoice Profit by Cost/RMA Cost/ with On Hand Value - (to be verified)
Work Order Misc Invoices Profit by W/O Cost - (to be verified)
Sales Order Invoice Profit by W/O Cost - (to be verified)

Salesperson Commissions (1…5) – This Salesperson Commission reports For each Salespersons the Commission Percentage as per the Customer File setup. It also Includes the Sales Invoice dates and MDSE totals.
Salesperson Commissions – This Salesperson Commission reports by each Salesperson to list their Commission Percentage as per the Customer File Setup. It also Includes the Sales Invoice dates and MDSE totals.
Commission Class A – This report lists the Customer, Delivery and Ordered Dates, Unit Prices and OEM information for each Invoice.
Salesperson Commissions By Gross Profit – This report calculates all Salesperson Commission Percentages as well as the Gross Profit Percentage for Sales Invoices.
Salesperson Commission by Gross Profit (by Line) - (to be verified)
Invoices Summary by Salesperson (1) – This list summarizes by Salesperson the total amount of the Sales Invoice and the average Commission amount per Invoice.
Point of Sale - (to be verified)
Invoices by Purchasing Details - (to be verified)

R.M.A. Register – The R.M.A. Register can be filtered by date, Customer, R.M.A. among others. It lists the R.M.A. Header details.
R.M.A. Journal – The R.M.A. Journal is similar to the Register being that it Can be filtered by date, Customer, R.M.A. among others. It lists the R.M.A. Line details.
R.M.A. Tax \ Misc. Register – This report lists the details of the R.M.A.Miscellaneous Charges and the Tax Charges breakdown.
Parts Owed To Us – This R.M.A. report lists the open R.M.A. that have Been issued for Customers but the parts have not been received into stock.

Call Tracking – This reports function is to print out the Call Tracking activity based on the actual Call Tracking documents entered into the system. This report will include by Customer Account Number the Dates, Call Tracking details & status.
Point of Sale by Customer - (to be verified)
Point of Sale - (to be verified)

Purchase Reports

Vendors

Vendor List – This is a basic report listing the Vendor Accounts Name, Address, Account Number and Phone Numbers.
Tax Exempt Vendors – This reports the Vendor Tax ID, Certification and Survey information as per the setup in the Vendor File.
Non Active Vendors – This report will list the Vendor Accounts which are Currently inactive or not being used.
Remit Bank Account Changes - (to be verified)

R.F.Q.

Vendor Bids Statistics – This reports the R.F.Q. Line(s) statistics for the Lines with actual Vendor Bids and the value of the actual lines bought.
R.F.Q. Lines Status – This reports the R.F.Q. line statistics and status.
R.F.Q. Lines By Category – This report can be run by an R.F.Q.(s) for the Line details by Part Number Category.

Purchase Orders

P.O. Register – The Purchase Order Register can be filtered by Date, Orders of Vendors. It lists the Purchase Order Header details.
P.O. Register (Not Acknowledged) – This report is identical to the P.O. Register with the exception that it only lists those Purchase Orders that were Not acknowledged, Received into Stock and closed.
P.O. Journal – The Purchase Order Journal is similar to the Register being That it can be filtered by Date, Vendor or Purchase Order among others yet It focuses more on the Purchase Order Line details.
PO Journal - Single Line Format - (to be verified)
Maintenance PO Journal - (to be verified)
Maintenance PO Journal/Notes - (to be verified)
Open P.O. Expedite – This report focuses on the Purchase Order Lines and The Quantity open not Received into Stock.
Parts On Repair Aging – This report lists the Repair Purchase Orders Sent out to Vendors for Repair along with the Purchase Shipper. It lists the Aging by days and months it takes for that part to be returned into Stock.

Shipping

Purchase Shipping Register – The Purchase Shipping Register can be Filtered by Date, Vendor or Repair/Exchange/Process Orders among Others. It lists the Header details.
Purchase Shipping Journal – The Purchase Shipping Journal focuses more On the Purchase Shipper Line details and Part Number information.
Purchase Shipping Parts on Repair Value – This reports the Unit Cost and Value Out Of the Part at the time it was shipped to Vendor by Part Number.

Receiving

Receiving Register – The Purchase Receiving Register can be filtered by Date, Vendor or Warehouse among others. Its list the Header details.
Receiving Journal – The Receiving Journal focuses more on the Purchase Receiver Line details and Part Number information.
Receiving Journal and Open Converted Doc – This Receiver Journal Focuses more on the Receiver Line details and Part Number information as Well as the information linking the Receiver to the allocated Sales Order it Was specifically Purchased for.
Receiving Journal and Vendor Added Cost - (to be verified)
Receiving Excluded Amount - (to be verified)

Invoicing

Invoice Register – The Invoice Register can be filtered by date, Vendor, Purchase Invoice among others. It lists the Purchase Invoice Header details.
Invoice Register - Currency Discrepancy - (to be verified)
Invoice Journal – The Invoice Journal is similar to the Register being that it Can be filtered by date, Vendor, Purchase Invoice among others yet it Focuses more on the Purchase Invoice Line details.
Invoice Misc. Register – This report lists the details of the Purchase Invoice Miscellaneous Charges i.e. Freight, Shipping and Packaging.
Invoice Tax \ Misc. Register – This report lists the details of the Purchase Invoice Miscellaneous Charges and the Tax Charges breakdown.
Invoice Tax \ Misc Journal - (to be verified)
Purchasing Invoices Taxes - (to be verified)
Purchase Invoice Domestic Taxes - (to be verified)

Claims

Claims Register – The Claim Register can be filtered by date, Vendor, Claim Among others. It lists the Claim Header details.
Claims Journal – The Claim Journal is similar to the Register being that it Can be filtered by date, Vendor, Claim among others. It lists the Claim Line Details.
Claims Tax \ Misc. Register - This report lists the details of the Claim Miscellaneous Charges and the Tax Charges breakdown.
Claim Journal - Single Line Format - (to be verified)

Operations Reports

Work Orders

Work Order Register – This reports the basic information for a given Work Order i.e. Part Number, Components, Dates, Quantities and Unit Prices also Including Serial Numbers and Work Order Types.
Work Order Register by A/C – This Register has the basic information for a Given Air Craft Work Order i.e. Part Number and Components, Dates and Quantities. Also including Unit Prices and Serial.
Work Order History – This report summarizes the information for a Work Order including the Type and Charges.
Work Orders Cost Distribution – This reports the Costs Distribution by W/O.
Work Orders Global Cost Distribution - (to be verified)
Work Orders Parts & Cost as of - (to be verified)
Work Orders Cost / Charge Distribution – Detailed – This report lists the Costs Distribution by W/O including the details on the Operations and Total Cost/Charges per W/O.
Work Orders Cost / P&M Distribution - Detailed - (to be verified)
Work Order Profit – This is a detailed report calculating the Gross Profit by the total Unit Price for the Work Order Unit. This includes the total Costs and Charges from Parts, Material and Labor.
Work Order Profit Single Line Format - (to be verified)
Work Order Consumption Analysis – This report analysis by Part Number The Total Quantity Requested, Allocated, Reserved and Used with Costs.
Work Order Parts Availability – This report lists the Part Numbers Physical Stock Availability and Status as well as the Average and Costs.
Work Order Reserved Parts – This report lists the total Quantities Reserved For a given Work Order.
Work Order Pending Parts – This report lists the total Work Order Parts Quantities in Pending Status.
Work Order Parts Status - (to be verified)
Work Orders Turn Around – This report lists the Work Order Turn Around Time which is counted between their Enter & Ship dates for a given W/O.
Parts Used By W/H (removed from stock) – This report lists by Warehouse, and shows the Part Number, Quantity & Unit Price as well as the Status of the Operation if was Used for.
Work Order Details – This report lists the details of the W/O with Operations & Work Centers. It also lists the Regular, Overtime and Total Hours worked.
Work Order Charges Analysis – This report analysis in details the total Charges, Operations, Dates, Hours and Costs Codes.
Work Order Charges Analysis Actual vs Budget – This report lists the Budgeted and Actual Hours & Costs used on a given Work Order in details.
Work Order Charges Analysis Actual vs Budget Summary – This report Summarizes the Budgeted, Regular, Overtime & Actual Hours & Costs used on a given W/O.
Work Order Charges Analysis Actual vs Plan Summary - (to be verified)
Work Order Labor / Material Costs – This report lists by W/O the total Accumulated & Budgeted Labor, Parts & Material & Outside Services Costs.
Work Order Labor / Material Costs + Overhead (Burden) - (to be verified)
Work Order Cost / Overhead (Burden) - Summary - (to be verified)
Work Order WIP – This report lists the Work Order Status, Cost Code and Costs details for the Work In Progress by a given Work Order.
Work Orders not Shipped or not Invoiced:

Work Orders not Invoice and not Shipped – This report lists the Part Number and Work Orders which have not been Shipped or Invoiced To Customer. It includes Serial Numbers.
Work Orders Shipped but not Invoiced – This report lists the Part Number and Work Orders which have been Shipped to Customer But not Invoiced. It includes Serial Numbers.
Work Orders Invoiced but not Shipped – This report lists the Part Number and Work Orders which have been Invoiced to Customer But not Shipped out. It includes Serial Numbers.

Work Order Shop Floor Status – This report lists by Work Order- the Current Operation and Status. It includes Serial Numbers.
Work Order Status – Summary Statistic – This report runs by an As Of Date & lists by W/O Status- Totals & Average Orders by Month and Year To Date.
Work Order Status Report – Grouped By W/O Status Code – This report Lists by W/O- the Operation and Shop Status with Serial Numbers.
Tools Required by Work Order – This report lists the Tooling information for the Parts/Tools of a given Work Order.
General Parts Consumption:

Detail – This reports the Part Number, Quantity and Unit Price Details for those which were used in a given Operation.
Summary – This report summarizes the Part Number, Quantity and Unit Price for those used in a given Operation.

MRP Reports:

BOM / Parts:

MRP Report by W/O BOM – This Materials Requisitions Planning Report is based on Work Order Bill of Materials for Open Work Orders Only. It includes the Part Number, Quantities and Costs.
MRP Report by W/O BOM and Parts Net Availability – This Materials Requisitions Planning Report is based on Work Order Bill Of Materials and Parts Net Availability for Open Work Orders Only. It includes the Part Number, Quantities, Status and Costs.
Kit MRP by W/O and Parts Stock Availability - (to be verified)
MRP Report by Work Order – This Materials Requisitions Planning Report is based on Work Order Bill of Materials. It lists by Work Order the Part Number, Quantities and Cost details.

Tooling:

Tooling MRP Sorted by Tool P/N - (to be verified)
Tooling MRP Sorted by W/O Header - (to be verified)

Master Scheduling and MRP:

Lead Time - (to be verified)
ATP-Available to Promise - (to be verified)
MRP Logic - (to be verified)

Employee Labor Reports:

Employee Working Hours – For the total Dates and Hours a User has put in on a Work Order.
Employee Hours/Cost Details – For the total Hours, Dates And Cost a User has put in on a Work Order.
Employee Hours/Charges Details Report – For the total Regular Hours and Overtime Hours Costs for each User.
Employee Training History - (to be verified)

W/O Installed/Removed Parts (By Aircraft):

Parts Installation –Lists the Work Order and Part Number Information for the parts Installed in a selected Aircraft.
Parts Removal – Lists the Work Order and Part Number Information for the parts Removed from a selected Aircraft.
All Parts –Lists the Work Order and Part Number information For the parts Installed in and Removed from the selected Aircraft.

Work Order Quantity Finish – This reports the Part Quantity Finished on a Work Order including Dates & Cost.
Work Order Worksheet – The Work Order Worksheet filtered by Work Order Will list the Sales and Purchase History, Warehouse information, Cost, Quantities and Serial Numbers for the selected Work Order Part Number.
Work Order Traceability - (to be verified)
Work Order Operations Cost - (to be verified)
Work Order Employee Assignment - (to be verified)
Work Orders Ready for Assembly/Completion Detail - (to be verified)
Work Order Status - (to be verified)
Work Order Excluded Amount - (to be verified)

Maintenance:

Employee Labor Reports:

Maintenance Only:

Employee Working Hours - (to be verified)
Employee Hours/Cost Details - (to be verified)
Employee Hours/Charges Details - (to be verified)
Employee Training History - (to be verified)

Maintenance and Work Orders:

Employee Working Hours - (to be verified)
Employee Hours/Cost Details - (to be verified)
Employee Hours/Charges Details - (to be verified)
Employee Training History - (to be verified)

Employee Labor - (to be verified)
Maintenance Employee Labor - (to be verified)
Work Center Billable vs Non-Billable Time - (to be verified)

Maintenance WIP - (to be verified)
Maintenance Cost Distribution - (to be verified)
Maintenance Cost / Charge Distribution - Detailed - (to be verified)
Maintenance Charges Analysis:

Maintenance Charges Analysis - (to be verified)
Maintenance Charges Analysis Actual vs Budget - (to be verified)
Maintenance Charges Analysis Actual vs Budget Summary - (to be verified)

Maintenance Profit Analysis - (to be verified)
Maintenance Consumption Analysis - (to be verified)
Maintenance Parts Availability - (to be verified)
Maintenance Reserved Parts - (to be verified)
Maintenance Pending Parts - (to be verified)
Maintenance Parts Required - (to be verified)
Maintenance Installed / Removed Parts - (to be verified)
Maintenance Cards Summary - Cost / Charges / Profit - (to be verified)
Maintenance Cards Summary - Hours - (to be verified)
Maintenance Cards Summary - Costs - (to be verified)
Maintenance Cards Discrepancy - (to be verified)
Maintenance Cards History - (to be verified)
Parts Used by W/H (Removed from Stock) - (to be verified)
Maintenance Employee Assignments - (to be verified)
Tools Required by Maintenance - (to be verified)
MRP Reports:

Parts:

MRP by Maintenance Parts Net Availability - (to be verified)
MRP by Maintenance - (to be verified)

Tooling:

Tooling MRP Sorted by Tool P/N - (to be verified)
Tooling MRP Sorted by Maintenance Header - (to be verified)

Maintenance Traceability - (to be verified)

Flight Operation:

Flight Operation Schedule - (to be verified)
Crew Flight Schedule - (to be verified)
Passenger Flight Schedule - (to be verified)
Flight Log Plan vs Actual - (to be verified)
Aircraft Flight Log - (to be verified)
Plan Flight Schedule List - (to be verified)
Flight Leg Fuel and Oil Usage - (to be verified)
Cancelled Flight Logs - (to be verified)
Aircraft Defects Report - (to be verified)
Aircraft Deferred Cards - (to be verified)
Trend Monitoring - (to be verified)

FBO:

Fuel Meter Justification Report - (to be verified)
Fuel Sales Spreadsheet Report - (to be verified)

Record Keeping:

Aircraft Installation/Removal:

Aircraft Installation Register - (to be verified)
Aircraft Removal Register - (to be verified)
Installation Journal - (to be verified)
Removal Journal - (to be verified)

Aircraft Status - (to be verified)
Aircraft Sparing - (to be verified)
Aircraft Components Status - Retired Parts - (to be verified)
Aircraft Inspection List - (to be verified)
Engine/Assembly Inspection List - (to be verified)
Engine/Assembly Components Inspection List - (to be verified)
Aircraft Unit Inspection List - (to be verified)
APU Inspection List - (to be verified)
Aircraft Work Order - (to be verified)
Aircraft MEL Expiration - (to be verified)
Forecasting:

By Aircraft - (to be verified)
By Engine/Assembly - (to be verified)
By Unit - (to be verified)
By Engine/Assembly Component - (to be verified)
Maintenance Due - (to be verified)
Aircraft Projection/Forecasting for A/C Fleet Only - (to be verified)
Aircraft Projection/Forecasting for A/C Configuration Only - (to be verified)
Aircraft Compliance - (to be verified)

Weekly Scopes Schedule - (to be verified)

Exchanges:

Core Parts To Be Sent For Repair – This reports the details on Inventory Which has been received by an R.M.A. and is due to be sent out for Repair.
Cores Owed To Vendors – This reports the details of the Claims created in the System for which Core parts are due to be sent to the Vendor.
Customer Core Aging – This reports the Core part not yet received back from The Customer which have been entered in an R.M.A.
Customer Core Aging Range – This reports the Core part not yet received Back from the Customer with the aging due by days and months.

Leases:

Customer Lease Aging - (to be verified)
Customer Lease Aging Range - (to be verified)

Employee / Security:

Employee List – This is your basic Employee List which can be sorted by User. It lists the Users Skill, Title and current status.
Employee Skill - (to be verified)
Employee Cards – An employee card is printed per each User. It includes The general information details listed in the User File.
Employee Security Settings – This reports by User the Login Security Settings entered in the User File.
Security Groups List – This report lists the assigned Users in the current Security Groups set up.
Groups Security Assignments – This report lists the Security Groups Assignments, the Table names and how the Tables are restricted.
Users Not Assigned to Security Groups - (to be verified)
Mandatory Fields Assignments - (to be verified)
Security Components - (to be verified)

Employee Attendance (ETS/ETSA):

Employee Payroll Form – A basic Payroll Form which can be printed by User/Employee and Work Dates.
Employee Payroll by Users Salary Hrs - (to be verified)

Employee Attendance (ETS-TA):

Daily Activity - (to be verified)
Employee Attendance - (to be verified)
Employee Attendance by Users Salary Hrs - (to be verified)
Employee Attendance vs Working Hours - (to be verified)
Attendance Updates - (to be verified)
Daily Utilization - (to be verified)
Labor Schedule - (to be verified)
Schedule vs Actual - (to be verified)
Hours Worked Detail - (to be verified)
Hours Worked Summary - (to be verified)
Attendance Balances - (to be verified)
Employee Listing - (to be verified)
Employee Scheduling Task - (to be verified)
Employee Assignment - (to be verified)

Employee Training:

Open Training By Employee – This reports each Employee Training Information including their Skill, Course, and Training Facility & Date.
Open Training By Course – This reports each Employee Training Information including their Skill & Training Facility by Training Course.
Course Planning - (to be verified)
Employee Skills Expiration - (to be verified)
Users OJT Comparison - (to be verified)
Completed Employee Training Courses - (to be verified)
Incomplete Training by Employee - (to be verified)

Tools:

Tools List – This reports the Part Numbers in Inventory which are setup For Tooling. It includes Inspection status and scheduled Calibration.
Tools List 2 - (to be verified)
Work Orders Tools Usage History - (to be verified)
Maintenance Tool Usage History - (to be verified)
Tool Status and Allocation - (to be verified)

Lot Management:

Lot (Virtual W/H) Shipping Journal – This Shipment Journal reports the Shipping and Picking activity by the selected Lot Warehouse.
Lot (Virtual W/H) Invoice Journal – The Invoice Journal reports the Picking And Invoicing activity for Customers by Inventory and Lot Warehouse.
Lot (Virtual W/H) Summary – This report summarizes the Lot Warehouse Received vs. sold activity including the GL Account.
Lot (Virtual W/H) Cost/Profit – This Cost Profit report calculates the original Quantity vs. quantity sold profit percentage by Lot Warehouse.
Lot (Virtual W/H) Cost/Profit Returns – This report calculates the Cost Profit By Lot Warehouse including the factor for Inventory that has been returned.
Lot (Virtual W/H) Activity/Profit – The Activity/Profit report calculates the Cost Profit by Lot Warehouse and includes the documented detailed information.
Lot (Virtual W/H) Qty Balance Status - (to be verified)

Consignment Management:

Consignment (Virtual W/H) Shipping Journal – The Shipment Journal reports The Shipping/Picking activity Inventory to/from a Consigned Warehouse.
Consignment (Virtual W/H) Invoice Journal – The Invoice Journal reports the Picking and Invoicing activity for Consigned Inventory to the Customers.
Consignment (Virtual W/H) Summary – This report summarizes the Consigned Warehouse received vs. sold activity including the GL Account.
Consignment (Virtual W/H) Cost/Profit – This Cost Profit report calculates The original quantity vs. quantity sold profit percentage for Consigned Inventory by Consigned Warehouse.
Consignment (Virtual W/H) Cost/Profit Returns – This report calculates the Cost Profit of Consigned Inventory by Warehouse and includes the factor for Those parts which have been returned.
Consignment (Virtual W/H) Activity/Profit – The Activity/Profit report Calculates the Cost Profit for Consigned Inventory and also includes the Documents detailed information.
Consignment (Virtual W/H) Activity/Profit Analysis - (to be verified)
Consignment (Virtual W/H) Activity/Profit Split – This report calculates Cost Profit with the documented activity for Consigned Inventory and includes the Details on Consigned Inventory to be returned to the Consignee and any Costs associated with the returns and repairs of those parts.

Publication:

Applications - (to be verified)
Manuals - (to be verified)
Drawings - (to be verified)
Bulletins - (to be verified)
Directives - (to be verified)

FRACAS (Failure Reporting Analysis and Corrective Actions)

Mean Time Between Overhaul - (to be verified)
Mean Time Between Repair - (to be verified)
Mean Time Between Maintenance - (to be verified)

Quality CAR:

Quality CAR Status Report - (to be verified)

Import / Export License:

Import License Report - (to be verified)
Export License Report - (to be verified)
Import / Export License Expiration Date Report - (to be verified)

Flight Reservation:

Cargo Flight Information - (to be verified)
Passengers Flight Information - (to be verified)
Cargo Cancellation List - (to be verified)
Passengers Cancellation List - (to be verified)
Monthly Summary Status per Country (Passengers and Cargo) - (to be verified)
Aircraft Utilization - (to be verified)
Monthly Flight Cancellation - (to be verified)
Customer Project List - (to be verified)

Financial Reports

Accounts Receivable:

Receipts By Bank Account- The Cash Receipts register which must be Filtered by Bank Account and lists the Cash Receipts dates, status and amount information as well as the Customer it was received from.
Deposit Register – The Deposit Register lists the Deposits created in the System to correspond with its allocated Accounts Receivable Checks Including the dates and amounts.
All Receipts Register – The All Receipts Register is similar to the Cash Receipts Register with the exception that it also includes all types of Accounts Receivables i.e. Checks, Credit Cards, Wire Transfers, E.F.T. and Cash Receipts with their dates and amounts information.
Customer Credit Register (As Of) – This is an As Of report which lists the Open Credits issued to Customers which are created from R.M.A. or Advance Receipts from Customers.
Customer Credit Register (Status) – This report is run by a specific date Range opposed to the As Of Register. It lists the Credits issued to Customers which are created from R.M.A. or Advance Payments to Customers.
Account Aging – This is the basic Customer Account Aging report. It can be Run in details or summarized to list the outstanding Customer Invoices by Aging Range.
Accounts Receivable Analysis As Of – This report analyses the Customer Balances owed and its aging range in summary.
Balance Activity – This report can be run by Customer to list in detail the Different types of document transactions and their document status.
Customer Activity Summary - (to be verified)

Accounts Payable:

Check Register – The Check Register includes all Accounts Payable checks Filtered by bank account with its dates, status, amounts and Pay To info.
Other Accounts Payable – This Payables Register includes all other Accounts Payable documents i.e. Wire Transfers, E.F.T., Cash Payments And Credit Card Payments with their date, amount and status details.
All Accounts Payable – This report must be filtered by bank account to Include all Accounts Payable from Checks to Other Payables with their Dates, Pay To and amount details.
All Accounts Payable Journal - (to be verified)
Our Credit Register (As Of) – This is an As Of report which lists the open Credits issued by Vendors which are created from Claims or Advance Payments to Vendor.
Our Credit Register (Status) – This report is run by a specific date range Opposed to the As Of Register. It lists the Credits issued by Vendors which Are created from Claims or Advance Payments to Vendors.
Account Aging – This is the basic Vendor Account Aging report. It can be run In details or summarized to list the outstanding Vendor Invoices by aging Range.
Account Payable Analysis As Of – This report analyses the Vendor balances Owed and its aging range in summary.
Balance Activity – This report can be run by Vendor to list in detail the Different types of document transactions and their document status.
1099-Misc – Run this report by Vendor and/or Fiscal Year. Although this is Not where you actually print the 1099, the report lists in details the different Types of charges for the specified Vendors 1099 Miscellaneous Forms.
Vendor Activity Summary - (to be verified)

General Ledger:

Chart Of Accounts – This is a detailed report on your General Ledger Codes And Their begin balances
G/L Accounts – This is a detailed report which includes the General Ledger Account Tables and their assigned General Ledger Codes.
Journal Entry List – This detailed report lists the transactions that occurred For (a) selected Journal Entry. It includes the Debit, Credit, and Document Date & Post to Date as well as notes on the Journal Entry.
Journal Entry Journal - (to be verified)
Transactions As Of – This report will list all Debit/Credit Transactions to The General Ledger Codes and the Account balances by a specified As Of Date.
Transactions Journal – This report will list all Debit/Credit Transactions To the General Ledger Codes and the Account balances for a specific time Period or date ranges.
Transactions Journal by State/Line Ref - (to be verified)
Document Transactions Journal – This report will list all Debit/Credit Transactions to the General Ledger Codes and the Account balances for a Specific time period or date ranges focusing on the actual document detail.
Journal Entries by Reference - (to be verified)
Transaction Currency Differences – This General Ledger report lists by General Ledger Code the currency differences which may occur in Transactions with converted currencies. It lists the currency factor & date as Well as the debit and credit balances.
A/R G/L Account Currency Differences - (to be verified)
A/P G/L Account Currency Differences - (to be verified)
Trial Balance – The Trial Balance can be run in details or summarized and is an As Of Date Filtered report. This report includes the previous balance, current activity and ending Balance for the listed General Ledger Codes.
Account Posting Transactions – This General Ledger report reflects the Posted transactions in detail as far as debits and credits, how the Transaction affected the General Ledger.
G/L Transaction Matching - (to be verified)
G/L Trans Posting by Financial Group Code and Document - (to be verified)

Sales Tax:

Sales Tax Journal - (to be verified)
Sales Tax Journal by VAT Code - (to be verified)
Sales Tax Journal by VAT Code 2 - (to be verified)
Sales Tax Summary - (to be verified)
Sales Tax Journal by Group - (to be verified)
Sales Tax Summary by Group - (to be verified)

Cash Flow Forecast:

Receivable Forecast – This report forecasts your receivables by Sales Orders with the weekly and monthly periodic receipts data.
Payment Forecast – This report forecasts your payments by Purchase Orders with the weekly and monthly periodic payments data.

Recurring Entries/Invoices:

Recurring Journal Entries – Lists the Recurring Journal Entries which have Been setup and created in the system with their current status.
Recurring Sales Invoice Register – Lists the Recurring Sales Invoices which Have been setup and created in the system with their current status.
Recurring Purchase Invoice Register – Lists the Recurring Purchase Invoices which have been setup and created in the system with their current Status.

Financial Reports As Of – This is where you run your customized Financial Statements i.e. Balance Sheet & Income Statement.
Cost Accounting:

Cost Accounting Journal - (to be verified)
Cost Accounting Statistics - (to be verified)

Administration Reports:

Financial Grouping List – This detailed report lists the Financial Groups Setup up for creating the Financial Statements and also includes their Assigned General Ledger Codes.
Financial Report Setup – This detailed report shows the current setup of a Selected Financial Statement without balances.

Fixed Assets:

Active Assets - (to be verified)
Sold Assets - (to be verified)
Open Depreciation - (to be verified)
Fixed Assets Balance - (to be verified)

Subsidiary Detail to G/L Comparison Reports

Transaction with Incorrect Status - (to be verified)
Subsidiary Inventory Detail to G/L Comparison - (to be verified)
Subsidiary Inventory Detail to G/L Comparison by Document Type - (to be verified)
Unbalanced WIP Entries - (to be verified)
Unbalances Receiver Entries - (to be verified)
Inventory Value by W/H - (to be verified)
Inventory Cost Comparison between Stock - Documents - General Ledger - (to be verified)
Inventory Cost Comparison between Stock and Documents - (to be verified)
Inventory Price Adjustment Posting Analysis - (to be verified)
Inventory Value Changes Summary - (to be verified)
Inventory Value Changes Detail - (to be verified)

Payment Statistics

Customer Payment Statistics - (to be verified)
Vendor Payment Statistics - (to be verified)

Statistics Reports

Sales Statistics

Top Customers by Sales Orders – The Top Customer by Sales Orders report can be filtered to show the top 10, 20, 30 +, etc. Customers Sales Order activity etc. It Calculates the totals for the current fiscal year.
Top Customers by Sales Invoices – The Top Customer by Sales Invoices report can be filtered to show the top 10, 20, 30 + Customers Invoice activity, etc. It calculates the totals for the current fiscal year.
Top Partnumbers by Sales Orders – The Top Part Number by Sales Orders report Can be filtered to show the top 10, 20, 30+, etc. Part Number activities by the Sales Orders the Part Number occurs in. It calculates the totals for the current fiscal year.
Top Partnumbers by Sales Invoices – The Top Part Number by Invoices report can be filtered to show the top 10, 20, 30+, etc. Part Number activities by the Invoices the Part Number occurs in. It calculates the totals for the current fiscal year.
Customer Shipping/Rejection – This report includes the Sales Order and Pick Ticket lines, with the details on the Quantity Shipped and Quantity rejected and Sent back from the Customer via R.M.A.

Purchasing Statistics

Top Vendors by Purchase Orders – The Top Vendors by Purchase Orders Can be filtered to show the top 10, 20, 30 + etc. Vendors by the Purchase Order activity. It calculates the totals for the current fiscal year.
Top Vendors by Purchase Invoices – The Top Vendors by Purchase Invoices report can be filtered to show the top 10, 20, 30+ etc. Vendors by Purchase Invoice activity. It calculates the totals for the current fiscal year.
Top Part Numbers by Purchase Orders – The Top Part Numbers by Purchase Orders report can be filtered to show the top 10, 20, 30+ etc. Part Numbers by Purchase Order activity. It calculates the totals for the current Fiscal year.
Top Part Numbers by Purchase Invoices – The Top Part Numbers by Purchase Invoices can be filtered to show the top 10, 20, 30+ etc. Vendor By Purchase Invoice activity. It calculates the totals for the current fiscal Year.
Vendor Receiving/Rejection – This report includes the Purchase Order and Receiver lines, with the details on the Quantity Ordered and Quantity rejected and sent back to the Vendor by Claim.

System General Reports

Tables Printing – Lists the Table names, Codes and their Descriptions for the General Administration Tables currently in your system.
Calls Category – Lists the different types of Call Categories used in the Call Tracking system.
Inventory Category – Lists the Part Number Categories Currently set up on your System.

Advanced Management Reports

Stock Reorder Point Report – Use this list to view Part Numbers which have reached their Reorder Point as per the setup in the Part Number File. This report has 5 Methods of Calculation:

Max Consumptions Per Time Unit
Percentage of Growth
Safe Time (Time Units)
Statistic – By an Equal Division of Demand
Statistic – For a Divided Amount of Issues From The Storage House

Sales Order Profit Analysis – This is a full detail report to see Sales Order Profits. It includes the Sales Orders, Lines, Mdse Total and Cost as well as detailing the Purchase Order the S.O. is linked to with Quantity, Date, Shipping Duty & MFG.
Booked Sales Orders – Run this report to view a summarized list of Sales Orders which have been booked including the various activities the Order was Booked for. Also includes the Gross Profit, Margin and the total number of Orders.
Open Sales Orders – Run this report to view a summarized list or Open Sales O Orders not yet shipped along with the Sales Order currency rate and Cost. It also includes the Resale amount and Gross Profit & Margin.
Shipped Sales Orders – Run this report to view a summarized list of Sales Orders which have been shipped out to Customers but that haven been Invoiced. It also includes the Cost, Resale Price and Gross Profit and Margin.
Shipped Orders Profit – This report is more detailed than that of the Shipped Sales Orders report. It lists the Cost, Allocated Cost and Allocated Resale Price, Gross Profit and Margin as well as the Currency base on a Sales Order.
Gross Profit Breakdown – This report summarizes the Gross Profit Breakdown for all Sales in the system.
P&M Forecast Requirement for Maintenance and Repair - (to be verified)
Tool Forecast Requirement for Maintenance and Repair - (to be verified)

Warranty Administration Reports

Warranty Administration – This is a more detailed than that of the Warranty Expiration were is also including the Serial Number, Document information for each Part Number as well as the Warranty Expiration Date.

FRACAS (Failure Reporting Analysis and Corrective Actions) Reports

Mean Time Between Failures (MTBF) - (to be verified)
Mean Time Between Maintenance (MTBM) - (to be verified)
Mean Time Between Repair (MTBR) - (to be verified)
Mean Time Between Inspection (MTBI) - (to be verified)

[More information may be obtained from Pentagon 2000 Technical Support]

AEROSPACE • DEFENSE • ELECTRONICS • POWER SYSTEMS • METALS• DEFENSE • ELECTRONICS • POWER SYSTEMS • METALS
		Canned Reports Directory