DPAS SCR: 01535

• SCR Number
  01535
• Title
  Physical Inventory Inquiry
• DPAS Module
  Warehouse
• Reporting Organization
  USMC: CSP
• State
  Done
• History
  Submitted: 2 Aug 2019
• Description

  Description
  Currently it is very difficult to locate the last Table of Authorized Material Control Number (TAMCN) or Stock Number inventory date.   Unless the user has manually recorded the Physical Inventory number for every TAMCN and Stock Number as they complete,  there is no simple way to locate that information within DPAS.  As part of our annual FISCAM audit process, the auditors request of the last inventory dates of selected TAMCN and stock numbers.   Without this capability, it is very difficult to meet this audit requirement. 

  Recommended
  Recommending that a Physical Inventory Inquiry by enterprise level be created to make researching when the required physical inventories were conducted on TAMN's and Stock Numbers.  At a minimum this inquiry should have the following columns: Logistics Program, Region, Site, Warehouse, TAMN, Stock Number, Item Description, Physical Inventory Number, Expected Qty, Counted Qty, Difference Qty, Date of Inventory, User ID.  If the physical inventory required that an Inventory reconciliation to be conducted, then the Inventory reconciliation document number, the date of the reconciliation and user id should also be included in the query.

  Mission Critical
  This is mandated by FISCAM audit.  Inventory must be verified against last annual inventory date. 

  Benefits
  This improves accountability and audit readiness of DPAS.  

  Users
  All IIF & UIF.  All services and entities required to undergo FISCAM audits would benefit from this SCR. 

  Completed -- Release 2021.2 - 28 May 2021