Stock > Inquiries > Stock > Available stock 

Use this function to project the available stock and the stock available to promise, for a given product or site, and for a period in days, weeks or months, from a reference date.

    Prerequisites

    SEEREFERTTO Refer to documentation Implementation

    Screen management

    This inquiry contains:

    • A header to enter your selection criteria.
    • A section displaying:
      • The current stock and the stock situation details at the time of the inquiry.
      • The available stock on the entered reference date.

    Header

    Presentation

    Use the header information to define the site and the product for which you want to display the available stock.

    You can also define:

    • A reference date, when calculations start.
    • A periodicity, that is the period covered: in days, weeks or months.


    Close

     

    Fields

    The following fields are present on this tab :

    Block number 1

    Enter or select the storage site where the selected product is active.

    The Selection icon (magnifying glass) only suggests products that are referenced in the products-sites table.

    Enter the reference of the product for which the stock needs to be inquired.

     

    • Reference date (field REFPER)

    Enter the reference date used for calculating the expiration date of a lot in stock. This field displays today’s day by default. The availability of this field depends on the expiration management mode set on the product record.

    Block number 2

    • Periodicity (field PERCOD)

    Periodicity of the inquiry:

    • Days
    • Weeks
    • Months

    Close

     

    Tab Available stock

    Presentation

    Two sets of information are displayed in this section:

    • The current stock when launching the inquiry (not considering the entered reference date). Information related to the current stock is split into two blocks:
      • Current stock: includes the physical stock, stock pending putaway, stock on loan and subcontractor stock.
      • Detail stock situation: stock per status (or situation).
    • The Available stock on the entered reference date. The available stock is displayed according to the periodicity and entered selection criteria. Requirements are displayed in red (they include SOF firm customer orders and MWP planned material requirements). Resources are displayed in black (they include POF firm purchase orders and WOF work orders). Positive and negative signs are not displayed.
      • The Available stock does not include future requirements to come.
      • The Stock available to promise corresponds to the smallest stock quantity available for the relevant period. You can use these results to determine if you can make a commitment to a customer for a specific period. When a product has an expiration date, you can choose to consider the expiration date and the use-by date (UBD) to determine the stock available to promise by clicking Criteria in the action panel.
      • The Coverage displays the number of periods before the stock runs out.

    Close

     

    Fields

    The following fields are present on this tab :

    Current stock

    • Total internal stock (field PHYSTO1)

     

    • Total stock pending put-away (field PLFSTO1)

     

    • Total loan stock (field BPRSTO1)

     

    • Total subcontract stock (field SCOSTO1)

     

    • Total stock (field TOTSTO1)

     

    • BP stock (field SCCLNDSTO)

     

    Block number 2

    • Total internal alloc. (field ALLSTO1)

     

    • Demand horizon (field FOHENDDAT)

     

    • Firm horizon (field PLHENDDAT)

     

    • First availability (field FIRAVADAT)

     

    Grid Detail stock situation

    • Description (field INTFLD)

     

    • Value (field VALFLD)

     

    Grid Available stock

    • Description (field COL000)

     

    • field COL001

     

    • field COL002

     

    • field COL003

     

    • field COL004

     

    • field COL005

     

    • field COL006

     

    • field COL007

     

    • field COL008

     

    • field COL009

     

    • field COL010

     

    • field COL011

     

    • field COL012

     

    • field COL013

     

    • field COL014

     

    • field COL015

     

    • field COL016

     

    • field COL017

     

    • field COL018

     

    • field COL019

     

    • field COL020

     

    • field COL021

     

    • field COL022

     

    • field COL023

     

    • field COL024

     

    • field COL025

     

    • field COL026

     

    Close

     

    Action icon

    WIP

    Click WIP from the Actions icon to display the orders included in the totals for the selected line.

     

    Close

     

    Specific actions

    The following fields are included on the window opened through this button :

    Selection

    • Active memo (field MEMO)

     

    Order type

    • field SO

     

    • Firm (field SOFFLG)

    Specify if the WIP order type must be taken into account in the calculation.

    • Planned (field SOPFLG)

     

    • Suggested (field SOSFLG)

     

    • Back-to-back order (field CTMFLGS)

     

    • field PO

     

    • Firm (field POFFLG)

    Specify if the WIP order type must be taken into account in the calculation.

    • Planned (field POPFLG)

     

    • Suggested (field POSFLG)

     

    • Back-to-back order (field CTMFLGP)

     

    • field MS

     

    • Firm (field MSFFLG)

    Specify if the WIP order type must be taken into account in the calculation.

    • Planned (field MSPFLG)

     

    • Suggested (field MSSFLG)

     

    • field WO

     

    • Firm (field WOFFLG)

    Specify if the WIP order type must be taken into account in the calculation.

    • Planned (field WOPFLG)

     

    • Suggested (field WOSFLG)

     

    • Back-to-back order (field CTMFLGW)

     

    • field MW

     

    • Firm (field MWFFLG)

    Specify if the WIP order type must be taken into account in the calculation.

    • Planned (field MWPFLG)

     

    • Suggested (field MWSFLG)

     

    • field TR

     

    • Firm (field TRFFLG)

    Specify if the WIP order type must be taken into account in the calculation.

    • Planned (field TRPFLG)

     

    • Suggested (field TRSFLG)

     

    • field TP

     

    • Firm (field TPFFLG)

    Specify if the WIP order type must be taken into account in the calculation.

    • Planned (field TPPFLG)

     

    • Suggested (field TPSFLG)

     

    • field BW

     

    • Firm (field BWFFLG)

    Specify if the WIP order type must be taken into account in the calculation.

    • Planned (field BWPFLG)

     

    • Suggested (field BWSFLG)

     

    • field EO

     

    • Firm (field EOFFLG)

    Specify if the WIP order type must be taken into account in the calculation.

    • Planned (field EOPFLG)

     

    • Suggested (field EOSFLG)

     

    • Back-to-back order (field CTMFLGSC)

     

    • field MT

     

    • Firm (field MTFFLG)

     

    • Planned (field MTPFLG)

     

    • field CR

     

    • Firm (field CRFFLG)

    Specify if the WIP order type must be taken into account in the calculation.

    Starting stock deductions

    • Detailed allocations (field ALLSTOFLG)

    Tick so that the detailed allocated stock will be subtracted from the starting stock.

    • Global allocations (field RERSTOFLG)

    Check so that the detailed allocated stock will be deducted from the starting stock

    • Pending issues (field WAISTOFLG)

    Select this check box so that the pending issues are not deducted from the starting stock.

    • Subcontract stock (field SCOSTOFLG)

    Check so that the detailed stock will be deducted from the starting stock

    • BP stock (field SCCSTOFLG)

     

    Add initial stock

    • Quality control stock (field CTLSTOFLG)

    Choose.

    If the stock under control must not be included in the start stock.

    If the stock under control must be thoroughly included to the start stock.

    If the stock under control must be included to the available stock at control end date.

    • Add QC leadtime (field LTIFLG)

    Tick if the quality control lead-time must be added to the end dates for the resources (POP POF WOP WOF).

    (By taking into account the quality control code for the purchased products).

    • In-transit stock (field TRFSTOFLG)

    Select this check box if stock in transit must be added to the starting stock.

    Block number 7

    • Apply shrinkage % (field SHRFLG)

    Check this box if the remaining quantities of current WOs must

    be reduced in the percentage of product-site loss.

    • Ignore previous lost sales (field SOSCOD)

    tick to ignore the sales provisions where the date precedes the current date.

    • Expiration considered (field EXYFLG)

     

    Suggestion filter

    • field MRPFLG

    This flag is used to filter the suggestions based on their origin.

    Periodicity

    • Periodicity (field PERCOD)

    Periodicity of the inquiry:

    • Days
    • Weeks
    • Months

    Display

    Display criteria:

    - A screen code (optional) that makes reference to the set up inquiry screens. Notably these screens define the columns to be displayed in the inquiry grid.

    All these criteria can be saved by the user under a code XXX by clicking on the "Memo" button. To re-display criteria saved under memo code YYY, click on button "Call" and enter YYY.

    The criteria saved under the memo code STD will be pre-loaded when the user enters the function.

    Close

    Click the Criteria action to access additional selection criteria:

    Order type
    Select the check boxes corresponding to the order types to consider in the projected stock calculations.

    Suggestion filters
    Select the suggestions to display in the projected stock calculations: MRP and/or MPS. By default, all suggestions are displayed.

    You can control the starting stock levels by defining which stock is to be considered in the projected stock calculations. For example, you can exclude detailed allocations from the starting stock. Conversely, you can add stock in quality control and in transit to the starting stock.

    You can also control the calculations by defining if product-site loss percentages and sales forecasts should be included.

    Expiration considered
    When the expiration date is managed for a product, specify if you consider it:

    • 'No': the expiration date is not considered. This is the default value.
    • 'Yes': the Expiration date is considered according to the entered reference date and the selected periodicity.
    • 'Yes with margin': the Use-by date (UBD) is considered according to the entered reference date and the selected periodicity.

    Example

    The 'Bread' product is managed in lots.

    Reference date: July 8
    Periodicity: Week

    On July 8, the stock quantity is 22 units.

    - Lot A: 12 units
    - Lot B: 10 units

    Expiration date of lot A: June 27
    Expiration date of lot B: July 11

    Use-by date (expiration warning range): 0.5 coefficient for a 10-day use-by period, that is 10 * 0.5 = 5 days before the expiration date

    Use-by date of lot A: June 22
    Use-by date of lot B: July 6


    If Expiration considered is set to 'No':

    July 8

    July 8++

    July 15++

    Available

    22

    22

    22

    Available to promise

    22

    22

    22


    If Expiration considered is set to 'Yes':

    July 8

    July 8++

    July 15++

    Available

    10


    Available to promise

    10



    If Expiration considered is set to 'Yes with margin':

    July 8

    July 8++

    July 15++

    Available

    0

    Available to promise

    0



    You can save one or several sets of criteria by saving Memo codes.
    To recall these codes, click Recall. To delete these codes, click Delete memo.

    Menu actions

    Click the WIP action to display the work in progress for the selected product and site.

    Click the Graph action to display a Graph of available or available to promise requirements and resources by period.

    Local menus

    The only error messages are the generic ones.

    Tables used

    SEEREFERTTO Refer to documentation Implementation