Analysis and Adjustment Using On-Hand Inventory
Use the On-Hand Inventory table to review item on-hand inventory.
- You can filter data by items, item descriptions, or by a selection in the Gantt chart. Selection in the Gantt chart is only possible on single-capacity resources.
- When you select an item in the table, its consuming operations are highlighted
in the Gantt chart. Highlighting is possible on single-capacity resources only.
This readily helps you note the scheduling impact of unexpected supply delays.
Click the Clear Pegging Highlights button to remove the
highlighting.Note: Filtering data by Gantt chart selection and operation highlighting are accurate only after a solve action.
- An item isn'tlisted in the table if the On-Hand Quantity, On-Hold Quantity, and Shortage Quantity value are zero for the item. The item is listed only if one of the values is greater than zero. For lot-based inventory, the lots must be received before schedule horizon start and not yet expired. Lots that are on hold are considered if the hold date is before schedule horizon end.
- Inventory lots are displayed in the on-hand inventory table. You can only view up to 25 inventory lots in the table. All the other inventory lots can be accessed through the deep links from the items. Click the View Item Quantities icon to view item quantity information and all inventory lots in the Inventory Management work area.
Analyze
Use the On-Hand Inventory View to review on-hand supply, on-hold supply, and supply
shortages for items.
- If there's more demand than supply, say, due to the cancellation of a work
order, a shortage quantity is reported. The operations that consume shortage
quantity are scheduled after the shortage resolution date considering item's
lead time. These operations are highlighted separately on the Gantt
chart.Note: The highlighting for items with shortage inside the fixed time fence isn't accurate and should be ignored.
- Hold date is the date when an inventory lot that's currently on hold comes off hold and can be consumed. Inventory lots are listed only if their hold date is after the horizon start. All other inventory lot quantities are aggregated and displayed as the on-hand quantity.
Adjust
To override the lead time of items that have shortages:
- Double-click the Override for Lead time (Days) cell in the On-hand inventory table.
- Specify the new lead time in the Override for Lead time (Days) cell. The new shortage resolution date based on the new lead time is displayed in the Shortage Resolution On field.
- Click Solve to solve the schedule if you’re ready to solve, otherwise continue to other adjustments.
The solve process considers the new shortage resolution date during subsequent solves.
Note: The override value isn't released to Supply Chain Execution when you release the
schedule.