Shortages by Component Subtab

The Shortages by Component subtab shows a list of components used in multiple work orders that might have shortages. The results are based on the dates you enter 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 columns you want to see 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	If Demand Planning is on, you'll use the work order's production start date. Otherwise, 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	The vendor's predicted risk confidence. If there are multiple supplies and the earliest one’s a purchase order, you’ll see the vendor’s confidence percentage. 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

If Demand Planning is on, you'll use the work order's production start date. Otherwise, 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

The vendor's predicted risk confidence.

If there are multiple supplies and the earliest one’s a purchase order, you’ll see the vendor’s confidence percentage. 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 creates an .xls file with the data from the subtab.

To Select Columns for the Subtab Grid:

Related Topics