JDE Reference
41Inventory Management
Supply chainItem master, branch/plant records, on-hand balances, and the inventory movement ledger
12 tables13 programs
Tables
Master Data · 9
- F4100Warehouse location master: one row per storage location within a branch/plant, defining physical attributes plus putaway, pick, and replenishment behavior.master
- F4101Item master — one row per item with descriptions, units of measure, and category codes shared across branchesmaster
- F4102Item branch — branch/plant-level item attributes, planning parameters, and sourcing responsibilitymaster
- F41021Item location — on-hand, committed, and inbound quantities by item, branch, location, and lotmaster
- F4104Item cross-reference: links internal item numbers to external identifiers such as customer or supplier part numbers, substitutes, and replacements, keyed by cross-reference type.master
- F4105Item cost table: one row per item, branch, location, lot, and cost method carrying the unit cost used to value inventory and purchasing transactions.master
- F4106Item base price table: effective-dated unit and credit prices by item and branch, optionally specific to a customer, customer group, currency, and unit of measure.master
- F41061Supplier price catalog: supplier- and catalog-specific purchase prices with quantity breaks and effective date ranges, feeding PO unit cost retrieval.master
- F4108Lot master: one row per lot or serial number by item and branch, holding lot status, grade, potency, supplier lot linkage, and the full set of lot control dates.master
Transactional · 1
Control / Setup · 2
- F41001Branch/plant inventory constants: the per-branch switchboard for item number symbols, location formatting, costing methods, commitment rules, and G/L interface options.control
- F41002Item-level unit of measure conversions: the factor that translates one UOM into another for a given item and branch, used everywhere quantities change units.control
Programs
- P41001Branch/Plant Constants — define per-branch inventory rules: availability calculation, location format, and lot processingInteractive
- P4101Item Master — the interactive application that creates and maintains F4101 itemsInteractive
- P41026Item Branch/Plant — assign items to branch/plants and maintain branch-level item attributes and locationsInteractive
- P4105Cost Revisions — maintain item costs by cost method and branch/plant, generating variance journal entries on changeInteractive
- P4106Base Price Revisions — maintain base sales prices by item, branch, customer, or customer group with effective datesInteractive
- P41061Supplier Catalog Maintenance — maintain supplier price catalogs used for purchase price retrieval at PO entryInteractive
- P4108Lot Master — maintain lot records, statuses, and dates for lot- and serial-controlled inventoryInteractive
- P4111Item Ledger Inquiry (Cardex) — review the full transaction history behind every inventory quantity movementInteractive
- P4112Inventory Issues — remove inventory from stock (for example to scrap or expense) with matching journal entriesInteractive
- P4113Inventory Transfers — move inventory between locations or branch/plants, recording both sides of the movementInteractive
- P4114Inventory Adjustments — correct on-hand quantity discrepancies (cycle count variances, damage, initial loads)Interactive
- P4116Item Reclassifications — reclassify inventory from one item number, lot, or location to anotherInteractive
- P41202Item Availability — inquire on on-hand, committed, and available quantities by item, branch, location, and lotInteractive