This chapter contains these topics:
Section 4.7, "Entering Item Branch/Plant Manufacturing Information"
Section 4.8, "Duplicating Item Information for Multiple Branch/Plants"
Section 4.9, "Updating G/L Class Codes to Inventory Locations"
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 each item based on the warehouse.
After you enter master information for an item, you can assign the item to different warehouses or branch/plants. You can then customize the item information for each branch/plant. You can also specify the locations in the branch/plant in which the item is stored.
Figure 4-1 Item Information Assignment and Customization
Every JD Edwards World system that retrieves item information must search for the item's branch/plant information before it can use that item's master information.
You can enter item information for a single branch/plant, or copy existing item information and duplicate it for multiple branch/plants.
Figure 4-2 Item Information Can Be Copied
After you enter item information for a specific branch/plant, the system creates a record in the Item Branch table (F4102).
Item Branch/Plant Information (P41026) supports import functionality. Item Location Information (P41024) supports import/export functionality. See theJD Edwards World Technical Tools Guide for more information.
Use the Item Master/Branch Z File Processes menu (G4101Z) to access Z file programs that allow you to add item information in batch mode. Each Z file program calls a version of a corresponding interactive program. For example, the Basic Item Master Z file program (P4101Z) loads data from F4101Z and runs it through the Item Master Revisions (P4101) program to create new items. You can set processing options for Item Master Revisions (P4101) to automatically launch other programs in batch mode. For example, you can set up P4101Z to call a version of P4101 for which the processing option is set to call the Item Branch program. If the processing option for the item branch program is set to call the Cost Revisions screen, and the Z files are populated properly, when you run P4101Z, the system creates item master records, item branch records, and item branch cost records.
From Inventory Management (G41), choose Inventory Master/Transactions
From Inventory Master/Transactions (G4111), choose Item Branch/Plant Information
After you enter master information for an item, you must assign the item to a specific branch/plant. After assigning the branch/plant, you can locate the item and branch/plant to customize the master information.
Figure 4-3 Item Branch/Plant Information screen
To assign an item to a branch/plant
On Item Branch/Plant Information
Complete the following fields:
Branch/Plant
Item Number
Field | Explanation |
---|---|
Branch/Plant | A code that identifies a separate entity within a business for which you want to track items and costs. This entity might be a warehouse location, job, project, work center, or branch/plant. The Business Unit field is alphanumeric.
Form-specific information This is the branch/plant or warehouse to which this item information is applicable. |
From Inventory Management (G41), choose Inventory Master/Transactions
From Inventory Master/Transactions (G4111), choose Item Branch/Plant Information
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
Multiple secondary locations
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.
The system prompts you for the primary location immediately after you assign an item to a branch/plant. You can 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.
If you specify location control in Branch/Plant Constants, you can assign an item to only those locations set up on Branch/Plant Location Master. If you do not specify location control, you can assign an item to any location.
Each time you enter a location for an item, the system creates a record in the Item Location table (F41021).
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 can prevent the assignment of an item that belongs to multiple lots and has multiple statuses within a lot to a single location. For example, assume that a pharmaceutical company receives a portion of a lot, approves the received portion, and stores it in a warehouse. The remainder of the lot arrives but needs to be approved. The pharmaceutical company stores the unapproved portion of the lot in a staging location, rather than storing the unapproved portion with the approved portion.
Complete the following tasks:
Assign a primary location to an item.
Assign a secondary location to an item.
Change the primary location for an item.
Change the status of a location.
Topic | Description |
---|---|
Creating a lot | When you assign locations, you might be able to create a lot if you have set the branch/plant constants appropriately.
For more information, seeSection 33.1, "Setting Up Constants". |
See Also:
Section 42.3, "Entering Information for Lots"for information about defining lot details
Section 43.4, "Working with Lot Statuses" for information about putting lots and locations on hold
Work with PC Import/Export in the JD Edwards World Technical Tools Guide
To assign a primary location to an item
On Item Branch/Plant Information
Choose Change Primary (F10).
On Primary Location, complete the following fields to assign a branch/plant to an item:
Location
Lot/SN (Lot/Serial Number)
To assign a secondary location to an item
On Item Branch/Plant Information
Choose Item/Location Information (F11).
Figure 4-5 Item/Location Information screen
On Item/Location Information, S in the following field identifies the secondary (S) locations for an item:
P/S (Primary/Secondary Location)
For each secondary location and lot, complete the following fields:
Location
Lot
Lot Status
To change the primary location for an item
On Item Branch/Plant Information
Choose Item/Location Information (F11).
Choose Primary Location (F10).
In the Primary Location window, complete the following fields:
Location
Lot
Press Enter to save information and return to Item/Location Information.
After you change the primary location for an item, the previous primary location becomes a secondary location.
To change the status of a location
On Item Branch/Plant Information
Choose Item/Location Information (F11).
Choose Location Master (F6).
Figure 4-6 Location Master Definition screen
Access the detail area (F4).
Figure 4-7 Location Master Definition screen (Detail area)
Complete the following field:
Hold
Field | Explanation |
---|---|
Location | A code that identifies inventory locations in a branch/plant. You define the format of the location identifier by branch/plant.
Form-specific information If you do not specify a location in this field, the system uses the blank location set up for the branch/plant in Branch/Plant Location Master. |
Lot/SN | A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics. |
P S | A value that indicates if this is the primary or secondary location for this item within this stocking location. Valid values are:
P – Primary storage location S – Secondary storage location Note: You can only have one storage area within each branch or warehouse marked as primary. In some cases, the system uses the primary storage area as the default. |
Lot Status | A user-defined code (system 41/type L) that indicates the status of the lot. If you leave this field blank, it 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. Form-specific information The default for this field comes from the lot status code (including a blank value) that you assign to the item on Item Master Information or Item Branch/Plant Information. The code that you enter here serves as the lot status default when you assign an item to a secondary location. |
Topic | Description |
---|---|
Effects on quantities | If you change an item's primary location and any of the following quantities exist, the quantities transfer to the new primary location:
|
Deleting a primary location | To delete a primary location, you must first change it to a secondary location. No quantities can exist in the locations that you delete. |
Reviewing lot information | To display more specific information about the lot, access the Lot Information form. This form displays the item that belongs to the lot, the branch/plant to which the lot is assigned, the lot expiration date, the lot status, and so on.
For more information, see Section 43.1, "Viewing Lot Availability" |
From Inventory Management (G41), choose Inventory Master/Transactions
From Inventory Master/Transactions (G4111), choose Item Branch/Plant Information
You can specify whether an item is subject to tax when you enter branch/plant information. The system uses the values that you enter as default information in the Sales Order Management and Procurement systems.
On Item Branch/Plant Information
Complete the following fields:
Sales Taxable
Purchasing Taxable
Field | Explanation |
---|---|
Sales Taxable | A code 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 | A code 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. |
From Inventory Management (G41), choose Inventory Master/Transactions
From Inventory Master/Transactions (G4111), choose Item Branch/Plant Information
You can locate the country in which an item originates and the preferred supplier for an item. Locating these sources allows you to distinguish items based on a country or supplier. You specify this information when you enter branch/plant information for an item.
On Item Branch/Plant Information
Complete the following fields:
Country of Origin
Supplier
Field | Explanation |
---|---|
Country of Origin | A user-defined code (system 00/type CN) that identifies the country in which the item originates. This is useful for organizations that must periodically separate their inventory by source. |
Supplier | The address book number of the preferred provider of this item.
You can enter the number for the supplier or you can have the system enter it each time that you receive the item from a supplier. You specify whether the system enters the supplier using processing options for Enter Receipts. |
From Inventory Management (G41), choose Inventory Master/Transactions
From Inventory Master/Transactions (G4111), choose Item Branch/Plant Information
You can specify the minimum, maximum, and normal reorder quantities for an item during your entry of branch/plant information. You can also specify the level of stock at which reordering takes place. The system uses these values for the Enterprise Requirements Planning and Execution system.
To enter item reorder quantities
On Item Branch/Plant Information
Choose Item Branch Quantities (F8).
On Item Branch Quantities, complete the following fields:
Reorder Quantity
Maximum Reorder Qty
Minimum Reorder Qty
Reorder Point
Multiple Order Qty
Units Per Container
Safety Stock
Field | Explanation |
---|---|
Reorder Quantity | The estimated reorder quantity for an item. You can enter this quantity if there is not enough sales history available for the system to accurately calculate a reorder quantity. |
Maximum Reorder Qty | The maximum order quantity for an item. You can base the quantity on factors other than usage, such as perishability, storage capacity, and so forth. |
Minimum Reorder Qty | The minimum order quantity for an item. You can base the quantity on factors other than usage, such as perishability, storage capacity, and so forth. |
Reorder Point | A quantity for an item that specifies when replenishment occurs. Typically, this occurs when the total quantity on-hand plus the quantity on order equal or do not meet a specified quantity. You can enter this quantity or the system can calculate it if there is sufficient sales history.
If there is no safety stock quantity defined, the system first calculates the safety stock by multiplying the square root of the average lead time quantity. Then, the system adds the calculated safety stock quantity to the average lead time quantity to determine the reorder point. Form-specific information Define the quantity that specifies when replenishment occurs. If you leave this field blank, the system calculates the replenishment quantity by adding the safety stock quantity (defined in the Item Location table (F41021)) to the average lead time quantity. |
Multiple Order Qty | 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 | 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 | The quantity of stock kept on hand to cover high-side variations in demand. |
From Inventory Management (G41), choose Inventory Master/Transactions
From Inventory Master/Transactions (G4111), choose Item Branch/Plant Information
You can define manufacturing information for an item that is specific to each branch/plant. This information includes:
Requirements - Enter information about inventory shrinkage for the item to plan for the quantity you need to replace due to shrinkage.
Lead time information - Enter lead time 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 an item, so that you can refer back to the plans.
Complete the following tasks:
Enter requirements planning information.
Enter lead time information.
Enter engineering information.
To enter requirements planning information
On Item Branch/Plant Information
Choose Plant Manufacturing Data (F10).
Figure 4-9 Plant Manufacturing Data screen
On Plant Manufacturing Data, complete the following fields:
Shrink Factor
Shrink Factor Method
To enter lead time information
On Item Branch/Plant Information
Choose Plant Manufacturing Data (F10).
On Plant Manufacturing Data, complete the following fields:
Time Basis
Queue Hours
Standard Setup Hours
To enter engineering information
On Item Branch/Plant Information
Choose Plant Manufacturing Data (F10).
On Plant Manufacturing Data, complete the following fields:
ECO Reason
ECO Number
ECO Date
Item Revision Level
Field | Explanation |
---|---|
Shrink Factor | A fixed quantity or percentage that the system uses to determine inventory shrinkage for an item. The system increases the planned order quantity by this amount in MPS/MRP/DRP generation. The shrink factor method you specify for the item determines whether the shrink factor is a percentage or a fixed quantity.
If you are entering a percentage, enter 5% as 5.00 and 50% as 50.00. |
Shrink Factor Method | A value that determines whether the shrink factor you enter for this item is a percentage or a fixed quantity. Valid values are:
% – Percentage of order or requested quantity F – Fixed amount to be added to quantity |
Time Basis | A user-defined code (system 30/type TB) that identifies the time basis or rate for machine or labor hours entered for any routing step. You can set rates per unit, per 10, per 1000, and so on.
The system uses the values in the Description-2 field on the User Defined Codes form for costing and scheduling calculations. The description is what the code represents, but is not used in calculations. |
Total Queue/Move Hours | The total time (in 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 Item Branch table (F4102). You can calculate this value using the Leadtime Rollup program or you can enter it manually. When you run the Leadtime Rollup program, the system overrides manual entries with calculated values. |
Setup Labor | The standard setup hours you expect to incur in the normal completion of this item. |
ECO Reason | A user-defined code (system 40/type CR) that identifies the reason for the engineering change order. |
ECO Number | The number assigned to an engineering change order. |
ECO Date | The date of the engineering change order. |
Item Revision Level | The revision level for an item. If you enter a revision level, verify that the revision level of the routing for an item matches the revision level on the bill of material for the item. |
From Inventory Management (G41), enter 27
From Inventory Advanced and Technical Operations (G4131), choose Item/Branch Duplication
You might have items for which the same information applies across multiple branch/plants. You can enter item information for one branch/plant and then duplicate that information for up to ten other branch/plants by doing the following:
Use Item Branch Duplication to select individual items for duplication
Use the Item Branch Duplication batch program to define criteria for items that you want to duplicate
For both procedures, you use processing options to specify the branches to which you are duplicating information. You can also specify additional information to duplicate, such as costs, prices, units of measure, and so on.
If you use Item Branch Duplication to select individual items for duplication, you can set processing options to display up to four search fields that allow you to locate items for a particular branch/plant.
Set up a blank location at the branch or branches to which you want to duplicate items.
Specify the branch or multiple branches to which you want to duplicate items in the processing options for the Item/Branch Duplication program (P41015).
To duplicate item information for multiple branch/plants
Figure 4-10 Item/Branch Duplication screen
To specify the branch/plant from which to duplicate information, complete the following field:
Branch/Plant
Enter 1 (Select to Duplicate) in the Option field next to each item to duplicate.
Press Enter to activate the batch job and exit the screen.
Topic | Description |
---|---|
Primary locations | 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.
For information about blank locations for branch/plants, see Setting Up Warehouse Locations |
From Inventory Management (G41), choose Inventory Master/Transactions
From Inventory Master/Transactions (G4111), choose Item Branch/Plant Information
You must assign a G/L Class Code to each branch record you create for an item. When you create a new location, the G/L Class Code for the location defaults from the item branch record. If you change the G/L Class Code for an item branch record and you want existing locations to reflect the change, you must set the Global Update Processing Option to 1.