Physical Inventory History Inquiry

Warehouse

Leidos

New

Submitted: 15 May 2019

Description
Right now, the only way to pull a list of completed Physical Inventories is to go to each Warehouse and do it one by one on each Warehouse. This is not very feasible for our users to have to go to each warehouse. We will need to develop a history inquiry that users can search on Physical Inventories as needed.
Request from NSWC:
Can you guys pull a listing of all the 'CRC - Closed - Reconciled' Physical Inventories for LP's NSWC WH and NSWC WH Armory. Since there is no way for us to do this as the end user LP wide, Justin suggested we submit a ticket to make this happen.
We will need the following fields for this data pull:

• Condition Cd(s)
• Cost Center
• Established By
• Established Dt/Tm
• Expected Completion Dt
• Facility/Facilities
• ICP Physical Inv Nbr
• Interface System Cd
• Inv Execution Type
• Inv Release Type
• Inv Segment Cd
• Inv Type
• Last Transaction Dt/Tm
• Last Updated By
• Location
• Logistics Program
• Owning DoDAAC
• Personnel
• Physical Inv Nbr
• Physical Inv Status
• Prj Cd
• Program Id
• Region
• Reportable Commodity Type(s)
• Request Type
• Scheduled Start Dt
• Sequence Nbr
• Serial Nbr(s)
• Serial Number(s)
• Site
• Stock Nbr(s)
• Warehouse
• Zone(s)

Recommended
Create an inquiry or report that allows a user the ability to pull the history of all completed physical inventories.

Mission Critical
N/A

Benefits
Reduces wait time for the user to get their data.

Users
All