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.

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.

Grouping

Items used to define groups of other items that are intended to be sold together, but can be modified as necessary on the invoice. Items are not quantity tracked as each item that makes a group is quantity tracked individually.

These values are available for all supertrack kinds except Expense and Grouping.

Enter the department that will be prefilled on new items that use this inventory template.

Enter the category that will be prefilled on new items that use this inventory template.

Enter the warranty that will be prefilled on new items that use this inventory template.

Enter the manufacturer that will be prefilled on new items that use this inventory template.

Enter the commission type that will be prefilled on new items that use this inventory template.

These values are used to define the user-defined fields to be used when this template is chosen. This is not available for a Grouping

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.

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 910.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.

Select the default rounding method to use when calculating prices based on percentages on new items that use this inventory template.

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.

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.

Select the default taxation application for new items that use this inventory template.

The default GL account to be credited for sale transactions and debited for purchase transactions.

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

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.

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.

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.

Enter the value which the auto-generated number should always start with, if any.

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.

Enter the number that will be added to the Next Sequence Number, each time a unique number is generated.

When checked, will add a calculated check digit onto the end of the newly-generated number to decrease data entry errors.

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 Setup Inventory.

Enter the default number by which items' quantity must be a multiple of on sales transactions.

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

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.

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.

Select the default values for these fields. When checked, causes the chosen field to be skipped when this item is used on a transaction.

Select the default values for these fields. Choose whether the selected field will allow user changes when this item is used on a transaction.

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.

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.

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?



	© 2015 - Intellisoft Solutions, Inc. All rights reserved.

	Other Related Links
	Business Software \| Cellular Software \| Pager Software \| Business Management Software