IntelliTrack Stockroom Inventory - Manual (Page 15)

Table of Contents
xv
Syncing Data..................................................................................................... 258
CHAPTER 17: Managing Physical Inventory ....................................259
Introduction.............................................................................................................. 260
Counting Physical Inventory ................................................................................... 260
Moving Inventory .................................................................................................... 261
Moving a New Item .......................................................................................... 263
CHAPTER 18: Issuing/Receiving Inventory ......................................265
Introduction.............................................................................................................. 266
Issuing Inventory ..................................................................................................... 266
The Receipt Process................................................................................................. 268
CHAPTER 19: CE Batch: Data Search ..............................................271
Overview.................................................................................................................. 272
Searching for Sites............................................................................................ 272
Searching for Locations.................................................................................... 274
Searching for Items........................................................................................... 276
Searching Inventory......................................................................................... 278
Searching for Departments ............................................................................... 281
Searching for Transactions ............................................................................... 281
APPENDIX A: Data Structure ............................................................285
Site ........................................................................................................................... 286
Inventory Table ........................................................................................................ 286
Inventory by Location Table.................................................................................... 289
Bin Location Table................................................................................................... 291
Field Types............................................................................................................... 291
APPENDIX B: Database Maintenance ...............................................293
Verifying Database Connection ............................................................................... 294
IntelliTrack Database........................................................................................ 294
SQL Server Logon Information........................................................................ 294
SQL Server 2008 Login Strong Password Requirements ......................... 294
Testing the Database Connection via the UDL File ......................................... 295
Database Connection Test Example.......................................................... 297
2289.book Page xv Thursday, July 7, 2011 5:10 PM