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.