Inventory Movement Data Extract

Warehouse

USMC

Done

18-Apr-17

Description
Currently there is no way to pull warehouse inventory activity data for the CSP enterprise without having to generate and extract the data for one selected TAM, NSN, ICN, or document number at a time.  The view does not allow the search of all item inventory activity within a given time period and also does not provide the ability to pull activity for more than one warehouse.

Recommended
Recommend a monthly data extract of the CSP enterprise inventory warehouse movement transactions to be provided.  This would include all internal warehouse movements that occurred within the warehouse during the month.  The following columns are required in this data set.  See attached data dictionary for reference.

• Region
• Site
• Warehouse
• NSN
• Nomenclature
• Transaction Qty
• Serial Number
• Lot Number
• Contract Number
• Expire Date
• Maintenance Date
• Maint Due Date
• Calibration Date
• Cal Due Date
• From_Location
• To_Location
• From_Container
• To_Container
• Date
• Reason_Code
• User_ID
• Comments

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, and also improves reporting accuracy by preventing users from manually manipulating large data sets to achieve the required results.

Users
All IIF/UIF

Completed - Release 5.2 - 29 September 2017