Supertrack Inventory
Previous  Top  Next


Menu Navigation

Lists ... Inventory ... Supertrack Inventory List
Activities ... Inventory ... New Inventory Item
Activities ... Inventory ... Inventory Explorer


About Supertrack Inventory

The Supertrack Inventory system is the linchpin of this business management software. This extensive system allows you to track the ordering, receipt, and sale of tangible items and intangible services. It also keeps tabs on expenses and supplies purchased for company use. Redemption of coupons and trade-in's can easily be tracked as well. Items can be grouped together to form kits or abbreviated with aliases, for easier data entry. Items can also be assembled (manufactured) from other items. Even serial numbers and lot numbers can be individually managed. These diverse kinds of tracking make this feature truly a "super" track inventory.


In this Topic
   Field by Field Help - Supertrack Inventory screen
   Intellisearch
   Supertrack Inventory List
   Inventory Explorer
   Q & A - Supertrack Inventory


Related Topics
   2.7   How to Use Lists
   2.10   How to Use Activities
   3.6   Setup Accounting
   9.2   Inventory Templates
   9.3   Inventory Aliases
   9.4   Serial Numbers and Lot Numbers
   9.5   Categories
   9.6   Departments
   9.7   Measures
   9.8   Manufacturers
   9.9   Warranties
   16.9   Lists and Labels




Field by Field Help - Supertrack Inventory screen

Buttons

Save
Click this button to save the current information and return to the previous window.

View Activity Log
Click this button to view the activity log for this customer record, which denotes any changes made to any field in the record.

Attach documents to this record
Click this button to view or attach documents to this record in the Intellifile Explorer.

Send Records to Lists & Labels Manager
Click this button to send the selected record to the Inventory Lists & Labels Manager so that it can be included in the next printing of labels for inventory.

exclaimIf you have multiple locations defined in ManageMore, be sure to double-check the item that is selected before sending it to the Lists & Labels Manager for processing. Each individual location will have its own list fo inventory items for which labels are to be created, thus sending the right item in the wrong location will cause the label not to print until the other location does so.  

General


Inventory Template
Select a user-defined template for this item. This field determines the setting for the Supertrack Kind field, and can also be used for easy, automatic entry of many of the supertrack inventory fields.

fig9-1
Figure 9-1.   Supertrack Inventory screen

Supertrack Kind
Displays the kind of inventory assigned by the template chosen. This critical value determines the behavior of the item. The supertrack kind cannot be changed once the item has been used on a transaction. The following kinds are available:

Tangible InventoryItems used on all documents. Items are quantity tracked. Items are subject to costing (Cost of Goods Sold) on sale documents.  
 
Intangible InventoryItems used on purchase and sale documents only. Items are not quantity tracked. Items are not subject to costing on sale documents.  
 
ExpenseItems used on purchase transactions only. Items are not quantity tracked.  
 
SuppliesItems used on purchase and inventory documents only. Items are quantity tracked.  
 
RedemptionItems used as deductions on sale documents. Items are not quantity tracked.  
 
Kit CompositionItems used to define groups of other items. Items are quantity tracked for informational purposes.  
 
exampleKit compositions are extremely useful for companies that sell items in a bundled fashion, but can also sell the individual components/parts that encompass the grouped item. For example, a Bath Gift Set could be considered one item that is comprised of several items, also sold separately (e.g. Body Wash, Soap, Shampoo, and Conditioner).  

SKU Item
Enter the alphanumeric Stock Keeping Unit code used to identify the item. Numeric codes are recommended, especially if barcodes are used. Once the SKU item has been used on a transaction, this field cannot be modified.

UPC Item Code
Optionally enter the Universal Product Code number of the item in this field. This value can be used to locate an item while creating transactions.

Location
Enter or select the location where this SKU is used, such as a retail store or warehouse. A SKU must be entered for each location that will create transactions for the item. The SKU may be entered for multiple locations simultaneously using the duplicate SKU option provided.

Full Description
Enter the description of the SKU to be printed on documents, and for searching for items. Unlike other software, the program's advanced Intellisearch feature eliminates the need to organize the items by the first word entered in the description. The program can search for any phrase or partial phrase entered, no matter its location in the description.

