DPAS SCR: 02085

• SCR Number
  02085
• Title
  Historic Inventory Level Repository
• DPAS Module
  Warehouse
• Reporting Organization
  USMC
• State
  New
• History
  11/26/2024
• Description
  Change Request: New System Process

  
  Description: Currently, the system does not provide the ability to check the On-Hand Inventory status for previous dates. This is due to DPAS being a live system, where assets are constantly moving. As a result, researching inventory history, whether for routine inventory processes or resolving discrepancies, becomes impossible. To address this challenge, I propose the introduction of a Date Field to the Inquiry Screens for LIN/TAMCN, Stock Number, and ICN. This would allow users to pull inventory data for a specific location and view its status (e.g., quantity on hand) on any given date. Alternatively, another solution could be the implementation of a historical repository to capture and store inventory status at different points in time. This would provide a reliable way to track and query the inventory history as needed. The proposed enhancement will improve Users from ALL Agencies using DPAS ability to manage inventory discrepancies, streamline reporting processes, and ensure more accurate inventory auditing.

  
  Recommended: Recommendation 1: Add a Date Field to the Inquiry Screens Introduce a Date Field to the Inquiry Screens for LIN/TAMCN, Stock Number, and ICN. This enhancement would allow users to select a specific date and view inventory data as it appeared on that day, including the status of assets, quantities, and other relevant details. By enabling this functionality, it would be possible to track historical inventory movements, improving visibility and accountability. OR Recommendation 2: Implement a Historical Repository Develop a new historical repository that stores and tracks inventory data at specific points in time. This repository would allow users to pull detailed reports for previous dates to verify status information such as asset counts, quantities, contract IDs, and other key inventory details. By providing access to this historical data, it would become easier to resolve discrepancies and perform inventory audits efficiently. Both options aim to enhance inventory tracking and reporting capabilities, addressing the challenges of monitoring inventory history in a live system.

  
  Mission Critical: This process improvement will help immensely in the researching of discrepancies and researching for inventory accuracy.

  
  Benefits: This will help ALL agencies operating in DPAS as a whole to better manage and verify inventory accuracy and research any possible discrepancies.

  
  Frequency: Daily

  
  Users: Users across all agencies operating in DPAS.