After creating new inventory items or deleting old ones, the following functions/rebuilds should be run. 

Select: Inventory Menu
# 10 Utilities
# 26 Sequence Number Conversion
Sequence numbers are a means of assigning a logical order to your inventory items within each product category.  They control the layout of reports and the order in which the items display during inquiries.  Sequence numbers may be assigned manually or by running this function.  They are also used as a cross-reference to the item number and control the order in which items display when the auto forward/backward feature is used.

Select: Inventory Menu
# 3 Miscellaneous Maintenance
# 24 Rebuild Inventory Cross Reference
This function rebuilds the cross references between the item number and it’s description, sequence number, search key, vendor number, vendor item number, and bar code.  It is necessary to be able to search for an item by any one of these cross-references.  It may be run at any time but may take some time depending upon the number of items currently on file.

Select: Inventory Menu
# 3 Miscellaneous Maintenance
# 25 Rebuild Vendor Cross Reference
This function rebuilds the cross references between the item number and the bar code.  It is necessary to be able to scan bar codes at point for sale.  It may be run at any time but may take some time depending upon the number of items currently on file.

Select: Inventory Menu
# 3 Miscellaneous Maintenance
# 26 Rebuild Master Chain
This function is necessary to create the auto forward/backward linkage between item numbers.  It is dependent upon the cross reference of item number to sequence number, therefore, the Sequence Number Conversion and Rebuild Inventory Cross Reference functions must be performed first.

This is a STAND ALONE function and should be run on USER 0 in order to process faster and without causing slowness for other users.

Common UPC Code (Alias) File

Common UPC Code Maintenance allows the user to attach as many cross references to an item as necessary.  This is commonly used for products that have unique item numbers and UPC codes, but are actually the same product, with identical costs and selling prices.  (ex. Beanie Babies – instead of having an inventory master and store record setup for each individual Beanie Baby, you could simply enter each UPC code into this file under one item number).
This file may contain other alphanumeric cross-references, not only bar codes. (ex. you're in-house coding system, or a completely different item number that a staff member uses to reference your computer item number).  Once a cross reference is entered into this file, it is immediately written to the vendor cross reference file, therefore, it can be scanned or entered at point of sale without running any rebuilds.  However, if a cross reference is deleted, it will remain in the vendor cross-reference file until the following rebuild is run.

Select: Inventory Menu
# 3 Miscellaneous Maintenance
# 25 Rebuild Vendor Cross Reference
To manually enter a cross reference into the Common UPC Code file:

Select: Inventory Menu
# 3 Miscellaneous Maintenance
# 33 Common UPC Code Mtce