Short Description
Enter the description of the SKU that appears on narrow SKU selection lists. This value also appears on narrow-format documents (e.g. 20-column and 40-column receipts)

Create label(s) to print when item received
If checked, then the receipt of this item via a purchase receipt will cause labels to be put into the Lists and Labels queue for later printing.

Serialized Item Tracking
If checked, the program will allow individual serial numbers or lot number to each unit of inventory. A new tab labeled "Serial Numbers" will be available. This option will be available only on tangible items which have not already been used.

Recurring Item
If checked the item will be posted with start and end dates when a recurring transaction is generated for this item. These values are used to compute unearned revenue.

Discontinued Item
If checked, this item will no longer be available for new transactions, and will be excluded from most lists. The item, however, can still be used in transactions.

Automatically discontinue item when zero on hand
If checked, the program will automatically place the item on "discontinued" status when the quantity on hand reaches zero. This is especially useful for items which will no longer be sold, but for which a quantity remains in stock.

Item on Hold
If checked, this item will temporarily not be available for new transactions.

bulbSuppose you have an item that is being recalled. You can select "Item on Hold" to stop any and all transactions from involving that item.  

Automatically duplicate this SKU for all other active locations
If checked, the program will automatically enter a duplicate of the new item being added for every active location in your company. This allows for quicker data entry with less errors.

Stock Status

These fields contain the quantities of inventory for this SKU.

infoThe number of decimal places displayed in the stock status fields is determined by the quantity precision setting in the Inventory section of Setup ... Accounting.  


Quantity Available
Displays the current quantity that is available for sale. It is found by subtracting the quantity held and quantity committed (S.O.) from the quantity on hand.

Quantity On Hand
Displays the on hand count of this item.

Quantity Held
If return processing is used, displays the current quantity held in return processing, items that have been returned but have not been processed.

Quantity Transfer Pending
Displays the total quantity awaiting transfer into the location denoted above.

Quantity Transfer Out
Displays the total quantity transferred out of the location denoted above, that has yet to be received by the receiving location.

Quantity Pending (P.O.)
Displays the total quantity of this item that is currently not received in open purchase orders.

Quantity Committed (W.O/S.O.)
Displays the total quantity of this item awaiting sales order fulfillment or work order fulfillment.

Reorder Point Quantity
Enter the quantity at which this item should be reordered. This value is used on reports and for the AutoFill feature.

Minimum Quantity Level
Enter the lowest quantity of this item for this location. This value is used on reports.

Maximum Quantity Level
Enter the highest quantity of this item for this location. This value is used on reports and for the AutoFill feature.

Detail

Department ID
Enter or select the department identification code applicable to this item. Department codes are used to separate your inventory for analysis and reporting.

Category ID
Enter or select the category identification code applicable to the item. Category codes are used to separate your inventory for analysis, reporting, and inventory counts. This can also be used to copy some of your items from one location to another.

Warranty ID
Enter or select the identification code of the warranty applicable to the item.

Manufacturer ID
Enter or select the identification code of the manufacturer of the item. Manufacturer codes are used to identify manufacturer information more quickly and easily as well as filtering items out for use in inventory count, and reporting.

Commission ID
Enter or select the identification code of the commission structure to be used for calculating the commission amounts for the sale of this item.

Ship Weight
Enter the weight of the item, per unit, for shipping purposes. The ship weight is used in conjunction with the shipping methods to automatically calculate shipping charges, when applicable.

Net Weightgear
Enter the net weight of this item as it pertains to the calculation of tax by volume.

Bin Location 1, 2, 3
Enter a value that can be used to indicate an item's physical location, such as aisle number, shelf, or container number. This is useful when attempting to locate an item for invoicing or inventory counts. These values are optionally used for sorting inventory count reports.

User-Defined Field 1-5
Enter any user defined information in these fields, such as Manufacturer or Model Number. The descriptions of the fields are dependent upon the template selected, and can be edited in the template record(s).

