Shortages by Component Subtab

The Shortages by Component subtab displays the list of components used across multiple work orders with potential shortages. The results are displayed based on the dates you provide in the Date Range filter. Components with back ordered quantity greater than zero in work orders are listed here. You can filter the results based on the first required date, component, and insufficient supply.

You can use Choose Columns option to select the required columns to display on the Shortages by Component subtab grid.

To Select Columns for the Subtab Grid:

Go to Reports > Supply 360 > Supply 360 > Shortages by Component subtab.
On the Shortages by Component subtab, click Choose Columns.
On the Choose Columns window, check the boxes for the required columns to show on the grid.
Click Save.

To retain the default columns available on the grid, click Reset.

The following table provides details about the columns in the Shortages by Component subtab.

Column Name	Description
First Required Date	Production start date of the work order is considered if Demand Planning feature is enabled. Else, the transaction date of the work order is considered.
Component	Name of the component.
Total Short Quantity	Sum of back ordered quantities for a component across all the work orders within the selected date range. Note: In any of the below conditions, the Total Short Quantity column appears in red color for that line: If any one of the work order has supply quantity lesser than the short quantity. If there is a historical dated work order in the selected time frame.
Units	Base unit of the component item.
Supply Source	Supply transactions displayed with a hyperlink. (Work order, purchase order, transfer order, inter company transfer order, or inbound shipment) In case of multiple supplies, the Multiple hyperlink opens a popup which displays all eligible supply transactions within a selected date range.
Supply Quantity	Sum of the supply quantity from all supply types across multiple work orders. If there are no planned supplies, it will be zero.
First Supply Quantity	Supply quantity is taken from the first source (if source is multiple) whose expected receipt date, production end date, or expected delivery date which is at the earliest. If it is a single source, the corresponding supply quantity is displayed associated to a supply type.
Confidence	Predicted risk confidence of vendor. In case of multiple supplies, if the earliest supply is a purchase order, confidence percentage associated to vendor is displayed on results. If none of the supplies contain purchase order, the confidence will be blank.
First Receipt Date	It shows the earliest supply date. The column value is derived from one of the following transactions: Expected receipt date for purchase order, transfer order, or inter company transfer order. Production end date of the work order. (if Demand Planning feature is disabled, transaction date of the work order is considered) Expected delivery date for inbound shipment.

Column Name

Description

First Required Date

Production start date of the work order is considered if Demand Planning feature is enabled. Else, the transaction date of the work order is considered.

Component

Name of the component.

Total Short Quantity

Sum of back ordered quantities for a component across all the work orders within the selected date range.

Note:

In any of the below conditions, the Total Short Quantity column appears in red color for that line:

If any one of the work order has supply quantity lesser than the short quantity.
If there is a historical dated work order in the selected time frame.

Units

Base unit of the component item.

Supply Source

Supply transactions displayed with a hyperlink. (Work order, purchase order, transfer order, inter company transfer order, or inbound shipment)

In case of multiple supplies, the Multiple hyperlink opens a popup which displays all eligible supply transactions within a selected date range.

Supply Quantity

Sum of the supply quantity from all supply types across multiple work orders. If there are no planned supplies, it will be zero.

First Supply Quantity

Supply quantity is taken from the first source (if source is multiple) whose expected receipt date, production end date, or expected delivery date which is at the earliest.

If it is a single source, the corresponding supply quantity is displayed associated to a supply type.

Confidence

Predicted risk confidence of vendor.

In case of multiple supplies, if the earliest supply is a purchase order, confidence percentage associated to vendor is displayed on results. If none of the supplies contain purchase order, the confidence will be blank.

First Receipt Date

It shows the earliest supply date. The column value is derived from one of the following transactions:

Expected receipt date for purchase order, transfer order, or inter company transfer order.
Production end date of the work order. (if Demand Planning feature is disabled, transaction date of the work order is considered)
Expected delivery date for inbound shipment.

To download data from the Shortages by Component subtab, click Export button. This will generate an .xls file containing the relevant subtab data.

To Select Columns for the Subtab Grid:

Related Topics