IntelliTrack Stockroom Inventory - Manual (Page 16)

I NTELLI T RACK S TOCKROOM V 7.0
User Manual
xvi xvi
Import Access Inventory Data.................................................................................. 315
Query Import Data – Site Table ........................................................................ 316
Query Import Data – Bin Location Table ......................................................... 317
Query Import Data – Inventory Table............................................................... 318
Query Import Data – Inventory by Location Table........................................... 319
Exporting Data ......................................................................................................... 320
Custom Reports ........................................................................................................ 320
Adding Reports ................................................................................................. 320
Custom Queries ....................................................................................................... 321
Adding Queries ................................................................................................. 322
APPENDIX D: Customizing IntelliTrack ..........................................323
Cautions when Customizing IntelliTrack................................................................. 324
APPENDIX E: Bar Code Symbology ..................................................325
Bar Code Symbology Characteristics ...................................................................... 326
APPENDIX F: Sample Reports ...........................................................327
History by Date Report ............................................................................................ 328
History by Item# Report........................................................................................... 329
Inventory by Category Report.................................................................................. 330
Inventory by Location Report .................................................................................. 331
Inventory by Lot/Exp Date Report........................................................................... 332
Inventory Item Detail Report ................................................................................... 333
Inventory Item Summary Report.............................................................................. 334
Inventory W/Pictures Report.................................................................................... 335
Inventory, Negative Qty Report ............................................................................... 336
Issue Number Report................................................................................................ 337
Issue Transactions Report ........................................................................................ 338
Overstock Summary Report ..................................................................................... 339
Receipt Number Report............................................................................................ 340
Receipt Transactions Report .................................................................................... 341
Reconciliation Report............................................................................................... 342
Reorder Report ......................................................................................................... 343
Usage by Demand Report ........................................................................................ 344
Usage by Department Report ................................................................................... 345
2289.book Page xvi Thursday, July 9, 2009 2:35 PM