Description:
Currently there is no way to pull an inventory report for the CSP enterprise to include issued quantities along with an inventory break out by location type code. The inquiry views include only issued, onhand, allocated, etc. and do not include a way to pull inventory by location type code.
Recommended:
Recommend a monthly data extract of the CSP enterprise inventory to include issues qty along with onhand inventory by location type to be provided. The following columns are required in this data set. See attached data dictionary for reference.
Region
Site
Warehouse
NSN
Nomenclature
Issued Qty
OnHand Qty
Repair Qty
DRMO Qty
Laundry Qty
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
Disclaimer | Accessibility