Store
The store code associated with this inventory. Click F8 view and select store codes.
Product Code
Enter "01" for Carpet or "02" or Vinyl. No other entry is allowed in this field.
Manufacturer
Enter the manufacturer of the material. If the manufacturer is the same as the supplier, leave this entry blank. The system will automatically insert the supplier name, after the supplier field is completed.
Manufacturer from Manufacturer File Only (Products, Inventory and Purchase Orders) controls whether or not a manufacturer must be pulled from the manufacturer file. If so, click the ellipsis button to access the manufacturer file. If the manufacturer is not yet in the file, it can be entered from this screen.
If importing buying group electronic product files, the switch should be checked to ensure data entry consistency.
Supplier
Enter the first few characters of the supplier name and click or press F8 to import from the supplier file.
Supplier From Supplier File Only (Products, Inventory and Purchase Orders) controls whether or not a supplier must be pulled from the supplier file. If so, click the ellipsis button to access the supplier file. If the supplier is not yet in the file, it can be entered from this screen.
If importing buying group electronic product files, the switch should be checked to ensure data entry consistency.
Private Supplier
Enter the name of the private supplier company, if applicable.
PO #
The purchase order number will be supplied automatically by the system if the material is added from an open purchase order. Otherwise, no entry in this field is allowed. The type of PO is listed besides the PO#.
Style
Enter the private label style name or press F8 to import product information from the pricing file. The manufacturer and supplier name must be an exact match to the manufacturer and supplier name in pricing for this style. If no match is found, a message will display.
Color
If the style name was imported from pricing and colors have been entered, the private label color name will also be imported.
The system uses the names entered in the PRIVATE label style and color fields for search functions. If private label names are not used, the mill names should be entered in these fields.
Style #
Optional. Enter the style number supplied by the mill.
Style Type
Press F8 to access the Style Family pick list. For example: Berber, Cut & Loop, etc. Highlight the desired style type and press Enter to select. Additional options are:
Add a Style Type
Edit an existing style type
Delete an existing style type
If the style name was imported from products, the type will also be imported.
Priv Color #
Enter the color number supllied by the mill
Color Type
Press F8 to access the Color Type pick list. This field is NOT the actual color of the carpet. Enter the color type, for example, Solid, Multi-tone, etc.
Add a color type
Edit an existing color type
Delete an existing color type
If the color was imported from Products, the color type will also be imported.
Fiber
Optional
Press F8 to access the Fiber Type pick list (nylon, etc.)
Add a fiber type
Edit an existing fiber type
Delete an existing fiber type
Quality
Optional. Press F8 to access the Quality Type pick list. (First, Second, Best, etc.)
Backing
Optional. Press F8 to access the Backing Type pick list.
Dye Lot
Optional. Enter the dye lot number supplied on the bill of lading or shipping ticket.
Roll/Cut
Click the down arrow to select either Roll or Cut. The default is Roll.
Pile Height
Optional. Enter the pile height, up to four decimal places for carpet.
Pile Weight
Optional. Enter the pile weight, up to four decimal places.
Toxicity #
Optional - Eighteen characters.
SKU
The SKU field is designed to interact with the RFMS E-Commerce program, also known as B2B. This field will be populated from the Product Catalog and will carry through to the Inventory Record. The field is 48 characters in length.
Manufacturer SKU
Some vendors send a product id number as assigned from the manufacturer which differs from their SKU.
Collection
Private Collection
Roll #
Required - up to twelve characters. The roll number is usually the same as the mill roll number to allow for easier tracking. If not using the mill assigned roll numbers, click the F8 button to assign a sequential computer generated number. If the Roll is costed and not assigned to anything, the roll number may be edited.
Enter the first three characters of the mill or supplier name in front of the roll number for instant identification, i.e., CC10939 for Carpet Company - roll number 10939.
Date Received
The date received is manually entered when receiving a roll on a Bill of Lading. Use the system date or click the F8 button to access the on-line calendar. If the roll is received through a supplier invoice, the date received field is the same as the invoice date. This is important for aging inventory.
Invoice #
System supplied. The vendor invoice number is automatically inserted when the roll is costed. For more information, see Costing Rolls in this section. Once costed or if the roll has history attached, the invoice number cannot be changed.
If the manufacturer or supplier name is changed on a roll, ALL other rolls that were costed on the same manufacturer invoice number will also be changed.
Invoice Date
The vendor invoice date. This date is inserted automatically when the roll is costed and may not be changed.
Location
Optional - Twelve characters. The location will print on the roll tags. If using the Bar coding module, perform physical inventory counts and reconciliations by location. The barcoding module utilizes an electronic scanner and barcode labels.
Sidemark
Optional - Twelve characters. The side mark will print on the roll tags.
Comments
User Number
This field is numerical field and can be up to two decimal places. No calculations or conversions for square feet versus square yards are done on this field. One use for this field could be to track the weight of material.
The label for this field is set in >Utilities>System Options>System Wide>Inventory>User Number
Gross Cost
Enter the per square yard or foot gross cost of the material or press F8 to import product information from the Products file, if that file has been established. The gross cost is used for calculating material costs during job costing.
Net Cost
Gross Cost MINUS Discount Amount PLUS freight the system will automatically calculate the net cost or it may be entered manually.
Freight
Freight cost per square yard or foot. If a freight factor is used, the freight amount will be entered by the system when the roll is costed.
Load
Enter a flat dollar amount on a roll or item inventory record that is added to the cost on a customer order job cost. This number does not post to the general ledger.
Width
Enter the width of the roll. Convert inches to decimal. For example, a 12' 6" length would be entered as 12.5. Press <Shift F1> to access the RFMS conversion chart.
Beginning Length
Enter the beginning length of the roll. The length is entered as linear feet (convert inches to decimal.) The system calculates the square yards. The beginning length will always remain as originally entered.
Used
The "USED" amount is supplied by the system, based on the assignment of lines in Order Entry. "USED" refers to square yards that are in a "CUT," "DELIVERED" or "JOB-COSTED" status. Also, any size adjustments made to the roll will appear in the "USED" total. The value of the used material is not reflected in inventory value reports.
Reserved
The "RESERVED" amount is supplied by the system, based on the assignment of lines in Order Entry. The "RESERVED" amount reflects the total square yards assigned from this roll. The value of the reserved material is reflected in inventory value reports.
Available
The available linear feet on the roll (square yard conversion is to the right of this field.) This amount is calculated by the system in the following way: Beginning Length MINUS Used MINUS Reserved.
Unit Price
Choices here include:
1. Enter a selling price manaully.
2. Price Selector-This screen is accessed by pressing F8 at the unit price field on the inventory record. Click the option to select a selling price for individual roll records from those entered on the corresponding product record.
3. Price Calculator-Click C to access. This tool will copute a selling price based on a user-defined formula. For more information, click here.
Initial Value
This dollar amount is calculated by the system and is the amount received multiplied by the gross cost. It is used for display and historical purposes only and cannot be changed.
View PO 
This button allows viewing the purchase order for the current inventory record. No editing is possible.
Notes 
This button allows adding, editing or deleting notes for the current inventory record.
Comments
Article is closed for comments.