This chapter provides an overview of item information and discusses how to:
Enter item master information.
Enter branch/plant information.
Work with matrix and parent items.
Enter item cost information.
Enter sales price information.
Before you can work with inventory, you must provide the system with information about the items that you stock. When you enter each inventory item, you provide the system with details such as:
Item identifiers.
Item descriptions (foreign and domestic).
Item rules.
Item costs and prices.
Item weights and measures.
You also must provide the system with information about the location of each item, including:
The branch/plant where each item resides.
The locations that are used within each branch/plant.
The system uses this information to help track and process each item through the distribution and manufacturing systems. Entering an item includes two steps:
Entering item master information, which includes basic information about an item.
Configuring the item master information to suit each branch/plant that the item occupies.
When you enter item master information, the system creates a record in the Item Master table (F4101). This table includes item information that applies throughout the branch, such as category codes and planner/buyer numbers. When you enter branch/plant information for an item, the system creates records in the Item Branch File (F4102) and the Item Location File (F41021), which includes item information that is specific to certain locations, such as on-hand quantities and General Ledger GL class codes.
Before you complete the tasks in this section, you must:
Set up GL class codes.
Review and modify branch/plant constants.
Set up next numbers.
Set up default locations and printers.
Set up applicable user-defined codes (UDCs), including:
GL posting categories
Stocking type codes
Units of measure
Classification code categories
Cost method codes
Language preference codes
This section provides an overview of item master information, lists prerequisites, and discusses how to:
Set processing options for Item Master (P4101).
Enter item identification and processing information.
Enter alternate descriptions.
Create a template for segmented items.
Enter a segmented item.
Attach messages to an item.
Enter notes for an item.
Enter attachments for an item.
Assign item responsibility.
Enter classification codes.
Enter default units of measure for items.
Define item unit of measure conversions.
Specify a dual unit of measure for an item.
Set up search sequence using price units of measure.
Set up manufacturing information.
Country-specific functionality for entering item master information exists for Brazil.
See Also
(BRA) Working With Inventory Management for Brazil
Setting Up UDCs for Tax Processing for Brazil
You must enter master information for all stock and non-stock items. Master information includes the item number, item name, description, and general information about the item. The system uses this information to identify and process each item in the distribution and manufacturing systems.
You may want to enter one item that you use as a template when you enter additional items. By creating an item to use as a template, you can enter field values that are common to many items that you want to add in the future. When you add the new items, you first locate the item that you entered as the template and modify field values as necessary for the new item.
When you enter a new item, the system creates an item master record in the F4101 table. After the system creates the item master record, you cannot delete master information for the item if any of this information exists:
Item branch records
Bills of material
Item cross-reference numbers
Supplier relationships
Sales prices
Basic Item Information
Each item can have up to three identifiers. You use the identifiers to locate the item. These identifiers can represent universal product codes (UPCs), bar codes, supplier numbers, or a user-defined value.
On the Branch/Plant Constants form, you must specify a primary item identifier. In the item master, you must also enter an item description and the text on which you are most likely to search when trying to locate the item. You can also translate item descriptions and search text into multiple languages to locate items using alternate languages. The system administrator can make descriptions in other languages available based on user profiles.
If you revise the second and third item identifiers, the program can transfer these changes to other selected files, depending on how you activate the related processing option.
Item processing information consists of values that control how the system processes the item. These values pertain to stocking, packaging, accounting transactions, system interfaces, and so on.
Many industries have base products that differ from another base product because of packaging components, packaging processes, other attributes, or other differences that can cause costing structures to differ. Each variation of the product is usually a unit that is used for order entry, and it may have:
Manufacturing data
Inventory management information
Forecasts
Pricing rules
Preferences
You can use segments to accommodate these types of items, for example:
Polo shirts with segments of size and color.
Fruit drinks with segments of flavor, packaging, and type.
A segmented item can have up to ten identifying characteristics or attributes.
You might want to enter text about an item that others can view or print when working with the item. Item messages are predefined, so you can attach the same message to multiple items.
Unlike item messages, item notes are not predefined. If notes already exist for an item, a paper clip button appears next to the item number on Work With Item Notes. The system stores item notes by the language in which they are entered so that you can print the notes on documents (such as invoices and purchase orders) in multiple languages.
Unlike item notes, attachments can be viewed and printed regardless of the language in which you are working. Typically, you enter an attachment to provide others within the organization with a picture or diagram of an item. You cannot print attachments on documents such as invoices and purchase orders.
When you enter master information for an item, you can specify the persons or businesses that are responsible for the item, including the buyer, planner, and preferred carriers. Before you can assign responsible persons or businesses to an item, each person and business must have an address book number in the JD Edwards EnterpriseOne Address Book system.
Item Classification Codes
You might want to group items with similar characteristics so that you can work with the entire group at the same time. For example, grouping items provides good sales analysis information.
To group items, you assign classification codes to them. You can assign classification codes to items when you enter item master information or when you enter item branch/plant information. In either case, you assign classification codes on Category Codes. The fields are the same.
Several categories of classification codes are available. Each category represents a different item classification or property type, such as shipping conditions. From the shipping conditions category, you can select a code that indicates the condition, such as fragile, under which you ship an item.
Four types of classification codes are available. Each type relates to one or more of these systems:
JD Edwards EnterpriseOne Sales Order Management
JD Edwards EnterpriseOne Procurement
JD Edwards EnterpriseOne Inventory Management
JD Edwards EnterpriseOne Warehouse Management
JD Edwards EnterpriseOne Transportation Management
Item Units of Measure Information
You must provide the system with the item units of measure that are most common to each of the distribution processes, such as sales, purchasing, and so on. For example, you might purchase an item in pallets, stock it in boxes, and ship it in individual containers.
If you work with an item in multiple units of measure, you must specify how to convert one unit of measure to another. For example, if you stock items in boxes and crates, you must specify the number of individual items in a box and the number of boxes in a crate.
In some instances, the system must work with an item in its smallest (primary) unit of measure. The item conversions that you specify must enable the system to trace all units of measure back to the primary unit of measure.
You can set up unit of measure conversions that are specific to an item or to an item and branch/plant combination. You specify whether item conversions are specific to a branch/plant on the System Constants form. You can also set up units of measure that are standard for all items.
You must set up all units of measure for an item in the Item Unit of Measure table (F41002) or the Unit of Measure Standard Conversions table (F41003). The system verifies the item unit of measure conversions before using standard unit of measure conversions.
Dual Unit of Measure for an Item
You can maintain inventory and perform transactions for items in two units of measure. For example, you specify a dual unit of measure for an item that is sold by quantity but purchased by cost or priced by weight. Similarly, a transaction can use a dual unit of measure for which a standard conversion exists. For example, if an item's unit of measure is weight, you can consider a transaction in tons or pounds to be a dual unit of measure. In this case, the dual unit of measure is the unit of measure that is used on item ledger records and item balance records for the dual quantity.
When you specify a dual unit of measure, the system determines whether the item has a variable conversion between the primary unit of measure and secondary unit of measure for all inventory transactions. You must set up the item with the primary unit of measure as the costing unit of measure and the secondary unit of measure as the other unit of measure to track inventory.
The system enables a dual unit of measure only for packaged, manufactured end items. The system does not track a secondary unit of measure for bulk items.
These programs enable you to enter either the transaction quantity that is related to primary unit of measure, or the transaction quantity that is related to secondary, dual unit of measure; a standard conversion is used to determine the other quantity:
Purchase Orders (P4310).
Sales Order Entry (P4210).
Manufacturing Work Order Processing (P48013).
You can also enable picking options and set tolerance amounts, as described in this table:
Option |
Setup Task |
Picking is the movement of inventory from a warehouse location to satisfy an order. You can specify at the item level whether warehouse suggestions display the primary unit of measure or the dual unit of measure. Picking with dual units of measure also specifies whether the entire quantity has been shipped for a sales order line or whether the line requires splitting. For example, if a sales order for 100 pounds and 10 cases is hard committed, the picking option enables ten cases that weigh ninety-eight pounds to satisfy the order without creating a line for two pounds. Assuming that the tolerances are met and that you are using the picking option, the system would not split the sales order. Picking with dual units of measure affects other areas of the system in these ways:
|
|
Tolerance |
After you specify a dual unit of measure for an item, you can specify whether the system must check for tolerance amounts during any inventory transaction. Tolerances ensure that when you enter secondary quantities on a transaction, the primary and secondary quantities are within a certain percentage of the standard conversion. For example, if a case of an item weighs approximately 100 pounds and you set the tolerance to three percent, the weight must be between 97 and 103 pounds to fall within the tolerance level. The system does not check tolerances when using the Inventory Adjustments (P4114) or the Inventory Issues (P4112) programs. |
The system converts the dual unit of measure using the special handling code. For a dual unit of measure item, the special handling code of the primary and secondary units of measure is different. For similar units of measure, such as ounces, pounds, and tons, the special handling code is the same. For example, weight might have pounds as the dual unit of measure. A dual transaction quantity could be entered for tons. In this case, pounds and tons must have the same special handling code.
The system uses these tables when processing information for dual units of measure:
F4101
F4111
F41021
F4602
Search Sequences Using Price Units of Measure
You can specify multiple units of measure to locate base prices and adjustments. For example, you can specify that pallets are the first unit of measure for the system to use when searching. If the system finds nothing, you can specify cases as the second unit of measure, and then boxes. You can set up as many as eight sequences for a specific item, and the search sequences do not have to follow a certain progression.
The system uses the conversion factors to convert adjustments into the other unit of measure. For example, if the system locates an adjustment using the transaction unit of measure, the system also displays the pricing unit of measure. The system uses the unit of measure conversion factors to recalculate the adjustment in the pricing unit of measure
You set up the price unit of measure sequence for items on the Item Unit of Measure Conversions form. You can specify one for sales and another for procurement.
The system uses these tables for processing search sequences using units of measure:
Item Manufacturing Information
When you enter item master information, you define manufacturing information about an item, including:
Requirements planning information to develop an inventory planning forecast that you use to run the distribution and manufacturing operations.
Leadtime information to calculate the time frames that are necessary to assemble or manufacture items.
Engineering information about the drawing plans for an item.
Item Grade and Potency Information
After you enter item master information or item branch/plant information, you specify whether grade or potency applies to an item. Grades enable you to classify items (for example, grade A eggs and grade B eggs). Potency enables you to specify an active ingredient in a product (for example, the percentage of alcohol in cough syrup).
When you activate grade or potency control for an item, you can enter a standard grade or potency for the item and a range of acceptable values. If you receive or issue items that are not within the range, the system provides a warning message. You cannot complete sales transactions on items that are not within the range.
You can specify an acceptable grade or potency range for each of the customers using preference profiles. Item grade and potency are applicable only to items that are produced in lots. You cannot use both grade control and potency control for the same item. You can specify the grade or potency of all items in a lot on the Work With Lot Master form. If you do not specify a grade or potency, the system uses the standard grade or potency that is entered on the Additional System Information form.
Use the Demand Flow®to specify that an end item belongs to the Demand Flow® process. You specify a Demand Flow® end item to suppress Material Requirements Planning (MRP) messages and to facilitate uploading DFM items to the DFM system.
If you are going to include an end item in the line design, you must specify that the end item is part of the Demand Flow® process. Multimode manufacturers who use both MRP and Demand Flow® processes must specify which end items are part of the Demand Flow® process.
See Also
Before you complete the tasks in this section, you must:
Verify that Branch/Plant ALL is available in the system.
You must have the Branch/Plant ALL available in the system when you enter item information because the system uses it as a source of default information.
Set up the symbol to identify segmented items and the separator character (optional).
Create a template to use for different types of segmented item.
Set the processing options on the Defaults and Process tabs in the Item Master program (P4101) to use templates.
Create text for the predefined message before you attach it to an item.
Set up the special handling code in the UDC 00/UM.
Specify the values for unit of measure in the Sales Price Retrieval UOM and Purchase Price Retrieval UOM fields on the System Constants form of the Branch/Plant Constants program (P41001).
Form Name |
FormID |
Navigation |
Usage |
Work With Item Master Browse |
W4101E |
Inventory Master/Transactions (G4111), Item Master |
Work with item master browse. |
Item Master Revisions |
W4101A |
Click Add on the Work With Item Master Browse form. |
Enter item identification and processing information. Enter a segmented item. Attach messages to an item. Assign item responsibility. Enter default units of measure for items. Specify a dual unit of measure for an item |
Item Master Alternative Description |
W41016WA |
Select Item Alt Desc from the Row menu on the Work With Item Master Browse form. |
Enter alternate descriptions. |
Additional System Information |
W4101C |
Select Add System Info from the Row menu on the Work With Item Master Browse form. |
Set up manufacturing information. |
Work with Templates |
W410014A |
Inventory Master/Transactions (G4111), Template Master |
Review templates. |
Template Master Revisions |
W410014B |
Click Add on the Work With Templates form. |
Create a template for segmented items. |
Work with Item Notes |
W40163B |
Select a record, and then select Item Notes from the Row menu on the Work With Item Master Browse form. |
Review item notes. |
Item Notes Revisions |
W40163A |
Click Add on the Work with Item Notes form. |
Enter notes for an item. |
Media Objects |
W4310J |
|
Enter attachments for an item. |
Category Codes |
W4101B |
Select Category Codes from the Row menu on the Work With Item Master Browse form. |
Assign item responsibility. Enter classification codes. |
Work with Item Unit of Measure Conversions |
W41002A |
Item Revisions (G4112), Item Master U/M Conversion |
Review item unit of measure conversions. |
Item Unit of Measure Conversions |
W41002D |
|
Define item unit of measure conversions. Set up search sequence using price units of measure. |
Processing options enable you to specify the default processing for programs and reports.
Defaults
1. Primary Unit of Measure |
Enter a code from UDC 00/UM that specifies the primary unit of measure that the system uses. If you leave this processing option blank, the system uses EA (each). |
2. Weight Unit of Measure |
Enter a code from UDC 00/UM that specifies the unit of measure for weight that the system uses. If you leave this processing option blank, the system uses LB (pounds). |
3. Volume Unit of Measure |
Enter a code from UDC 00/UM that specifies the unit of measure by metric conversion for ambient volume. |
4. Template |
Enter a template name that you can use when entering items in P4101. This name is case-sensitive. |
Process
1. Notes From Date |
Specify the effective from date that the system uses in the Item Notes table (F4016). If you leave this processing option blank, the system uses the system date. |
2. Notes Thru Date |
Specify the effective through date that the system uses in the F4016 table. If you leave this processing option blank, the system uses the last day of the default century. |
3. Category Codes |
Specify whether the system displays the Category Codes form when you add or change information on the Item Master Revisions form. Values are: Blank: Do not display. I: Display. |
4. Additional System Information |
Indicate whether the system displays the Additional System Information form when you add or change information on the Item Master Revisions form. Values are: Blank: Do not display. 1: Display. |
5. Storage/Shipping |
Specify whether the system displays the Storage/Shipping form when you add or change information on the Item Master Revisions form. Values are: Blank: Do not display. 1: Display. |
6. Cost Revisions (Conditional) |
Specify whether the system displays the Cost Revisions form when you add or change information on the Item Master Revisions form. Values are: Blank: Do not display. 1: Display.
For the system to display the Cost Revisions form, you must also set the value for the Inventory Cost Level field to 1 on the Item Master Revisions form. |
7. Price Revisions (Conditional) |
Specify whether the system displays the Price Revisions form when you add or change information on the Item Master Revisions form. Values are: Blank: Do not display. 1: Display. For the system to display the Price Revisions form, you must also set the value for the Sales Price Level field to 1on the Item Master Revisions form. |
8. Unit Of Measure Conversions (Conditional) |
Specify whether the system displays the Unit of Measure form when you add or change information, and when the system performs the unit of measure conversations at the item level. Values are: Blank: Do not display. 1: Display. |
9. Item Branch |
Specify whether the system displays the Item Branch form when you add or change information on the Item Master Revisions form. Values are: Blank: Do not display the Item Branch form. 1: Display the Item Branch form, but return to the Item Master form. 2: Display and remain on the Item Branch form. |
10. Attachments |
Specify whether the system displays the Item Notes form when you select a media object on the Work With Item Master Browse form. Values are: Blank: Display only the internal attachments. 1: Display the Item Notes form. |
11. Use Templates |
Specify whether you want to use templates for segmented items. Values are: Blank: Do not use templates. 1: Use templates. |
Global Update
This processing option enables you to update changes that are made to the second or third item numbers to records in selected tables.
1. Transfer Changes |
Specify which tables the system updates when you have made changes to item numbers in the item branch records. Use UDC 40/IC to compile the list of tables. Values are: Blank: The system does not update any tables. 1: The system updates only those tables that contain item branch information with changes to the second and third item numbers. 2: The system updates only selected tables that contain item branch information with changes to the second and third item numbers. |
Versions
If you leave any of the following processing options blank, the system uses default version ZJDE0001.
1. Item Availability (P41202) |
Specify the version of the Item Availability program to use. |
2. Item Branch (P41026) |
Specify the version of the Item Branch program to use. |
3. Cost Revisions (P4105) |
Specify the version of the Cost Revisions program to use. |
4. Segmented Item Availability (P41206) |
Specify the version of the Segmented Item Availability program to use. |
Interop
1. Transaction Type |
Enter a code from UDC 00/TT that identifies the type of transaction, such as an invoice or a sales order, for which you want the system to search. The system uses the transaction type as the default. If you leave this processing option blank, the system does not perform export processing. |
2. Before/After Image Processing |
Specify whether the system creates a record of a transaction after the transaction is changed, or whether the system creates records of a transaction before and after a transaction is changed. Values are: Blank: Create a record of a transaction after changes. 1: Create two records: one record before changes and one record after changes. |
Access the Item Master Revisions form.
When you enter a new item, first you must enter information that identifies the item. Next, you must enter an item description and the text. The item description and text represent the information upon which you are most likely to search when trying to locate the item. Each item can have up to three identifiers that you use to locate the item.
Basic Item Data
Select the Basic Item Data tab.
Item Number |
Enter an identifier for an item. |
Catalog Number |
Enter an identifier for an item. |
Search Text |
Specify how the system searches for an item. The entry should be specific and descriptive of the item. In single-byte environments, where computer storage space can hold only Latin-based language character sets, the system inserts the first 30 characters from the item's description if you do not enter search text. In double-byte environments, where computer storage space can hold more complex language character sets (in languages such as Japanese, Chinese, and Korean), you must complete this field. It is a single-byte field that you complete with single-byte characters to phonetically represent the item description (which can be single-byte, double-byte, or both). |
Stocking Type |
Enter a code from UDC 41/I that specifies how you stock an item, for example, as finished goods or as raw materials. These stocking types are hard coded and you should not change them: F: Feature K: Kit parent item The first character of Description 2 in UDC 41/I indicates whether the item is purchased (P) or manufactured (M). |
GL Class |
Enter a code from UDC 41/9 that controls which general ledger accounts receive the monetary amount of inventory transactions for this item. |
Backorders Allowed |
Select this check box to enable backorders for this item. You can enable backorders by item using the Item Master (P4101) program or the Item Branch/Plant (P41026) program, by customer using the Customer Billing Instructions program (P03013), or by branch/plant using the Branch/Plant Constants program (P41001). |
Check Availability |
Select this check box to enable availability checking. You might want to enable availability checking for certain items. For other items, if you assume that an adequate supply is available, leave availability checking disabled. |
Additional Info
Select the Additional Info. tab.
A Ranking, B Ranking,C Ranking, and D Ranking None |
Enter a code that specifies this item's ABC ranking by sales amount. Values are: A: Assign this item to the first (largest) amount ranking. B: Assign this item to the second (intermediate) amount ranking. C: Assign this item to the third (smallest) amount ranking. D: Do not include this item when you run ABC Analysis. Three types of ABC analysis are available: sales, margin, and on-hand value. Within each type of analysis, you can have three groups: A, B, and C. The ABC Code fields contain a percentage that tells the system how to define the A, B, and C groups for categorizing items during ABC analysis. Each group measures a total within the type of analysis. For all groups, the system compares the appropriate sales, margin, or on-hand value totals of a single item to the appropriate total for all items and calculates the value of each item. An item's value is its percentage of the appropriate total. The system then arranges the values of all items from highest to lowest value and accumulates the percentages. The next step depends on the group: A group: If an item's value causes the accumulated total to exceed the A accumulated percentage, the system assigns the item to the B group. B group: When the accumulated total reaches the percentage that you entered for items in the A group, it continues adding values until it reaches the percentage that you entered for items in the B group. The system assigns all items for which the value falls between the A and B percentages to the B group. C group: If an item's value causes the accumulated total to exceed the B accumulated percentage, the system assigns the item to the C group. The percentage that you usually enter for the C group is 999. |
Lot Processing
Select the Lot Processing tab.
Serial No. Required (serial number required) |
Enter the code that specifies whether you must attach a serial number to this item at receipt or sale for basic serial number processing, or whether memo lot information is required for advanced serial number processing. Advanced serial number processing enables you to use a serial number to track an item through purchasing and sales. For basic serial number processing, the values are: Y: The system requires a serial number for all transactions pertaining to this item in related inventory, sales, and purchase order programs. N: The system does not require a serial number. To specify lots for items with serial numbers, the values are: 3: Supplier lot number is required (purchasing only). 4: Supplier lot number is required (purchasing only). Memo lot 1 is also required. 5: Supplier lot number is required (purchasing only). Memo lot 1 and memo lot 2 are also required. 6: Non-serialized item number. Values 3 through 5 specify whether lot assignment is required for items with serial numbers. You can require assignment of up to three lot numbers, including supplier lot, memo lot 1, and memo lot 2. |
Lot Status Code |
Enter a code from UDC 41/L that indicates the status of the lot. Leaving this field blank indicates that the lot is approved. All other codes indicate that the lot is on hold. You can assign a different status code to each location in which a lot resides on Item/Location Information or Location Lot Status Change. |
Lot Process Type |
Enter the code from UDC H41/SR that specifies whether lot or serial number is assigned. Lot and serial number processes use the F4108 table. Values are: 0: Lot assignment is optional. You can manually assign numbers. Quantity can be greater than one. (Default) 1: Lot assignment is required. The system assigns numbers using the system date in YYMMDD format. Quantity can be greater than one. 2: Lot assignment is required. The system assigns numbers in ascending order using Next Numbers. Quantity can be greater than one. 3: Lot assignment is required. You must manually assign numbers. Quantity can be greater than one. 4: Serial number assignment is optional except during shipment confirmation. Quantity must not exceed one. 5: Serial number assignment is required. The system assigns numbers using the system date in YYMMDD format. Quantity must not exceed one. 6: Serial number assignment is required. The system assigns numbers in ascending order using Next Numbers. Quantity must not exceed one. 7: Serial number assignment is required. You must manually assign numbers. Quantity must not exceed one. |
Commitment Date Method |
Enter a code from UDC H40/CD that specifies which date the system uses to commit inventory when an item is committed by date. The default value is 01 (lot expiration date). The date fields are stored in the F4108 table. |
Lot Expiration Date Method |
Enter the code that indicates which method the system uses for calculating the expiration date for a lot. Values are: 1: On-hand date plus shelf life days 2: Based on date plus shelf life days 3: Least expiration date of active components |
Shelf Life Days |
Enter the number of days that an item can remain in inventory before it expires. The system adds this number to the date that the item is received to determine the expiration date for the item. If you do not enter a value here, you must enter an expiration date each time you receive the lot item. |
Best Before/Sell By Default Days |
Enter the number of days that an item can remain in inventory before it should be consumed. The system uses the number that you enter to calculate the best before date using two different methods, depending on whether the number that you enter in this field is positive or negative. If the value is positive, the system adds the days to the based-on date to determine the best before date for the lot. If the number is negative, the system subtracts the days from the lot expiration date to determine the best before date. |
Manufacturing Effective Days |
Enter the number of days that an item must remain in inventory before the system considers the item to be available for sales and manufacturing commitments. To calculate the lot effective date, the system adds the number that you enter in this field to the based-on date that appears in the F4108 table. |
Purchasing Effective Days |
Enter the number of days after a purchased item is received that a lot becomes available. The system uses this number when calculating and displaying the Effective Date field in the Purchase Orders program (P4310) and the PO Receipts program (P4312). |
User Lot Date 1–5 Default Days |
Enter the number of days that the system uses to calculate the value for the User Lot Date 1 through User Lot Date 5 fields of the F4108 table. The system calculates the values using one of two methods, depending on whether the number that you enter in this field is positive or negative. If you enter a positive value, the system adds the days to the based-on date to determine the value for the fields. If you enter a negative value, the system subtracts the days from the lot expiration date to determine the value for the fields. |
Access the Item Master Alternative Description form.
After you enter item identification and processing information, you can locate the item and enter a description and search text in one or more languages. This alternate text is available in the language setup at the system level or in the user profile.
Language Preference |
Enter a code from UDC 01/LP that specifies the language to use on forms and printed reports. Before you specify a language, a code for that language must exist at either the system level or in the user preferences. |
Access the Template Master Revisions form.
You create one or more templates for entering segmented items. If the same template is not applicable for all the segmented items, create a template for each type and name each template appropriately.
After you have created a template, you can attach it to Item Master Revisions form if the Use Templates processing option has been activated.
Template |
Enter a template name that you can use when entering items on Item Master Revisions form. This name is case-sensitive. If you use any capital letters in the template name when you add it, you must enter those letters in capitals whenever you search for or attach the template to the Item Master Revisions form. |
No Separators |
Specify whether characters will be used to separate the segments. If you select this control, separators are not used in this template and all 25 character spaces can be allotted to the segmented item number. Note. You must also leave the Segment Separator Character field in the Branch/Plant Constants program (P41001) blank. |
Length Used |
Use this field to keep a running total of the number of spaces, including separators, that are used in all the segments. |
Access the Item Master Revisions form.
Access the Item Master Revisions form.
After you have entered basic item information, you can attach predefined messages to an item.
Print Message |
Enter a code from UDC 40/PM that represents a predefined message from the Print Message Revisions form. You can print the message on sales orders, purchase orders, and so forth. |
Item Flash Message |
Enter a code from UDC 40/FL that directs the system to display a particular message each time someone works with the item. The message is the description for the UDC. When you work with an item that has a flash message, the message appears next to the item number or the system highlights the item number. If the number is highlighted, you can access the message by placing the cursor on the item number and performing the appropriate function called for by the program. |
Access the Item Notes Revisions form.
Enter item notes to provide additional information about an item, such as information about discounts or deliveries. Unlike item messages, item notes are not predefined.
Item Number |
Enter a number that the system assigns to an item. It can be in short, long, or third-item number format. |
Effective From |
Enter the date when a transaction, contract, obligation, preference, or policy rule becomes effective. |
Effective Thru |
Enter the date on which a transaction, text message, agreement, obligation, or preference has expired or been completed. |
Access the Select an Image form.
Typically, you enter attachments for an item to provide graphical information such as a picture or diagram. Unlike item notes, you can view and print attachments regardless of the language in which they were entered. Therefore, if you attach a diagram that contains text to an item, the system displays the text only in the language in which the text was entered.
Access the Category Codes form.
Planner Number |
Enter the address number of the material planner for this item. |
Buyer Number |
Enter the address number of the person responsible for setting up and maintaining the correct stocking levels for the item. |
Preferred Purchasing Carrier |
Enter the address number for the preferred carrier of the item. The supplier or the organization might prefer a certain carrier because of route or special handling requirements. This value serves as the carrier default when you enter a purchase order for the item. |
Access the Category Codes form.
Sales Catalog Section |
Enter a code from UDC 41/S1 that represents an item property type or classification, such as color or material content. The system uses this code to sort and process like items. This field is one of ten classification categories that are available primarily for sales purposes. |
Sub Section |
Enter a code from UDC 41/S2 that represents an item property type or classification, such as color or material content. The system uses this code to sort and process like items. This field is one of ten classification categories that are available primarily for sales purposes. |
Sales Category Code 3 |
Enter a code from UDC 41/S3 that represents an item property type or classification, such as color or material content. The system uses this code to sort and process like items. This field is one of ten classification categories that are available primarily for sales purposes. |
Sales Category Code 4 |
Enter a code from UDC 41/S4 that represents an item property type or classification, such as color or material content. The system uses this code to sort and process like items. This field is one of ten classification categories that are available primarily for sales purposes. |
Sales Category Code 5 |
Enter a code from UDC 41/S5 that represents an item property type or classification, such as color or material content. The system uses this code to sort and process like items. This field is one of ten classification categories that are available primarily for sales purposes. |
Preferred Purchasing Carrier |
Enter the address number for the preferred carrier of the item. The supplier or the organization might prefer a certain carrier because of route or special handling requirements. This value serves as the carrier default when you enter a purchase order for the item. |
Item Pool Code |
Enter a code from UDC 41/P0 that represents an item property type or classification, such as commodity type or planning family. The system uses this code to sort and process like items. This field is one of six classification categories that are available primarily for purchasing purposes. |
Category Code 6 |
Enter a code from UDC 41/S6 that represents an item property type or classification, such as color or material content. The system uses this code to sort and process like items. This field is one of ten classification categories that are available primarily for sales purposes. |
Category Code 7 |
Enter a code from UDC 41/S7 that represents an item property type or classification, such as color or material content. The system uses this code to sort and process like items. This field is one of ten classification categories that are available primarily for sales purposes. |
Category Code 8 |
Enter a code from UDC 41/S8 that represents an item property type or classification, such as color or material content. The system uses this code to sort and process like items. This field is one of ten classification categories that are available primarily for sales purposes. |
Category Code 9 |
Enter a code from UDC 41/S9 that represents an item property type or classification, such as color or material content. The system uses this code to sort and process like items. This field is one of ten classification categories that are available primarily for sales purposes. |
Category Code 10 |
Enter a code from UDC 41/S0 that represents an item property type or classification, such as color or material content. The system uses this code to sort and process like items. Use this field as one of ten classification categories that are available primarily for sales purposes. |
Purchasing Classification Codes
Commodity Class |
Enter a code from UDC 41/P1 that represents an item property type or classification, such as commodity type or planning family. The system uses this code to sort and process like items. This field is one of six classification categories that are available primarily for purchasing purposes. |
Commodity Sub Class |
Enter a code from UDC 41/P2 that represents an item property type or classification, such as commodity type or planning family. The system uses this code to sort and process like items. This field is one of six classification categories that are available primarily for purchasing purposes. |
Supplier Rebate Code |
Enter a code from UDC 41/P3 that represents an item property type or classification, such as commodity type or planning family. The system uses this code to sort and process like items. This field is one of six classification categories that are available primarily for purchasing purposes. |
Master Planning Family |
Enter a code from UDC 41/P4 that represents an item property type or classification, such as commodity type or planning family. The system uses this code to sort and process like items. This field is one of six classification categories that are available primarily for purchasing purposes. |
Landed Cost Rule |
Enter a code from UDC 41/P5 that indicates the landed cost rule for an item. The landed cost rule determines purchasing costs that exceed the actual price of an item, such as broker fees or commissions. You set up landed cost rules on the Landed Cost Revisions form. |
Inventory and Transportation Classification Codes
Shipping Conditions Code |
Enter a code from UDC 41/C that represents an item property type or classification, such as special shipping conditions. The system uses this code to sort and process like items. This field is one of three classification categories that are available primarily for inventory and shipping purposes. |
Shipping Commodity Class |
Enter a code from UDC 41/E that represents an item property type or classification, such as international shipment handling. The system uses this code to sort and process similar items. This field is one of three classification categories that are available primarily for inventory and shipping purposes. |
Cycle Count Category |
Enter a code from UDC 41/8 that represents the family or cycle in which an item is counted. Cycle counting means that you count different inventory items at different times. Cycle codes commonly represent item values, item locations, time frames, or product groups. |
Note. The JD Edwards EnterpriseOne Transportation Management system uses the Shipping Conditions Code and Shipping Commodity Class fields.
Warehouse Classification Codes
Item Dimension Group |
Enter a code from UDC 41/01 that identifies a group of items that share the same dimensions. An item dimension group defines the dimensions for all items that belong to the group. After you set up an item dimension group, you can assign items to the group through the Classification Codes program (P41011). |
Warehouse Process Grp 1 through Warehouse Process Grp 3 (warehouse process group) |
Enter codes from UDC 41/02 that identify a group of items that you want to move the same way. A process group determines what movement instructions the system uses for putaway, picking, and replenishment. You use the Classification Codes program (P41011) to assign items to process groups. |
Access the Item Master Revisions form.
After you enter basic item information, such as the item identifier and the item's primary unit of measure, you must provide the system with more specific unit of measure information for the different distribution processes.
Weights and Measures
Select the Weights and Measures tab.
Primary |
Enter a code from UDC 00/UM that indicates the primary unit of measure for the item. The primary unit of measure must be the smallest unit of measure in which you handle the item. This is the PSAU of measure that the system uses to store all inventory. If you change the primary unit of measure, the conversion factors in the item-level conversion table are no longer valid. The default value for this field is the unit of measure that you specify for the item on the Item Master Revisions form. |
Secondary |
Enter a code from UDC 00/UM that indicates an alternate unit of measure for the item. |
Purchasing |
Enter a code from UDC 00/UM that identifies the unit of measure in which you usually purchase the item. |
Pricing |
Enter a code from UDC 00/UM that indicates the unit of measure in which you usually price the item. |
Shipping |
Enter a code from UDC 00/UM that indicates the unit of measure in which you usually ship the item. |
Production |
Enter a code from UDC 00/UM that indicates the unit of measure in which you produce the item. |
Component |
Enter a code from UDC 00/UM that indicates the unit of measure for an item when the item serves as a component, for example, for a bill of material or work order parts list. |
Weight |
Enter a code from UDC 00/UM that identifies the unit of measure that the system uses to indicate weight for this item. You can specify ounces, grams, kilograms, and so on, as weight standards. The system uses this unit of measure for the item or overrides it for an individual item or container. The default value for this field is the weight unit of measure that you specify in processing options for the Item Master program. |
Volume |
Enter a code from UDC 00/UM that indicates the unit of measure by metric conversion for ambient volume. For example, the unit of measure code for a gallon might be GL, or for a liter it might be LT. |
Access the Item Unit Of Measure Conversions form.
After you enter the default unit of measure information, you must provide the system with unit of measure conversion information if the item has multiple units of measure (for example, an item that you stock in boxes and in crates).
You can update conversion information only for items that already exist in the system. For new items, you must select OK to save the item, and then select the item on the Work With Item Master Browse form, and return to the Item Master Revisions form.
From UoM (from unit of measure) |
Enter a code from UDC 00/UM that identifies the unit of measure for an item. For example, the unit of measure can be eaches, cases, or boxes. |
Quantity |
Enter the factor that the system uses to convert one unit of measure to another unit of measure. |
To UoM (to unit of measure) |
Enter a code from UDC 00/UM that indicates a secondary unit of measure. |
Access the Item Master Revisions form.
Weights and Measures
Select the Weights and Measures tab.
Secondary |
Enter a code from UDC 00/UM that indicates an alternate unit of measure for the item. |
Additional Info.
Select the Additional Info. tab.
Dual Unit of Measure Item |
Use this option to specify whether the system must maintain inventory balances and record transactions for an item in a secondary unit of measure that does not have a fixed conversion to the primary unit of measure. Typically, you select this option when the item is ordered or sold by a packaged quantity and priced by weight or volume. Note. For a dual unit of measure item, the system might require a tolerance check for inventory transactions (excluding inventory adjustments) between the primary unit of measure and the secondary unit of measure. |
Dual Picking Process |
Specify whether the system uses the primary or secondary unit of measure for a dual unit of measure item for these processes:
To use the primary unit of measure, do not select this option. To use the secondary unit of measure, select this option. |
Dual Unit of Measure Tolerance |
Specify whether the system must maintain inventory balances and record transactions for an item in a secondary unit of measure that does not have a fixed conversion to the primary unit of measure. Typically, you select this option when the item is ordered or sold by a packaged quantity and priced by weight or volume. Note. For a dual unit of measure item, the system might require a tolerance check for inventory transactions (excluding inventory adjustments) between the primary unit of measure and the secondary unit of measure. |
Dual Tolerance Percentage |
Enter a number, expressed as a percentage, that the system uses to ensure that the primary and dual quantities on a transaction are within a certain range of the standard conversion. For example, assume that you enter three percent as the dual tolerance for an item and that a case of the item weighs approximately 100 pounds. When the system confirms shipment for a case of the item, you must enter a weight between 97 and 103 pounds to be within dual tolerance. The system does not check dual tolerance for inventory adjustments due to evaporation or shrinkage. |
Access the Item Unit Of Measure Conversions form.
Note. You can specify up to eight levels in these fields.
Sales UOM Seq. (sales unit of measure sequence) |
Enter a code that determines which from level units of measure the system uses when searching for base prices and adjustments. This code also determines the order in which the system searches for the units of measure. The system always searches first for the unit of measure with the smallest sales price code value. |
Procurement UOM Seq. (procurement unit of measure sequence) |
Enter a code that determines the units of measure for the from level that the system uses when searching for purchase prices and adjustments. This code also determines the order in which the system searches for units of measure. The system first searches for units of measure that have the lowest purchase price code value. |
Access the Additional System Information form.
Manufacturing Data
Select the Manufacturing Data tab.
Order Policy Code |
Enter a code that specifies the rules for inventory reordering in the JD Edwards EnterpriseOne Requirements Planning system and the JD Edwards EnterpriseOne Procurement system. The hard coded values are: 0: Reorder point. (Not planned by Master Production Schedule (MPS), Material Requirements Planning (MRP), or Distribution Requirements Planning (DRP)) 1: Lot-for-lot or as required. 2: Fixed order quantity. 3: Economic order quantity (EOQ). 4: Periods of supply. 5: Rate scheduled item. |
Value Order Policy |
Enter a order policy code. Values are: 2: Fixed order quantity. 4: Periods of supply. This value represents the number of days of net requirements that the system uses to determine order size. 5: Rate scheduled item. This value represents the desired inventory level. When the ending available quantity is less than the desired inventory level, the system then issues an increase rate to message. When the ending available quantity is greater than the desired inventory level, the system then issues a decrease rate to message. |
Planning Code |
Enter a code that indicates how MPS, MRP, or DRP processes this item. The hard coded values are: 0: Not Planned by MPS, MRP, or DRP. 1: Planned by MPS or DRP. 2: Planned by MRP. 3: Planned by MRP with additional independent forecast. 4: Planned by MPS, Parent in Planning Bill. 5: Planned by MPS, Component in Planning Bill. |
Planning Fence Rule |
Enter a code from UDC 34/TF that the system uses in conjunction with the Planning Time Fence Days field to determine how forecast demand or actual customer demand is used. Values are: C: Customer demand before, greater of forecast or customer demand after. F: Forecast before, forecast plus customer demand after. G: Greater of forecast or customer demand before, forecast after. S: Customer demand before, forecast after. 1: Zero before, forecast after. 3: Zero before, forecast plus customer demand after. For example, if you enter 5 in the Planning Time Fence Days field and S in this field, then the system only uses only customer demand for the regeneration for the first 5 days. After 5 days, the system uses the forecast for the regeneration. |
Planning Fence |
Enter the number of days that the system uses in conjunction with the time fence rule to determine how the forecast is used. Enter the number of days after the start date when the time fence rule changes from the first rule to the second rule. For example, if the planning fence rule is S, the generation start date is 01/03/05, and the planning time fence is three days, the system plans using customer demand through 01/06/05. Beginning on 01/07/05, the system plans using the forecast. Note. The system does not count the generation start date; that is, the day after the generation start date is day 1. |
Freeze Fence |
Enter the number of days from the generation start date within which the system does not generate action messages. For example, if the generation start date is 01/03/05, and the freeze time fence is three days, the planning system does not generate messages with required dates that are before or equal to 01/06/05. Note. The system does not count the generation start date; that is, the day after the generation start date is day one. |
Message Display Fence |
Enter the number of days after the generation start date within which the system should display order messages. For example, if the generation start date is 01/01/05, and the message time fence is 30 days, the system displays messages with dates before or equal to 01/31/05. The system does not display messages with dates of 02/01/05 or later. However, the planning horizon for orders continues past this date and is reflected in available to promise totals. Note. The system does not count the generation start date; that is, the day after the generation start date is day one. |
Suppress MRP Messages (suppress material requirements planning messages) |
Specify whether you want the system to suppress MRP messages. You can specify 0 or 1 regardless of whether the item is defined as MRP or Demand Flow®. Values are: 0: Suppress MRP messages. 1: Do not suppress MRP messages. |
Issue and Receipt |
Specify whether an item is received at the time of inventory issues or whether the system uses the Move and Disposition program. Values are: 0: The system does not perform any actions. 1: The system receives an item when an inventory issue occurs. 2: The system uses the Movement and Disposition program when an inventory issue occurs. |
Replenishment Hours |
Enter the time that is required before a consuming location has a replacement kanban available from its supplying location. This value is used only for kanban card processing in the JD Edwards EnterpriseOne Shop Floor Management system. |
MFG Leadtime Quantity (material requirements planning leadtime quantity) |
Enter the quantity that determines the leadtime level for a manufactured item. Each of the routing steps for the item are extended by this quantity. For the system to calculate the leadtime level, the quantity in this field must be a value other than zero. |
Leadtime Level |
Enter a value that represents the leadtime for an item at its assigned level in the production process, as defined on Plant Manufacturing Data. The system uses this value to calculate the start dates for work orders using fixed leadtimes. Level leadtime is different for purchased and manufactured items: Purchased: The number of calendar days that are required for the item to arrive at the branch/plant after the supplier receives the purchase order. Manufactured: The number of workdays that are required to complete the fabrication or assembly of an item after all the components are available. You can enter level leadtime manually on the Plant Manufacturing tab of the Additional System Information form, or you can use the Leadtime Roll up program to calculate it. To calculate level leadtime using the Leadtime Roll up program, you must first enter a quantity in the Manufacturing Leadtime Quantity field in the F4102 table. |
Leadtime Manufacturing |
Enter the total number of days that are required to build an item from its lowest level components to the final assembly. This value is the total of the level leadtimes for all manufactured items, plus the highest manufacturing leadtime for all its components. If all components are purchased, the manufacturing leadtime equals the item's level leadtime. Purchased item leadtimes are not included in the calculation of manufacturing leadtimes. You can enter the manufacturing leadtime manually, or you can have the system calculate it when you run the Leadtime Roll up program. |
Leadtime Per Unit |
Enter the total number of hours that are required to build one unit as specified on the routing. This value is factored by the time basis code. You can enter this value manually or you can have the system calculate it when you run the Leadtime Roll up program. The system overwrites this value when you run the Leadtime Roll up program. The system uses this field to calculate start dates for work orders when you use variable leadtimes. |
Leadtime Cumulative |
Enter the total number of days that are required to build an item from its lowest level components to the final assembly. The system calculates the value differently for manufactured and purchased items. Manufactured: The total of all level leadtimes for all manufactured items, plus the highest cumulative leadtime of all its components. Purchased: The item's level leadtime. Purchased item leadtimes are included in the calculation of cumulative leadtimes. You can enter this value manually or you can have the system calculate it when you run the Leadtime Roll up program. |
Fixed/Variable |
Enter a value that determines whether the system uses fixed or variable leadtimes. This value works in conjunction with the value from either the Level Leadtime field or the Leadtime Per Unit field. Values are: F: The system calculates work order start dates using the value from the Leadtime Level field. V: The system calculates work order start dates using the value from the Leadtime Per Unit field. |
Drawing Size |
Enter a code that represents the engineering drawing size. For example: A: A-size drawing D: D-size drawing |
Last Revision No (last revision number) |
Enter a subset to the drawing number. It provides an additional description of the drawing and is useful if the system uses an engineering drawing as a reference for this item. |
Drawing Number |
Enter an engineering drawing number. It might be the same as the part or item number. |
Grade and Potency
Select the Grade and Potency tab.
Grade/Potency Pricing |
Enter a code from UDC 41/05 that groups several items that contain the same requirements for the Stock Valuation system. Valuation methods are set up by item or pool. The items that are assigned to the pool use the pool's designated valuation methods for extracting and valuing the inventory. |
Potency Control |
Enter a code that indicates whether you control the item by potency. |
Standard Potency |
Enter the percentage of active ingredients that are normally found in an item. |
From PotencyandThru Potency |
Enter a values that indicates the minimum and maximum potency or percentage of active ingredients that are acceptable for an item. The system displays a warning message if you try to purchase or issue items that do not meet the minimum acceptable potency or exceed the maximum acceptable potency. The system does not allow you to sell items that do not meet the minimum acceptable potency or exceed the maximum acceptable potency. |
Grade Control |
Enter a code that indicates whether you control the item by grade. |
Standard Grade |
Enter a code from UDC 40/LG that represents the normal grade for an item. |
From Grade and Thru Grade |
Enter codes from UDC 40/LG that indicate the minimum and maximum grades that are acceptable for an item. The system displays a warning message if you try to purchase or issue items with grades that do not meet the minimum grade or exceed the maximum grade. The system does not allow you to sell items with grades that do not meet the minimum grade or exceed the maximum grade. |
Service/Warranty
Select the Service/Warranty tab.
Cost Type |
Enter a code from UDC 30/CA that designates the item. Values include: A1: Material B1: Labor X1: Freight X2: Travel |
Return Policy |
Enter a code from UDC 17/RT that specifies whether to return the part with the claim. |
Create Equipment Master Record |
Specify whether the system creates an equipment record for an item when you run the Equipment Master Update program (R17024). The system creates the equipment record during the update only if you activate this option for the item. |
Supply Chain Planning
Select the Supply Chain Planning tab.
Constraints Flag |
Enter a code from UDC 42/AC that specifies whether to include an item in Supply Chain Planning (SCP). Values are: Blank or 0: Do not include the item. 1: Include the item. |
Sellable Item |
Specify whether an item is sellable. Use the Update Sellable Flag program (R41900) to update this field for multiple items. |
Demand Flow®
Select the Demand Flow ® tab.
Demand Flow® Product |
Select whether an item is an end item for Demand Flow®. An item can be added to a mixed model family only if you select this option. |
Total Product Cycle Time |
Enter a value that represents the calculated work content through the longest path of the process or processes that are required to build a product. The value is in the scenario unit of measure (hours, minutes, seconds, or whatever was used in the scenario). |
Primary Line |
Enter a number that you have previously set up in the F30006 table to define which product line primarily produces the end item. Detailed work center operations can be defined within the line or cell. |
Explode BOM |
Select whether the BOM is expanded by one subordinate level. For example, if you select this option at level one, the system displays the children at level two. The children for level two do not appear unless you select this option for level two end items, and so on. The functionality of this option applies only when the item is a Demand Flow® item and you are performing BOM explosion using the Volume Design and Product Synchronization program (PF30L201). Normal BOM explosion remains as it is in base manufacturing. |
This section provides an overview of branch/plant information, lists prerequisites, and discusses how to:
Set processing options for Item Branch (P41026).
Assign an item to a branch/plant.
Assign a primary location to an item.
Assign a secondary location to an item.
Change the primary location for an item.
Enter sales, purchasing, and warehouse classification codes.
Enter inventory and transportation classification codes.
Enter tax information.
Locate item sources.
Enter item reorder quantities.
Enter branch/plant manufacturing information.
Set processing options for Item Branch Duplication (P41015).
Duplicate item information for multiple branch/plants.
See Also
(ARG) Working with Item Information and Inventory Inflation Adjustment
Information about an item might differ from warehouse to warehouse. For example, taxes might be applicable to an item in one warehouse but not in another. You might also have different quantity requirements for items depending on the warehouse.
After you enter master information for an item, you can assign the item to warehouses or branch/plants. You can then configure the item information for each branch/plant. You can also specify the locations within the branch/plant where the item is stored.
Every JD Edwards EnterpriseOne system that retrieves item information searches for the item branch/plant information before searching the item master information.
You begin entering item information for a branch/plant on the Item/Branch Plant Info. form. Most fields on Item/Branch Plant Info. are identical to those on the Item Master Revisions form. The system uses the default values from Item Master Revisions. You can enter item information for a single branch/plant or copy existing item information and duplicate it for multiple branch/plants.
Besides location information, you can enter item processing information. Use processing options to specify that other forms, such as Category Codes, appear so that you can add or change the information.
After you enter item information for a specific branch/plant, the system creates a record in the F4102 table.
After you assign an item to a branch/plant, you can indicate multiple locations in which the item resides. For each branch/plant, you can assign:
A primary location.
A primary location is required.
Multiple secondary locations.
Secondary locations are optional.
The system prompts you for the primary location immediately after you assign an item to a branch/plant. The system usually processes an item through its primary location. For example, when you receive an item, the system assigns the item to its primary location unless you specify a secondary location.
You can also assign secondary locations to an item when you enter branch/plant information. The system automatically assigns a secondary location if you enter a location other than the primary location for an item when you receive it.
Each time that you enter a location for an item, the system creates a record in the F41021 table. To delete a primary location, you must first change it to a secondary location. You cannot delete locations that contain quantities.
If you specify location control on the System Constants form, you can assign an item to only those locations that are set up on the Branch/Plant Location Master form. If you do not specify location control, you can assign an item to any location.
In addition to assigning locations to an item and branch/plant, you can assign multiple lot numbers to each location. You can enter lot numbers manually when you enter item locations or when you receive the items.
You also can change the primary location for an item. However, if you change an item's primary location and any of these quantities exist, the quantities transfer to the new primary location:
Quantity on back order
Quantity on purchase order
Quantity on work order
Other purchasing 1
Quantity on soft commit
If you use license plate processing in the JD Edwards EnterpriseOne Warehouse Management system, you activate functionality at the branch/plant level and can specify whether to automatically create a license plate number for an item or item dimension group in a specific unit of measure.
Item Branch Classification Codes
You might want to group items with similar characteristics so that you can work with the entire group at the same time for branch/plants. For example, grouping items together provides good sales analysis information.
Four types of classification codes are available. Each type relates to one or more of these systems:
JD Edwards EnterpriseOne Sales Order Management
JD Edwards EnterpriseOne Procurement
JD Edwards EnterpriseOne Inventory Management
JD Edwards EnterpriseOne Warehouse Management
JD Edwards EnterpriseOne Transportation Management
Item Branch/Plant Manufacturing Information
For each item, you can define manufacturing information that is specific to each branch/plant, including:
Type of information |
Description |
Requirements planning information |
Enter information about inventory shrinkage for items to plan for the quantity that you need to replace due to shrinkage. |
Leadtime information |
Enter leadtime information to calculate the time frames that are necessary to assemble or manufacture an item. |
Engineering information |
Enter reference information about the drawing plans for items. |
Most of the items on Plant Manufacturing Data are identical to those on Manufacturing Data. The system uses the default values that you specified on Manufacturing Data.
Item Information Duplication for Multiple Branch/Plants
You might have item information that applies to items in multiple branch/plants. You can enter item information for one branch/plant and then duplicate the information for as many as ten other branch/plants by using either of these programs:
Item Branch Duplication program (P41015) to select individual items for duplication.
Item Branch Duplication batch program (R41826) to define criteria for items that you want to duplicate.
These programs use the F41015 table during processing.
You use processing options in both programs to specify the branch/plants for which you are duplicating information. You can also specify additional information to duplicate, such as costs, prices, units of measure, and so on. For either procedure, the system sends a message to the Employee Work Center when the duplication process is completed.
When you duplicate item information, the system does not duplicate the primary location for an item. The system uses the blank location that you have set up for the branch/plant to which you are duplicating information.
If you use the R41826 program to select individual items for duplication, you can set processing options to display up to four search fields to enable you to locate items for a particular branch/plant.
For matrix-controlled items, use the R41826 program to copy information about the matrix parent item to all children that you have chosen for the system to generate in the matrix. The system creates records in these tables for the children in the matrix:
F4101
F4102
F41021
F4105
F4106
F41002
See Also
Setting Up Allowed Lot Status Codes
Before you complete the tasks in this section, you must:
Set up the origin of imported items in UDC 41/L9.
Set up customs codes in UDC 41/L0.
Enter a value in the Country of Origin field on the Item Branch/Plant Info. form.
Form Name |
FormID |
Navigation |
Usage |
Work with Item Branch |
W41026E |
Inventory Master/Transactions (G4111), Item Branch/Plant |
Review item branches. |
Item/Branch Plant Info. |
W41026A |
Click Add on the Work with Item Branch form. |
Assign an item to a branch/plant. |
Primary Location |
W41026B |
This form appears automatically after you assign an item to a branch/plant on the Item/Branch Plant Info. form. |
Assign a primary location to an item. |
Work with Item Locations |
W41024B |
Select Location Revisions from the Row menu on the Work with Item Branch form. |
Change the primary location for an item. |
Location Revisions |
W41024A |
Click Add on the Work with Item Locations form. |
Assign a secondary location to an item. |
Category Codes |
W41026G |
|
Enter inventory and transportation classification codes. Enter sales, purchasing, and warehouse classification codes. |
Item/Branch Plant Info. |
W41026A |
Select Item/Branch Info. from the Row menu on the Work with Item Branch form. |
Enter tax information. Locate item sources. |
Quantities |
W41026C |
Select Quantities from the Row menu on the Work with Item Branch form. |
Enter item reorder quantities. |
Additional System Info (additional system information) |
W41026D |
Select Addl System Info. from the Row menu on the Work with Item Branch form. |
Enter branch/plant manufacturing information. |
Work with Item Branch Duplication |
W5541015A |
Inventory Advanced Technical Ops (G4131), Item/Branch Duplication |
Duplicate item information for multiple branch/plants. |
Processing options enable you to specify the default processing for programs and reports.
Process
These processing options specify whether the system displays additional Item Branch forms when you add or change information on the Item Branch/Plant Info. form.
1. Category Codes |
Specify whether to display the Category Codes form when you add or change information. Values are: Blank: Do not display. 1: Display. |
2. Quantities |
Specify whether to display the Quantities form when you add or change information. Values are: Blank: Do not display. 1: Display. |
3. Additional System Information |
Specify whether to display the Additional System Information form when you add or change information. Values are: Blank: Do not display. 1: Display. |
4. Item Profile Revisions |
Specify whether to display the Item Profile Revisions form when you add or change information. Values are: Blank: Do not display. 1: Display. |
5. Cost Revisions |
Specify whether to display the Cost Revisions form when you add or change information. Values are: Blank: Do not display. 1: Display. |
6. Price Revisions |
Specify whether to display the Price Revisions form when you add or change information. Values are: Blank: Do not display. 1: Display. |
7. Unit of Measure |
Specify whether to display the Unit of Measure form when the unit of measure conversions are at the branch level and you are adding or changing information. Values are: Blank: Do not display. 1: Display. |
Versions
If you leave either of the following processing options blank, the system uses default version ZJDE0001.
1. Summary Availability (P41202) |
Specify the version of the Item Availability program to use. |
2. Item/Location Information (P41024) |
Specify the version of the Location Revisions program to use. |
Interop
1. Transaction Type |
Enter a code from UDC 00/TT that identifies the type of transaction, such as an invoice or a sales order. You can enter a transaction type or select one from the Select User Define Code form. The system uses the transaction type as the default. If you leave this processing option blank, the system does not perform export processing. |
2. Before/After Image Processing |
Specify when the system creates a record of a transaction. Values are: Blank: Create a record of a transaction after changes. 1: Create two records: one record before changes and one record after changes. |
Access the Item/Branch Plant Info. form.
The F41001 table must contain a record for the branch/plant that you enter.
Access the Primary Location form.
Location |
Enter the area in the warehouse where you receive inventory. The format of the location is user-defined, and you enter the location format for each branch/plant. |
Lot/Serial |
Enter a number that identifies a lot or a serial number. A lot is a group of items with similar characteristics. |
Access the Location Revisions form.
To assign a secondary location to an item, enter the location and lot/serial information.
Access the Work With Item Locations form.
The system changes the location that was the primary location to a secondary location and changes the location that you selected to the primary location.
Access the Category Codes form.
Access the Category Codes form.
The JD Edwards EnterpriseOne Transportation Management system uses the Shipping Conditions Code and Shipping Commodity Class fields.
Access the Item/Branch Plant Info. form.
Sales Taxable |
Enter a code from UDC H00/TV that indicates whether the item is subject to sales tax when you sell it. The system calculates tax on the item only if the customer is also taxable. |
Purchasing Taxable |
Enter a code from UDC H00/TV that indicates whether the item is subject to sales tax when you purchase it. The system calculates tax on the item only if the supplier is also taxable. |
See Also
Entering Sales Order Header and Detail Information
Access the Item/Branch Plant Info. form.
You can locate the country in which an item originates and the preferred supplier for an item. Locating these sources enables you to distinguish items based on a country or supplier. You specify this information when you enter branch/plant information for an item.
Supplier Number |
Enter a user-defined name or number that identifies an address book record. You can use this number to locate and enter information about the address book record. If you enter a value other than the address book number (AN8), such as the long address or tax ID, you must precede it with the special character that is defined in the Address Book constants. When the system locates the record, it returns the address book number to the field. For example, if address book number 4100 (Total Solutions) has a long address TOTAL and an * distinguishes it from other entries (as defined in the Address Book constants), you could type *TOTAL into the field, and the system would return 4100. |
Country of Origin |
Enter a code from UDC 00/CN that identifies the country in which an item originates. This information is useful to organizations that must periodically separate their inventory by source. |
You can specify the minimum, maximum, and normal reorder quantities for an item. You can also specify the level of stock at which reordering takes place. The system uses these values in the JD Edwards EnterpriseOne Requirements Planning system.
Reorder Quantity |
Enter the estimated reorder quantity for an item. You can enter this quantity if the system does not have enough sales history to accurately calculate a reorder quantity. |
Maximum Reorder Qty (maximum reorder quantity) and Minimum Reorder Qty (minimum reorder quantity) |
Enter the maximum and minimum order quantities for an item. You can calculate the quantity on factors other than usage, such as perishability, storage capacity, and so forth. |
Reorder Point |
Enter a quantity for an item that specifies when replenishment occurs. Typically, this occurs when the total quantity on hand plus the quantity on order fall to or lower than a specified quantity. You can enter this quantity, or the system can calculate the quantity if a sufficient sales history is available. |
Multiple Order Quantity |
Enter a multiple for rounding up planned order quantities in MPS/MRP. The system rounds up the planned order quantity to the nearest multiple that you enter in this field. |
Units Per Container |
Enter the standard quantity of containers that you use in the manufacturing process (typically, in a repetitive manufacturing environment). The quantity that you enter determines the number of bar code labels that you will need for shipping. It also modifies order release quantities. |
Safety Stock |
Enter the quantity of stock that is kept on hand to cover high-side variations in demand. |
Access the Additional System Info. form.
Shrink Factor |
Enter a fixed quantity or percentage that the system uses to determine inventory shrinkage for an item. If you are entering a percentage, enter 5 percent as 5.00 and 50 percent as 50.00. The system increases the planned order quantity by this amount in MPS/MRP/DRP generation. The shrink factor method that you specify for the item determines whether the shrink factor is a percentage or a fixed quantity. |
Shrink Factor Method |
Enter a value that determines whether the shrink factor that you enter for this item is a percentage or a fixed quantity. Values are: %: Percentage of order or requested quantity. F: Fixed amount to be added to quantity. |
Issue and Receipt |
Enter a code that indicates whether an item is received at the time of inventory issues or whether the system uses the Move and Disposition program. Values are: 0 : The system does not perform any actions. 1: The system receives an item when an inventory issue occurs. 2: The system uses the Movement and Disposition program when an inventory issue occurs. |
Replenishment Hours |
Enter the time that is required before a consuming location has a replacement kanban available from its supplying location. This value is used only for kanban card processing in the JD Edwards EnterpriseOne Shop Floor Management system. |
Setup Labor |
Enter the standard setup hours that you expect to incur in the normal completion of this item. This value is not affected by crew size. |
Queue Hours |
Enter the total hours that an order is expected to be in queue at work centers and moving between work centers. The system stores this value in the F4102 table. You can calculate this value using the Leadtime Roll up program, or you can enter it manually. When you run the Leadtime Roll up program, the system overrides manual entries and populates the table with calculated values. |
Time Basis |
Enter a code from UDC 30/TB that indicates how machine or labor hours are expressed for a product. Time basis codes identify the time basis or rate to be used for machine or labor hours that are entered for every routing step. Examples are 25 hours per 1,000 pieces and 15 hours per 10,000 pieces. You can maintain the time basis codes in Time Basis Codes. The system uses the values in the Description-2 field on the UDC for costing and scheduling calculations. The description is what the code represents, but is not used in calculations. |
ECO Number (engineering change order number) |
Enter the number that is assigned to an engineering change order. |
ECO Reason (engineering change order reason) |
Enter a code from UDC 40/CR that identifies the reason for the engineering change order. |
ECO Date (engineering change order date) 7 |
Enter the date of the engineering change order. |
Item Revision Level |
Enter the revision level for an item. If you enter a revision level in this field, verify that the revision level of the routing for an item matches the revision level on the bill of material for the item. |
Kanban Item |
Identify an item as a kanban-specific item. |
Note. You might need to use the scroll bars to locate all the fields.
Processing options enable you to specify the default processing for programs and reports.
Defaults 1
Branch One through Branch Six |
Enter the branch/plants to which you want to duplicate the items. |
Default 2
Branch Seven through Branch Ten |
Enter the branch/plants to which you want to duplicate the items. |
Process
Enter 1 to duplicate the file. If you leave this processing option blank, the file will not be duplicated.
Cost Ledger File (F4105) |
Specify whether to duplicate the Cost Ledger table. |
Base Price File (F4106) |
Specify whether to duplicate the Base Price table. |
UOM Conversion Factor (F41002) |
Specify whether to duplicate the UOM Conversion Factor table. |
Bulk Depot/Product Information (F41022) |
Specify whether to duplicate the Bulk Depot/Product Information table. |
Item Profile (F46010) |
Specify whether to duplicate the Item Profile table. |
Item Unit of Measure Definition (F46011) |
Specify whether to duplicate the Item Unit of Measure Definition table. |
Item Branch Master-Service/Warranty Extension (F41171) |
Specify whether to duplicate the Item Branch Master-Service/Warranty Extension table. |
Access the Work With Item Branch Duplication form.
See Also
Setting Up Warehouse Locations
This section provides an overview of matrix and parent items, lists prerequisites, and discusses how to:
Set processing options for Matrix Items (P4101E).
Review matrix items.
Set processing options for Matrix Order Entry (P41902).
Specify quantities of items to order.
In the Consumer Packaged Goods (CPG) industry, products often have a number of variations though they share the same basic properties. For example, the inventory might contain a beverage such as bottled water. However, customers demand a number of variations in the attributes of bottled water, including flavored water, plain water, carbonated water, plastic bottles of water, and glass bottles of water. Bottled water is available in six packs, twelve packs, and cases. Additionally, differently sized bottles are available. However, the bottled water remains the same in its basic properties, such as requirements for storage conditions, shipping, and pricing.
When you define segments in the Template Master program (P410014), you can specify which values the system uses for the segments when generating children for the matrix and how the child items appear in the matrix.
When you access the Item Master program (P4101) using the Work With Matrix Items form, specify the template that you created and whether the system should create a matrix for the parent item, and then add the item information. Select values for each segment that you defined in the template to select the attributes for the children of the parent item. The combined values that you select identify all of the variations of the parent item. As you continue the item entry process, the system displays all variations of the parent item so that you can review all of the child items to be created and remove those that you do not want the system to create when you run the Item Branch Duplication - Batch Selection program (R41826).
Run the Item Branch Duplication program to create the child items and optionally populate the matrix with all of the variations of the parent item that you have created and chosen. Running the Item Branch Duplication program prevents you from having to enter individual items for each separate combination of attributes. Provided that you set the processing options appropriately, the system can also copy item cost, item price, and unit of measure conversion information to selected branch/plants.
Use the Matrix Maintenance program (P41903) to rearrange the sequence or modify the column headings in the matrix. You can also use this program to add items to the matrix. The information that you specify when using this program determines how the matrix appears when you are placing a sales order or purchase order for matrix items.
See Entering a Segmented Item.
See Duplicating Item Information for Multiple Branch/Plants.
Matrix Items
You must enter a parent item in the Item Master program (P4101) to create all of the variations (child items) of the parent item. You enter a parent item just as you would any other item in the inventory, except that you specify a template and indicate that the item is matrix-controlled or not matrix-controlled. The system uses this information to display forms that enable you to add all variations of the parent item.
Ordering Matrix Items
The Matrix Order Entry program (P41902) enables you to create purchase orders and sales orders for matrix items. You also can access existing sales orders or purchase orders to order quantities of a matrix item. When you enter a sales order or purchase order, you can access the P41902 program, which also enables you to:
Review all of the possible variations (child items) of the parent item.
Review the on-hand and available quantities, provided that you have set the processing option in the Matrix Order Entry program.
Order quantities for the child items that you select (if you have already ordered quantities, you can update the quantities before placing the order again).
When you are working with an existing sales order or purchase order, you also can review both segmented item availability and summary availability. This information helps you review available quantities before you enter an order for matrix items. When you enter a sales order or purchase order for a matrix item, the system automatically creates order detail lines for the child items that you have chosen.
See Entering Sales Order Header and Detail Information.
See Entering Purchase Orders for Brazil.
Before you complete the tasks in this section, you must:
Complete the Segment Separator Character field if you want to use all 25 characters; otherwise, this is populated in the Branch/Plant Constants program (P41001).
Set the appropriate processing options for the matrix version to be used in the Item Branch Duplication - Batch Selection program (R41826) to copy item cost, item price, and unit of measure conversion information.
Create a template that contains the product attributes.
For orders, set the appropriate processing option on Matrix in the Sales Order Entry program (P4210) or the Purchase Orders program (P4310).
Form Name |
FormID |
Navigation |
Usage |
Work with Matrix Items |
W4101EC |
Inventory Master/Transactions (G4111), Matrix Item |
Review matrix items. |
Item Master Revisions |
W4101A |
Click Add on the Work with Matrix Items form. |
Create an item master record for a matrix item. |
Work with Matrix Headings |
W41903A |
Inventory Advanced – Technical Ops (G4131), Matrix Maintenance |
Review matrices. |
Matrix Heading Maintenance |
W41903B |
Select a record on the Work with Matrix Headings form. |
Revise matrices. |
Customer Service Inquiry |
W4210E |
Sales Order Processing (G4211), Sales Order Detail |
Review customer service inquiries. |
Sales Order Detail Revisions |
W4210A |
Click Add on the Customer Service Inquiry form. |
Revise sales order details. |
Matrix Order Entry |
W41902A |
On the Sales Order Detail Revisions form, select Matrix Order from the Row menu. |
Specify quantities of items to order. |
Work With Segmented Item Availability |
W41206A |
|
Inquire on segmented item availability. |
Processing options enable you to specify default processing for programs and reports.
Versions
If you leave either of the following processing options blank, the system uses default version ZJDE0001.
1. Item Master (P4101) |
Specify the version of Item Master to use. |
2. Item Segment Selection (P410015) |
Specify the version of Item Segment Selection to use. |
Access the Work With Matrix Items form.
If you are working with the Matrix Order Entry program (P41902), the value in this field specifies the defined organization of the matrix items. You can enter order amounts in this field during sales or purchase order entry. If you access the P41902 program from the Work with Matrix Items form, the system displays the available items within the matrix item. A value of 1 in this field indicates the combination of items that is available in the parent matrix item.
Processing options enable you to specify the default processing for programs and reports.
Display
1. Display Quantities |
Specify whether to display quantities. Values are: Blank: Do not display quantity on hand or available items. 1: Display quantity on hand. 2: Display quantity available. 3: Display both. |
Access the Matrix Order Entry form.
This section provides an overview of item cost information and discusses how to:
Set processing options for Cost Revisions (P4105).
Assign a cost level to an item.
Assign a cost method to an item.
Enter manufacturing setup cost information.
You must provide cost information for items in order to track inventory costs. Cost information determines:
Whether the system maintains one overall cost for the item or a different cost based on branch/plant.
Which cost method the system uses to track inventory costs.
Which cost method the system uses for purchase orders.
You can also add prorated setup costs for manufacturing.
For each cost method that you assign to an item, you must also specify a cost. For example, to use the last-in cost method for an item, you must enter an initial cost for that cost method. The system updates the last-in cost based on the cost of the item as of the last receipt date. The system stores inventory cost records in the F4105 table.
You determine whether the system maintains one overall cost for an item or a different item cost for each branch/plant. You can also define a different cost for each location and lot within a branch/plant. The level where you assign a cost to an item determines whether the system maintains costs at the lot, location, branch/plant, or master level. The cost level also determines how you locate the item to assign cost methods and enter item costs. For example, you can locate the item based on the:
Item.
Item and branch/plant.
Item, branch/plant, and location.
You can also indicate from which table the system is to retrieve a cost for an item when you enter a purchase order. The purchase price level that you specify for an item indicates which of these costs to use:
The inventory cost for the item, which is stored in the F4105 table.
The supplier's cost for the item if supplier costs are set up in the F41061 table.
Cost Methods for Items
You must specify the cost method that the system uses to determine an item's cost for:
Sales and costs of goods sold.
Purchase orders.
For example, you can use the weighted average cost method to determine the cost of goods that is sold for an item, and the last-in cost method to determine the item's unit cost for purchase orders. You can enter cost methods for items when you enter either item master information or item branch information.
The system provides eight predefined cost methods. You can define the own cost methods with UDCs, although the cost methods 01 through 19 are reserved.
If you do not enter an item cost for the cost methods that you assign to sales, inventory, or purchasing, the system displays a warning message. If you ignore the warning, the system assigns a zero cost for the cost method.
Item Cost Setup
You establish costs for an item by entering an amount for each cost method. When you review costs for the item, the system displays only those methods for which you entered an amount.
You can change the amount for any cost method at any time. For example, if you change the amount for the cost method that you use to track costs of goods sold, the system applies the new amount to the on-hand quantity of the item. It also creates journal entries to record the difference between the old and the new amounts.
Certain programs update the amount for cost methods 01 through 08. For example, the system updates last-in and weighted average amounts in this way:
For last-in, or cost method 01, the system interactively updates this amount based on the last cost of the item at the time of receipt.
For weighted average, or cost method 02, the system calculates and updates this amount by adding transaction quantities together, adding transaction costs together, and dividing the total cost by the total quantity. You cannot use the weighted average cost method (02) for the sales/inventory cost method with stocking type C or R.
For actual cost, or cost method 09, the system calculates the cost of the product that is built on a work order or rate schedule based on the actual hours that are used and the actual quantity of parts that are issued. The system updates the cost based on the most current information. You cannot use actual cost method (09) for the sales/inventory cost method with stocking type C or R.
The system also updates these costs:
Last-in, purchasing, and lot costs are updated by the PO Receipts program (P4312).
Purchasing cost is updated by the Voucher Match program (P4314).
If you create additional cost methods, you must update their amounts manually.
You can delete a cost method for an item if it is no longer applicable. If you try to delete the sales, inventory, or purchasing cost method, the system displays a warning message. The system does not delete the cost method, but assigns a zero cost for the cost method.
Form Name |
FormID |
Navigation |
Usage |
Item Master Revisions |
W4101A |
Inventory Master/Transactions (G4111), Item Master Select Item Revisions from the Row menu on the Work With Item Master Browse form. |
Assign a cost level to an item. |
Work with Item Cost |
W4105B |
Select a record, and select Cost Revisions from the Row menu on the Work With Item Master Browse form. |
Review the cost methods of an item. |
Cost Revisions |
W4105A |
Select a record on the Work with Item Cost form. |
Assign a cost method to an item. |
Additional System Information |
W4101C |
Select Addl System Info. from the Row menu on the Work With Item Master Browse form. |
Enter manufacturing setup cost information. |
Processing options enable you to specify the default processing for programs and reports.
Process
Standard Cost |
Specify whether to change the standard cost. Values are: Blank: Change. 1: Do not change. |
Interop
Transaction Type |
Enter a code from UDC 00/TT that specifies the transaction type for the interoperability transaction. If you leave this processing option blank, outbound interoperability processing is not performed. |
Flex Acct
Flex Accounting |
Specify whether to use flexible accounting. Values are: Blank: Do not activate flexible accounting. 1: Activate flexible accounting. |
Access the Item Master Revisions form.
Inventory Cost Level |
Enter a code that indicates whether the system maintains one overall inventory cost for the item, a different cost for each branch/plant, or a different cost for each location and lot within a branch/plant. The system maintains inventory costs in the F4105 table. Values are: 1: Item level. 2: Item/Branch level. 3: Item/Branch/Location level. |
Purchase Price Level |
Enter a code that indicates where to retrieve the purchase price for an item when you enter a purchase order. Values are: 1: Use the supplier/item price from the F41061 table. 2: Use the supplier/item/branch price from the F41061 table. 3: Use the inventory cost from the F4105 table. This cost is based on the inventory cost level and the purchasing cost method that you specify for the item. The first two codes are applicable only if you set up supplier costs in the JD Edwards EnterpriseOne Procurement system. If you do not set up supplier costs, the system uses the inventory cost as the default for the purchase order. |
See Also
Generating Supplier Prices in an Alternate Currency
Access the Cost Revisions form.
Sales/Inventory |
Enter a code from UDC 40/CM that indicates the cost method that the system uses to calculate the cost of goods that is sold for the item. Cost methods 01–19 are reserved. If you maintain costs at the item level, the system retrieves the default value for this field from the data dictionary. If you maintain costs at the item and branch/plant level, the system retrieves the default value from Branch/Plant Constants. |
Purchasing |
Enter a code from UDC 40/CM that indicates the cost method that the system uses to determine the cost of the item for purchase orders. Cost methods 01–19 are reserved. If you maintain costs at the item level, the system retrieves the default value for this field from the data dictionary. If you maintain costs at the item and branch/plant level, the system retrieves the default value from Branch/Plant Constants. |
Cost Method |
Enter a code from UDC 40/CM that specifies the basis for calculating item costs. Cost methods 01–19 are reserved. |
Access the Additional System Information form.
If you use JD Edwards EnterpriseOne manufacturing systems, you can prorate setup costs for an item based on the quantity of the item that you plan to produce.
Accounting Cost Qty(accounting cost quantity) |
Enter an amount that the system uses in the Cost Roll up program to determine the allocation of setup costs. The system totals the setup costs and divides the sum by this quantity to determine a unit setup cost. The default value is 1. |
This section provides an overview of sales price information and discusses how to:
Assign price levels and price list groups to an item.
Enter item prices.
If you use the JD Edwards EnterpriseOne Sales Order Management system with the JD Edwards EnterpriseOne Inventory Management system, you must provide sales price information for each item. You can have a different sales price for each unit of measure and currency in which you sell an item. You can also specify the effective dates for each sales price.
You determine whether the system maintains overall sales prices for an item or different prices for each branch/plant. You can also define different prices for each location and lot within a branch/plant. The level where you assign a sales price to an item indicates the level at which the system maintains prices. The sales price level also determines how you locate the item to assign price methods and enter item prices. For example, you can locate an item based on the:
Item.
Item and branch/plant.
Item, branch/plant, and location.
To change an item's price level after you have entered prices, you must use Sales Price Level Conversion.
You can also specify how the system calculates the sales price for a kit item. You can have the system add prices for all components that make up the kit, or you can use one price for the entire kit.
During the entry of sales price information, you can specify that the system maintain overall prices for an item or different prices for each branch/plant. You can also assign items with similar characteristics to price groups to which the system applies discounts and markups from the JD Edwards EnterpriseOne Sales Order Management system. You can assign price groups to items on Item Master Revisions or Item Branch/Plant Info.
You enter sales prices for an item by entering an amount for the unit of measure, currency, and effective dates for which the price is applicable. You also can enter a currency code for a price if you use multiple currencies. The system stores sales prices in the F4106 table.
See Also
Setting Up Base and Standard Pricing
Form Name |
FormID |
Navigation |
Usage |
Item Master Revisions |
W4101A |
Inventory Master/Transactions (G4111), Item Master Select a record on the Work With Item Master Browse form. |
Assign price levels and price list groups to an item. |
Work With Preference Base Price |
W4106J |
Select a record and then select Price Revisions from the Work With Item Master Browse form. |
Review item prices. |
Preference Hierarchy Selection |
W40073F |
Click Add on the Work With Preference Base Price form. |
Select item and customer groups. |
Base Price Revisions |
W4106K |
Select the item and customer group on the Preference Hierarchy Selection form. |
Enter item prices. |
Access the Item Master Revisions form.
Sales Price Level |
Enter a code that indicates whether the system maintains standard sales prices for an item, different sales prices for each branch/plant, or different sales prices for each location and lot within a branch/plant. The system maintains sales prices in the F4106 table. Values are: 1: Item level. 2: Item/Branch level. 3: Item/Branch/Location level. |
Kit/Configurator Pricing Method |
Enter a code that determines how the system calculates the price for kit items or configured items. Values are: Blank: Use for items that are neither kit items nor configured items. 1: The system accumulates the base prices of components with the configured price adjustments, and then discounts the total. 2: The system accumulates the base price of the parent item with the configured price adjustments, and then discounts the total. 3: The system accumulates the configured price adjustments, and then discounts the total. 4: The system accumulates the individually discounted price of the components with the configured price adjustments. Note. Only configured price adjustments are included in the calculation for a configured item. Also, the system discounts costs only if you are using the JD Edwards EnterpriseOne Advanced Pricing system from Oracle. This is an example of how the system uses the various methods: Parent Item: 125 Component A: 50 Component B: 100 Configured Cost Adjustment 1: 15 Configured Cost Adjustment 2: 10 Advanced Price Discount: 10 percent Methods: 1: 50 + 100 = 150 + 15 + 10 = 175 − 17.50 = 157.5 2: 12 + 1510 = 150 − 15 = 135 3: 15 + 10 + 25 − 2.5 = 22.5 4: (50 − 5) + (100 - 10) = 135 + 15 + 10 = 160 |
Additional Info
Select the Additional Info. tab.
Item Price Group |
Enter a code from UDC 40/PI that identifies an inventory price group for an item. Inventory price groups have unique pricing structures that direct the system to incorporate discounts or markups on items on sales and purchase orders. The discounts or markups are based on the quantity, monetary amount, or weight of the item ordered. When you assign a price group to an item, the item takes on the same pricing structure defined for the inventory price group. You must assign an inventory price group to the supplier or customer, as well as to the item, for the system to interactively calculate discounts and markups on sales orders and purchase orders. |
Basket Reprice Group |
Enter a code from UDC 40/PI that identifies a price group for an item. Basket reprice groups have unique pricing structures that direct the system to incorporate discounts or markups for items on sales orders. The discounts or markups are based on the quantity, monetary amount, or weight of the item that is ordered. When you run the Order and Basket Level Pricing program (R42750), the system identifies ordered items that belong to a common basket reprice group and applies the appropriate discounts or markups to the price of each item. |
Order Reprice Group |
Enter a code from UDC 40/PI that identifies a price group for an item. Order reprice groups have unique pricing structures that direct the system to incorporate discounts or markups for items on sales orders. The discounts or markups are based on the item quantity, monetary amount, or weight on the sales order as a whole. When you run the Standard Order/Basket Reprice procedure, the system identifies ordered items that belong to a common order reprice group and implements the appropriate discount as a flat dollar amount in a new discount line for the order. |
Access the Base Price Revisions form.
Unit Price |
Enter the list or base price to be charged for one unit of this item. In sales order entry, all prices must be set up in the F4106 table. |
Credit Price |
Enter credit orders in the JD Edwards EnterpriseOne Sales Order Management system. To enter a credit order, use a line type for which the Reverse Sign Flag (RSGN) is set to Y in the F40205 table. The system stores all credit prices in the F4106 table. |
Amount |
Select this check box if the factor value is an additional/deductible amount when applied to an order's price. |
Percentage |
Select this check box if the factor value is a multiplier (percent) when applied to an order's price. |