On Hand Data

These processing options control how the program calculates on-hand inventory.

1. Include Lot Expiration Dates

Specify whether the system performs lot validations when calculating on-hand inventory. Values are:

Blank: Do not include.

If you leave this processing option blank, the system does not consider lot dates when calculating available quantities.

1: Lot Expiration Date

The system reduces the available quantities based on the Lot Expiration Date.

2: Sell By Date

The system reduces the available quantities based on the Sell By Date.

3: Best Before Date

The system reduces the available quantities based on the Best Before Date.

4: User Defined Date 1

The system reduces the available quantities based on User Lot Date 1.

5: User Defined Date 2

The system reduces the available quantities based on User Lot Date 2.

6: User Defined Date 3

The system reduces the available quantities based on User Lot Date 3.

7: User Defined Date 4

The system reduces the available quantities based on User Lot Date 4.

8: User Defined Date 5

The system reduces the available quantities based on User Lot Date 5.

9: Commitment Date Method used in Item/Branch Master

The system reduces the available quantities based on the Commitment Date Method from Item/Branch Master.

2. Safety Stock Decrease

Specify whether to plan based on a beginning available quantity from which the safety stock quantity has been subtracted. Values are:

Blank: Do not decrease.

1: Decrease.

3. Receipt Routing Quantities

Specify whether items in transit, in inspection, or otherwise dispositioned are considered in the beginning available calculation or they are part of the In Receipt (+IR) bucket on the time series.

Quantity in Transit

In a manufacturing environment, sometimes it is necessary to establish where stock is in order to determine whether it is available for immediate use. Enter 1 if you want quantities in transit to be included in the Beginning Available calculation on the time series. Otherwise, the program includes these quantities in the In Receipt (+IR) line of the time series. The quantities are still considered available by this program; the only difference is how you view the quantities in the time series. Values are:

Blank: Do not include in on-hand inventory.

1: Include in on-hand inventory.

Quantity in Inspection

In a manufacturing environment, sometimes it is necessary to establish where stock is in order to determine whether it is available for immediate use. Enter 1 if you want quantities in inspection to be included in the Beginning Available calculation. Otherwise, the program includes these quantities in the In Receipt (+IR) line of the time series. The quantities are still considered available by this program; the only difference is how you view the quantities in the time series. Values are:

Blank: Do not include in on-hand inventory.

1: Include in on-hand inventory.

User Defined Quantity 1 and User Defined Quantity 2

In a manufacturing environment, sometimes it is necessary to establish where stock is, in order to determine whether it is available for immediate use. Enter 1 if you want these user defined quantities (defined on the Receipt Routings Revisions form in the Update Operation 1 or Update Operation 2 fields) to be included in the Beginning Available calculation. Otherwise, the program includes these quantities in the In Receipt (+IR) line of the time series. The quantities are still considered available by this program; the only difference is how you view the quantities in the time series. Values are:

Blank: Do not include in on-hand inventory.

1: Include in on-hand inventory.

4. Lot Hold Codes (up to 5)

Specify the lots to be included in the calculation of on-hand inventory. You can enter a maximum of five lot hold codes (41/L).

Blank: Do not include held lots in calculation of on-hand inventory.

*: Include all held lots in calculation of on-hand inventory.

5. Include Past Due Rates as a supply

Specify whether the system considers open quantities from rate schedules that are past due as a supply. If you enter a 1 in this processing option, the system includes these quantities in the calculation of the rate schedule unadjusted (+RSU) and the rate schedule adjusted (+RS) quantities. Values are:

Blank: Do not consider.

1: Consider.

6. Location Hold Codes (up to 5) (Release 9.2 Update)

Specify the locations to be included in the calculation of on-hand inventory. You can enter a maximum of five lot location codes (41/LS).

Blank: Include no held locations in the calculation of on-hand inventory.

*: Include all held locations in the calculation of on-hand inventory.

For more information, see Allowing Inventory Locations to be Put on Hold in the JD Edwards EnterpriseOne Applications Inventory Management Implementation Guide.