Description
Currently there is no way to pull warehouse inventory adjustment 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 adjustments within a given time period and also does not provide the ability to pull data for more than one warehouse at a time.
Recommended
Recommend a monthly data extract of the CSP enterprise inventory adjustment transactions to be provided. This would include all inventory adjustments that resulted in a change to the location or container qty, which occurred within the month. The following columns are required in this data set. See attached data dictionary for reference.
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