WILLIAMS CO 001 TIME-PHASED PART AVAILABILITY 4/24/97
DSP01 WHS BEL Horizon Date 5/01/97 DETAIL
AAA CD UM EA Prod Type MRP Pln Pol A/R
Leadtime Days .000000 Backordered Qty 11.000
Total Balance - Mfg 2999.000 Allocated Qty - Mfg 11.000
Reserved Qty 142.000 On Order Qty 5001.000
Order No/ O Start/ Tran Iss/ On Hand Total-Mfg
Part - Customer S Due Date Quantity Rcpt Qty - Mfg Available Short
AA1 O 9/27/96 2001.000 BLK 2999.000 5000.000
AAA
ASF99 O 9/27/96 1000.000 BLK 2999.000 6000.000
AAA
ASF99 O 10/25/96 1000.000 BLK 2999.000 7000.000
AAA
005281 O 11/04/96 120.000 ISS 2999.000 6880.000
CUS-ACE
005303 O 11/20/96 2.000 ISS 2999.000 6878.000
CUS-ACE +
F2=Command F3=Exit F7=MO Det/Summ F8=Order Shortage
F9=Req Review F12=Stock Status F13=Whse Stock Stat
This screen displays the availability records (issues and receipts) for a specified part based on its component requirements, manufacturing orders, purchase orders, transfer orders, customer orders, Synchro offset releases, production schedule, and production schedule requirements. The balances on component requirement records are accumulated and time-phased to display shortage conditions. This information can be displayed for a specific company/warehouse or across all company/warehouses, depending on whether the company/ warehouse fields on the Function Select screen were entered or left blank. This information may also be displayed for a specific job number/part number combination.
Each line represents an expected stock movement, which may take the form of:
o Receipt against a manufacturing order (MRP parts)
o Receipt against a flow/production schedule (JIT parts)
o Receipt against a purchase order
o Receipt against a transfer order
o Issue to a manufacturing order
o Issue to a production center
o Issue to a sales order
o Shipment to customer (sales order line).
o Shipment to another company/warehouse (transfer order line)
o In-process shipment for an offset release (Synchro)
o Order quantity for a delivery request (item/delivery point line)
If a job-controlled part and a valid job were selected on the Function Select screen, then the job number, description, and status will appear.
If the company/warehouse fields were left blank, then only the part description and its unit of measure will be displayed in the headings.
COMPANY/WAREHOUSE
Display only. The company/warehouse in which the inquiry is being made.
HORIZON DATE
Display only. Only data up to the horizon date is loaded on this screen. If the date is not entered on the Function Select screen, it defaults to the last date on the calendar file for the company/warehouse. If company/warehouse is not entered on the Function Select screen, the date defaults to the largest last date for all company/warehouse combinations.
JOB NUMBER/JOB DESCRIPTION
Display only. Only availability records associated with this job are displayed.
JOB STATUS CODE
Display only. Indicates the status of the job. Possible values are:
O - Open
C - Closed
Z - Costing closed.
Additional job status codes may be defined on Reference File category D48.
PART NUMBER/PART DESCRIPTION
Display only. This field displays the part number and its corresponding description for which the inquiry was requested.
UNIT OF MEASURE
Display only. The unit of measure is which the requested part is stocked.
PRODUCTION TYPE
Display only. The production type associated with the part (either MRP or JIT) as defined on Reference File category C01.
PLANNING POLICY
Display only. The planning policy associated with the specified part. Planning policy codes are defined on Reference File category 404.
LEADTIME DAYS - DISTRIBUTION
Display only. The portion of the days that it takes to manufacture or purchase the part that does not vary with order quantity.
LEADTIME DAYS - MANUFACTURING
Display only. The portion of the days that it takes to manufacture or purchase the part that does not vary with order quantity. Not displayed if all company/warehouses were selected.
BACKORDERED QUANTITY
Display only. The total of backorder quantities on all open sales orders for the specified part in the specified warehouse.
TOTAL BALANCE - MANUFACTURING
Display only. For the manufacturing warehouse, this field is calculated as follows:
Inventory in any balance type available for manufacturing (Order Planning flag = Y)
Plus Work-in-process inventory
Plus Distribution inventory held in any distribution warehouses for the plant, if the warehouse is considered available for planning (as specified on the Warehouse Description File).
Minus Inventory reserved for sales orders if distribution sales orders are not available for planning (as specified on the Warehouse Balance File).
If the part is potency controlled, the quantity in this field is displayed in reverse image and reflects the balance in terms of potent units. Potent units are calculated as follows:
SKU for each balance type on each part/lot/location multiple location record
Multiplied by The actual potency on the lot control master record for the part/lot
Divided by The standard potency on the Lot Control master record for the part/lot
If negative inventory is being ignored (inventory netting flag is set to 'I'), then this field will be displayed in reverse image and will reflect the real-time amount (not zero). However, the supply demand for this part and displayed real-time, will not account for negative inventory that existed at the time of planning.
TOTAL BALANCE - DISTRIBUTION
Display only. For a distribution warehouse, this field contains the sum of the inventory held in balance types considered available for distribution. This quantity is displayed in the order unit of measure.
If the part is potency controlled, the quantity in this field is displayed in reverse image and reflects the balance in terms of potent units. Potent units are calculated as follows:
SKU for each balance type on each part/lot/location multiple location record
Multiplied by The actual potency on the lot control master record for the part/lot
Divided by The standard potency on the Lot Control master record for the part/lot
ALLOCATED QUANTITY - MANUFACTURING
Display only. The quantity of the allocated inventory required to satisfy existing open orders regardless of horizon. Allocated quantity includes the following:
o The quantity allocated for filling open manufacturing orders, transfer orders (relief code = 'M'), and sales orders (MFG, relief code = 'M').
o The quantity allocated for filling flow authorizations (this quantity is updated when a part availability order shortage report is requested).
o The quantity allocated for filling Synchro offset releases and delivery point backlogs (this quantity is taken into account only if the user has set the Synchro Allocated Quantity Update flag to 'Yes' on the Daily Batch Parameter category G26).
The system retrieves these quantities from the Warehouse Balance file.
AVAILABLE QUANTITY - DISTRIBUTION
Display only. This is the quantity of inventory available for this item at the sourcing warehouse, taking into account inventory reserved for filling other sales orders and the quantity on backorder. This quantity is displayed in the order unit of measure.
If the part is potency controlled, the quantity in this field is displayed in reverse image and reflects the balance in terms of potent units. Potent units are calculated as follows:
SKU for each balance type on each part/lot/location multiple location record
Multiplied by The actual potency on the lot control master record for the part/lot
Divided by The standard potency on the Lot Control master record for the part/lot
RESERVED QUANTITY
Display only. Used to define the quantity that is presently reserved for release to sales orders and transfer orders using relief code = 'D'.
ON-ORDER QUANTITY - DISTRIBUTION
Display only. This is the quantity of this item currently on order for the sourcing warehouse; for example, outstanding purchase orders for the item. This quantity is displayed in the order unit of measure.
ON-ORDER QUANTITY - MANUFACTURING
Display only. The quantity that has been ordered but not received against firm and open manufacturing, purchase, or transfer orders. For JIT manufactured parts, this is the sum of the warehouse balance on-order quantity (any outstanding purchase or transfer order quantities for the part) plus the warehouse balance flow authorization supply quantity (updated for firmed flow schedules by the Order Shortage Program). Not displayed for job-controlled parts.
SCHEDULE/SUPPLY QUANTITY
Display only. The quantity currently scheduled or requisitioned in a supply order.
UNRESERVED QUANTITY - DISTRIBUTION
Display only. This is the quantity which is neither reserved or backordered for this part out of distribution balances, but is unreserved quantity to blanket parent orders, which have not been released yet.
SELECT
Optional. Enter an X in this field to select a line for further processing. The part number will be returned to the select screen to allow you to perform another inquiry.
ORDER NUMBER
Display only. For requirements: either the parent manufacturing order for which the displayed part is a component, or the sales order if the displayed part is sold direct from the manufacturing warehouse. For supply: the manufacturing order, purchase order, requisition, or, for flows, the producing cell.
RELEASE NUMBER
Display only. The release number associated with the order number.
PART - CUSTOMER NUMBER
Display only. The part number or customer number associated with the order number. Customer numbers are preceded by 'CUS-'.
ORDER STATUS
Display only. Displays the manufacturing order status. Valid codes:
A - Active
P - Planned
F - Firmed
O - Open
R - Released
C - Closed
Z - Accounting Closed
START/DUE DATE
Display only. The start date and due date associated with the order.
QUANTITY
Display only. The transaction quantity is the quantity that is expected to be received against manufacturing, transfer, or purchase orders, or to be issued to manufacturing or sales orders. Receipt quantities are deflated by the scrap factor to estimate yield. This quantity may also include target inventory or forecast demand if these options were specified on the Function Select screen.
COMPANY/WAREHOUSE
Display only. The company/warehouse associated with the order number. These fields are displayed only if the company/warehouse fields were left blank on the Function Select screen.
PLANT
Display only. The plant associated with the order number. This field is displayed only if the company/warehouse fields were left blank on the Function Select screen.
ISSUE/RECEIPT
Display only. This code identifies the type of stock transaction. Possible values are:
ISS - Issue of component to manufacturing order, flow/production schedule, or shipment to a customer
MFG - Receipt against manufacturing order or flow/production schedule
RWK - Receipt against rework order
SRC - Issue to a Transfer Order
REC - Receipt from a Transfer Order
SGL - Receipt against single purchase order
BLK - Receipt against blanket purchase order
BYP - Receipt of a by-product (manufactured component)
ON-HAND QUANTITY - DISTRIBUTION
Display only. This figure is the expected on hand inventory assuming a "worst case" scenario. If the transaction is expected to have a positive effect on inventory (e.g., PO Receipts), this balance will not reflect the expected positive effect on inventory. If the transaction is expected to have a negative effect on inventory (e.g., Sales Orders), this balance will reflect the expected negative effect.
ON-HAND QUANTITY - MANUFACTURING
Display only. This figure is the expected on hand inventory resulting from the transaction. Manufacturing, purchase, and transfer order receipts are not included in the calculation of on hand inventory as the stock may not become available for use in manufacturing immediately upon receipt. This quantity may also include target inventory or forecast demand if these options were specified on the Function Select screen. Target inventory records will not, however, reduce the quantity in the projected inventory column like other requirements, because they are a time-phased restatement of the existing demand.
AVAILABLE QUANTITY (DISTRIBUTION WAREHOUSE)
Display only. This figure represents the inventory that is considered available for distribution resulting from the transaction.
AVAILABLE QUANTITY - MANUFACTURING
Display only. This figure represents the inventory that is considered to be available for planning for manufacturing. It includes On Hand Quantity - Manufacturing, but also includes inventory that is not immediately available. This additional inventory may be stock that has been received but must be inspected or quarantined before it can be used. Manufacturing, Purchase, and Transfer Order Receipts are included in this balance. This quantity may also include target inventory or forecast demand if these options were specified on the Function Select screen. Target inventory records will not, however, reduce the quantity in the projected inventory column like other requirements, because they are a time-phased restatement of the existing demand.
OPERATION LEADTIME DAYS
Display only. The number of days required to complete the operation. This field is displayed only if the company/warehouse fields were left blank on the Function Select screen.
SHORTAGE
Display only. This code indicates whether or not a shortage position has been detected for the part. Different codes indicate the severity of the shortage:
H - On Hand Shortage. The inventory currently on hand is insufficient to meet the requirement.
T - Manufacturing Available Shortage. The sum of the inventory on hand and available for planning is not sufficient to meet the requirement.
O - On Order Shortage. The sum of the on hand, available and projected receipts to that date is insufficient to meet the requirement.
YIELD FACTOR
Display only. This is the amount of the order you expect to lose during production of the item. This field is displayed only if the company/warehouse fields were left blank on the Function Select screen.
COMMAND KEYS
F2 - Display a window where a fast path option or mnemonic can be entered. Fast path allows the next menu selection to be made directly from this screen. When the window is displayed, pressing F3 will remove it.
F3 - Exit program and return to menu. If this screen was accessed from another conversation, pressing F3 will return you to that original conversation.
F7 - Enter the M.O. Status Inquiry Detail or Summary screen depending on whether a specific manufacturing order was selected or the user-entered part number was carried along in the Fast Path part field, respectively.
F8 - Transfer to the Order Shortage Inquiry and display the detail screen for the selected order.
F9 - Display the Requirements Review Select screen (if Requirements Planning is installed), defaulting the part number entered by the user on the Function Select screen if no record was selected, or defaulting the part number associated with the order number selected from the detail line.
F12 - Enter the Inventory Stock Status detail screen for either the part associated with a selected order number, or for the part whose availability is currently being reviewed, if no specific order was selected.
F13 - Enter the Warehouse Stock Status detail screen for either the part associated with a selected order number, or for the part whose availability is currently being reviewed, if no specific order was selected. This inquiry displays inventory balances across warehouses within plants.
|