IntelliTrack Inventory Management - Manual (Page 15)

Table of Contents
xv
Full Access Import................................................................................................... 308
Import Access Inventory Data ................................................................................. 309
Query Import Data – Site Table........................................................................ 310
Query Import Data – Bin Location Table ..........................................................311
Query Import Data – Inventory Table .............................................................. 312
Query Import Data – Inventory by Location Table .......................................... 313
Exporting Data......................................................................................................... 314
Custom Reports........................................................................................................ 314
Adding Reports................................................................................................. 314
Custom Queries ....................................................................................................... 315
Adding Queries................................................................................................. 316
APPENDIX G: Customizing IntelliTrack ..........................................317
Cautions when Customizing IntelliTrack ................................................................ 318
APPENDIX H: Bar Code Symbology .................................................319
Bar Code Symbology Characteristics ...................................................................... 320
APPENDIX I: Sample Reports ...........................................................321
History by Date Report ............................................................................................ 322
History by Item# Report .......................................................................................... 323
Inventory by Category Report ................................................................................. 324
Inventory by Location Report.................................................................................. 325
Inventory by Lot/Exp. Date Report ......................................................................... 326
Inventory Item Detail Report................................................................................... 327
Inventory Item Summary Report ............................................................................. 328
Inventory w/Pictures Report .................................................................................... 329
Inventory, Negative Quantity Report....................................................................... 330
Overstock Summary Report..................................................................................... 331
Reconciliation Report .............................................................................................. 332
Reorder Report......................................................................................................... 333
INDEX .............................................................................................................. 335
2287.book Page xv Thursday, July 7, 2011 4:45 PM