2 Understanding Bulk Stock Inventory

This chapter contains the following topics:

• Section 2.1, "Bulk Stock Inventory System Functionality"

• Section 2.2, "Bulk Stock Inventory System Tasks"

• Section 2.3, "Tables Used by the Bulk Stock Inventory System"

2.1 Bulk Stock Inventory System Functionality

This section discusses:

• Features of the JD Edwards Bulk Stock Inventory system.

• Intra-depot stock movements.

• Bulk product receipts.

• Reconciliations.

2.1.1 Features of the Bulk Stock Inventory System

With the JD Edwards Bulk Stock Inventory system, you can:

• Control the storage and movement of liquids at varying temperatures from one container to another.

• Calculate the volume for each transaction (sale, receipt, movement, and so on) for each product and for each container (tank, truck, and so on).

• Assign Lots and Country of Origin to Bulk items. (Release 9.1 Update)

• Perform volume and density conversions to any base temperature using international standard algorithms.

• Calculate product gain or loss accurately for each stock movement.

• Track inventory balances for each product in various units of measure, and show the details of the transactions that create the balance.

• Track commingled or custody stock in a tank and manage the transactions associated with each product by owner.

2.1.2 Intra-Depot Stock Movements

Intra-depot stock movements track inventory within a depot. The primary transactions, receiving new product and selling to customers, add or decrease inventory into and out of a depot.

You record an intra-depot stock movement whenever you need to account for stock that can no longer be found in the location or container to which it was previously assigned.

Bulk stock movements include:

• Tank-to-tank transfers

• Repacking

• Rebranding

• Regrading

• Decanting

• Filling

• Simple blending

• General stock adjustments

Movements can occur at numerous points within a depot. The General Stock Movements programs allow you to record the various types of movements, convert them to standard quantities by using calculation programs, and record any gains or losses that might have occurred.

2.1.3 Bulk Product Receipts

You record the receipt of bulk products requested on a purchase order as they arrive at the depot. You can confirm the receipt of the products requested on the purchase order, record the volumes received, and make adjustments to correct variances. Additionally, you can calculate any gains or losses that might have occurred during transportation.

As product moves between storage locations, gains or losses might occur due to spillage, theft, faulty meters, and so on. Four-Point Analysis Maintenance helps you track these gains or losses. You perform a four-point analysis primarily for long voyages to determine the product lost in transit, but you can record the data for any movement.

Receipts is a standard JD Edwards program. However, when you record the receipt of a bulk product, the JD Edwards Bulk Stock Inventory system version of the program displays the Bulk Product Receipts form. This form allows you to record product volumes and temperatures that were recorded when the product was received.

2.1.4 Reconciliations

The reconciliation process attempts to reconcile confirmed sales figures for a given period. During this process, the system should identify discrepancies due to transactions not being entered (lost invoices), theft, leakage, or faulty meters.

2.1.4.1 Throughput Reconciliations

The throughput reconciliation process compares confirmed sales figures and other metered outgoings with the measured throughput based on the meter readings for a given period. The comparison identifies discrepancies due to transactions not being entered, theft, leakage, or faulty meters.

2.1.4.2 Operational Reconciliations

The operational reconciliation process performs the actual reconciliations. From all inbound and outbound transactions (since the last reconciliation), the JD Edwards Bulk Stock Inventory system calculates the amount that should be in physical inventory and compares it to the actual amount in the tanks (from the final physical tank dip). In other words, the system measures and compares the physical inventory levels with the book inventory levels, so that differences can be reconciled and operational gains or losses recorded. It then updates the book inventory to reflect the current physical inventory.

2.2 Bulk Stock Inventory System Tasks

This diagram illustrates the tasks for managing bulk stock:

Figure 2-1 Managing bulk stock

Description of "Figure 2-1 Managing bulk stock"

2.3 Tables Used by the Bulk Stock Inventory System

Information used in the JD Edwards Bulk Stock Inventory system is stored in either master maintenance or transaction processing tables. The JD Edwards Bulk Stock Inventory system uses these tables:

• Item Cost Component Add-Ons (F30026)

• Price Adjustment Ledger File (F4074)

• Location Master (F4100)

• Inventory Constants (F41001)

