On-Hand Inventory Data Extract

Warehouse

USMC

Removed

27-Mar-17

Description:
Currently there is no way to pull on-hand inventory data by location for the CSP enterprise without having to generate and extract the data one warehouse at a time.

Recommended:
Recommend a monthly data extract of the CSP enterprise on-hand inventory to be provided.  The following columns are required in this data set.  See attached data dictionary for reference.
Region
Site
Warehouse
Location ID
Location Type
NSN
Nomenclature
On-Hand Qty
Serial Number
Lot Number
Contract Number
Expire Date
Maintenance Date
Maintenance Due Date
Calibration Date
Calibration Due Date

Mission Critical:
Yes, this data is needed for monthly and ad-hoc reporting requirements, to help maintain inventory accuracy and assist the CSP Program Management Office personnel in operational decisions. 

Benefits:
Having this data will reduce time/cost by preventing users from having to complete multiple steps to get the information needed to fulfill monthly and ad-hoc reports.

Users:
All IIF/UIF

17Nov2017 – cancelled per Jack Sanders
These requirements are now supported or no longer needed.