Inventory > Inventory Fields

Listed below are the available inventory fields a short description of the fields function. Inventory Fields with descriptions in red below and on the inventory editor are required fields and must be filled in to create a new item.

Stock Number - A unique item identification number. 50 characters.

Description - The description of the item. 250 characters.

Manufacturer Part # - The manufacturer's part number. 50 characters.

Vendor Part # - The vendor's part number. 50 characters. The vendor part number will be used on purchase orders to properly identify the vendor's item.

Preferred Vendor - The item's preferred vendor.

Department - The department for the item. Used to categorize your inventory for reporting.

Class - The class for the item. A class is a further categorization of your inventory for reporting. This can be used as a sub-department but can be independent of the departments.

Stock Type - The stock type of the item. See: Inventory Stock Types

Matrix Definition - The matrix associated with the item if the item is a sized item. See: Size Matrix

Quantity - On Hand Quantity for each location. See quantity descriptions in the Inventory Manager.

Last Cost - The last received cost for the item.

Suggested Retail - The suggested retail selling price for the item. This price is used on the Sales Screen to show discount percentages to be calculated.

Price 1 - The actual selling price of the item.

Price 2 - Additional selling price for the item based on customer pricing level.

Price 3 - Additional selling price for the item based on customer pricing level.

Price 4 - Additional selling price for the item based on customer pricing level.

Price 5 - Additional selling price for the item based on customer pricing level.

Dynamic Cost (Use Dept. Margin if Avg Cost = $0.00) - Checking this box will allow you to sell an item and RetailEdge will calculate a cost based on the margin of the department it is associated with. This can be useful when you want to discount a consignment item and the consignor gets a fixed percentage of the selling price. Dynamic Cost is calculated when the sale is posted, so changing pricing after the item is entered onto the sales screen will affect the calculated cost of the item. This is different from Department SKUs and Non-Entered items, that determine a cost when the item is initially entered onto the sales screen and subsequent changes to the price do not affect the initial cost.

Min Sales Price - This will prevent clerks from over discounting an item. This also can be useful for consignment items when a consignor has a minimum price they want to receive for an item.

Split pricing - Normally 1, but can be set to a value that will allow you to sell an item at totals that can't normally be sold at based on the unit cost (e.g., 3 for $1.00). This can also be accomplished with discount rules.

Bin/Shelf - The physical location of the item within the business.

Min/Max Fields - Fields used for item reordering quantities and can be used for auto-generating purchase orders. There are four different minimums and maximums to allow for quarterly seasonality ordering differences.

UPC 1 Code - Item UPC (Universal Product Code). Usually the barcode that comes on pre-barcoded items.

UPC 2 Code - Alternate UPC item lookup code. Can be used for any other barcode that comes with the item (e.g., European Article Number EAN)

Export/Report Code - User defined code. Is used for many different report filters.

Sales Screen: Ask For Quantity - Check this box for items you want to have automatically prompt for a quantity other than one. This can be useful for businesses that have items always sold multiple quantities.

User Fields 1-5 - Additional fields used for filtering inventory and reports (i.e., Author, Publisher, etc.).

Tare Weight - Weight of item that will be automatically removed from the quantity when being sold.

Manually Weighed Item Checkbox - Check this box if you want to have the item automatically prompt for a quantity when sold and append the weight units to the description of the item.

Manual Weight Unit - Units for manually weighed items. This will automatically append this value along with the unit price (e.g., @$100.00/lbs MAN WT) to the item's description when selling a manually weighed item.

Export Weight Value - Weight of the item. The values can be exported in an inventory export or imported in a REDI import file format and can be exported in a customer shipping export for use in an external shipping program.

This Item Requires Age Verification Checkbox - Check this box to enable the ability for the item to prompt for age verification when selling the item.

Minimum Age for this item - The minimum age that a customer must be to purchase this item.

Sales Screen: Automatically Use Scale - Check this box for items that will always be weighed using an attached scale at the point of sale.

Notes 1 - Notes for the item. Can be used for product notes about ordering, etc.

Notes 2 - Additional Notes the item. Can be used for longer descriptive information and captions that can be used on web sites.

Notify at Sales Screen Checkbox (Notes 1 and 2) - Check this box if you want the contents of the inventory notes field(s) to be displayed when the customer is entered on the Sales Screen (e.g., dry clean only, does not work with item XYZ, etc.).

First Date - Item creation date.

Last Edit Date - Last date item was edited.

Last Edit Time - Last time item was edited.

Item ID - Unique item identifier. For additional information see: RetailEdge Item ID.

Average Cost - The average cost for the item. For additional information see: Tracking Inventory Costs.