Intellitrack Inventory Management Manuel d'utilisateur

Naviguer en ligne ou télécharger Manuel d'utilisateur pour Logiciel Intellitrack Inventory Management. IntelliTrack Inventory Management User Manual Manuel d'utilisatio

  • Télécharger
  • Ajouter à mon manuel
  • Imprimer
  • Page
    / 366
  • Table des matières
  • MARQUE LIVRES
  • Noté. / 5. Basé sur avis des utilisateurs
Vue de la page 0
i
Reasonable measures have been taken to ensure that the information
included in this manual is complete and accurate. However, IntelliTrack
reserves the right to change any specification at any time without prior
notice. IntelliTrack is a registered trademark of IntelliTrack, Inc. The Intel-
liTrack logo is a trademark of IntelliTrack. Microsoft Windows, Microsoft
Access, Microsoft SQL Server, Microsoft Internet Information Services,
Windows Mobile Device Center, and Microsoft ActiveSync are registered
trademarks of Microsoft Corporation. All other trademarks and trade
names referred to herein are property of their respective owners.
IntelliTrack DMS™ (Data Management System)
Inventory v8.1 SQL
User Manual
Rev. A (July 2011)
Copyright © 2003–2011 IntelliTrack Inc.
An Unpublished Work - All rights reserved. No part of the contents of this
documentation or the procedures described therein may be reproduced or
transmitted in any form or by any means without prior written permission
of IntelliTrack Inc. Owners of IntelliTrack products are hereby granted a
non-exclusive, revocable license to reproduce and transmit this documen-
tation for the purchaser's own internal business purposes. Purchaser shall
not remove or alter any proprietary notices, including copyright notices,
contained in this documentation and shall ensure that all notices appear on
any reproductions of the documentation. Should future revisions of this
manual be published, you can acquire printed versions by contacting Intel-
liTrack, Inc. Electronic versions will either be downloadable from the Int-
elliTrack website (www.intellitrack.net) or provided on appropriate media.
If you visit our website and would like to make comments or suggestions
about this or other IntelliTrack publications, please let us know via the
“Contact IntelliTrack” page.
IntelliTrack, Inc.
5 Shawan Rd., Suite 200
Hunt Valley, Maryland 21030
(888) 583-3008
2287.book Page i Thursday, July 7, 2011 4:45 PM
Vue de la page 0
1 2 3 4 5 6 ... 365 366

Résumé du contenu

Page 1

iReasonable measures have been taken to ensure that the information included in this manual is complete and accurate. However, IntelliTrack reserves t

Page 2 - Agreement

INTELLITRACK INVENTORY V8.1User Manualxx CHAPTER 6: Lookups ...83Introduction ..

Page 3 - Disclaimer

INTELLITRACK INVENTORY V8.1User Manual744.Click the Delete button found along the bottom of the form. A warning message appears, asking you if you are

Page 4 - Liability

Chapter 5System Setup75The following selections are available:• Inventory Titles: select to display the User Defined Titles form with inventory/item d

Page 5

INTELLITRACK INVENTORY V8.1User Manual76In the screen example above, the inventory and item data titles avail-able for custom defining are listed in t

Page 6

Chapter 5System Setup77The custom title entered in the Yo ur Title column will be substituted for the Normal Title where applicable in the system.Imp

Page 7

