Manual

INTELLITRACK WMS: WAREHOUSE MANAGEMENT SYSTEM V8.1
User Manual
xvi
APPENDIX A: Database Maintenance ...............................................319
Verifying Database Connection................................................................................320
IntelliTrack Database ........................................................................................ 320
SQL Server Logon Information ........................................................................ 320
SQL Server 2008 Login Strong Password Requirements..........................320
Testing the Database Connection via the UDL File..........................................321
Database Connection Test Example ..........................................................323
Connecting to the Database with SQL Server Management Studio .................325
Changing the Application Database Connection ..............................................327
Changing the Database Connection in Check In-Out, Fixed Assets, Inventory, or
Stockroom.................................................................................................. 327
Changing the Database Connection in Package Track ..............................329
Changing the Database Connection in WMS or ISRP ..............................331
Database Backup and Restore..................................................................................332
Database Maintenance ......................................................................................333
Database Backup and Restore with SQL Server/SQL Express ........................333
Database Backup with SQL Server Management Studio ..........................333
Database Restore with SQL Server Management Studio .......................... 341
IntelliTrack Backup and Restore Database Utilities ........................................ 349
Batch Utilities ............................................................................................349
Databackup Folder Permissions.................................................................351
APPENDIX B: Sample Inventory Reports ..........................................357
Available Warehouse Space Report..........................................................................358
Batch Cycle Count ...................................................................................................359
History by Date Report ............................................................................................360
History by Item Report.............................................................................................361
Inventory by Category Report..................................................................................362
Inventory by Location Report .................................................................................. 363
Inventory by Lot, Expiration Date Report ............................................................... 364
Inventory Item Detail Report ...................................................................................365
Inventory Item Summary Report..............................................................................366
Inventory Reconciliation Report ..............................................................................367
Inventory with Pictures Report ................................................................................368
Inventory with Negative Quantity Report................................................................369
Kit Maintenance Form Report..................................................................................370
Location Sequence Report .......................................................................................371
Overstock Summary Report .....................................................................................372