Data collected during a physical inventory scan must be uploaded and imported into the Download/Reconcile page prior to processing. Raw data files may be viewed and edited prior to importing.

Upload and Import

1. Log in with a user name and password that has been granted rights to Download/Reconcile.
2. Choose the appropriate Module.
3. Click Download Reconcile in the menu on the left side of the home screen.
4. Click the radio button next to From ASCII File.
5. Click Select, navigate to and select the ASCII file of scanned data.
6. Click Upload and Import.
7. Click Save All after uploading each individual ASCII file.

Note: The system is set to auto-logout after twenty minutes of inactivity. Your work will not be saved before logout. Pay attention to time and Save All to preserve completed work if you must step away or are nearing the twenty minute logout limit.

Viewing Saved Records

If the Save All option has been utilized, imported data that has been viewed but not processed have been saved in suspense tables. To import these saved records for processing:

1. Log in with a user name and password that has been granted rights to Download/Reconcile.
2. Choose the appropriate Module.
3. Click Download Reconcile in the menu on the left side of the home screen.
4. Click View Unprocessed Record.
5. Click Import.

Exporting Saved Records

Saved records may be exported to Excel for further review prior to processing.

1. Log in with a user name and password that has been granted rights to Download/Reconcile.
2. Choose the appropriate Module.
3. Click Download Reconcile in the menu on the left side of the home screen.
4. Click View Unprocessed Record.
5. Click Import.
6. Click Export All Tabs.

Saved records may be exported as a report in .pdf format for ease of printing.

1. Log in with a user name and password that has been granted rights to Download/Reconcile.
2. Choose the appropriate Module.
3. Click Download Reconcile in the menu on the left side of the home screen.
4. Click View Unprocessed Record.
5. Click Import.
6. Click Print.
7. The file may be Downloaded.
8. The file may be Printed.

Raw Data Files

The raw data contained in ASCII (or .TXT) files may be viewed and edited prior to importing.

1. Browse to the file location.
2. Identify the correct file, Right Click the file name.
3. Select Open to view and/or edit the raw data.
4. Be sure to Save any edits that are made.

Raw data files share a common format. The data is interpreted using the following information.

XA05 – Chemical Module Physical Inventory
UN – Unit Number of the Device
HU – User Tag Number
HD – Date and time stamp for the transaction
EP – Inventory Process ID
EA – Scanned Location
EB – Inventory Item
EC – Quantity (defaults to 1 container)

The information below is specific to the sample file above.

AX05	Designates file as Chemical Module Physical Inventory data
UN123	Identifies the device used for scan as scanner number 123
HU0686	Identifies the user who performed the scan as user tag 0686
HD09/02/2024 06:20	Time, date stamp for scan. Time is recorded in 24 hour format.
EP43	Associates data with physical inventory process 43
EA70612	Associates data with inventory location tag 70612
EB037633	Scan of item with inventory tag 037633
EC1	Designates a quantity of one

Back to Physical Inventory Overview