Basic Information

Purpose of this query

Slow Moving and Obsolete Off-Grade KPI consists of 3 categories, which are prioritized to avoid double counting:

1st priority: OFF-GRADE

"Stock Type" of Batch is one of the following:

• Blocked Stock (C)
• Restricted use (E)

2nd priority: OBSOLETE

Batch expiration date is in the past

• For each month, last calendar day is considered (example: obsolete in July = batch expiration date compared to 31/07/2020)

3rd priority: SLOW MOVING

Slow Moving: Current Date - Batch Creation Date/Last GR > 365 days

• For Valuation Class sub-types Raw Material & Trading Goods → Batch Last GR date
• For Valuation Class sub-types Finished Product & Semi Finished → manufacturing date

• For each month, last calendar day is considered (example: Slow Moving in July = batch manufacturing date compared to 31/07/2020)

Scope

Only "main stock". "Main stock" considers Raw Materials, Finished Product, Intermediates and Trading goods.  Those are defined by list of Valuation Classes for each system (PF1 and WP1). Complete Mapping here.

Key Figures

Filters

Characteristics

Key Figures