Full Size Image
Enter or select the file that contains a graphic representation of the item, such as a photograph or drawing. This image can be in GIF, JPG or BMP format. This value is used by the program to display an image of the item selected.

Thumbnail Image
Enter or select the file that contains a graphic representation of the item in thumbnail (miniature) format, similar to the full size image above. This value is used by the program to display an image of the item selected.

Pricing

Average Cost
Displays the unit average price paid for the item. This value is updated automatically as new transactions are made, but may be adjusted manually. This value is used to record cost of goods sold and inventory reduction for tangible items on invoices entered, if the average costing method is chosen on this item. This value may optionally be used to calculate price. This field is not displayed for supertrack kinds of Expense and Supplies. The number of decimal places displayed in this field is determined by the cost precision setting in the Inventory section of Setup ... Accounting.

Unit Last Cost
The last price per unit paid for the item. This value is updated automatically as new transactions are made, but may be adjusted manually. This value is used to record cost of goods sold and inventory reduction for tangible items on invoices entered, if the last costing method is chosen on this item. This value is optionally used to fill new transactions. This field is displayed only for supertrack kinds of Tangible and Intangible. The number of decimal places displayed in this field is determined by the cost precision setting in the Inventory section of Setup ... Accounting.

Lowest Selling Price
The lowest sale price for this item. The program can optionally disallow any entered price that is less than this set price. This field is displayed only for supertrack kinds of Tangible, Intangible, and Kit.

Latest Cost
The last price paid for the item. This value is updated automatically as new transactions are made, but may be adjusted manually. This value is optionally used to fill new transactions. This field is displayed only for supertrack kinds of Expense and Supplies. The number of decimal places displayed in this field is determined by the cost precision setting in the Inventory section of Setup ... Accounting.

Promotion Plan Id
Enter or select a promotion plan ID to apply to this item. Based on the value present, a promotional discount will be applied to automatically adjust pricing for this item when entered on a transaction. This value can be set for multiple items using the global price change feature.

Suggested Retail Price
Enter the retail price for this item. This value is optionally displayed on labels and screens.

Web Sale Price
Enter the selling price of the item on the company website. This value is used for e-commerce functions.

Price Calculation
Select the method by which the program should calculate the price of the item.

Markup Percentage   Applies to standard and price break pricing. Defined as the profit divided by the cost of the item. Markup% = 100 × (Sale Price - Latest Cost) / (Latest Cost). Has no maximum. Enter the percent or actual value for each standard price. Enter the percentage for each tier.

Margin Percentage   Applies to standard and price break pricing. Defined as the profit divided by the sale price of the item. Margin% = 100 × (Sale Price - Latest Cost) / (Sale Price). Has a maximum of 99.99%. Enter the percent or actual value for each standard price. Enter the percentage for each tier.

Fixed Percentage   Applies to price break pricing only. Enter the percentage in decimal format BY which to change the price for each tier (e.g. a 5.00% price decrease is entered as 5.00).

Reduction Amount   Applies to price break pricing only. Enter a flat amount BY which to reduce the price for each tier (e.g. a 5.00 price decrease is entered as 5.00).

Fixed Price   Applies to price break pricing only. Enter a flat amount TO which to set the price for each tier.

Price Rounding
Select the rounding method to use.

Not RoundedDo not adjust the value.  
 
to the Nearest AmountAdjust the decimal value of the price to the amount provided.  
 
Ending with NumberAdjust the decimal value of the price to end with the number provided.  

Price Adjustment
Enter the value used with the price rounding calculation.

SKU Base Price
Enter the base price for each price level. This value may be automatically filled based on the markup/margin calculation.

Markup/Margin Calculation
If either of these price calculation methods are used, enter or select the percent to use for each price level.

Allow price break discount on base price
If checked, will allow the user to enter discounted prices/percentages based on the quantity of an item.

Accounting

Calculate Invoices for this item with {Tax Type}
If checked, this item will be included in tax calculation for the tax type on sale transactions.

Income GL Account/Expense GL Account
The GL account to be credited for sale transactions and debited for purchase transactions.

Cost of Goods GL Account
The GL account to be debited for the cost of sale transactions. This account is only used for tangible inventory items.

