Steps in the screenshots correspond to the numbers in the headings.
Inventory Management is a vital piece of your business. Having the right part available at the right time is crucial to Operational Excellence. There will be times when it is a good idea have a part on hand for an extended period of time: for example, a Critical 1 Spare with an Extended Lead Time to Purchase. However, there is also a cost to carrying inventory, and the Active/Inactive Report will help determine which parts have been issued from your site within the last 365 days.
This report will display information for all locations at your site.
DEFINITIONS: (Issued = On a Work Order or through Misc Adjustment)
- ACTIVE: Has been issued within the last 365 days.
- INACTIVE NEW: Has been received into stock within the last year and not been issued within last 365 days.
- INACTIVE SLOB: Has been in stock for more than 1 year and has not been issued within the last 365 days.
- UNKNOWN: Has no movement at all.
1. To run the report, enter to the SSRS Reporting Server in your URL.
Running the report through the SSRS Server provides the greatest performance
2. Click on the ATS_FMS_Reports folder.
3. Choose Active/Inactive Inventory from the list.
4. To mark the report as one of your favorites, click on the three dots in the upper right corner of the tile.
5. Click the star to add the report to your Favorites.
6. Enter your four-digit site number.
7. All the possible available locations appear.
8. Click Select All to deselect all.
9. Select the appropriate locations for your site.
10. Click off the box to confirm your selection.
11. Click View Report.
12. A loading message will appear.
13. You will know the report is populating correctly when the bar below the parameter populates.
14. The Report loads.
15. If you wish to export the Report to Excel, click on the floppy disc icon and choose Excel from the drop-down list.
Fields include:
- Site
- Ownership
- Location
- Part ID
- OEM
- MFG Part #
- Description
- QOH
- Moving Average Cost
- Status
0 Comments
Add your comment