The letters or phrase in parenthesis is how the field is represented on the Item Inventory Browse screen
Store (SC)
The store code associated with the inventory. Click F8 view and select store codes.
Product Code (PC)
The product code associated with the inventory
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.
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.
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 beside the PO#.
Private Item #
Once the item record has a history even if the inventory is unassigned the ability to change the item number is locked. The adjustment feature can be used to transfer to another Item and at that time the Item number can be changed.
Private Item Name (Private Name)
This is for private labeling
Description
Description is the information used to separate the item into colors or varieties.
Private Description #
This is for private labeling
Width
The measurement for the item
Length
The measurement for the item.
Units
The unit of measure by which the material is sold.
Seq #
This number is automatically generated by the system for items with the same item number. The sequence number is incremented by 1 each time a record with the same item number is received.
Run Lot
This information is optional
UD Ser #
The name of this field user definable in >Utilities>System Options>System Wide>Inventory>Serial Number Prompt. Change the name to something meaningful. For example, name this field "Size" and use it to enter Rug sizes.
System Reference Number
The System Reference number (SRN) is a unique identifier generated for each inventory record.
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.
Manf SKU
Some vendors send a product id number as assigned from the manufacturer which differs from their SKU.
Sidemark
This field is used to add any identifiers, job name, etc. to the item. These notations can be added to the purchase order and will pull into the inventory record, or can be added or edited directly on the inventory record.
Comments
These comments can be added to the purchase order and will pull into the inventory record, or can be added or edited directly on the inventory record.
Inventory User #
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 Prompt.
Lading #
This is the bill of lading number on which the items were received by the supplier
Date Rcvd
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.
Invoice #
System supplied. The vendor invoice number is automatically inserted when the item is costed. Once costed or if the roll has history attached, the invoice number cannot be changed.
Invoice Date
The vendor invoice date. This date is inserted automatically when the item costed and may not be changed.
Location
The location indicates where the inventory is physically located. This field may be left blank if your store does not track locations for inventory. Optional - Twelve characters. The location will print on the roll tags. If you use the Bar coding module, you can perform physical inventory counts and reconciliations by location. The bar coding module utilizes an electronic scanner and bar code labels.
Carton/Buying Qty
If a carton/buying quantity is entered in products, it will display here.
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.
Qty Rcvd
This indicates the last amount received.
Qty Used
The "USED" amount is supplied by the system, based on the assignment of lines in Order Entry. "USED" refers to units that are in a "CUT," "DELIVERED" or "JOB-COSTED" status. Also, any size adjustments made to the item will appear in the "USED" total. The value of the used material is not reflected in inventory value reports.
Qty Resv
The "RESERVED" amount is supplied by the system, based on the assignment of lines in Order Entry.
The "RESERVED" amount reflects the total units assigned from this roll. The value of the reserved material is reflected in inventory value reports.
Soft Reserved: The amount which has been put on a temporary hold, but can still be sold.
Qty Aval
This amount is calculated by the system in the following way:
Beginning amount MINUS Used MINUS Reserved
Unit Price
Enter a selling price or click the F8 button to choose a price from the price selector or C access the price calculator to enter a formula.
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.
Additional Information Tab
This information can be added or edited from this table. If it is in the Products file, it will pull from there. This field will print on the .csv output of Item Inventory Value Report, Item Inventory Range Report and Item Inventory Physical Report.
The fields are
Private Collection
Collection
Price Code
Construction
Fiber
Country
Comments
Article is closed for comments.