During inventory accountability inspections and audits which NECC forces undergo; inventory counts are validated "by NSN" and "by location". ?Inspection teams request inventory reports by facility (or zone as applicable) with detail (exact locations with quantities and serial numbers as applicable) prior to arrival on the first day of inspection. ?Audit teams have requested full command inventory encompassing all facilities and locations prior to arrival and request specific inventory reports following arrival to validate against the data received earlier. ?The ?By NSN? validation requires reporting of all locations, including kits where a particular NSN exists in quantity or by individual serial numbers; it also includes reporting of issued NSNs/serial numbers and producing custody documentation. DPAS WM does not currently have the capability to produce detailed inventory reports at the facility, ?zone or ?parent? location level. Inventory inquiry by NSN displays numbers overall quantities on hand and issued but requires selecting a particular NSNs hyperlink for further details (serial, location) and does not display the serial number(s) for issued equipment and where it is issued. You must utilize multiple modules and queries within the system to piecemeal separate reports for issued equipment and multiple, lower level locations must be queried for inventory. ?Capability to produce inclusive inventory results exists in current, less sophisticated COTS programs such as ?WASP? using ad-hoc reporting features, therefore it is attainable in DPAS WM and a necessity for data calls and inspections. Ad-hoc reporting or modifications to the inquiry module enabling it to report: ?1. By individual NSN: ?in a single report, the quantities and serial #s for a given NSN, with location (including placement in kits) and if issued, ideally the UIC or individual issued to. ?2. By location: to comprehensively report inventory items (including serial numbers) at higher levels to include all sub locations. If a shelf is chosen for an inventory report then the contents of the containers on that shelf should also report.