MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Reference Library > Manufacturing > Inventory Control > Screens > Time-Phased Part Availability > IC810S02 - Detail

IC810S02 - Detail

 

 

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.