Inventory/Expense GL Account
The GL account to be credited for the cost of sale transactions, debited for purchase transactions, and adjusted by inventory transactions. This account is only used for tangible and supply inventory items. The expense account is only used for intangible and expense inventory items.

Adjustment GL Account
The GL account to be debited for a decrease adjustment, credited for an increase adjustment. This account is only used for tangible and supply inventory items.

Scrap/Shrinkage GL Account
The GL account to be credited for scrap or shrinkage due to use of most of a product but not all (scrap), or when items are lost due to theft (shrinkage). This account is only used for tangible items only.

Variance GL Account
The GL account to be debited or credited when costs change during the assembly of a manufactured item. This amount is usually defined as the Extended Cost minus the Standard Cost minus the Scrap Cost.

Vendor

Purchasing Method
Select the method to use when purchasing this item for this location.

Location Based   The item is purchased and received at this location.
Centralized gear   The item is purchased and received at another location and transferred to this location. This option will be available only if the centralized purchasing feature is activated.

Select Vendor Level
Select the vendor level which will apply to all of the remaining fields. A set of values will be maintained for each level.

Vendor ID
Enter or select the vendor ID for the vendor level chosen. The settings for this level will apply when the selected vendor is chosen.

Purchase SKU
Enter the SKU the vendor chosen uses for this item, if different than the SKU used by the company. This value will default to the SKU item. This value will be optionally printed on purchase documents.

Purchase Description
Enter the item description the vendor chosen uses for this item, if different than the SKU used by the company. This value will default to the SKU description. This value will be optionally printed on purchase documents.

Best Cost
This field displays the lowest cost paid for this item from this vendor. This value is for informational purposes, and is updated automatically by the program. This value may be edited.

Last Cost
This field displays the most recent cost paid for this item from this vendor. This value is optionally used to prefill purchase transactions, and is updated automatically by the program. This value may be edited.

Minimum Order
The least quantity of this item which can be ordered from the selected vendor. This value is used to optionally AutoFill purchase transactions.

Economical Order
Enter the most cost-effective quantity of the item that you can order from the vendor. This value may optionally be used to AutoFill purchase documents. EOQ can be generally defined using the following formula:

eoq


Last Purchase Order
Displays the last date this item was ordered from the selected vendor. This value is updated automatically by the program. This value may be edited.

Lead Time (In Days)
Enter the number of days between the date when the item is ordered for the selected vendor and the date it is expected to be received into inventory. This value is used to calculate the estimated delivery date.

Memo Alert Note
Enter a note that will appear to the user automatically every time the item is entered on a purchase order. This value is for internal purposes and will not print on any documents.

Statistics

First Date Sold
Displays the first date this item was included on a sales invoice. This value is maintained by the program, but may be edited by the user.

Last Date Sold
Displays the last date this item was included on a sales invoice. This value is maintained by the program, but may be edited by the user.

Last Date Ordered
Displays the last date this item was placed on a purchase order. This value is maintained by the program, but may be edited by the user.

Est. Delivery Date
Displays the date (based upon lead time) that this item should be received. This value is maintained by the program, but may be edited by the user.

Total Quantity Sold
Displays the overall quantity of this item sold by the company. This value is maintained by the program, but may be edited by the user.

Total Discards
Displays the overall quantity of this item removed from inventory through return processing. This value is maintained by the program, but may be edited by the user.

Average Sale Price
Displays the average sale price for all sales of this item. This value is maintained by the program, but may be edited by the user.

Last Date Counted
Displays the last date this inventory item was counted using the Inventory Counts feature. This value is maintained by the program, but may be edited by the user.

Classification
Select a classification for this item based on the frequency this item should be counted. Choose from A, B, or C. This classification is used in conjunction with Physical Inventory Counts.

Month To View
Select a month in which to view historical information on this SKU.

Prior Year to View
Select a previous year in which to provide comparative data.

Statistics
Displays statistics for this item, maintained by the program. Some of these values can be edited.

Notes

Internal Notes
Enter notes about this item that will only be seen by users of the program.

