DPAS SCR: 02183

• SCR Number
  02183
• Title
  Cost of Inventory Report
• DPAS Module
  Warehouse
• Reporting Organization
  USCG
• State
  New
• History
  9/2/2025
• Description
  Change Request: Process Improvement

  
  

  Description:

   

  Uniform Distribution Center (UDC) needs a report to show the total value of all stock on hand for the entire warehouse like the one attached from their current Integra system. The Unit Cost should represent the 'cost' of the goods.  The report needs to be made available within the Materiel Mgmt and Warehouse Mgmt applications.

   

  Recommended:

   

  The report should contain the following criteria filters: Grand Total by Type Asset Code and Grand total of all.  Select specific Stock Nbr(s) to display in report.  The report should provide for all warehouses, or for specific selected warehouses. For equipment, it should be the actual cost as the Unit Cost, and for OM&S, it should be the actual cost paid using the Moving Average Cost methodology to determine the current on hand cost.  When displaying specific Stock Nbrs, the report should display Stock Nbr, Item Desc, Serial Nbr, Lot Nbr, Condition Cd, Qty, Unit Cost and Total Cost. Add a Stock Status Report to the Real-Time Reports tab in the system.  When displaying specific Stock Nbrs, include Qty On Hand

   

  Mission Critical:

  USCG has a requirement to know the cost of their inventory for financial purposes.

   

  Benefits:

   

   

  This change would allow UDC to obtain a dollar value of the stock on hand.

  
  

  Frequency: 

  Monthly

  
  

  Users: 

  This report will not only benefit USCG, but all ELMS users.