Add or Change a Branch Inventory Item
Use the Branch Item Maintenance (IMB) program to add or change or copy an item to a branch with settings that apply only to that branch. See Background and Road Map for more information.
Enter the item number or click the Lookup icon and use the standard lookup options to select the item from a list. The item must be set up in the Enterprise Item Maintenance (IM) program.
OR
Enter * to create or change the default record. If you create a branch item default record, it is recommended that you also create a default record in Item Cost Maintenance (ICM) for overhead codes and tax settings. See Create a Default Record for a Maintenance Program.
The program lists the branches in which the item exists and to which you have access:
Field Name |
Displays |
||||||||||||
Br |
The code of the inventory branch |
||||||||||||
Subcl |
The product subclass for this item |
||||||||||||
Cur ECL |
The engineering change level for the current bill of material for this item; manufacturing planning programs use the value in this field as the default ECL. |
||||||||||||
Last ECL |
The engineering change level of the most recent bill of material created for this item in the Bill of Material Maintenance (MPS) program |
||||||||||||
Cur RRL |
The routing revision level that is defined as the current RRL This entry is used as the default for the Routing rev lvl field in the Manufacturing Order Maintenance (MIM) program. |
||||||||||||
Insp? |
If this item requires inspection:
|
||||||||||||
Buyer |
The code for the buyer who is responsible for purchasing this item for this branch |
||||||||||||
Plnr |
The code for the person who is responsible for planing this item |
||||||||||||
Price cl |
The code for an item price category to be used for reporting and for order pricing, discounts, and commissions |
||||||||||||
ABC cl |
The ABC class from A through J that identifies the relative value of this inventory item according to criteria established by your company |
||||||||||||
WO? |
Selected if the item is work orderless; blank if the item requires standard manufacturing order processing |
||||||||||||
Flr stk |
Floor stock code: |
||||||||||||
Sls UOM |
The unit of measure used to sell this item |
||||||||||||
Mfg br |
The branch that manufactures or assembles this item |
||||||||||||
Pref vendor |
The number of the vendor that you prefer to use to purchase this item |
Choose the appropriate options:
To |
Do This |
Add a branch record for this item |
Click Add. See step 3. |
Delete a branch record |
Highlight a line and click Delete. See Background for restrictions on deleting items. |
Copy this item to another branch |
Click Copy. See Copy an Item to Another Branch. |
Display or change the item's branch record |
Highlight the line and click Select or double click the line. |
Print the branch listing |
Click Print. See Print. |
Specify a different item |
Click OK. |
Exit the program |
Click Exit. |
The program displays the selected item and branch and these settings from the Enterprise Item Maintenance (IM) program:
Field Name |
Displays |
||||||||
Whse/Bin ctrl? |
|
||||||||
Serial/Lot ctrl? |
|
||||||||
Make/Buy/Kit |
|
||||||||
Pre-assign? |
|
||||||||
Item code |
A code for make-to-order items that are not a configured product or parent of a subassembly for which you want to create a cascading order |
||||||||
Invty acct cd |
The inventory account code assigned to this item; you can use inventory account code as a posting criterion in the Posting Criteria Maintenance (XPC) program |
||||||||
Unq CP RRL? |
|
||||||||
Last CP RRL |
The most recent routing revision level for this item |
Enter or change data in these fields:
Note
Fields can only be specified if the field is appropriate to the type of item being maintained. For example, planning/forecast fields cannot be entered for service (order code 3) items.
Field Name |
Type / Max Length |
Action / Description |
||||||||||||
Mfg branch |
Required |
Accept the displayed branch or select a different branch that manufactures or assembles this item. |
||||||||||||
Stocking branch |
Optional |
Used as the default stocking branch for released manufacturing orders. If left blank the manufacturing branch is used. The field is available for those organizations that have separate manufacturing and distribution branches. This field is active only for "make" items (Make/Buy/Kit field is M). |
||||||||||||
Item status |
Required |
Accept
0 for an active item or assign another status that you have defined
in the Item Status Codes (TISM)
program. |
||||||||||||
Sales UOM |
Optional |
Select the code for the unit of measure used when you sell the item. |
||||||||||||
Stocking UOM |
Display only |
The unit of measure in which the item is stocked |
||||||||||||
Item type |
Display only |
The item type based on order and bypass codes entered in the Enterprise Item Maintenance (IM) program. See Item Types. |
||||||||||||
Product class |
Display only |
The product class assigned to this item; you can use product class as a posting criterion in the Posting Criteria Maintenance (XPC) program |
||||||||||||
Product subclass |
Optional |
Accept
the displayed product subclass or select another subclass for
this item to be used for reporting, order pricing, discounts,
and commissions. |
||||||||||||
Price class |
Optional |
Select the code for an item price class that can be used for reporting, order pricing, discounts, and commissions. |
||||||||||||
Buyer |
Optional |
Accept
the displayed buyer code or select the code of the buyer who is
responsible for purchasing this item for this branch. |
||||||||||||
Planner |
Optional |
Select the code of the person who is responsible for planning this item. The Finished Goods Planning (MFP) and Material Requirements Planning (MRP) programs and various reports allow you to select items by planner code. |
||||||||||||
Preferred vendor |
Optional |
Accept
the displayed vendor number, click the Lookup icon and use the
standard
lookup options to select the vendor from a list, or leave
blank if you do not purchase or have a preferred vendor for this
item. |
||||||||||||
Consignment? |
Optional |
Select if this is a consignment item or leave blank if it is not. If you select,
you must enter a vendor number in the Preferred vendor field.
You may also want to enter a quantity in the Lot size field. Consignment items cannot be inspected; you should set the Inspection? field to N. See Overview: Consignment Inventory for more information. |
||||||||||||
Drop ship? |
Optional |
Select
if you routinely have your vendor ship this item directly to your
customer or leave blank if you do not. |
||||||||||||
Floor stock code |
Required |
Accept 0 if this is not a floor stock item or select 1 for a floor stock item. A non-manufacturing branch can only be 0. A manufacturing branch can be of 0 or 1. The default is set in the Flr stk cd field in Enterprise Item Maintenance (IM). See Floor Stock Code for more information. |
||||||||||||
Inspection? |
Optional |
Select an inspection requirement option when receiving a purchase order, manufacturing order, consignment inventory, or RMA:
If an item requires inspection, you must run the Receiving and Inspection (IRI) program to enter inspection results before it can be received to stock. |
||||||||||||
Receipt trigger |
Conditional |
Enter a quantity if you selected R or Q in the Inspection? field or leave zero if you selected N or left the selection blank. |
||||||||||||
PO receipt tol |
Optional |
Select the code that defines the levels of tolerance for purchase order over-receipts. See Receipt Tolerance Codes. |
||||||||||||
Mfg receipt tol |
Optional |
Select the code that defines the tolerance for manufacturing over-receipts. See Receipt Tolerance Codes. |
||||||||||||
Safety stock |
Optional |
Enter
the minimum quantity of this item that should be kept in inventory
at all times to protect against fluctuations in demand or supply. |
||||||||||||
Minimum order qty |
Optional |
Enter
the minimum quantity of this item to be ordered on a planned manufacturing
order. |
||||||||||||
Lot size |
Optional |
Enter
the standard quantity of the item that you make during the production
process. |
||||||||||||
Primary whse |
Optional/Conditional |
Enter the code for the warehouse where this item is to be stocked or leave blank. If Whse map active? is selected in the Branch Maintenance (TBM) program for this branch, the entries for warehouse and bin location are only validated against the warehouse map if they are not blank. For a warehouse/bin controlled item, the receiving program displays your entry as a default. If you leave blank, the program requires that you enter either a warehouse or bin location. |
||||||||||||
Primary bin loc |
Conditional |
Enter or select the code for the bin location in the stockroom, or leave blank. If Whse map active? is selected in the Branch Maintenance (TBM) program for this branch, the entries for warehouse and bin location are only validated against the warehouse map if they are not blank. If a customer has the Use prime loc field in the Customer Maintenance (CM) program set to A (for always) or D (for default), orders for the customer must be picked from this location. For a warehouse/bin controlled item, receiving programs display your entry as a default. If you leave blank, the program requires that you enter either a warehouse or bin location. Physical inventory programs display and print Primary whse and Primary bin loc even if an item is not warehouse/bin controlled. |
||||||||||||
Maximum pick qty |
Optional |
Enter the quantity of this item to set as the maximum to pick from the primary location. |
||||||||||||
Current RRL |
Optional |
Enter the routing revision level that is set up in the Routing Maintenance (RTM) program for this item to be the current routing revision level. This entry is used as the default for the Routing rev lvl field in the Manufacturing Order Maintenance (MIM) program. |
||||||||||||
Current ECL |
Optional |
Enter the Engineering Change Level to be used as the default for the ECL field in the Manufacturing Order Maintenance (MIM) program. |
||||||||||||
Last ECL created |
Display only |
The Engineering Change Level of the most recent bill of material created for this item in the Bill of Material Maintenance (MPS) program |
||||||||||||
Work orderless? |
Conditional/Optional |
Select if this is an uncontrolled parent item that has no controlled components that you make without a manufacturing order or leave blank if it is not. Work orderless items cannot be inspected; you should set the Inspection? field to N. |
||||||||||||
One-step mfg? |
Conditional/Optional |
If you make this parent item, select to use one-step manufacturing or leave blank to use multiple-steps to process orders. If you select, the system obligates components, creates a shipment, confirms picking, and can the print shop paper when you release a manufacturing order. Do not select for a configured product, bulk movement item, or cascading orders. |
||||||||||||
Scrap % |
Optional |
Enter
the percent of this item that you normally scrap during the manufacturing
process. |
||||||||||||
LT update |
Optional |
|
||||||||||||
Mfg LT |
Optional |
Enter the number of shop days required to manufacture this item. This time does not include order preparation lead time or the time required to purchase raw material or components. For a configured product, manufacturing lead time is the length of time between the release of a manufacturing order and shipment to the customer. For a make-to-stock item, it is the length of time between the release of a manufacturing order and receipt of the finished goods into inventory. The Material Requirements Planning (MRP) program uses this lead time for scheduling planned orders for components. |
||||||||||||
Order prep LT |
Optional |
Enter the number of shop days it takes to prepare an order for release, which can include determining the quantity required, entering the order, and printing or sending the paperwork. |
||||||||||||
Intransit LT |
Optional |
Enter the number of shop days after an order is placed with a vendor for the item to be delivered. |
||||||||||||
Put-away LT |
Optional |
Enter the number of shop days required to receive an item into inventory, which can include unloading, moving, receiving, and inspection. The Purchase Order Maintenance (VOE) program adds this lead time to the Date promised to determine the Due date in stk. |
||||||||||||
Accumulated LT |
Optional |
For a configured product, enter the number of shop days required to manufacture or procure this item. For other items, you can enter
a number. However, if you select I or E for the LT update field,
the Accumulated Lead Time Calculation
(MLT) program overwrites your entry. |
||||||||||||
Auto planning? |
Optional |
Select
if you want the Finished Goods Planning
(MFP) and Material Requirements Planning
(MRP) programs to disregard the planning time fence and move,
cancel, or replan up to the current date. If you select this field, you cannot also select the Excl from plan? field. |
||||||||||||
Planning period |
Optional |
Select
a code that designates the length of the periods (for example,
days, weeks, months) displayed for this item by the Planning
Profile Inquiry (MRD) and Planning
Profile Maintenance (MPM) programs and set up in the Planning
Period Codes Maintenance (MDM) program.
|
||||||||||||
Max planning period |
Optional |
Enter
the number of shop days for a single planned order for this item. |
||||||||||||
Exclude from plan? |
Optional |
Select to exclude this item from planning or leave blank to include the item in planning. If you select this field, you cannot also select the Auto planning? field. |
Field Name |
Type / Max Length |
Action / Description |
||||||||
Update safety stock? |
Optional |
Select to have the Forecast Calculation (MFC) program update safety stock or leave blank to update it manually. If you select, you can manually maintain the Safety stock field in this program. |
||||||||
Update in MFU? |
Optional |
Select to have the Forecast Update (MFU) program create a sales forecast based on the New forecast and Extend fcst by month fields or leave blank if you do not forecast or want to update the forecast for this item in the Sales Forecast Maintenance (MSF) program. For service or rough forecast, leave the field blank. The New forecast and Extend fcst by month fields will be used to calculate Service forecast when peg demand (see Planning Profile Maintenance). |
||||||||
Extend fcst by month |
Optional |
Enter
the number of months that you want the Forecast
Update (MFU) program to extend the quantity in the New forecast
field or enter 0 if you do not want to extend the forecast for
the current period to subsequent periods. For example, if you
enter 6 and the forecast quantity is 100, when you run Forecast
Update, the total forecast quantity for the next six months will
be 600. |
||||||||
Exclude past due? |
Conditional |
If
you also enter days for the Spread
forecast field, select if you do not want unconsumed forecast
to display for previous periods in the Planning
Profile Maintenance (MPM) and Planning
Profile Inquiry (MRD) programs or leave blank if you do. |
||||||||
Spread forecast |
Optional |
Enter the number of shop days to use to calculate the forecast increment. If you do not enter a number, the forecast quantity will be due on the first day of the period. The Finished Goods Planning (MFP) and Material Requirements Planning (MRP) programs use the forecast spread to take an item's forecast from the New forecast field and/or the forecast from the Forecast Maintenance (MSF) program and spread it throughout the forecast period: Forecast increment = Forecast quantity / INT(Shop days in forecast period /Forecast spread) For example, if you enter 5, the forecast period is 21 shop days (the current month is October, which has 31 calendar days and 21 shop days), and if the forecast quantity for the period is 100, then the forecast increment is 25. 25 = 100 / (21 / 5) If the first day
of the period (October 1) is a Saturday, the system plans the
first forecast for the first shop date prior (September 30). It
would plan a forecast increment of 25 for September 30, and successive
dates that are 5 shop days later: October 7, October 14, and October
21. |
||||||||
Accumulated demand |
Display only |
The accumulated demand from sales orders since the last time the Forecast Calculation (MFC) program was run. After you run MFC, the New forecast quantity updates and the quantity in this field resets to 0. |
||||||||
Old forecast |
Display only |
The previous month's New forecast value; the Forecast Calculation (MFC) program updates this field. |
||||||||
New forecast |
Optional |
Enter the expected demand for this item based on actual demand and past forecasts or enter 0 if you want to remove the forecast for the current period and all subsequent periods. If you want to update forecasts with the Forecast Update (MFU) program, you must also select the Update in MFU? field. If you enter a number of months in the Ext fcst by mo field, the Forecast Update program creates a forecast for this quantity for this number of months. Run the Forecast Maintenance (MSF) program to display the new forecast. Alternatively, you can use the Forecast Calculation (MFC) program to calculate a new forecast. If an item has no master schedule, the Material Requirements Planning (MRP) program uses the New forecast value for planning material requirements. |
||||||||
Trip signal |
Optional |
Accept
0. |
||||||||
MAD |
Optional |
Accept 0 to have the Forecast Calculation (MFC) program calculate and update MAD or enter a mean absolute deviation. Mean absolute deviation or MAD is equal to the average forecast error for the current period and is calculated by the Forecast Calculation (MFC) program, which also calculates the actual forecast error. The average forecast error is based on the difference between this item's new forecast value and its actual demand multiplied by the alpha factor entered in MFC. |
||||||||
ABC class |
Optional |
Enter an ABC class value from A through J that identifies the relative value of this inventory item according to criteria established by your company. The physical inventory Cycle Count Preparation (HCP) program can use this field to count high-value, high-usage items more frequently. You can use the ABC Class Update (HAA) program to update this field. |
||||||||
Count frequency |
Optional |
Enter the frequency of physical inventory count for this item; for example, enter 90 to count this item every 90 days (quarterly). The system updates the number of days between counts when you run the Physical Inventory Update (HCU) program. You can also run the ABC Class Update (HAA) program to update this field. |
||||||||
Eng drawing no |
Optional |
Enter the number that references the item's engineering drawing. The drawing number can also be associated with the bill of material for manufactured items. |
||||||||
Item class |
Optional |
Enter the item's class. The field is not used by PowerShift but you can use it in custom reporting. |
||||||||
Country of origin |
Optional |
Select
the country in which this item is manufactured. |
||||||||
Shipping category |
Optional |
Select the shipping category that you want to print on the bill of lading. |
||||||||
Non-commissionable |
Optional |
|
||||||||
Commission class |
Optional |
Select a commission class to assign to this item for this branch. |
||||||||
Bulk move item? |
Optional |
Select
if you move this item to the work center where it will be consumed
or leave blank if you do not. The Whse/bin loc? field for this
item in the Item Maintenance (IM) program
must be selected. |
||||||||
Bulk movement qty |
Optional |
If you selected Bulk move item?, enter the quantity you want to move based on the size of the container that you normally use. For example, if the stocking unit of measure is a 5-lb bag, enter 5. |
||||||||
IBT transfer qty |
Optional |
For
future use. |
||||||||
Build time |
Optional |
Enter
the number of hours that it takes to manufacture this item. |
||||||||
Qty short |
Optional |
Enter the current quantity of this item ordered by customers but not immediately available in stock. |
||||||||
Qty reserved |
Optional |
Enter the quantity of this item set aside for branch use. This field is not currently used by the system, but you can use it in custom reports. |
||||||||
Minimum sales qty |
Conditional/Optional |
Enter smallest quantity in the stocking unit of measure that can be ordered. The Sales Order Maintenance (OE) program issues a warning message if the sales order quantity is less than this entry. |
||||||||
Stock at last oper? |
Optional |
If you report operation completion with Barcode Labor Entry or WIP Movement, you can opt to stock manufactured items when the last operation is completed. Items controlled by warehouse/bin are stocked in the stocking location specified in Work Center Maintenance. This option is not available for lot or serial controlled items and is not applicable to workorderless items. Select if you want good pieces reported at the last operation sequence to generate a receipt of the finished good. If inspection is required, the receiver must be processed through Receiving and Inspection. If the item does not require inspection, good pieces reported are stocked. |
Click Other info to enter or change these fields:
Field Name |
Type / Max Length |
Action / Description |
Freight unit |
Optional |
This is field can be used in custom reports but is not otherwise processed by the system. |
Weight per UOM |
Optional |
Enter
the weight of one stocking unit of measure. The unit of measure
depends on the setting for the Base
wt UOM field in record for this branch in the Branch
Maintenance (TBM) program. |
Volume per UOM |
Optional |
Enter
the volume of one stocking unit of measure. |
Package width |
Optional |
Enter the width of the package in inches. |
Package length |
Optional |
Enter the length of the package in inches. |
Package height |
Optional |
Enter the height of the package in inches. |
Units per pack |
Optional |
Enter the number of stocking units of measure that can be placed in a package. The default entry is 1; zero is not allowed. |
Package weight |
Optional |
Enter
the weight of the packaging material. |
Units per master pk |
Conditional/Optional |
Enter the number of units that are included in a master pack. A master pack is typically made up of a number of packs. |
Master pack weight |
Conditional/Optional 10 numeric in the format 99999.9999 |
Enter the weight of
the master pack packaging material. The unit of measure depends on the setting for the Base wt UOM field in record for this branch in the Branch Maintenance (TBM) program. |
Units per pallet |
Conditional/Optional |
Enter the number of units that can be put on a pallet if you selected P for the Pallet/Container field. |
Pallet/Container wt |
Conditional/Optional |
Enter
the weight of an empty pallet if you selected P
for the Pallet/Container
field or container if you selected C
for that field. This weight is for information only and is not used in weight calculations. |
Pallet/Container |
Optional |
Select P if this item is shipped by pallet, select C if it is shipped by container, or leave blank if you use neither a pallet nor a container. |
Location type |
Optional |
Select the location type. See Location Type Maintenance (TLOCT) for more information. |
Location category |
Optional |
Select the location category. See Location Category Maintenance (TLCAT) for more information. |
Choose the appropriate options:
To |
Do This |
Display additional fields |
Click Other info. |
Delete a saved record |
Click Delete. See Delete. See Background for restrictions on deleting items. |
Enter notes for this item |
Click Notes. See Enter Notes for Items. |
Enter data in custom fields your company uses |
Click User. See Enter Data in User or Shadow File Fields. This button is active only if you have set up fields for this program in the User Fields Maintenance (XMO) program. |
Go to related program |
Click Jump. See Jump. |
Display change history for this item |
Click
Audit. See Display an Audit
Trail. |
View related information |
Click View. See The View Button. |
Display the cost record for this item |
Click Item costs. See Display Item Costs. Click OK to return to this program. |
Update the Accum demand field |
Click Accum dem. |
Display or maintain this item's bill of material |
Click Bill
of material. If the item has a standard bill of material, it is displayed in Bill of Material Maintenance or Bill of Material Inquiry. If it is a configured item, it is displayed in Configured Product Maintenance or Configured Product Inquiry. Click OK to return to this program. |
View or import documents associated with this branch item record |
Click Documents.
See Document Archiving and Document Import for more information. Note |
Accept the data |
Click OK. See step 2. |
Exit the program |
Click Exit. |