• Item Master (F4101)

• Bulk Item Master (F41011)

• Conversions Table Interface File (F41012)

• Item Branch File (F4102)

• Item Location File (F41021)

• Bulk Depot/Product Information (F41022)

• Item Cost File (F4105)

• Item Base Price File (F4106)

• Lot Master (F4108)

• Location Detail Information (F4602)

• Tank Master Additional Information Tag File (F41500T) (Release 9.1 Update)

• Gain/Loss Transactions Additional Information Tag File (F41512T) (Release 9.1 Update)

• Operational Reconciliations History Tag File (F41514T) (Release 9.1 Update)

2.3.1 Master Maintenance Tables

The master maintenance tables store constants and setup information for the JD Edwards Bulk Stock Inventory system:

Table	Description
Item Master (F4101)	Stores product information specific to bulk products.
Conversion Table Interface File (F41012)	Stores conversion information for bulk products.
Item Branch File (F4102)	Stores item information specific to a depot (branch/plant).
Bulk Depot/Product Information (F41022)	Stores information specific to a depot and product for all bulk items.
Item Location File (F41021)	Stores information for an item at a specific location. The main purpose of this table is to store inventory balances on an item or location level. The table also stores basic item information that is identical to information found in the Item Master table. This information provides the default values for the Item Location table from the Item Master table. You can override the default values here.
Inventory Constants (F41001)	Stores various branch/plant constants. Each branch/plant represents a depot.
Item Units of Measure Conversion Factors (F41002)	Stores Unit of Measure conversion information about each item of inventory stored in the depot.
Unit of Measure Standard Conversion (F41003)	Stores standard Unit of Measure conversion information.
Location Master (F4100)	Stores basic information about all warehouse and tank locations for each branch/plant.
Tank Master File (F41500)	Stores structural information about the physical tank and information required for volume calculations. The system uses this table, in conjunction with the Tank Strapping table and the Default Tank Information table, to validate any products entered for bulk transactions.
Tank Strapping Table Maintenance (F41503)	Stores the gauging increments (physical dimensions) of the tank. This table is used in volume calculations.
Blend Category File (F41501)	Stores information on the allowed blend categories for blending tanks.
Default Tank Information (F41508)	Stores the default temperature and density and gravity information used in conversion routines.
Meter Master (F41506)	Stores information concerning the in a depot. This table is required for processing and reconciliations.
Allowed Products Matrix File (F41505)	Identifies the product groups that can be contained in the tanks and the order they can be used.
Item Cost File (F4105)	Stores the cost of products received into and sold out of the system.
Item Cost Components Add-Ons (F30026)	Defines the cost components to be updated when receiving product.
Location Detail Information (F4602)	Defines the locations used in warehousing to store product.
Lot Master (F4108)	Defines the detail lot locations that identify batches of product received.
Four-Point Analysis Maintenance File (F41509)	Stores the volumes recorded at different points in the movement of products.
Four-Point Temperature Maintenance (F415091)	Stores the temperatures recorded at different points in the movement of products.

2.3.2 Transaction Processing Tables

These tables store information from product transactions:

Table	Description
P. O. Detail Ledger File - Flexible Version (F43199)	Stores detail information for each purchase order line (item number, price, quantity ordered, and so forth).
Purchase Order Receiver File (F43121)	Stores details about the volume of product received.
Sales Order Header File (F4201)	Stores the header information for each sales order (sales order number, customer number, shipment date, default shipping locations, and so forth).
Sales Order Detail File (F4211)	Stores detail information for each sales order line (item number, quantity ordered, price, and so forth).
Item Ledger File (F4111)	Stores history information for all inventory transactions. Any change to the bulk inventory is recorded in this table. Some examples are purchase order receipt and inventory adjustment.
Bulk Product Transaction File (F41511)	Stores supplemental information that pertains to bulk transactions only, such as temperature and density information, ambient and standard volumes, tank dip information, weighbridge information, and so forth.
Gain/Loss Transactions File (F41512)	Tracks all gains and losses for analysis and reconciliations. Information used in the four-point analysis is tracked with a separate table.
Multi-Meter Readings (F41515)	Stores information regarding opening and closing meter readings.