Steps in the screenshots correspond to the numbers in the headings.
This metric will show the number of times a part needed for a Work Order was available/allocated by the Part Need Creation Date and the Task's Planned Date. This will help to identify potential parts to stock.
HIT = If the later of the Part Need by Date / Task Plan Start Date is ON OR BEFORE the Part Need Allocation Date
MISS = If the later of the Part Need by Date / Task Plan Start Date is AFTER the Part Need Allocation Date
As usual, all reports should be run from the ATS Reporting Server. Running reports from the Web impacts the EFP Portal and Client performance the least.
1. Enter the ATS Reporting Server URL in your Internet browser address bar.
If you are having trouble accessing the report, you can do it by using the Internal ATS reporting server: https://ssrs-internal.advancedtech.com/Reports. You must be VPN'd in to access the internal server.
2. Click on the Ats_Fms_Reports folder.
3. Find the Service Level for Stocked Items Tile.
4. If you wish to add this to your favorites, click on the three dots in the upper right corner.
5. The report parameters will load will load.
6. Enter your four-digit site number.
7. Enter the Date Range you wish to view.
8. Click View Report.
9. A loading message will appear.
10. You will know that the report is building properly when the bar populates below the parameters.
11. The report builds.
12. Click on the floppy disc icon to export it to Excel.
Report fields:
- Place ID
- Place Name
- Work Order Type
- Work Order ID
- Task ID
- Part Need Status
- Part ID
- MFG Part Number
- Material Description
- Part Need Qty
- PO#
- Task Creation date
- Part Need Creation date
- Part Need by Date
- Task Plan Start Date
- Allocation Date
- Part Need Completion Date
- Stocked Item?
- Hit or Miss
0 Comments
Add your comment