ÿþ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