Welcome Guest, you are in: <root>AFIweb • Login

Page History: Item Master

Compare Page Revisions

68 67 66 65 64 63 62 61 60 59 58 57 56 55 54 53 52 51 50 49 48 47 46 45 44 43 42 41 40 39 38 37 36 35 34 33 32 31 30 29 28 27 26 24 23 22 21 20 19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0 Current 68 67 66 65 64 63 62 61 60 59 58 57 56 55 54 53 52 51 50 49 48 47 46 45 44 43 42 41 40 39 38 37 36 35 34 33 32 31 30 29 28 27 26 24 23 22 21 20 19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: Thu, 30 Jul 2009 13:57

Table of Contents [Hide/Show] Default Menu Location General Description Basic    Fields/Filters Settings    Fields/Filters @    Fields/Filters

Default Menu Location¶

Maintain >> Item Control >> Item Master

General 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 insight into any item in your database.

Basic¶

Item Master - Basics

Basics 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 - Settings

Settings 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

@¶

Item Master - @

The @ tab of the Item Master displays the locations of the item selected.

Fields/Filters¶

Rack#: Rack number in the warehouse

Current Qty: Current Quantity

Location: Warehouse location

Held For: Inventory being held for

Supplier: Supplier company

Track#: Tracking number

Owner: Inventory owner

CW Qty: Catch Weight quantity

Serial: Serial number

Lot: Lot number

VarUnit: Variable Unit

VarQty:' Variable Quantity