eFactoryPro Wiki

4.18 Is there a report that will help me determine which parts I should stock? (Service Level Report)

Updated on

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

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Previous Article 4.17 What is the purpose of the Active/Inactive Report?
Next Article 4.19 Is there an easy way to check to see which parts are missing the Refill Flag in the Stock Record?