Use these fields to create and maintain items in FACTS.
*. Item
Specify the item number (up to 20 characters). Press S to enter a default item. Press I to import a catalog item.
Main tab
1. Description 1
Specify the first line of the item description (up to 30 characters). In all inventory reports, the user selects whether to print item description 1, 2 or both.
Note: Due to space limitations, the description may be abbreviated on various reports, forms and screens.
2. Description 2
Specify the second line of the item description (up to 30 characters). In all inventory reports, the user selects whether to print item description 1, 2 or both.
Note: Due to space limitations, the description may be abbreviated on various reports, forms and screens.
3. Alpha
Specify the alphabetic sort key for this item to be used to sort items alphabetically for printouts and searches (up to 10 characters). Users determine the alpha. However, pressing Enter defaults to the first 10 characters of Description 1.
4. Vendor
Specify the primary vendor number. The entry must be a valid vendor number. Press Enter to initially default to the vendor of the item just entered (otherwise the first vendor on file). This vendor entered is used to sort items by vendor for reporting purposes. All inventory reports may be printed in vendor order. The vendor entered is the primary vendor. Secondary vendors may be assigned for purchasing purposes in the purchase orders module.
When changing a vendor in Item F/M, if that vendor has any records in the Buyers Control Center (POE400) for any buyer, the message: Important! Alert buyer to recalculate the BCC due to vendor change! Planned Special Order Purchase Orders on file should be verified for old vendor" to inform buyers of the need to perform recalculation in the Buyers Control Center. This is only a message and does not stop nor prevent the change, and no changes are made to the current BCC records. Exiting planned special orders in the POSUGG file are also checked and if any special orders for that changed vendor (and item shown) exist a message is shown to alert the user to verify existing records for the 'old vendor'.
5. Purchasing Line
Specify the purchasing line for the item. The purchase line information for an item for a vendor is set in Purchase Line Entry (ICE920). This information overrides the vendor defined in Item F/M & over writes it in the Item file. If you modify the primary vendor on a purchase line Purchase Line Entry, the vendor is updated for all of the items on that purchasing line. Before you can update the vendor for an item you must remove the purchase line value by selecting None.
6. Item Class
Specify the item class for this item. The entry must be a valid class. Press Enter to initially default to the item class of the item just entered (otherwise the first item class on file). The item class entered is used to sort items by item class for reporting purposes. All inventory reports may be printed in item class order.
7. Item Type
Specify whether this is a Stocked, Nonstocked, or Uninventoried item. Press Enter to default to S. This flag may be changed only if the item is not in process of an inventory update. Additionally, to change an item type to U-univentoried, there must be no existing quantities for the item. Changing the Item Type displays a message if the item is currently in the Companion files
If you change the item type from stocked to non-stocked or uninventoried, the system reads all ICWHSE records and changes the Replenish setting (located on the Main tab if Warehouse/Item F/M) to No.
If item type is changed from non-stocked or uninventoried to stocked, the system makes no change in ICWHSE table and displays a message advising you to review the Replenish setting on the Main tab if Warehouse/Item F/M and ensure the setting allows for proper replenishment of the item.
When changing an item from Non-stocked to any other type, the system sets all item/warehouse records for this item’s "Allow purchase of non-stocked items w/o SO" flag to "No".
8. Conversion Factor Mask
Specify the conversion factor mask. This field allows you to format conversion factors throughout the system. Nine characters are used (including an optional decimal). Options: ########0, #######.0, ######.00, #####.000, ####.0000, ###.00000, ##.000000, #.0000000. Press Enter to initially default to ########0.
9. Serial/Lot
Specify whether this is a Serialized item, item stored in Lots or Not applicable (neither). Press Enter to initially default to the item last entered (otherwise N). If serial/lot items are not used (as set in the IC static control record), this field is skipped.
10. BOM/Formula
Specify whether this is a Bill of material finished item, Formulation finished item or Neither. Press Enter to initially default to the last item entered (otherwise N). BOM and formulation items are used in the manufacturing module.
11. Active
Indicate whether an item is active. If an item is inactive, the item may not be purchased. The item may be sold through sales orders and may be transferred between warehouses. Press Enter to initially default to the active flag of the item just entered (otherwise Y). If the item is stocked, the system will prompt "Is the item active for purchasing and replenishment?". If the item is nonstocked or uninventoried, the system will prompt "If the item active for purchasing?If you uncheck the Active check box, a message is displayed if parent companion items exist.
12. Sequence Number
If sequence numbers are used, enter the sequence number for this item (up to 5 characters). Sequence numbers are used as a way of determining the order items are to print within the same item class. For example, items 100, 300, 400 and 200 are all assigned the same item class. Without the use of sequence numbers, the items print in this order: 100, 200, 300, 400. If the same items are assigned sequence numbers 100-#10, 300-#5, 400-#20 and 200-#15, the items print in this order: 300, 100, 200, 400.
13. Standard Pack
Specify the standard pack size (1-99999). The entry should be a multiple of the buying unit of measure.
14. Freight Class
Specify the freight classification of this item (up to three characters). Press Enter to default to the freight class of the item just entered. (This does not print anywhere.)
16. Use ROQ for Purchasing
Indicate whether to round up to vendor order quantity (next standard pack) for purchase order documents. This option will round up the recommended order quantity for the item in the Buyer’s Control Center. The unit of measure to utilize is based on an available buying unit of measure for the item.
17-18. Quantity and (UM)
Specify the quantity and UM to be applied, if needed. The default quantity is 1 and must be an integer value for rounding.
19. Use ROQ for Transfers
Indicate whether to round up to vendor order quantity (next standard pack) for warehouse transfers. This option will round up the recommended order quantity for the item in the Buyer’s Control Center. The unit of measure to utilize is based on an available buying unit of measure for the item.
20. Default Item
The system displays the designated default item to use for item creation.
Sales tab
1. Taxable
Indicate whether this item is taxable. This flag is used in the Sales Orders and Purchase Orders systems. In SO and PO the flag may be overridden for individual sales orders and purchase orders respectively. Press Enter to initially default to the item last entered (otherwise Y).
2. Miscellaneous Sales
Indicate whether this item is to post to the miscellaneous sales GL account number in the SO to GL Posting F/M rather than the merchandise sales GL account number. Press Enter to initially default to the item last entered (otherwise N).
3. Use default prices?
Indicate whether to use calculated prices from default pricing, and quantity break units of measure for other pricing and quantity break UMs that do not have prices. You may not want to duplicate pricing records for each unit of measure if all prices for all units of measure calculate to the same price per the default price unit of measure. For example, if there are 10 each per box and the price per each is $1.00 and the price per box is $10.00 then you can simply set up the ‘each’ price allow the system to always calculate the box price for when the item is sold per box. If this flag is set to Y, the system will calculate the price of an item being sold based on the default pricing unit of measure. Press Enter to default to N.
4. Item Price Class
Specify the item price class for this item. This item price class is used to group items by different price types for use in contract pricing, costs and prices updates, and reporting purposes. Some inventory reports may be printed in item price class order.
5. GL Table
Specify the General Ledger posting table to which this item is assigned. The entry must be a valid General Ledger posting table. This GL table determines how the item is to post to the General Ledger module. Press Enter to initially default to the General Ledger posting table of the item just entered (otherwise the first GL table on file).
6. Commission Percent
Specify the commission percentage for this item (0-99.99). This percentage is used if the commissions calculated by item are a priority. Press Enter to default to the commission percentage of the item just entered (otherwise 0). Press F1 to default to NO PRIORITY.
7. Allow Web Purchase
Indicate whether or not an item will be available for sale from the web. An example of products that are not available for sale from the web might be products that are not allowed to be purchased over the web or products that you have in your inventory that you do not sell like boxes or bubble-wrap. The system sends these item records to eCatalog but they will not be presented for purchase to a customer in Storefront. When first adding a new item, the field will default based on the Item Type field. It is set to "selected" for stocked items and "unselected" for non-stocked and uninventoried items (Item F/M sets the item type in code to "S" so this field will be set to "selected"). Once the initial value is set, the system will no longer change this field. The user is free to set it as desired.
When a new item is added or certain fields are changed, the system adds a record to the eCatalog log file for the next update to the eCatalog database. A record is also added to the eCatalog log file whenever an item is deleted.
When a new item is added with substitute items or the substitute items are changed and the Company Control flag "substitutes to catalog" is "selected", a record is added to the eCatalog log file for the next update to the eCatalog database.
There is currently no way to remove substitute item records from eCatalog. When a substitute item is removed, any unprocessed records for this transaction will be deleted from the log file.
Field changes that trigger an eCatalog update are:
Description 1
Description 2
GL Table
Item Class
Active Flag
Vendor-Item
Allow Web Purchase **new field
Price Class
Primary Vendor
Substitute Items **note: this is special case
Alternate ID tab
The UPC field no longer exists in this program. Create UPC numbers using the standard part number instructions. Standard part numbers can be created manually or electronically through the EPU system.
1. Substitutes
You can specify an unlimited number of substitute item numbers (one for each field). The entry must be a valid item number. Substitute items are displayed while in the sales orders entry programs. Substitutes may be used if the item being ordered is out of stock and a substitute is offered. A blank entry assumes no substitute item is available.
2. Model #
Specify the model number for the item. Press Enter to leave this entry blank.
3. MSDS ID
If this item requires a Material Safety Data Sheet (MSDS), enter a valid MSDS ID. If this item does not require an MSDS sheet, leave this field blank. Press F3 to default to the item number. Any MSDS ID entered here must first be defined in the MSDS ID F/M (SOF987).
4. DOT Code
If this item is a hazardous material item, enter a valid DOT Code (up to six characters). For more information on hazardous materials and regulations, please refer to the DOT’s Hazardous Materials Guide.
5. Vendor-Item
Specify the manufacturer’s vendor-item number (up to 20 characters) for this item. This number is used in purchase orders to order an item using the vendor’s item number. F1 assigns the same number as the item number entered in the Item field.
Service tab
1. Item
Specify the sales item number if the item is to be associated with a single inventory item.
2. Service Type
Indicate whether the item is a: Service item, Labor item, Not a service item or create Equipment records at the time of the Daily Sales Register.
3. Model
Specify the model code for this item (up to 15 characters). The model code must be valid but may be generic or specific in nature (i.e., one model for all service items or one model for each item).
4. Service Sell Item #
Specify the sales item number if the item is to be associated with a single inventory item.
5. Pricing
Indicate the pricing method to use: Standard FACTS Pricing or Actual Parts and Labor Pricing. Press ` to default to A.
6. Warranty For Parts
Specify the number of default days for parts warranty. The days entered here will be used as the default to calculate the parts warranty expiration date. For example, if the installation date is 3/21/97 and the default number of days is 20, the parts warranty expiration date in the equipment record will be calculated by the system as 4/10/97.
7. Warranty For Labor
Specify the number of default days for labor warranty. The days entered here will be used as the default to calculate the labor warranty expiration date. For example, if the installation date is 3/21/97 and the default number of days is 20, the labor warranty expiration date in the equipment record will be calculated by the system as 4/10/97.
8. Metered
Indicate whether this item will have an associated meter record used for tracking purposes.
9. Meter um
Specify the default unit of measure to track this meter. This field will be skipped if the item is not metered.
10. Meter Track
Indicate whether the meter tracking will be an incremented (Up) or decremented (Down).
After all fields have been entered, select SAVE to add this record to the Item File. If Cancel or F4 is entered, the user may change or delete necessary information.
Many users have a few pieces of information about customers, vendors, and items that are unique to their business that they would like to enter into FACTS for reference purposes. The User-Defined screen displays user-defined fields in the major file maintenances and makes them available in FACTS Inquiry programs for information only. There are 5 user-defined fields available to any user that has access to Item F/M.
You will be able to configure these fields within these constraints:
If the user has administrator privileges for User-defined Fields setting on the Security tab of User Code F/M (SMF410): Each field can be designated by a type--text, numeric, validated list, and date, as well as a label that can be edited in the F/M to create custom labels for each field. This allows the user to have a meaningful label other than "User Defined 1" and so on.
To configure user-defined fields:
SO Companion tab
For companion items, this tab displays information from SO Companion Item Entry (SOE150) and provides access to SOE150 and comparison usage information. In the upper portion of the screen the parent companion item is active, In the browser, the companion line items are displayed. Click:
Manage SO Companions to access SO Companion Item Entry
Companion Usage Display to see overview information about parent companion items. Indicate what to display: the modules that use the companion item: SO, PO or all, and how the companion item is used: as a Parent item or companion line item. Click OK to display the Companion Items File Overview screen with the item usage. You can view companion line item usage by clicking Companion Line Usage Display in the line entry section.
PO Companion tab
For companion items, this tab displays information from PO Companion Item Entry (POE151) and provides access to POE151 and comparison usage information. In the upper portion of the screen the parent companion item is active, In the browser, the companion line items are displayed. Click:
Manage PO Companions to access PO Companion Item Entry
Companion Usage Display to see overview information about parent companion items. Indicate what to display: the modules that use the companion item: SO, PO or all, and how the companion item is used: as a Parent item or companion line item. Click OK to display the Companion Items File Overview screen with the item usage. You can view companion line item usage by clicking Companion Line Usage Display in the line entry section.
Item UM FM (ICF912)
After you save a new item record, the system automatically displays the Item/Unit of Measure F/M (ICF915), so that you can enter unit of measure details for the item.
Quick Item Entry (ICF911)
After you complete the UM F/M (ICF912) program for the new item , the system displays the Quick Item Entry (ICF911) program so you can enter pricing information for the new item.
Importing catalog items
Importing catalog items works much like setting up default items. When you first access the screen, press I at the selection prompt. Specify the catalog item number that you want to import or press F2 to search catalog items. After you enter a catalog item number, information for that item will display. You can then change any information or tab through the fields to keep them. Information for the catalog item includes the cost class based on the setting in the vendor file.
As warehouse/item records are created, the program populates the replenishment flag with the default value. For stocked items, the replenishment flag is set to Yes. For non-stocked items, the flag is set to No.
Note: When you import catalog items, the system does not allow you to import alternate bin locations for items.
If you want to clear the imported catalog item information before you add the new item number, press C.
When an item becomes dead stock or is discontinued, and there are no quantities in the warehouse, the item may be deleted. However, the sales history for the deleted item needs to be maintained in Sales Analysis to ensure accurate sales figures. To do this, set up at least one replacement item to which you can transfer sales history when deleting an item from the system. FACTS automatically prompts you for the alternate item number and then transfers sales history to the replacement item number in Sales Analysis.Deleting an item is not allowed if the item is a parent companion item or companion line item.
The item must be removed from all of these records and documents in the system before it can be deleted.
|
|
|
|
|
|
|
|
|
|
Procedure
1. Remove it from Warehouse/Item F/M first.
2. Use Item Inquiry to identify where the item is used. For planned special order purchase orders, review the contents of Planned Special order PO Entry program.
3. Once you identify the documents that included the item number, update them in their respective registers or delete them.
4. Delete the item from Item F/M by selecting the item record and choosing Delete. The system will scan the above locates to make sure it is not still in use. If FACTS finds the item in use, it displays a message to that effect.
5. Transfer the sales history to an alternate item number for Sales Analysis purposes. During initial set up, an alternate item number should have been created for this purpose. If not, make sure you create one under which you can store the item’s sales history.