IntelliTrack Stockroom Inventory - Manual (Page 17)

Table of Contents
xvii
Import Access Inventory Data ................................................................................. 359
Query Import Data – Site Table........................................................................ 360
Query Import Data – Bin Location Table ......................................................... 361
Query Import Data – Inventory Table .............................................................. 362
Query Import Data – Inventory by Location Table .......................................... 363
Exporting Data......................................................................................................... 364
Custom Reports........................................................................................................ 364
Adding Reports................................................................................................. 364
Custom Queries ....................................................................................................... 365
Adding Queries................................................................................................. 366
CHAPTER 20: Customizing IntelliTrack ..........................................367
Cautions when Customizing IntelliTrack ................................................................ 368
CHAPTER 21: Bar Code Symbology ..................................................369
Bar Code Symbology Characteristics ...................................................................... 370
CHAPTER 22: Sample Reports ...........................................................371
History by Date Report ............................................................................................ 372
History by Item# Report .......................................................................................... 373
Inventory by Category Report ................................................................................. 374
Inventory by Location Report.................................................................................. 375
Inventory by Lot/Exp Date Report .......................................................................... 376
Inventory Item Detail Report................................................................................... 377
Inventory Item Summary Report ............................................................................. 378
Inventory W/Pictures Report ................................................................................... 379
Inventory, Negative Qty Report............................................................................... 380
Issue Number Report ............................................................................................... 381
Issue Transactions Report ........................................................................................ 382
Overstock Summary Report..................................................................................... 383
Receipt Number Report ........................................................................................... 384
Receipt Transactions Report .................................................................................... 385
Reconciliation Report .............................................................................................. 386
Reorder Report......................................................................................................... 387
Usage by Demand Report ........................................................................................ 388
Usage by Department Report................................................................................... 389
2289.book Page xvii Thursday, July 7, 2011 5:10 PM