Available stock

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.

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

Screen code (field ECRAN)

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.