Stage DescriptionManage Logistic Stock Inventory on Tablet

Originator ISCType NormalVersion 1.0Status FinalRelease Date 22/08/2013Validity ILIAS Version 19.00Prepared by Pierre Van BrusselRevised by …Approved by …

1 Stage Description............................................................................................................................................ 3

1.1 Purpose...............................................................................................................................................................3

1.2 Technology..........................................................................................................................................................3

1.3 Detailed Description of the stage........................................................................................................................3

1.4 Expected Result...................................................................................................................................................4

Manage Logistic Stock Inventory on Tablet

1 STAGE DESCRIPTION1.1 PurposeElaborate a portable application connected to ILIAS for stock inventory (Apple or google)

1.2 TechnologyThe technology is open. It can be developed on Apple, Google or Windows tablet platform. If possible the application will be compatible with the different technologies.

A mobile device, e.g. Smartphone, Ipad or Android tablet - can scan the material (NATO Stock Number and lot), which will be automatically queried on a stocktake screen. The quantity can directly be corrected on the local device and uploaded in the ILIAS application.

Either this tablet PC works via secured wireless connection directly on the ILIAS database with existing business logics, either the local application will be made fully autonomously and will be synchronized with ILIAS via VPN or through the authorised computer of a store keeper connected to ILIAS.

1.3 Detailed Description of the stageThe goal is to build an application which will be used by warehouse keeper to establish a stock inventory of a warehouse managed in the ILIAS system.

First the stock situation known in the logistic system will be downloaded locally on the device with detailed description of the material registered in stock and the location where is material is supposed to be stocked

Then the stock keeper will be guided by this application based on different filtering and criteria to verify that the physical stock situation is correct and compliant with the logistic system. It is required to execute the stock inventory of all locations and all material at least once a year.

In case of data mismatch, it will be possible eithero to verify and confirm that the stock is correcto to mark that material is missingo to register found material not known in the logistic application

Version 1.0 CONFIDENTIAL ILIAS Solutions p. 2/3

Manage Logistic Stock Inventory on Tablet

The System will also be capable to read and interpret barcode information as registered on the material or on the warehouse location. Binlocation and material will indeed possibly be equipped of barcode stickers.

The overall process flow is the following:

Stock Inventory

War

ehou

se

keep

erBu

reau

Ana

lysis

With a mobile device

Initialise Mobile device with all data of ILIAS for a given

warehouse

Walking in the warehouse location

by locationCount quantity as

you walk

Analyse of differences

- verify directly - suggest correction- Send result to ILIAS

Automatic creation of

discrepancies

Investigate discrepancies Close discrepancies

On mobile device On mobile device LPDISC

LPDISC LPDISC

RSLUQP - Validated Inventory quantities

On mobile device

The logic in this system is fully done on the mobile device: counting, correction, validation. No ILIAS screen is necessary during the stock counting.

1.4 Expected ResultThe main advantage of this system is that all relevant information of a given NSN, stock is available while the store keeper is counting the data (picture of NSN, other location of the same NSN, overview of lots information of a given NSN, …) when the store keeper confirms a difference on the local device, it will be corrected in ILIAS at the moment data is synchronised again and discrepancies will be generated automatically. It brings ILIAS on the floor where the counted process is made.

Version 1.0 CONFIDENTIAL ILIAS Solutions p. 3/3