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