Menu Navigation
Lists ... Inventory ... Inventory Templates
About Inventory Templates
Inventory Templates make entry of new inventory items easy by providing default values for most of the necessary fields needed to complete an inventory item record. You can set up a template for each of your common types of inventory and provide preset values for items like category, department, pricing, commissions, accounting, and options. You can also select to auto-generate Item SKU numbers for this type of item, which can include a check digit for more accurate data entry.
In this Topic
Field by Field Help - Inventory Template screen
Q & A - Inventory Templates
Related Topics
2.7 How to Use Lists
9.1 Supertrack Inventory
Field by Field Help - Inventory Template screen
General
Inventory Template ID
Enter a unique identifier for this inventory template.
Full Description
Enter a full name for this inventory template.
Supertrack Kind
Displays the kind of inventory assigned by this template. This value determines the behavior of the item. A template of a different kind cannot be selected on an item once the item has been used. The following kinds are available:
| Tangible Inventory | Items used on all documents. Items are quantity tracked. Items are subject to costing on sale documents.
|
|
|
| Intangible Inventory | Items used on purchase and sale documents only. Items are not quantity tracked. Items are not subject to costing on sale documents.
|
|
|
| Expense | Items used on purchase transactions only. Items are not quantity tracked.
|
|
|
| Supplies | Items used on purchase and inventory documents only. Items are quantity tracked.
|
|
|
| Redemption | Items used as deductions on sale documents. Items are not quantity tracked.
|
|
|
| Kit Composition | Items used to define groups of other items. Items are quantity tracked for informational purposes.
|
|
|
|
|
These values are available for all supertrack kinds except Expense.
Department ID
Enter the department that will be prefilled on new items that use this inventory template.
Category ID
Enter the category that will be prefilled on new items that use this inventory template.
Warranty ID
Enter the warranty that will be prefilled on new items that use this inventory template.
Manufacturer ID
Enter the manufacturer that will be prefilled on new items that use this inventory template.
Commission ID
Enter the commission type that will be prefilled on new items that use this inventory template.
Screen Prompts
These values are used to define the user-defined fields to be used when this template is chosen.
Default Prompt
Enter the user prompt for the user defined field, when this template is chosen. If blank, the field will not be displayed for this template.
Picture Format
Enter the picture format to apply to this user defined field.
Default Pricing
Price Calculation
Select the default method by which the program should calculate the price of items, on new items that use this inventory template.
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.
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.
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 default rounding method to use when calculating prices based on percentages on new items that use this inventory template.
| Not Rounded | Do not adjust the value.
|
|
|
| to the Nearest Amount | Adjust the decimal value of the price to the amount provided.
|
|
|
| Ending with Number | Adjust the decimal value of the price to end with the number provided.
|
Price Adjustment
Enter the default value used with the price rounding calculation.
Markup/Margin Calculation
If either of these price calculation methods are used, enter or select the default percent to use for each price level, on new items that use this inventory template.
 | Tier percentage pricing will be entered on individual inventory items in Supertrack Inventory.
|
Default Accounting
Calculate Invoices for this item with (Name of Tax)
Select the default taxation application for new items that use this inventory template.
Income GL Account/Expense GL Account
The default GL account to be credited for sale transactions and debited for purchase transactions.
Cost Of Goods GL Account
The default GL account to be debited for the cost of sale transactions. This account is only used for tangible inventory items.
Inventory GL Account/Expense GL Account
The default GL account to be credited for the cost of sale transactions, debited for purchase transactions, and adjusted by inventory transactions. The inventory account is only used for tangible and supply inventory items. The expense GL account is used on intangible, expense, and redemption inventory items.
Adjustment GL Account
The default 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.
Auto Generate
Allow Automatic SKU generation when adding new inventory items for this template
When checked, allows the program to create a new SKU item number for new items created using this template.
Allow Automatic UPC generation when adding new inventory items for this template
When checked, allows the program to create a new UPC (Universal Product Code) number for new items in this template.
Assign Prefix
Enter the value which the auto-generated number should always start with, if any.
Assign Suffix
Enter the value which the auto-generated number should always end with, if any.
Next Sequence Number
The next value (between the prefix and suffix) that will be used to make a new auto-generated number when this template is used. This value will be maintained by the program, but may be edited.
Auto Increment by
Enter the number that will be added to the Next Sequence Number, each time a unique number is generated.
Add check digit to the SKU/UPC generated value
When checked, will add a calculated check digit onto the end of the newly-generated number to decrease data entry errors.
Options
Quantity Validation Precision
Enter the default number of decimal places that the quantity of this template should use. This value may be less than or equal to the number of decimal places displayed in the system, which is set in the Inventory category of Setup ... Accounting.
with valid sale increments of
Enter the default number by which items' 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 default 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. This applies only to tangible, intangible, and supplies inventory.
Sale Unit of Measure
Enter or select the default 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. This applies only to tangible, intangible, and supplies inventory.
Skip Description / Quantity / Price
Select the default values for these fields. When checked, causes the chosen field to be skipped when this item is used on a transaction.
Allow/Do not Allow Changes
Select the default values for these fields. 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 default percentage amount that should be charged as a restocking fee, should this item be returned by the customer after the default specified number of days. This will adjust the unit price for this item on the refund transaction. This applies only to tangible items.
Inventory Cost Method
Used only for tangible items, select the default method of costing to be used for this template:
| Average | Uses the current average cost when calculating the cost in a transaction.
|
| Last | Uses 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.
|
Q & A - Inventory Templates
| Q01. | Do I have to enter all of the information asked for in the template?
|
| A01. | It is not necessary to enter all of the information, but it is suggested you do. This way, entering a new item is much easier as most of the information concerning pricing, compartmentalizing, and other pieces of information will fill in automatically just from choosing the template.
|
|
|
| Q02. | Should I use inventory templates to separate my different types of inventory so that I can report on them later?
|
| A02. | No. Reports are mainly filtered by departments and categories. However, templates can be used to assign items to different departments and categories.
|
|
|
| Q03. | I don't see my question here. Where else can I get information?
|
| A03. | Visit our website's Technical Support section.
|
