The View/Update function is used to view inventory records, update single records, transfer, dispose or update one or more values in a selected batch of records. Retrieving the desired record(s) may be accomplished using the search, query, structure search or scan tag functions. To gain access to the view/update menu items, the user must be granted access to Update Inventory. The search results grid may be customized. Customize Results Grid

Search Tab

1. Log in with a user name and password that has been granted access to Lookup Inventory.
2. Choose the appropriate Module.
3. Click View/Update from the menu on the left side of the home screen.
4. Click the Search tab.
5. Enter selection parameters.
   • Choosing a Department value will filter the list of available Current Users to the users in that department. Clear the department value to display all current users. 
   • Searching by Location with no other parameters selected will return all records within the selected location. Clicking the icon will open the location tree.
   • Searching by Location Type is dependent upon the information included when the location was added to the system.
   • Toggle the check mark next to Include Sublocations to include sublocations in the search.
   • The Chemical Name parameter may be filtered by Is, Contains, Starts With or Ends With.  The default value is contains.  When using the chemical name parameter, you may search by Catalog entry or Synonym.  Synonym values within the catalog records may not be complete.
   • Searching by CAS number will return all records that share the value.
6. Click Search. Records matching the search criteria will populate in the results grid below the search tab.
7. Click Clear Results to clear all records from the results grid.

Query Tool Tab

1. Log in with a user name and password that has been granted access to Lookup Inventory.
2. Choose the appropriate Module.
3. Click View/Update from the menu on the left side of the home screen.
4. Click the Query Tool tab.
5. Select the desired Field, Condition and Value parameters.
6. Click Add.  Multiple parameters can be defined and added to the search criteria.
7. Individual parameters may be modified by selecting new Conditions and/or Values for a Field followed by clicking the blue Select text then clicking Update.
8. Individual parameters may be deleted by clicking the blue Select text in the first column followed by clicking Delete.
9. Clicking Clear deletes all defined criteria.
10. Once all search parameters have been defined, click Search. Matching records will populate in the Search tab.

Structure Search Tab

1. Log in with a user name and password that has been granted access to Lookup Inventory.
2. Choose the appropriate Module.
3. Click View/Update from the menu on the left side of the home screen.
4. Click the Structure Search tab.
5. Structures or substructures may be loaded from files or drawn using the Ketcher software. 
6. Ketcher settings are accessed by clicking the Cog button .
7. Help files are accessed by clicking the Question Mark button . 
8. Additional search criteria can be utilized by designating Location and/or Current User.
   • Choose a Location from the drop down menu or click the icon to access the location tree.
   • Choose a Current User from the drop down menu or click the icon to select the currently logged-in user.
9. To search for the Exact structure or Substructure click the corresponding check box.
10. Click Search. Matching records will populate in the Search tab.

Scan Tag

Use the scan tag function to view a group of records that may not share a common value that can be used in the search or query tools.

1. Log in with a user name and password that has been granted access to Lookup Inventory.
2. Choose the appropriate Module.
3. Click View/Update from the menu on the left side of the home screen.
4. Enter or scan a Chem Tag # in the Scan Tag section of the search tab.
5. Click Search Chem Tag # or the Enter key.
6. The record will show in the results grid below the Search tab.
7. Repeat the tag search with each Chem Tag # until all desired records are displayed.
8. Click Clear Results to clear the records from the results grid.