Page History: Item Master
Compare Page Revisions
Page Revision: Thu, 30 Jul 2009 12:21
Default Menu Location
Maintain >> Item Control >> Item MasterGeneral Description
Item Control is a scalable inventory and item management solution that tracks inventory levels, costs, prices, transaction history, inventory locations, and much more. Complex pricing for purchasing and sales is easily maintained through separate item pricing and product groups. The Item Control module also allows you to maintain costs on several levels and automatically update costs based on multiple variables. It handles an unlimited number of warehouse locations, serialized items, and lot-controlled items and allows for the inclusion of freight in/out, direct, and indirect costs of the item. Attach notes to any item that automatically print on purchase orders, quotes, sales orders, and invoices. Easy-to-use search features make finding similar/substitution items a breeze and a wide-ranging drill-down tool gives you instant insight into any item in your database.
Basic
Item Master - BasicsBasics tab displays some basic information of an item. It also includes five user-defined fields,
Today's Prices.
The rules for pricing display is maintained in the
Rule Maintenance screen by selecting Pricing for Basics from the drop-down menu.
Fields/Filters
Default Supplier: Default supplier/vendor for this item
Supplier Part#: Default supplier's part number for this item
Unit Group: Unit group for this item
Stock Unit: Stocking unit for this item
Price Group: Price group for this item
Product Group: Product group for this item
Item GL Code: Item Transaction Category for this item
Base Cost: Base cost for this item
List Sale Price: List sale price for this item
Sale Pricing Unit: The unit this item is priced by
Settings
Item Master - SettingsSettings tab is used to maintain the item's main properties.
Fields/Filters
Unit Group: The unit of measure group for this item
Purchase Unit: The default unit of measure for purchase
Stock Unit: The unit of measure the item stocked
Sell Unit: The default unit of measure for sale
Units of measure and their conversions are maintained in the
Rule Maintenance screen under Units of Measure.
War. Length: The warranty length for a produced item
Misc Code: User defined field
Unit Weight: Each unit's stock weight
Cubes: Used to further track inventory inside the warehouse
Sq. Ft: The square footage of the item
Qty Dec: The quantity of decimal places allowed when entering a quantity of the item
Stock Item: Stocked in a warehouse
Sales Tax: The item will have applicable sales tax
Resell: To sell the item more than once
Misc Item: Miscellaneous item (This will allow you to edit the item's description when it is used on a service order.)
Serialized: Check this box if you wish to track the item's serial numbers (All received serialized items will be logged as assets in the Asset Information screen.)
Lot # Control: Check this box if you wish the item to be lot controlled
Expiration Date: Check this box if the item has an expiration date (You will be required to enter an expiration date when this item is received.)
Hold For Inspection: Check this box if the item needs to be held for inspection upon arrival
Produce: Check this box if the item is run through production in order to be created
Active: Check this box if the item is active within your system (Leaving this box unchecked makes the item completely unusable.)
Pack Code: Packing code for the item
Price Group: The item's Price Group
- Price Groups are used to determine pricing in the Contract Master and are also used to determine margins in the Margin Calculator
- Price Groups are maintained in the Rule Maintenance Screen by selecting Item Pricing Codes from the drop-down menu
Comm Code: The item's Commodity Code
- Commodity Codes are used in the procurement system to Generate Vendor Inquiries
- Commodity Codes are maintained in the Rule Maintenance Screen by selecting Item Commodity Codes from the drop-down menu
Prod Grp: The item's Product Group
- Product Groups are used to determine pricing inthe Contract Master
- Product Groups are maintained in the Rule Maintenance screen under Item Product Group Codes
Item GL Code: Select the item's general ledger code
- Item GL Codes are maintained in the Rule Maintenance screen under Item Transaction Codes
Class: User defined field (Some inventory reports may be sorted by class)
ABC Code: The ABC Code is calculated based on item usage or on-hand value
- ABC codes are maintained in the Manage ABC Codes screen
Search Code: Similar/like/alternate items can have the same search code and be brought up on a list when clicking the button
Commission Code: Select the commission code for the item
- Commission codes are maintained in the Rule Maintenance screen under Commission Percentage Codes
Base Cost: The base cost of the item according to Stock Unit
- This cost is used as a base for the cost-plus calculations performed on the Group Pricing tab of the Contract Master
- The base cost will be updated based on PO Receipts if the Update BCost on Receipt attribute is selected
Direct Cost: Enter any direct costs associated with the item here
Indirect Cost: Enter any indirect costs associated with the item here
Freight In Cost: Enter the freight costs associated with receiving the item into inventory
Freight Out Cost: Enter the freight costs associated with shipping the item
Avg Cost: Average Cost is the system-maintained, weighted average cost of the inventory item
- This cost is used for inventory on-hand reports and monthly activity reports
- This is also the cost that is transferred to the GL
List Sale Price: The item's list sale price
- This price is used to price the item if no other contract rule can be applied to the part
Sale Pricing Unit: The unit of measure used to determine the item's pricing