INTELLITRACK INVENTORY V8.1User Manual78Access. IntelliTrack DMS v8.1 supports Microsoft Access 2007 and 2010* (*Microsoft Access 2010, 32-bit version

Page 8

Chapter 5System Setup79Caution: Form Name is the actual object name of the form that is used when the Title is selected.1. To change the appearance of

Page 9

INTELLITRACK INVENTORY V8.1User Manual80(To view the reports in the application, click the first record button found along the bottom of the form.)(To

Page 10 - INTELLITRACK INVENTORY V8.1

Chapter 5System Setup81menu without changing the Report (form), modify the Title field of the desired report.)3. Enter the object name of the report i

Page 11 - Table of Contents

INTELLITRACK INVENTORY V8.1User Manual822287.book Page 82 Thursday, July 7, 2011 4:45 PM

Page 12

83 CHAPTER 6LookupsIntroductionCategoryReaching the Categories FormAdding a CategoryEditing a CategoryDeleting a CategorySiteAdding a SiteEditing a Si

Page 13

Table of ContentsxiLocation/Item# and Item#/Location Form Buttons ...111Item#/Location Form ...

Page 14

INTELLITRACK INVENTORY V8.1User Manual84IntroductionIntelliTrack Inventory lookups help you accurately track site, item, and inventory data by maintai

Page 15

Chapter 6Lookups85Reaching the Categories FormSelect Manage > Lookup Tables > Category ribbon option. The Catego-ries form appears.Adding a Cate

Page 16

INTELLITRACK INVENTORY V8.1User Manual864.The field clears and the newly added category is now part of the Cate-gory list.Editing a CategoryTo edit a

Page 17 - About this Documentation

Chapter 6Lookups87The entry will be deleted from the list.SiteA “Site” refers to an area that contains locations. These areas in the appli-cation data

Page 18 - The DMS 8.1 Interface

INTELLITRACK INVENTORY V8.1User Manual882.Click the Add button found along the bottom of the form.3. The cursor appears in the field above the Site li

Page 19

Chapter 6Lookups89more information, please refer to “Precautions When Entering Data” on page 42.1. Select the Site you want to edit from the Site list

Page 20 - Action Conventions

INTELLITRACK INVENTORY V8.1User Manual90Measure Lookup table makes them available as UOM selections in Intelli-Track DMS Inventory. If you plan to imp

Page 21 - Clicking

Chapter 6Lookups91Click the Undo button to cancel adding the new unit of measure.Editing a Unit of MeasureTo edit a unit of measure, please refer to t

Page 22 - Choosing a

INTELLITRACK INVENTORY V8.1User Manual92The unit of measure is removed from the list.2287.book Page 92 Thursday, July 7, 2011 4:45 PM

Page 23 - Keyboard

93 CHAPTER 7Initializing the SystemInitializing the SystemCreating LocationsReaching the Location FormAdding a LocationChanging Location InformationDe

Page 24 - Formatting Conventions

INTELLITRACK INVENTORY V8.1User ManualxiixiiReports ...

Page 25 - Technical Support

INTELLITRACK INVENTORY V8.1User Manual94Initializing the SystemOnce you have set up your system options and added lookup data, you are ready to add lo

Page 26

Chapter 7Initializing the System95•Site (Defaults to “{0}” without Multiple Site option): You can have multiple sites with the same location name.• Lo

Page 27

INTELLITRACK INVENTORY V8.1User Manual961.Click the drop-down arrow in the Site List field and select the site to which you are adding the location fr

Page 28

Chapter 7Initializing the System973.A message box appears, asking you if you want to delete this location.Click Ye s to delete the location and close

Page 29 - Installation

INTELLITRACK INVENTORY V8.1User Manual98Adding ItemsItems are defined in the system at the Item Data form.Reaching the Item Data FormClick Manage >

Page 30

Chapter 7Initializing the System99Adding an Item to the DatabaseNew items are added to the database at the Item Data form. To add an item to the datab

Page 31 - Portable Device Support

INTELLITRACK INVENTORY V8.1User Manual1003.If you have an alternate item number, enter it in the Alt No field. (Using an alternate item number is opti

Page 32

Chapter 7Initializing the System1012.The IntelliTrack navigation window appears. It defaults to the follow-ing folder: for 32-bit systems, C:\Program

Page 33 - DMS CE Batch Setup

INTELLITRACK INVENTORY V8.1User Manual1024.Click the Open button. The IntelliTrack navigation window closes, and the picture is imported into the Item

Page 34

Chapter 7Initializing the System103Storing Reorder Quantity RangesYou are able to set a reorder quantity, a minimum quantity, and a maximum quantity f

Page 35

Table of ContentsxiiiSending Data to the Batch Portable Application ... 189Uploading Data to the Bat

Page 36 - Control (UAC)

INTELLITRACK INVENTORY V8.1User Manual104Page 2 contains 24 user defined fields. User defined fields allow you to add specific data to a form. They ha

Page 37 - Windows 7

Chapter 7Initializing the System105Conversion, Unit Cost, Min Qty, Max Qty, Reorder Qty, Item Pic-ture, and PictureLocation: 4. Enter the item number

Page 38

INTELLITRACK INVENTORY V8.1User Manual1064.The message closes and you are returned to the Item Data form. The form clears and the item is deleted from

Page 39 - Server 2008

Chapter 7Initializing the System1074.Enter the site and location by selecting from pull-down lists or entering new values.If you enter new values, cli

Page 40

INTELLITRACK INVENTORY V8.1User Manual1087.Select the Close button to save the data and exit the Item at Location form.After building the Inventory da

Page 41

109 CHAPTER 8Using IntelliTrack InventoryAdd, Edit, or Move Inventory DataLocation/Item# and Item#/Location Form ButtonsItem#/Location FormViewing All

Page 42

INTELLITRACK INVENTORY V8.1User Manual110Add, Edit, or Move Inventory DataIntelliTrack Inventory tracks item quantity, location, and movement. At the

Page 43 - “RDA Con

Chapter 8Using IntelliTrack Inventory111Location/Item# and Item#/Location Form ButtonsThe Location/Item# form and the Item#/Location form contain “tra

Page 44 - “Batch Installa

INTELLITRACK INVENTORY V8.1User Manual112Item#/Location FormUse the Item#/Location form to view which locations contain specific items. When the Item#

Page 45 - Microsoft SQL

Chapter 8Using IntelliTrack Inventory1132.All locations at the default site that contain the specified item appear in a table.Viewing All Locations (A

Page 46 - Configuration

INTELLITRACK INVENTORY V8.1User ManualxivxivBin Location Table ...

Page 47 - Accessed February 1, 2010

INTELLITRACK INVENTORY V8.1User Manual1145.The item being moved is the item selected in the Item#/Location form. This information is automatically pla

Page 48 - RDA Setup

Chapter 8Using IntelliTrack Inventory115Do not modify the contents of the field unless you want to change this value.6. Select the Close button to clo

Page 49

INTELLITRACK INVENTORY V8.1User Manual116the Item#/Location form and select Add Item# for Location to continue adding items to a location.3. Select th

Page 50 - Manual IIS

Chapter 8Using IntelliTrack Inventory117To view or work with the data in this form, please refer to the following sections.Viewing the Contents of Loc

Page 51 - Manual IIS RDA Setup Options

INTELLITRACK INVENTORY V8.1User Manual1186.Select the Do It button to process the transaction and reset the Move Item form or select the Close button

Page 52

Chapter 8Using IntelliTrack Inventory1192.Select the Delete button.3. Select Yes to confirm the deletion of this item.Adding an Item to a LocationTo

Page 53 - Computer

INTELLITRACK INVENTORY V8.1User Manual1208.Select the Do It button to process this transaction and reset the Item at Location form or select the Close

Page 54

Chapter 8Using IntelliTrack Inventory1218.Select Do It to process the transaction and reset the Move Item form for another transaction or select Close

Page 55 - Software

INTELLITRACK INVENTORY V8.1User Manual1222287.book Page 122 Thursday, July 7, 2011 4:45 PM

Page 56

123 CHAPTER 9Import/ExportReaching the Import and Export OptionsImporting Inventory DataAdditional Importing InformationImport File Type OptionsImport

Page 57 - Applying Firewall Exceptions

Table of ContentsxvFull Access Import... 308Import Acc

Page 58

INTELLITRACK INVENTORY V8.1User Manual124Reaching the Import and Export OptionsImporting and exporting asset inventory data adds a flexibility to the

Page 59 - Getting Started

Chapter 9Import/Export125Warning: DO NOT IMPORT data that contains special characters or quotes with the exception of dashes, dots, and spaces. Except

Page 60 - Basic Startup Procedures

INTELLITRACK INVENTORY V8.1User Manual126•Qty• Description• Unit Cost• Category• Minimum Qty• Maximum Qty• Reorder Qty• Alt_No. If the Item number alr

Page 61 - Using the Application

Chapter 9Import/Export127Import File Type ExamplesWhen you import files into IntelliTrack via the standard import function, make sure that the file co

Page 62

INTELLITRACK INVENTORY V8.1User Manual128990;5;Stapler;7.50;Office Supplies;5.00;2;10;3;990aTab Delimited File ExampleFor Tab delimited, the delimited

Page 63 - Password

Chapter 9Import/Export129Note: The imported file must comply with the field order and specifica-tions defined in “Import File Type Options” on page 12

Page 64 - Using the Dashboard

INTELLITRACK INVENTORY V8.1User Manual130The Purge All Data form appears.2. Enable all the check boxes and click the Do It button. (For more infor-mat

Page 65 - Using the Ribbon

Chapter 9Import/Export131•Quote Comma Quote (","): An ASCII (i.e., plain text) delimited file that separates each field by commas, encloses

Page 66 - Transaction Buttons

INTELLITRACK INVENTORY V8.1User Manual1328.After importing the item information, assign the rest of the item data. Please refer to “Edit Existing/Inco

Page 67 - Options form

Chapter 9Import/Export1332.A dialog box appears that provides information on the compare pro-cess. Review it; if you want to run an import compare rep

Page 68

INTELLITRACK INVENTORY V8.1User Manualxvixvi2287.book Page xvi Thursday, July 7, 2011 4:45 PM

Page 69 - Help Ribbon Options

INTELLITRACK INVENTORY V8.1User Manual1341.Select Import Command Tab > Import Command Set > to view the Import options in the Command Tab ribbon

Page 70

Chapter 9Import/Export1359.After importing item data, create Inventory manually via the Add Item to Location button at the Item Data form, or at the I

Page 71 - Chapter 3

INTELLITRACK INVENTORY V8.1User Manual1363.Select the folder in which to save the export file in the Save In pull-down list.4. A file name with the .t

Page 72

137 CHAPTER 10History, Queries, and ReportsView InventorySorting on a Specific FieldHistoryRunning a Standard Application QueryStandard Inventory Quer

Page 73 - Purging Data

INTELLITRACK INVENTORY V8.1User Manual138View InventoryUse the View Inventory function to view a list of all the items in a work-sheet form. Sort the

Page 74 - Reaching the Purge Options

Chapter 10History, Queries, and Reports139HistoryThe history logging function keeps a running history of all transactions performed within the Invento

Page 75

INTELLITRACK INVENTORY V8.1User Manual140grows rapidly. IntelliTrack recommends that History data be purged at regular intervals to keep file size man

Page 76 - Purging All

Chapter 10History, Queries, and Reports141ReportsThe IntelliTrack Inventory application contains several pre-formatted reports. Use these reports to m

Page 77

INTELLITRACK INVENTORY V8.1User Manual142View or Print Inventory ReportsDefine a set of criteria before viewing or printing most of the Inventory repo

Page 78 - Lookup Data

Chapter 10History, Queries, and Reports143Reports that don’t require criteria definitions display the View or Print buttons at the bottom of the Repor

Page 79

xviiPREFACEAbout this DocumentationThe DMS 8.1 InterfaceAction ConventionsMouse ActionsSelecting Ribbon OptionsClicking ButtonsChoosing a SettingQuery

Page 80

INTELLITRACK INVENTORY V8.1User Manual144Important: If you are using Microsoft Access 2007, in order to export the report in PDF or XPS format, you mu

Page 81 - System Setup

145 CHAPTER 11Label PrintingBar Code Label FeatureLabel Printer Required DriversPrinting and Previewing Location and Item LabelsPrinting Sequential La

Page 82

INTELLITRACK INVENTORY V8.1User Manual146Bar Code Label FeatureYour Inventory application contains a print-only bar code engine. The Bar Code Labels f

Page 83 - Setup Form

Chapter 11Label Printing147Printing and Previewing Location and Item LabelsTo preview and print bar code labels for inventory item data and for loca-t

Page 84 - Entering Company Information

INTELLITRACK INVENTORY V8.1User Manual1487.To print the selected label or labels in the label printing software appli-cation, click the Print button f

Page 85 - Setting System Options

Chapter 11Label Printing1499.If applicable, enter a label postfix in the Postfix field. The label postfix may be any alphanumeric character. For insta

Page 86

INTELLITRACK INVENTORY V8.1User Manual150Sequential: create a new sequential label in the label printing software.Custom: create a new custom label in

Page 87 - Setting International Options

Chapter 11Label Printing1513.Click the Edit button found along the bottom of the form.4. The label printing software application opens the selected la

Page 88

INTELLITRACK INVENTORY V8.1User Manual1527.Click the Print button to print the selected label from the selected printer. The label is sent to the prin

Page 89 - Setting Site Options

153 CHAPTER 12Installing DMS CE BatchDetermining your Device InstallationInstalling the CE Batch Portable ApplicationReaching your Device Installation

Page 90 - Setting Security

INTELLITRACK INVENTORY V8.1User ManualxviiiThe DMS 8.1 InterfaceDMS 8.1 uses the Microsoft Access 2007 or 2010 runtime (*for Microsoft Access 2010, 32

Page 91 - Security

INTELLITRACK INVENTORY V8.1User Manual154Determining your Device InstallationIntelliTrack supports many portable devices; please refer to the Hardware

Page 92

Chapter 12Installing DMS CE Batch155Installing the CE Batch Portable ApplicationOnce you complete the Batch installation prerequisites, including:• De

Page 93 - Chapter 5

INTELLITRACK INVENTORY V8.1User Manual156Retrieving your Device Installer from the Hardware Support MatrixTo download your device installer from the H

Page 94 - Maintaining System Users

Chapter 12Installing DMS CE Batch157Application on the Handheld Device” on page 157 for detailed step-by-step instructions.Installing the Batch Portab

Page 95

INTELLITRACK INVENTORY V8.1User Manual1583.The Choose Components window appears. At the Choose Components window, you have the option of selecting the

Page 96 - Editing the

Chapter 12Installing DMS CE Batch159Inventory CE Client: The Batch Portable application, which is sent to the portable device..NET Compact Framework:

Page 97

INTELLITRACK INVENTORY V8.1User Manual160Opening the Batch Portable ApplicationOnce you install the batch portable application on the handheld device,

Page 98

Chapter 12Installing DMS CE Batch1614.Tap the drop-down arrow in the User ID field and select a sample user-name, and then tap the Login button.5. The

Page 99

INTELLITRACK INVENTORY V8.1User Manual1622287.book Page 162 Thursday, July 7, 2011 4:45 PM

Page 100 - User Defined Titles

163 CHAPTER 13CE Batch Utility SettingsPreferences TabLocalization OptionsBatch Portable ApplicationRenaming Captions in the Batch Portable Applicatio

Page 101 - The User Defined Titles Form

PrefaceAbout this DocumentationxixThe Work Area of the screen contains a Dashboard tabbed window, which is the default window.When you open other appl

Page 102

INTELLITRACK INVENTORY V8.1User Manual164Preferences Tab CE Batch Utility options for language localization and upload processing are set in the Prefe

Page 103 - Custom System Setup

Chapter 13CE Batch Utility Settings165Batch Portable ApplicationThe Localization settings for the CE Batch Portable Application include captions and m

Page 104 - “Custom Queries”

INTELLITRACK INVENTORY V8.1User Manual166All default captions may be customized.MessageA message refers to dialog box messages found in the CE Batch P

Page 105 - Customizing

Chapter 13CE Batch Utility Settings1672.Next, in the left pane of the form, select Batch Portable Application from the menu tree.3. In the left pane o

Page 106

INTELLITRACK INVENTORY V8.1User Manual168•Double-click inside the column heading to sort the information. Each time you double-click, the sort order w

Page 107 - Customize

Chapter 13CE Batch Utility Settings1699.Click the Send button found in the bottom right corner of the form to send the caption changes to the Batch Po

Page 108

INTELLITRACK INVENTORY V8.1User Manual1702.Next, in the left pane of the form, select Batch Portable Application from the menu tree.3. Underneath the

Page 109 - Introduction

Chapter 13CE Batch Utility Settings171•Double-click inside the column heading to sort the information. Each time you double-click, the sort order will

Page 110

INTELLITRACK INVENTORY V8.1User Manual1729.Click the Send button found in the bottom right corner of the form to send the message changes to the Batch

Page 111 - Adding a

Chapter 13CE Batch Utility Settings173The default captions in the Batch Synchronization Utility may be custom-ized.MenuA menu refers to a menu name an

Page 112 - Deleting a

INTELLITRACK INVENTORY V8.1User ManualiiIntelliTrack DMS SOFTWARE License AgreementTHIS SOFTWARE LICENSE AGREEMENT FOR RESELLERS AND END-USERS IS YOUR

Page 113 - “Setting Site Options” on

INTELLITRACK INVENTORY V8.1User ManualxxAction ConventionsThis documentation uses action conventions to explain screen actions such as using the compu

Page 114

INTELLITRACK INVENTORY V8.1User Manual1741.In the Batch Utility, click the Preferences tab to bring this portion of the Main form to the front.2. Next

Page 115

Chapter 13CE Batch Utility Settings175The right pane of the form contains four data columns:• Form Name: lists the object name for the form in the Bat

Page 116 - Adding a Unit

INTELLITRACK INVENTORY V8.1User Manual176•Double-click inside the column heading to sort the information. Each time you double-click, the sort order w

Page 117 - Unit of

Chapter 13CE Batch Utility Settings1772.Next, in the left pane of the form, select Batch Synchronization Util-ity from the menu tree.3. In the left pa

Page 118

INTELLITRACK INVENTORY V8.1User Manual178The right pane of the form contains three data columns:Menu Name: Lists the object name for the menu options

Page 119 - Initializing the System

Chapter 13CE Batch Utility Settings1794.To customize a menu name or menu option, first locate the menu that you want to change in the Menu Name column

Page 120 - Creating Locations

INTELLITRACK INVENTORY V8.1User Manual180options for customizing the messages in the Batch Synchronization Utility appear in the right pane of the for

Page 121 - Reaching the Location Form

Chapter 13CE Batch Utility Settings181Double-click inside the column heading to sort the information. Each time you double-click, the sort order will

Page 122 - Information

INTELLITRACK INVENTORY V8.1User Manual182Upload Processing PreferencesTo specify which records are automatically added to the workstation data-base du

Page 123 - Chapter 7

Chapter 13CE Batch Utility Settings183Processing Mode: choose type of processing (process all records, return on each error) when uploading records fr

Page 124 - Adding Items

PrefaceAbout this Documentationxxi2.From the Inventory options, select Location Data from the ribbon:3. The Location form appears in the Work Area as

Page 125 - Database

INTELLITRACK INVENTORY V8.1User Manual184•You must enter the correct Sync URL setting (the network path to the IIS server location) in the DMS Batch S

Page 126 - Picture of the

Chapter 13CE Batch Utility Settings185•The Test Batch Registration Service button is a troubleshooting tool. Your batch registration must be set corre

Page 127

INTELLITRACK INVENTORY V8.1User Manual1862287.book Page 186 Thursday, July 7, 2011 4:45 PM

Page 128 - Establishing

187 CHAPTER 14Data Upload and DownloadDownloading Data to the Batch Portable ApplicationTransferring DataSending Data to the Batch Portable Applicatio

Page 129

INTELLITRACK INVENTORY V8.1User Manual188Downloading Data to the Batch Portable ApplicationYou will want to synchronize your data at regular intervals

Page 130 - Duplicate Item

Chapter 14Data Upload and Download189If you do not send the security settings, security is not enforced in the batch portable application.When you sen

Page 131 - Item Record

INTELLITRACK INVENTORY V8.1User Manual190Note: To send only the required system data (language options and User IDs), do not set any options in the Se

Page 132 - Item Data

Chapter 14Data Upload and Download191mark the Send Locations check box. The From and To fields become enabled.6. You may select a location range to se

Page 133 - Adding Items to Locations

INTELLITRACK INVENTORY V8.1User Manual192click the drop-down arrow in the To field and select the last selection that appears.To send one item number,

Page 134

Chapter 14Data Upload and Download19315.As the data information is sent to the handheld device (localization changes, data selections such as sites, l

Page 135 - Using IntelliTrack Inventory

INTELLITRACK INVENTORY V8.1User Manualxxii1.When instructed to “click the Add button,” click the Add button found along the bottom of the Inventory fo

Page 136

INTELLITRACK INVENTORY V8.1User Manual194nization process may be initiated from the handheld device or from the Batch Synchronization Utility.1. For m

Page 137 - Form Buttons

Chapter 14Data Upload and Download1953.If the handheld application is ready to synchronize data, click OK to close the message box and continue with t

Page 138 - Item#/Location Form

INTELLITRACK INVENTORY V8.1User Manual1966.Select ok to close the message and continue with the data upload. Please note that while in demo mode, only

Page 139

Chapter 14Data Upload and Download1979.Click the Refresh button. The uploaded data appears onscreen.2287.book Page 197 Thursday, July 7, 2011 4:45

Page 140 - Expiration

INTELLITRACK INVENTORY V8.1User Manual198Working with the Uploaded DataAfter data is transferred to the Batch Synchronization Utility, the transac-tio

Page 141 - Item to a

Chapter 14Data Upload and Download199•To view the data by site, click the drop-down arrow in the Site field and select the site from the list that app

Page 142 - Location/Item# Form

INTELLITRACK INVENTORY V8.1User Manual200The selected record(s) are deleted from the record detail portion of the form.Processing the Uploaded DataRec

Page 143

Chapter 14Data Upload and Download201•Process All Records: Processes all records. Rejected records are kept in the Error Log.• Return On Each Error: R

Page 144 - Quantity and

INTELLITRACK INVENTORY V8.1User Manual202If an error occurs, the processing stops and a message box appears noti-fying you that an error occurred in t

Page 145

203 CHAPTER 15Using the CE Batch PortableIntroductionOpening the Batch Portable ApplicationLogging InLogging OutConfiguring the Batch Portable Applica

Page 146 - Relocating Inventory

PrefaceAbout this DocumentationxxiiiQuery Boxes and Dialog BoxesA query box asks you a question or gives you a choice; when a query box appears you mu

Page 147 - Mass Move Form

INTELLITRACK INVENTORY V8.1User Manual204IntroductionThe CE Batch Portable Application resides on the handheld device. It sup-ports physical inventory

Page 148

Chapter 15Using the CE Batch Portable205application, tap the drop-down arrow in the User ID field and select your user name from the list that appears

Page 149 - Import/Export

INTELLITRACK INVENTORY V8.1User Manual206•The Sync menu provides an option for receiving data from the worksta-tion application or sending data to the

Page 150 - Importing Inventory Data

Chapter 15Using the CE Batch Portable2072.When you transfer data to the handheld device, the site data, as set in the Batch Synchronization Utility\Se

Page 151 - Requirements

INTELLITRACK INVENTORY V8.1User Manual208scanned into the field. If the Batch Portable application screens take a long time to load because of a large

Page 152 - NTELLITRACK INVENTORY V8.1

Chapter 15Using the CE Batch Portable209At the View menu, the view data options appear.• SitesTo view all site data found in the Batch Portable applic

Page 153 - Examples

INTELLITRACK INVENTORY V8.1User Manual210The locations in the Batch Portable application are listed in the screen by site.The total location record co

Page 154 - Integrity

Chapter 15Using the CE Batch Portable211•To delete all the items in the Batch Portable application, tap the Delete All button.• Tap the ok button or t

Page 155 - Importing

INTELLITRACK INVENTORY V8.1User Manual212•The transaction history of the collected records in the Batch Portable Application are displayed in the scre

Page 156

Chapter 15Using the CE Batch Portable213A message box appears, asking you if you want to proceed with purging all collected data on the handheld.Synci

Page 157

INTELLITRACK INVENTORY V8.1User ManualxxivFormatting ConventionsThis documentation uses formatting conventions to consistently describe forms, command

Page 158 - IntelliTrack

INTELLITRACK INVENTORY V8.1User Manual214•To upload collected data to the Batch Synchronization Utility, tap Sync > Send Data. A Status screen appe

Page 159 - Importing the Additional Data

215 CHAPTER 16CE Batch: Inventory FunctionsIntroductionCounting Physical InventoryMoving Inventory2287.book Page 215 Thursday, July 7, 2011 4:45 PM

Page 160

INTELLITRACK INVENTORY V8.1User Manual216IntroductionThe Batch Portable application on the handheld device supports the fol-lowing asset inventory fun

Page 161 - Custom Import

Chapter 16CE Batch: Inventory Functions2173.Enter the appropriate site in the Site field or use the default site if it was selected.4. Enter the locat

Page 162 - “Exporting Data” on page 314

INTELLITRACK INVENTORY V8.1User Manual2182.From the Inventory menu, select Move. The Move screen appears.3. In the Source tab from the Move screen, en

Page 163 - History, Queries, and Reports

219 CHAPTER 17CE Batch: Data SearchOverviewSearching for SitesSearching for LocationsSearching for ItemsSearching for Inventory By LocationSearching f

Page 164 - View Inventory

INTELLITRACK INVENTORY V8.1User Manual220OverviewThe Find function in the CE Batch Portable Application enables you to search for site location data:•

Page 165 - “Reports” on page 141)

Chapter 17CE Batch: Data Search221•From the Find screen, tap the drop-down arrow in the Find field and select Site from the list that appears. The Fin

Page 166 - Inventory

INTELLITRACK INVENTORY V8.1User Manual222•Next, tap the Find button to process the site data search.• The site or sites that match the search paramete

Page 167 - TABLE 7. List of Queries

Chapter 17CE Batch: Data Search2232.If you are using multiple sites and downloaded all sites to the Batch Portable Application, or if you added new si

Page 168 - View or Print

PrefaceAbout this DocumentationxxvTechnical SupportIntelliTrack support is only a mouse click or phone call away. The techni-cal support options inclu

Page 169 - Onscreen

INTELLITRACK INVENTORY V8.1User Manual224To search for location by a partial data string, enter the data in the Location field and mark the Partial Ma

Page 170

Chapter 17CE Batch: Data Search225Items may be searched by item number or by description. To search for items by item number, tap the drop-down arrow

Page 171 - Label Printing

INTELLITRACK INVENTORY V8.1User Manual226To search for all descriptions, select to search by description and leave the search selection field blank an

Page 172 - Bar Code Label Feature

Chapter 17CE Batch: Data Search2272.The Find Inventory By Location screen appears.If you are using multiple sites in the Batch Portable Application da

Page 173

INTELLITRACK INVENTORY V8.1User Manual228The inventory that matches the search parameters are listed in the Search Results portion of the screen.The n

Page 174 - Printing Sequential Labels

Chapter 17CE Batch: Data Search2292.If you are using multiple sites in the Batch Portable Application data-base, you may search by site. Tap the drop-

Page 175 - Creating a New Label Format

INTELLITRACK INVENTORY V8.1User Manual230Search by Site and LotTo search for inventory by location data by site and lot, please refer to the instructi

Page 176

Chapter 17CE Batch: Data Search231The number of records displayed in the Search Results portion of the screen are listed in the Record Count field.Tap

Page 177 - Printing Custom Labels

INTELLITRACK INVENTORY V8.1User Manual2324.Tap the Find button.The inventory that matches the search parameters are listed in the Search Results porti

Page 178

Chapter 17CE Batch: Data Search233arrow in the Site field and select the site by which you want to search inventory.3. To search for inventory by loca

Page 179 - Installing DMS CE Batch

INTELLITRACK INVENTORY V8.1User Manualxxvi2287.book Page xxvi Thursday, July 7, 2011 4:45 PM

Page 180

INTELLITRACK INVENTORY V8.1User Manual234The Batch Portable Application supports the physical inventory, move from, and move to transactions as listed

Page 181

235Appendix AData StructureSiteInventory TableInventory by Location TableBin Location TableField Types2287.book Page 235 Thursday, July 7, 2011 4:4

Page 182

INTELLITRACK INVENTORY V8.1User Manual236SiteThe Sites Table is the main table where site definitions are stored.Inventory TableThe Inventory Table is

Page 183 - Handheld Device

Appendix AData Structure237IMP QTY No Currency 8 Imported QuantityUSER1 No Text 25 User Defined Field 1USER2 No Text 25 User Defined Field 2USER3 No T

Page 184

INTELLITRACK INVENTORY V8.1User Manual238Inventory by Location TableThe Inventory by Location Table holds actual quantity, sites and locations. Shows

Page 185

Appendix AData Structure239Bin Location TableDefinition table for Locations where items can be stored. Can be different for each site.ItemID Yes/PKey

Page 186 - Application

INTELLITRACK INVENTORY V8.1User Manual240Field TypesFollowing is a brief summary of the field types and size settings for fields associated with your

Page 187

Appendix AData Structure241 Yes/No Yes and No values and fields that contain only one of two values. Yes/No fields can't be indexed.OLE Object An

Page 188

INTELLITRACK INVENTORY V8.1User Manual2422287.book Page 242 Thursday, July 7, 2011 4:45 PM

Page 189 - CE Batch Utility Settings

243Appendix BDatabase MaintenanceVerifying Database ConnectionIntelliTrack DatabaseSQL Server Logon InformationTesting the Database Connection via the

Page 190 - Localization Options

1 CHAPTER 1IntroductionOverviewProgram RequirementsUsing Microsoft Access with DMS InventoryDisabling User Account ControlInstallation and ActivationU

Page 191

INTELLITRACK INVENTORY V8.1User Manual244Verifying Database ConnectionYour IntelliTrack application contains a database that stores your data and all

Page 192 - Captions in

Appendix BDatabase Maintenance245that it must be a strong password. A strong password meets the following requirements:1. Can’t contain the account n

Page 193 - Chapter 13

INTELLITRACK INVENTORY V8.1User Manual246The screen example below shows the DATA.UDL file in the Check In-Out folder on a 32-bit system.TABLE 18. Inte

Page 194

Appendix BDatabase Maintenance247Database Connection Test ExampleYou are able to easily test your IntelliTrack application’s database connec-tion by

Page 195 - Messages in

INTELLITRACK INVENTORY V8.1User Manual2484.To test the server and database connection for Check In-Out, select the Test Connection button in the Data

Page 196

Appendix BDatabase Maintenance2496.If the test connection fails, it is usually because the database cannot be located or the server name or logon inf

Page 197

INTELLITRACK INVENTORY V8.1User Manual2503.It contains the server name, authentication, and database name of your IntelliTrack database. If all necess

Page 198

Appendix BDatabase Maintenance251Changing the Application Database ConnectionThe application database connection is set at application installation.

Page 199 - Batch Utility

INTELLITRACK INVENTORY V8.1User Manual2523.The server is found in the 1. Select to enter a server name field. (This is the SQL Server that runs your d

Page 200

Appendix BDatabase Maintenance253example for Check In-Out: DATACHE80, and then browsing or enter-ing the database name including the full path to it

Page 201

INTELLITRACK INVENTORY V8.1User Manual2OverviewThe IntelliTrack DMS Inventory software is designed to be used with por-table bar code readers to provi

Page 202 - Selection in

INTELLITRACK INVENTORY V8.1User Manual2542.In the Database portion of the Options window, click the Change Database button. The Data Link Properties w

Page 203

Appendix BDatabase Maintenance255then browsing or entering the data file name, including the full path (example for 32-bit systems: C:\Program Files\

Page 204

INTELLITRACK INVENTORY V8.1User Manual256•Select the radio button next to the Use Windows NT Integrated security option if you are using NT Authentica

Page 205 - Message in

Appendix BDatabase Maintenance257Database MaintenanceWe recommend backing up the database every day. Use SQL Server or an IntelliTrack Utility to bac

Page 206

INTELLITRACK INVENTORY V8.1User Manual2583.Once you are connected, the IntelliTrack database appears in the Object Explorer portion (left pane) of the

Page 207

Appendix BDatabase Maintenance2595.In the right-click menu, select Ta sks > Back Up.6. The Back Up Database dialog appears. The General page is di

Page 208 - Upload Processing Preferences

INTELLITRACK INVENTORY V8.1User Manual2607.In the Back Up Database window, accept all the default settings in the Source and Backup set portion of the

Page 209 - Sync URL

Appendix BDatabase Maintenance2619.The Destination area of the window is cleared.10. Next, select where you want the backup to go. Click the Add butt

Page 210 - Setting” on page 303

INTELLITRACK INVENTORY V8.1User Manual26213.Click OK to close this window. You are returned to the Select Backup Destination window. The database loca

Page 211

Appendix BDatabase Maintenance26314.In the Select Backup Destination dialog, click the OK button to close it. You are returned to the Backup Database

Page 212

Chapter 1Introduction3and create custom reports and queries. [IntelliTrack DMS v8.1 supports Microsoft Access 2007 and 2010* (*for Microsoft Access 20

Page 213 - Data Upload and Download

INTELLITRACK INVENTORY V8.1User Manual26416.In the Options portion of the Back Up Database window, in the Over-write Media portion to the right, selec

Page 214

Appendix BDatabase Maintenance26518.The database is backed up. (Note the default location of your database backup file; it is found in the Destinatio

Page 215 - Chapter 14

INTELLITRACK INVENTORY V8.1User Manual2663.Once you are connected, the IntelliTrack database appears in the Object Explorer portion (left pane) of the

Page 216

Appendix BDatabase Maintenance2674.Select the IntelliTrack database that you want to restore and then right-click it. The right-click menu appears.5.

Page 217

INTELLITRACK INVENTORY V8.1User Manual2686.The Restore Database window appears. It automatically selects the Destination and Source to restore. This i

Page 218

Appendix BDatabase Maintenance2699.The Specify Backup dialog appears. Click the Add button in the Spec-ify Backup dialog.10. The Locate Backup File w

Page 219 - Batch Portable, on page 203

INTELLITRACK INVENTORY V8.1User Manual27012.Click Ok to close the Specify Backup window. You are returned to the Restore Database window. This file lo

Page 220 - Data Sync

Appendix BDatabase Maintenance27114.In the Select Page portion of the Restore Database window select the Options selection to view the Options portio

Page 221

INTELLITRACK INVENTORY V8.1User Manual27216.If restoring a backup to the same database that the backup file came from, the Restore As “destination” se

Page 222

Appendix BDatabase Maintenance27318.When the database is successfully restored, the following message appears onscreen.19. Click OK to close the mess

Page 223

iii2) as a reseller, you may sublicense repackaged units of the Software in the original packaging of this Software as licensed to you by ITI., includ

Page 224 - Uploaded

INTELLITRACK INVENTORY V8.1User Manual4Note the software serial number of this product because you will need this information during registration and

Page 225

INTELLITRACK INVENTORY V8.1User Manual2742.These utilities are found in your program folder:• For 32-bit systems:For 64-bit systems:TABLE 19. IntelliT

Page 226 - Processing

Appendix BDatabase Maintenance2753.To create a backup, double-click the backup utility file backup.bat. A backup file of the database called backup.d

Page 227 - Return on Each Error

INTELLITRACK INVENTORY V8.1User Manual276From the Administrative Tools, select Services to reach the Services list.2. In the list of Services, locate

Page 228

Appendix BDatabase Maintenance2774.Select Properties from the right-click menu. The databackup Proper-ties window appears.5. In the databackup Proper

Page 229 - Using the CE Batch Portable

INTELLITRACK INVENTORY V8.1User Manual2786.Click the Add button in order add the name of the network service account that SQL Server uses. The Select

Page 230

Appendix BDatabase Maintenance2798.Click OK to add the account to the Groups or user names area of the Security tab. The Select Users, Computers, or

Page 231

INTELLITRACK INVENTORY V8.1User Manual28010.Click OK to close the databackup Properties window. Your databackup folder now has the necessary permissio

Page 232

281Appendix CCompact Workstation UtilityOverviewCompacting the Workstation Application File2287.book Page 281 Thursday, July 7, 2011 4:45 PM

Page 233

INTELLITRACK INVENTORY V8.1User Manual282OverviewWhen you install IntelliTrack Inventory, a Compact utility is created for the workstation application

Page 234 - The About

283Appendix DManual IIS SetupOverviewManual IIS RDA Setup RequirementsManually Configuring IIS on Windows XP/WindowsServer 2003 Operating SystemsSetti

Page 235

Chapter 1Introduction5 Portable Device SupportIntelliTrack DMS includes the DMS RF portable support and DMS CE Batch portable support; thus allowing y

Page 236

INTELLITRACK INVENTORY V8.1User Manual284OverviewThe additional IIS setup information listed in this section pertains to the Manual IIS RDA setup opti

Page 237

Appendix DManual IIS Setup285•If you use a manual RDA setup option with Windows 7/Windows Vista/Windows Server 2008, you must configure the IntelliTra

Page 238 - Collected Data

INTELLITRACK INVENTORY V8.1User Manual286Setting up IIS v6.0 to Allow the DMS Web Service ExtensionIf you are using IIS v6.0 and Windows Server 2003,

Page 239 - Chapter 15

Appendix DManual IIS Setup2876.Enter DMS in the Extension name field.7. Next, click the Add button in the Required files portion of the window. The Op

Page 240

INTELLITRACK INVENTORY V8.1User Manual28811.After you enable the web service extensions for IntelliTrack DMS, make sure the web extension for asp.net

Page 241 - CE Batch: Inventory Functions

Appendix DManual IIS Setup2895.From the IIS Manager, create a virtual folder called IntelliTrack under the Default Website.6. Configure the IntelliTra

Page 242 - Counting Physical Inventory

INTELLITRACK INVENTORY V8.1User Manual290If it exists, double-click to open the Edit ISAPI or CGI Restriction dia-log and make sure that the ISAPI or

Page 243 - Moving Inventory

Appendix DManual IIS Setup291Add SQL Server Compact Edition and apply the settings outlined above in step 4.5. Select the top level node (with the com

Page 244

INTELLITRACK INVENTORY V8.1User Manual2928.To set the executable path, click the browse button (...) in the Execut-able (optional) field. The open win

Page 245 - CE Batch: Data Search

Appendix DManual IIS Setup29310.In the Add/Edit Module Mappings window, click the Request Restric-tions... button.11. The Request Restrictions window

Page 246 - Overview

INTELLITRACK INVENTORY V8.1User Manual62287.book Page 6 Thursday, July 7, 2011 4:45 PM

Page 247

INTELLITRACK INVENTORY V8.1User Manual29413.In the Request Restrictions window, click the Access tab to bring this portion of the form to the front. M

Page 248 - Locations

Appendix DManual IIS Setup295For Windows Server 2008, when the ISAPI-dll mapping are complete, set the feature permissions. Click Edit Feature Permiss

Page 249 - Chapter 17

INTELLITRACK INVENTORY V8.1User Manual296Configuring the IntelliTrack Application PoolThis section applies to the Windows Vista, Windows 7, and Window

Page 250

Appendix DManual IIS Setup297•In Windows Server 2008, go to Start > Administrative Tools > IIS Manager.2. From the Internet Information Services

Page 251

INTELLITRACK INVENTORY V8.1User Manual2984.Once the IntelliTrack Application Pool is selected, right-click to view the right-click menu.5. At the righ

Page 252 - Inventory By

Appendix DManual IIS Setup2996.In the Process Model portion of the Advanced Settings windows, select Load User Profile.7. Select the drop-down arrow i

Page 253

INTELLITRACK INVENTORY V8.1User Manual30011.Next, select Restart in the Application Pool Tasks portion of the Actions navigation pane to restart the p

Page 254

301Appendix EChecking IIS SetupOverviewReaching the Batch Synchronization UtilitySync URL Setting2287.book Page 301 Thursday, July 7, 2011 4:45 PM

Page 255

INTELLITRACK INVENTORY V8.1User Manual302OverviewAfter you have installed the IntelliTrack workstation application and con-figured IIS (depending on y

Page 256 - Search by Site and Lot

Appendix EChecking IIS Setup303Upon startup, the Send Data portion of the Utility is to the front.Sync URL SettingThe Sync URL setting is the network

Page 257

7 CHAPTER 2DMS CE Batch SetupDMS Batch Installation OverviewBatch Installation Prerequisites by Operating SystemBatch Installation Prerequisites for W

Page 258 - Searching by Quantity

INTELLITRACK INVENTORY V8.1User Manual304The Sync URL setting is listed in the Sync URL portion of the form. The Sync URL setting is the network path

Page 259 - Transactions

Appendix EChecking IIS Setup305Vista/Windows 7/Windows Server 2008 Operating System” on page 288.3. Verify that the Sync URL setting matches the netwo

Page 260 - Table 9, “ Batch Portable

INTELLITRACK INVENTORY V8.1User Manual3062287.book Page 306 Thursday, July 7, 2011 4:45 PM

Page 261 - Data Structure

307Appendix FMicrosoft Access IntegrationOverviewFull Access ImportImport Access Inventory DataQuery Import Data – Site TableQuery Import Data – Bin L

Page 262 - Inventory Table

INTELLITRACK INVENTORY V8.1User Manual308OverviewMicrosoft Access is a powerful and flexible database management system. A full version of MS Access a

Page 263 - Inventory Table (Continued)

Appendix FMicrosoft Access Integration309custom Access query to place the information in the appropriate Intelli-Track table and fields.Before importi

Page 264 - Inventory by Location Table

INTELLITRACK INVENTORY V8.1User Manual310In the last window, name the table and click Finish.If existing data is going to be stored in several files,

Page 265 - Bin Location Table

Appendix FMicrosoft Access Integration311Click Ye s.Save the query as Import Sites. Click OK. 14. To verify the data is in the Site table:Select the S

Page 266 - Field Types

INTELLITRACK INVENTORY V8.1User Manual312Click on the Table tab.Select the Bin Location table.Click Open to view the imported data.Query Import Data

Page 267 - Numeric Fields Size Settings

Appendix FMicrosoft Access Integration313Click on the Table option in the Navigation Pane.Select the Inventory table.Click Open to view the imported

Page 268

INTELLITRACK INVENTORY V8.1User Manual8DMS Batch Installation OverviewThis section covers DMS CE Batch installation issues and procedures. Use the DMS

Page 269 - Database Maintenance

INTELLITRACK INVENTORY V8.1User Manual314Select the Inventory by Location table.Click Open to view the imported data.Exporting DataTo export data with

Page 270 - Verifying Database Connection

Appendix FMicrosoft Access Integration3154.Enter an optional description in the Description column.5. Enter the name of the custom report exactly as n

Page 271 - Connection

INTELLITRACK INVENTORY V8.1User Manual3162.The Form wizard appears. Select a table or query to use as a data source from the Select a Table/Query drop

Page 272 - User Manual

317Appendix GCustomizing IntelliTrackCautions when Customizing IntelliTrack2287.book Page 317 Thursday, July 7, 2011 4:45 PM

Page 273

INTELLITRACK INVENTORY V8.1User Manual318Cautions when Customizing IntelliTrackIf you have the appropriate version of Microsoft Access, you can modify

Page 274

319Appendix HBar Code SymbologyBar Code Symbology Characteristics2287.book Page 319 Thursday, July 7, 2011 4:45 PM

Page 275

INTELLITRACK INVENTORY V8.1User Manual320Bar Code Symbology CharacteristicsTable 21, “Bar Code Symbology Characteristics,” on page 320 summarizes the

Page 276

321Appendix ISample ReportsHistory by Date ReportHistory by Item# ReportInventory by Category ReportInventory by Location ReportInventory by Lot/Exp.

Page 277 - Changing the

INTELLITRACK INVENTORY V8.1User Manual322History by Date Report2287.book Page 322 Thursday, July 7, 2011 4:45 PM

Page 278

Appendix ISample Reports323History by Item# Report2287.book Page 323 Thursday, July 7, 2011 4:45 PM

Page 279

Chapter 2DMS CE Batch Setup9Batch Installation Prerequisites by Operating SystemThe steps for completing the IntelliTrack DMS Batch Application prereq

Page 280

INTELLITRACK INVENTORY V8.1User Manual324Inventory by Category Report2287.book Page 324 Thursday, July 7, 2011 4:45 PM

Page 281

Appendix ISample Reports325Inventory by Location Report2287.book Page 325 Thursday, July 7, 2011 4:45 PM

Page 282 - Database Backup and Restore

INTELLITRACK INVENTORY V8.1User Manual326Inventory by Lot/Exp. Date Report2287.book Page 326 Thursday, July 7, 2011 4:45 PM

Page 283

Appendix ISample Reports327Inventory Item Detail Report2287.book Page 327 Thursday, July 7, 2011 4:45 PM

Page 284

INTELLITRACK INVENTORY V8.1User Manual328Inventory Item Summary Report2287.book Page 328 Thursday, July 7, 2011 4:45 PM

Page 285 - Appendix B

Appendix ISample Reports329Inventory w/Pictures Report2287.book Page 329 Thursday, July 7, 2011 4:45 PM

Page 286

INTELLITRACK INVENTORY V8.1User Manual330Inventory, Negative Quantity Report2287.book Page 330 Thursday, July 7, 2011 4:45 PM

Page 287

Appendix ISample Reports331Overstock Summary Report2287.book Page 331 Thursday, July 7, 2011 4:45 PM

Page 288

INTELLITRACK INVENTORY V8.1User Manual332Reconciliation Report2287.book Page 332 Thursday, July 7, 2011 4:45 PM

Page 289

Appendix ISample Reports333Reorder Report2287.book Page 333 Thursday, July 7, 2011 4:45 PM

Page 290

INTELLITRACK INVENTORY V8.1User Manual105.After you setup Remote Data Access and install IntelliTrack, test your setup by going to the DMS Batch Synch

Page 291 - “Database

INTELLITRACK INVENTORY V8.1User Manual3342287.book Page 334 Thursday, July 7, 2011 4:45 PM

Page 292

Index335IndexAAccess Levelssecurity 66Actionswith computer mouse xxActivationsecurity 65ActiveSyncrequired setting for CE Batch 27Add / Edit Queries

Page 293

INTELLITRACK INVENTORY V8.1User Manual336viewing data 208CE Batch Portable Applicationopening on the handheld device 160Change databases 255Changin

Page 294

Index337FirewallWindows XP required settings for CE Batch 31Formatting Conventions xxivFormsCustom 315HHelp Filereaching 43HistoryLogging 139option

Page 295

INTELLITRACK INVENTORY V8.1User Manual338option 59MMaintenancefront-end 255Menuin CE Batch Utility 173renaming in the CE Batch Utility 176Messagein

Page 296

Index339Reports 79, 141Adding your own 79Ribbon Tabs, selecting xxSSearchfeature in CE Batch 220Securityaccess levelsuser 68activating 65option 60p

Page 297

INTELLITRACK INVENTORY V8.1User Manual340to backup database 273VViewhistory log 139inventory 138system reports 141WWindows XPrequired firewall sett

Page 298

Chapter 2DMS CE Batch Setup11Required IIS Settings for Windows 7 and Windows VistaImportant:These requirements pertain to Windows Vista/Windows 7 oper

Page 299 - Utilities

INTELLITRACK INVENTORY V8.1User Manual121.After you turn on IIS, you need to turn on specific IIS features. In the Windows Features window, click on t

Page 300

Chapter 2DMS CE Batch Setup137.Click the plus sign next to the Security selection, the options available for this selection appear, mark the check box

Page 301 - Databackup Folder Permissions

INTELLITRACK INVENTORY V8.1User ManualivITI's entire liability and your exclusive remedy under this guarantee (sub-ject to your returning the Sof

Page 302

INTELLITRACK INVENTORY V8.1User Manual14Please refer to “Remote Data Access (RDA) Components” on page 17 for more information.8. After you setup Remot

Page 303

Chapter 2DMS CE Batch Setup15Windows Server 2003 Requirement AFTER DMS InstallationWindows Server 2003 Operating Systems use IIS v6. If you are using

Page 304

INTELLITRACK INVENTORY V8.1User Manual165.In the Ta s k s portion of the window, select Add a new Web service extension... option. The New Web Servic

Page 305

Chapter 2DMS CE Batch Setup1711.After you enable the web service extensions for IntelliTrack DMS, make sure the web extension for asp.net 2.0 is allow

Page 306

INTELLITRACK INVENTORY V8.1User Manual18IntelliTrack Workstation ApplicationThe IntelliTrack workstation application is used to input system data, run

Page 307 - Compact Workstation Utility

Chapter 2DMS CE Batch Setup19more information about installing ActiveSync on your desktop computer, please refer to “Installing Microsoft ActiveSync o

Page 308

INTELLITRACK INVENTORY V8.1User Manual20RDA ConfigurationImportant: The sections that follow deal with advanced network settings. Consult your system

Page 309 - Manual IIS Setup

Chapter 2DMS CE Batch Setup21knowledge. For more information about manual IIS setup, please see “Manual IIS RDA Setup Options” on page 25.In determini

Page 310

INTELLITRACK INVENTORY V8.1User Manual22•sqlcesa35.dll: the resource dll for the application’s use of IIS.• Permissions: security rights to write and

Page 311 - “Configuring the Intelli

Chapter 2DMS CE Batch Setup23Notice that IIS and SQL Server are installed on one local computer, hence, this RDA setup supports automatic IIS setup wi

Page 312 - Extension

vGovernment Restricted Rights Legend; International UseUse, duplication or disclosure by the United States Government is subject to restrictions of Re

Page 313

INTELLITRACK INVENTORY V8.1User Manual24•Since IIS and SQL Server reside on the same computer, the Create IIS Dependencies Utility (Start > All Pro

Page 314

Chapter 2DMS CE Batch Setup25ally configure it. For manual IIS configuration setup procedures, please see “Manual IIS Setup” on page 283. To see manu

Page 315 - Setting Up IIS

INTELLITRACK INVENTORY V8.1User Manual26Manual IIS Setup Security RequirementsWhen you use a manual IIS setup option, please be aware of the following

Page 316

Chapter 2DMS CE Batch Setup27PC and Handheld Device CommunicationDepending on your operating system, you will use either Microsoft Active-Sync or Wind

Page 317

INTELLITRACK INVENTORY V8.1User Manual28In the Microsoft ActiveSync application, click File > Connection Set-tings. The Connection Settings window

Page 318

Chapter 2DMS CE Batch Setup29handheld according to the instructions that came with your handheld device. If a partnership is already established betwe

Page 319

INTELLITRACK INVENTORY V8.1User Manual30with PC-device connection and Windows Mobile Device Center Software installation.Setting Up a Windows Mobile P

Page 320

Chapter 2DMS CE Batch Setup31Applying Firewall ExceptionsImportant:This is an advanced setting. Please consult your network administrator before apply

Page 321 - Appendix D

INTELLITRACK INVENTORY V8.1User Manual322287.book Page 32 Thursday, July 7, 2011 4:45 PM

Page 322 - Configuring

33 CHAPTER 3Getting StartedBasic Startup ProceduresUsing the ApplicationLogging into the Workstation ApplicationUsing the Security Ribbon OptionsLoggi

Page 323

INTELLITRACK INVENTORY V8.1User Manualvi2287.book Page vi Thursday, July 7, 2011 4:45 PM

Page 324

INTELLITRACK INVENTORY V8.1User Manual34Basic Startup ProceduresUpon installation, you are provided with sample data. Use IntelliTrack DMS Inventory w

Page 325

Chapter 3Getting Started35Using the ApplicationBefore you set system options and enter any data, it is a good idea to become familiar with the worksta

Page 326

INTELLITRACK INVENTORY V8.1User Manual36Select a user ID (if you are using the sample data, it contains sample users). If security is enabled and a pa

Page 327 - Checking IIS Setup

Chapter 3Getting Started37Changing your PasswordIf security is enabled in the application, the Change Password option is available in the Manage >

Page 328

INTELLITRACK INVENTORY V8.1User Manual38Closing the ApplicationTo close the application, you must select the Quit option in the Manage > Security r

Page 329

Chapter 3Getting Started39To preview a query onscreen, select it from the dashboard’s query list and then click the View button. (If the View button i

Page 330

INTELLITRACK INVENTORY V8.1User Manual40tab ribbon options are displayed. Selecting a ribbon option will open an application form.If a selection in th

Page 331 - Appendix E

Chapter 3Getting Started41Do It! Run or process the data files.Duplicate Duplicate existing record.Edit Edit or modify the data record.Filter Select s

Page 332

INTELLITRACK INVENTORY V8.1User Manual42Precautions When Entering DataWarning: When entering data in the application, DO NOT USE special characters or

Page 333 - Microsoft Access Integration

Chapter 3Getting Started43Help Ribbon OptionsThe application contains online help and an About screen. The online help contains information about usin

Page 334 - Full Access Import

Table of ContentsviiTable of ContentsIntelliTrack DMS SOFTWARE License Agreement... iiLicense ...

Page 335 - Import Access Inventory Data

INTELLITRACK INVENTORY V8.1User Manual44Use the Contents tab to view the help contents; to reach a help topic, click on the content listing. The help

Page 336 - Data – Site

Chapter 3Getting Started45Selecting Help > Help > About option from the ribbon opens the About screen.The About screen contains useful applicati

Page 337 - Data – Bin

INTELLITRACK INVENTORY V8.1User Manual462287.book Page 46 Thursday, July 7, 2011 4:45 PM

Page 338

47 CHAPTER 4Purging DataIntroductionA Note About Sample DataReaching the Purge OptionsPurging Uploaded Physical Inventory DataPurging History DataPurg

Page 339 - Inventory by

INTELLITRACK INVENTORY V8.1User Manual48IntroductionThe Purge function manages application data by deleting old or obsolete information from the appli

Page 340 - Custom Reports

Chapter 4Purging Data49The Purge options include:• History• Uploaded Inventory• Select from All Data• Lookup Tables• Empty LocationsPurging Uploaded P

Page 341 - Custom Queries

INTELLITRACK INVENTORY V8.1User Manual501.Select Tools > Purge > History purge selection from the ribbon. The Purge History Data form appears.2.

Page 342

Chapter 4Purging Data51This option includes all the system purge options on one form. You may delete all or selected items including history data and

Page 343 - Customizing IntelliTrack

INTELLITRACK INVENTORY V8.1User Manual527.When you are ready to purge all the selected data, click the Do It but-ton found along the bottom of the for

Page 344

Chapter 4Purging Data534.To delete Units of Measure Lookup Table data, mark the Measure check box.5. Click the Do It button to purge the selected data

Page 345 - Bar Code Symbology

INTELLITRACK INVENTORY V8.1User Manualviiiviii CHAPTER 2: DMS CE Batch Setup ...7DMS Batch Installat

Page 346

INTELLITRACK INVENTORY V8.1User Manual542287.book Page 54 Thursday, July 7, 2011 4:45 PM

Page 347 - Sample Reports

55 CHAPTER 5System SetupIntroductionSystem SetupSetup Form ButtonsEntering Company InformationSetting System OptionsSetting International OptionsSetti

Page 348 - History by Date Report

INTELLITRACK INVENTORY V8.1User Manual56IntroductionBefore you begin using IntelliTrack DMS Inventory to assist with storing, tracking, and managing y

Page 349 - History by Item# Report

Chapter 5System Setup57Setup Form ButtonsThe Setup form buttons are described in the chart below.Setup Form ButtonsTABLE 2. Setup Form ButtonsButton D

Page 350 - Inventory by Category Report

INTELLITRACK INVENTORY V8.1User Manual58Entering Company InformationWhen you select Tools > Setup > Setup option in the ribbon, the Com-pany In

Page 351 - Inventory by Location Report

Chapter 5System Setup59Setting System OptionsSystem options are set in the Options portion of the form. To set system options, please refer to the ins

Page 352

INTELLITRACK INVENTORY V8.1User Manual60Sum Inventory on View: check this box to automatically update inventory quantity when you open the View Invent

Page 353 - Inventory Item Detail Report

Chapter 5System Setup61able on any forms. If you select the All option, pictures are viewable on all forms.Setting International OptionsThe internatio

Page 354 - Inventory Item Summary Report

INTELLITRACK INVENTORY V8.1User Manual623.The date format is displayed for your reference. The date format matches the date format set for your PC in

Page 355 - Inventory w/Pictures Report

Chapter 5System Setup631.The form contains four options in the Pull Down List field:Item/Locations: specify the data lookup option(s) for the Item Lis

Page 356

Table of Contentsix CHAPTER 4: Purging Data ...47Introduction...

Page 357 - Overstock Summary Report

INTELLITRACK INVENTORY V8.1User Manual642.Click the drop-down arrow in the Default Site field and select the default site from the list that appears.

Page 358 - Reconciliation Report

Chapter 5System Setup65System Users System users are added by the Administrator. Each user is assigned an access level, which grants or denies the use

Page 359 - Reorder Report

INTELLITRACK INVENTORY V8.1User Manual66Assigning Security Privileges to System AreasSecurity privilege access levels range from one to nine. The secu

Page 360

Chapter 5System Setup672.Place the access level in the Level column next to the Description col-umn.Important: You do not have to assign all nine leve

Page 361

INTELLITRACK INVENTORY V8.1User Manual68Maintaining System UsersSystem users are added by the administrator. Each user is assigned an access level, wh

Page 362

Chapter 5System Setup693.The Create User form appears. Enter the user name in the UserID field; press the TAB key on the keyboard.4. The cursor is pla

Page 363

INTELLITRACK INVENTORY V8.1User Manual70the cursor next to the newly created user); and assign an access level in the Level field (enter a value betwe

Page 364

Chapter 5System Setup713.In the User ID column, edit the username.4. In the Level column, edit the user access level.2287.book Page 71 Thursday, Jul

Page 365

INTELLITRACK INVENTORY V8.1User Manual725.Click the Close button found along the bottom of the form to close the form and save the changes.Changing th

Page 366

Chapter 5System Setup736.When you are finished, click the Close button found along the bottom of the form to close the Change Password form and set th

Commentaires sur ces manuels

Pas de commentaire