Understanding JD Edwards EnterpriseOne Inventory Management for Project Manufacturing

JD Edwards EnterpriseOne Inventory Management is the basis of the supply chain. You must set up and manage inventory to work effectively with other programs in JD Edwards EnterpriseOne systems. The JD Edwards EnterpriseOne Inventory Management system defines discrete inventory items, which enable you to manipulate inventory throughout your supply chain.

See “Introduction to JD Edwards EnterpriseOne Inventory Management" in the JD Edwards EnterpriseOne Applications Inventory Management Implementation Guide.

The JD Edwards EnterpriseOne Inventory Management system maintains both generic and production controlled inventory. Generic inventory refers to items that are not production number controlled. Production controlled inventory refers to items that have the Production Number Controlled option selected in the item master or item branch/plant record.

You assign production numbers to items to track inventory issues. When submitting direct inventory transactions, the production number is an attribute of the inventory itself.

The system stores generic inventory information in the Item Master (F4101), Item Branch (F4102), Item Ledger File (F4111), and Item Location File (F41021) tables.

Production controlled item information is stored in the F4101, F4102, and Item Location Tag File (F41021T) tables. The F4102 table stores the production controlled setting for the item branch/plant. The F41021T table maintains information on how much of the on-hand inventory is allocated to a specific production controlled item.

The system labels the on-hand quantity of production controlled items in a lot location in theF41021T table with the production number. One item can have multiple production numbers. The on-hand quantity in the F41021T table will not be negative. The system calculates item availability from the F41021 table at run time.

You manage inventory using the Inventory Adjustments (P4114), Inventory Issues (P4112), and Inventory Transfers (P4113) programs.

You can also manage inventory using the Item Ledger Inquiry (CARDEX) program. The Item Ledger File table (F4111) tracks inventory transactions for items with production numbers. However, the F4111 table does not track the on-hand consumption by production number from the F41021T table.

The system restricts you from issuing production controlled inventory in excess of what is currently on hand for that location in the F41021T table.

When fulfilling orders, such as sales orders, a production controlled item can consume the on-hand quantity of another production number or generic inventory. When you perform inventory transactions, such as issues or transfers, from a specific production number, the system does not allow you to use inventory from other production numbers.

Note: The system does not maintain commitments for production controlled inventory.

A reversal of production controlled inventory transactions increases or decreases the on-hand quantity of the production number used in the transactions.

When you reassign to generic using the Production Number Reassignment program (P34404), the system sets the quantity to 0 (zero) for the production number record in the F41021T table. The system updates the F4111 table as follows:

  • Creates a negative transaction for existing orders or inventory by production number, and lot and location record.

  • Creates a positive transaction for the orders and inventory by generic, and lot and location record.

The JD Edwards EnterpriseOne Inventory Management system does not support reclassifications of items with related production numbers. If you reclassify an item that is production controlled, then the item does not retain the production number.

The system supports electronic data interchange (EDI) for inventory transactions of production controlled items.