IntelliTrack Stockroom Inventory - Manual (Page 15)

Table of Contents
xv
Counting Physical Inventory ................................................................................... 276
Moving Inventory .................................................................................................... 277
CHAPTER 18: Issuing/Receiving Inventory ......................................279
Introduction.............................................................................................................. 280
Issuing Inventory ..................................................................................................... 280
The Receipt Process................................................................................................. 282
CHAPTER 19: CE Batch: Data Search ..............................................285
Overview.................................................................................................................. 286
Searching for Sites............................................................................................ 286
Searching for Locations.................................................................................... 288
Searching for Items........................................................................................... 290
Searching for Inventory By Location ............................................................... 292
Searching by Site and Location ........................................................................ 292
Searching by Site and Item Number................................................................. 294
Search by Site and Lot...................................................................................... 296
Searching by Site and Expiration Date............................................................. 297
Searching by Quantity ...................................................................................... 298
Searching for Departments ............................................................................... 300
Searching for Transactions ............................................................................... 300
APPENDIX A: Data Structure ............................................................303
Site ........................................................................................................................... 304
Inventory Table ........................................................................................................ 304
Inventory by Location Table.................................................................................... 307
Bin Location Table................................................................................................... 309
Field Types............................................................................................................... 309
APPENDIX B: Compact Instructions .................................................311
Overview.................................................................................................................. 312
Compacting the Workstation Application File ........................................................ 312
APPENDIX C: Microsoft Access Integration ..................................313
Overview.................................................................................................................. 314
Full Access Import................................................................................................... 314
2289.book Page xv Thursday, July 9, 2009 2:35 PM