Transaction Item Notes
Enter notes about this item that will be printed on transactions directly below the associated item. This value may be optionally overridden on selected transactions.

Web


Post SKU to Internet
When checked, this item is available for online sale. This setting can be enabled automatically when posting items for sale via e-commerce inventory export.

Web Sales Information
Enter any notes or text to display on the website about the item. This text can contain HTML tags.

Preview HTML
Click this button to see what the text will look like on the Web, if HTML tags are used.

Web Sale Price
Enter the selling price of the item on the company website.

Full Size Image/Thumb Nail Image
Click the appropriate buttons to select, delete, or view a picture to be used on the website as a full size image, or a thumb nail (small size) image.

Attributes

Attributes are additional fields of information that you can use for any purpose. Some examples are color, size, distribution center name, etc.

Set up attributes for your Supertrack inventory items by selecting Setup...Accounting...Inventory and choosing the Attributes tab

Options


Quantity Validation Precision
Enter the number of decimal places that the quantity of this SKU should use. This value may be less than or equal to the quantity precision setting in the Inventory category of Setup ... Accounting.

with valid sale increments of
Enter the number by which this item's quantity must be a multiple of on sales transactions.

Default Sale Quantity
Enter the default quantity for this item on sales transactions, which may optionally be overridden.

Purchase Units of Measure
Enter or select the unit of measure used on purchase transactions. The quantity from the unit of measure chosen will be multiplied by the transaction quantity to determine the actual unit effect.

Sale Unit of Measure
Enter or select the unit of measure used on sale transactions. The quantity from the unit of measure chosen will be multiplied by the transaction quantity to determine the actual unit effect.

Inventory Unit of Measure
Enter or select the unit of measure used to display the quantity counts on this inventory item. This unit of measure will be displayed in the appropriate column on inventory transfers and inventory adjustments.

Skip Description / Quantity / Price
When checked, causes the chosen field to be skipped when this item is used on a transaction.

Allow/Do not Allow Changes
Choose whether the selected field will allow user changes when this item is used on a transaction.

Item Restocking Fee after XX days
Enter the percentage amount that should be charged as a restocking fee, should this item be returned by the customer after the specified number of days. This will adjust the unit price for this item on the refund transaction.

Inventory Cost Method
Select the method of costing to be used for this item:

AverageUses the current average cost when calculating the cost in a transaction.  

LastUses the current last cost when calculating the cost of an item in a transaction.  

FIFO (First In, First Out)Uses the cost of the first goods acquired which are still on hand when calculating the cost of an item in a transaction.  

LIFO (Last In, First Out)Uses the cost of the last goods acquired which are still on hand when calculating the cost of an item in a transaction.  




Intellisearch

The Intellisearch method is an easy-to-use, convenient method of searching for items in your Supertrack inventory. The power of Intellisearch lies in its ability to retrieve Supertrack items by a keyword or phrase in the item's description. Intellisearch can look for items even if you do not know the exact spelling of the keyword or phrase, or if partial words are entered.

example   Lets say you have several items entered into inventory, with descriptions as follows:

   Deluxe Widget with Gold Trim
   Widget Professional 2000
   Standard Base Model Widget

   A search for "Widget" or even "Widjit" or "Wigit" will find any of these items.


To activate the Intellisearch feature, select Setup...Options...General Options and check the box labeled "Allow fast inventory description searches using Intellisearch lookup engine" in the Company Setup tab. Click OK to save the new settings.

Once you have enabled Intellisearch, a new tab labeled "Intellisearch" will be present in your Supertrack inventory in Lists...Inventory...Supertrack Inventory List. You will also see this tab whenever you click the SKU Search button on a transaction. To use the Intellisearch feature, simply switch to the Intellisearch tab and type a keyword or phrase that identifies the item in the Search field. You will be presented with a list of Supertrack items with descriptions that match the word(s) you have entered.

Check the box labeled "Search inventory from current location only" to search items only from the location in which the user is currently located. Check the box labeled "Use Sounds-like Search Method" if you want the program to search for keywords based on pronunciation instead of spelling.



Supertrack Inventory List

