Inventory Masterഀ
ഀ
SKU NUMBER (12 Alpha/Num)	│__│__│__│__│__│__│__│__│__│__│__│__│ഀ
LOCATION CODE (2 Num)		│__│__│ഀ
DESCRIPTION (40 Num)					ഀ
	│_│_│_│_│_│_│_│_│_│_│_│_│_│_│_│_│_│_│_│_│_│_│_│_│_│_*│_│_│_│_│_│_│_│_│_│_│_│_│_│_│ഀ
* Beyond this point will not appear on some reports however it WILL appear on all customer documents.ഀ
ഀ
CATEGORY (2 Alpha/Num)		│__│__│ Must be in Category Fileഀ
PRINT SEQ. (4 Num)		│__│__│__│__│ This # Determines where the Sku prints in price book.ഀ
UNIT OF INVENTORY (5 Alpha)	│__│__│__│__│__│ (EACH, EA, PC, PIECE, MBF, MSF, TSKU, $$)ഀ
MBF/MSF to each (9 Num)		│__│__│__│__│__│__│__│__│__│ 9 Numeric, 5 Decimalsഀ
Aisle (Physical) Location	│__│__│  │__│__│__│ Used for assigning location codes to inventory.ഀ
BULK SK COST % 			│__│__│__│__│__│ Used for bulk inv., i.e. Loose nails or screwsഀ
PRICE 1 (9 Num)			│__│__│__│__│__│__│__│__│__│Code (1 Num) │__│ഀ
PRICE 2 (9 Num)			│__│__│__│__│__│__│__│__│__│Code (2 Num) │__│ഀ
PRICE 3 (9 Num)			│__│__│__│__│__│__│__│__│__│Code (3 Num) │__│ഀ
PRICE 4 (9 Num)			│__│__│__│__│__│__│__│__│__│Code (4 Num) │__│ഀ
PRICE 5 (9 Num)			│__│__│__│__│__│__│__│__│__│Code (  Num) │__│ഀ
MARKUP % 1 (5 Num)		│__│__│__│__│__│			1=EACH, 2= PER 100, ഀ
MARKUP % 2 (5 Num)		│__│__│__│__│__│			3=MBF, 4=MSFഀ
MARKUP % 3 (5 Num)		│__│__│__│__│__│ഀ
MARKUP % 4 (5 Num)		│__│__│__│__│__│ഀ
MARKUP % 5 (5 Num)		│__│__│__│__│__│ഀ
REORDER POINT (5 Num)		│__│__│__│__│__│ഀ
REORDER QTY (5 Num)		│__│__│__│__│__│  VENDOR # │__│__│__│__│__│__│__│ഀ
MIN GROSS PROFIT % (2 Num)	│__│__│SUPPLIER Sku# │_│_│_│_│_│_│_│_│_│_│_│_│_│_│_│ഀ
COST CODE (1 Num)		│__│ഀ
MANUFACTURED SKU (1 Num)	│__│ഀ
WEIGHTED AVG COST (11 Num)	│__│__│__│__│__│__│__│__│__│__│__│ഀ
ON HAND (7 Numeric)		│__│__│__│__│__│__│__│ഀ
ഀ
Sku Number = The actual sku number you want displayedഀ
Location Code = 01 if you are a single location else by locationഀ
Description = Put in the description you wantഀ
Category = Put in a valid category (exp. LB - Lumber, NA - Nails, DO - Doors, etc.)ഀ
Print Sequence = We recommending arranging your categories using every 2nd or every 5th sequence number (i.e. 0002, 0004, 0006, etc.)ഀ
Unit of Inventory = Put in your counting type, up to 5 characters (exp. EA = Each, GAL = Gallon, etc.)ഀ
MBF/MSF = Put in the MBF calculation for lumber usedഀ
Aisle (Physical) location = Put in the location in the storeഀ
Bulk Sku Cost % = Put in the cost percentageഀ
Price 1-5 = Put your highest prices to lowest prices (these are markup prices)ഀ
Markup %1-5 = Put your standard cost plus markup percentagesഀ
Reorder Point = Put in your alert to restock order point (if any)ഀ
Reorder Qty = Put in your minimum reorder quantityഀ
Min Gross Profit % = Put in your minimum gross profit on this item ഀ
Cost code = (1 = each, 2 = 100, 3 = 1000 Linear feet, 4 = 1000 MBF)ഀ
Manufactured Sku = put in Y if you intend to tie this to a separate manufacturer skuഀ
Weighted Avg Cost = put in your average cost on this item or weighted averageഀ
On Hand = Put in the current quantity at your locationഀ
ഀ
For questions call IBS Corporation 888-427-1566