IntelliTrack Inventory Shipping Receiving Picking (ISRP) - Manual (Page 15)

xv
Generating an Inventory Report ....................................................................... 241
Picking Reports........................................................................................................ 244
Generating a Picking Report.................................................................................... 248
Receiving Reports.................................................................................................... 251
Generating a Receiving Report......................................................................... 254
IntelliTrack Report Print and Export Options.......................................................... 257
Print Options..................................................................................................... 258
Export Options.................................................................................................. 258
Customizing Reports................................................................................................ 259
Reaching the Customize Reports Form ............................................................ 259
Adding the New Report to the Front End.................................................. 260
APPENDIX A: Database Maintenance ...............................................263
Verifying Database Connection ............................................................................... 264
IntelliTrack Database........................................................................................ 264
SQL Server Logon Information........................................................................ 264
SQL Server 2008 Login Strong Password Requirements ......................... 264
Testing the Database Connection via the UDL File ......................................... 265
Database Connection Test Example.......................................................... 267
Connecting to the Database with SQL Server Management Studio................. 269
Changing the Application Database Connection.............................................. 271
Changing the Database Connection in Check In-Out, Fixed Assets, Inventory, or
Stockroom.................................................................................................. 271
Changing the Database Connection in Package Track.............................. 273
Changing the Database Connection in WMS or ISRP .............................. 275
Database Backup and Restore.................................................................................. 276
Database Maintenance ...................................................................................... 277
Database Backup and Restore with SQL Server/SQL Express ........................ 277
Database Backup with SQL Server Management Studio.......................... 277
Database Restore with SQL Server Management Studio.......................... 285
IntelliTrack Backup and Restore Database Utilities........................................ 293
Batch Utilities............................................................................................ 293
Databackup Folder Permissions ................................................................ 295
APPENDIX B: Sample Inventory Reports ..........................................301
Available Warehouse Space Report ......................................................................... 302
Batch Cycle Count ................................................................................................... 303
History by Date Report ............................................................................................ 304
History by Item Report ............................................................................................ 305