The Supertrack Inventory List contains several functions that can be carried out directly from this screen.

Copy Inventory
Click this button to copy inventory items from one location to another. The user can copy all items or only those in a certain category. All item fields will be copied except for quantity information.

View FIFO/LIFO item layers
Click this button to view/edit cost layers for SKU items. This button will be available only for items which use FIFO or LIFO as the inventory costing method.

Show inventory from current location only
If checked, SKUs from the login location only will be visible.

Show discontinued SKU items
If checked, discontinued items will be displayed.

Show Internal SKU items used by program
If checked, internal SKU items will be displayed. These items are used by various processes of the program and cannot be deleted.



Inventory Explorer

The Inventory Explorer window allows a user to select items and change their status within the Supertrack Inventory list. This window allows you to make these changes quickly and easily via selection, drag and drop method.

Refresh Data
Click this button to have ManageMore update the window with current data from the Supertrack Inventory list.

Select All
Click this button to select all items in the right pane of the window.

Select None
Click this button to deselect all items in the right pane of the window.

[Classification]
Select the method by which items should be grouped on the left pane of this window. Selections include: Categories, Commission, Department, Kind, Location, Manufacturer, Template, and Warranty. Selecting a method will update the folders in the left pane of the window.

[Item Information]
Displays the information about inventory items that match the condition set in the left pane of the window. Information includes: SKU Item, Location, Description, Qty on Hand, Qty on Order, Average Cost, Last Cost, Price Levels 1-8, Suggested Mfg. Retail Price, Lowest Sell Price, Web Sale Price, Quantity Held, Quantity Reorder, Min. Quantity Level, and Max. Quantity Level. Double clicking on any item will display the item's supertrack inventory record.

exampleIf you want to select multiple items, simply click them one after the other. Clicking on the item again will deselect the item. Once you have items selected, you may then drag them to another folder in the left pane of the window. Doing so will change each selected item's characteristics to match the folder you just dragged the items into. For example, if you selected several items, then dragged them into a Category folder named Services, then all of the dragged items's Categories would change to Services.  

Show inventory from current location only
Check this box to show inventory from the location you are logged into only. Note that if you select this box while exploring items from another location, the right pane of the window will go blank.

Show discontinued SKU items
Check this box to view all inventory items marked discontinued, in addition to those not marked.

Show Internal SKU items used by program
Check this box to view any internal inventory items ManageMore uses. Under most conditions, these items may not be dragged and dropped into different folders.




Q & A - Supertrack Inventory


Q01. I created all of my SKUs and everything is set properly. But now, I'm opening a second store. Do I have to create all of my SKUs again?  
A01. No, simply click on the Copy Inventory Icon when you are in the Supertrack Inventory List. Enter your first location in the "From" field, and the new location number in the "To" field. Then click the OK button. ManageMore will then copy all SKUs to the new location.  
 
Q02. Can I delete a SKU item if I am no longer selling it?  
A02. We highly recommend that you not delete SKU items, unless they have never been used on any transaction. Deleting an item will cause problems when trying to refund an invoice, transfer or adjust inventory, or when trying to post to the General Ledger. Simply mark the item as discontinued.  
 
Q03.Given all of the possible pricing scenarios (price levels, quantity price breaks, alias pricing, promotional pricing, and customer pricing), how is the selling price calculated?  
A03.ManageMore uses a "lowest selling price" scheme to determine the correct price that should appear when creating sales documents. The calculation works by considering all of the following factors that affect item price:  
A. Calculate the base selling price for the item (based on price level)  
B. Determine selling price based on quantity ordered (based on price level)  
C. Determine selling price for specific person (customer-based specific pricing)  
D. Determine selling price in a specified period (promotional pricing)  
E. Determine selling price if item is aliased (alias pricing)  
The selling price that is the least of all possible pricing calculations will be the amount shown on the document.  
 
Q04.I don't see my question here. Where else can I get information?  
A04.Visit our website's Technical Support section.  
 


© 2006 - Intellisoft, Inc. All rights reserved.
Other Related Links
  Business Software | Cellular Software | Pager Software | Business Management Software