Beginning Inventory On Hand

The Beginning Inventory On Hand group displays a summarization of the available quantity in the Quantity on Hand field for the item defined in the Item Number field in the Planning Selection group. The quantity on hand can include receipt routing buckets, safety stock, expired lots, held lots, and past due supply.

You set the Inventory On Hand processing options on the Defaults tab of the Planning Console program to define the initial quantities to include in the inventory on hand. You select the Include option in the Beginning Inventory On Hand group to interactively change the quantities to include in the available quantity calculation while on the Planning Console form. The system refreshes the Supply/Demand Details grid and charts every time you select an Include option.

You select the Quantity in Transit, Quantity in Inspection, Quantity in Operation 1, and Quantity in Operation 2 links to display the Receipt Routing Inquiry form of the Planning Console Receipt Routing Inquiry program (P34X221). You can also access the Receipt Routing Inquiry form from the In Transit Orders, In Inspection Orders, Operation 1 Orders, and Operation 2 Orders options on the Form menu.

You set the Lot Hold Codes to be considered as inventory on hand (Up to 5 Codes) Lot Hold Code 1 through 5 processing options on the Select tab of the Planning Console program to specify the lot hold codes from UDC 41/L that the system considers as inventory on hand. The system does not consider the lot hold codes specified in the processing option as on hold.

The expired lot quantity is a summarization of quantities from lots where the quantity on hand defined in the F41021 table is not equal to zero, and the lot expiration date defined in the F4108 table is not equal to zero and is less than or equal to the planning start date. You select the Expired Lots Quantity link or the Expired Lots option on the Form menu to access the Expired Lots form of the Planning Console Held Lots Inquiry program (P34X210).

The held lot quantity contains a summarization of quantities from lots with a hold code not equal to blank and not equal to the lot hold codes specified in the processing option. This summarization also includes only those lots effective as of the start date. The system retrieves the information for the held lot quantity from the Lot Master table (F4108). You select the Held Inventory Quantity link or the Held Lots option on the Form menu to access the Held Inventory form of the Planning Console Held Lots Inquiry program (P34X210).

The system retrieves all orders before the start date for past due supply and demand. The system stores all orders in the F34X200W table. The system displays individual past due supply and past due demand rows in the Supply/Demand Details grid. If past due supply is not included in the on-hand inventory, the system displays the row in gray colored font to indicate that it does not affect the inventory.

The system includes or excludes past due demand rows based on the planning time fence rule defined for the item:

Time Fence Rule	Before Time Fence	After Time Fence	34XEXCF - Past Due Demand
1	Zero	Forecast	All sales and forecasts are excluded.
3	Zero	Forecast plus customer demand	All sales and forecasts are excluded.
C	Customer demand	Greater of forecast or customer demand	All forecasts are excluded.
F	Forecast	Forecast plus customer demand	All sales are excluded.
G	Greater or forecast or customer demand	Forecast	All forecasts are excluded.
S	Customer demand	Forecast	All forecasts are excluded.
H	Forecast consumption periods		Current consumption period only and based on calculation. If you do not use forecast consumption, all forecasts are excluded. If you use standard forecast consumption or forecast consumption by customer, all consumed forecasts are excluded.