BW query : Physical inventory coverage rate 

 

To get BW installed : Business warehouse

 

 

 

 

Why the coverage rate is lower than expected ?

 

 The physical inventory is not finished

 

There are 7 steps in a physical inventory in MM when there is no variance and 10 spteps when a recount is needed

Physical inventory creation

MI31 
Inventory count from printingMI21 
Physical stock calculationOut of RCS 

Inventory count entry

MI04counted
Inventory count differences printingMI20 
Inventory count differences validationMI07validated

Results display

MB03 
Inventory recount if neededMI11 
Inventory recount entryMI04counted
Inventory recount differences validationMI07validated

A physical inventory is taken into account in the BW query when the status is validated (step 6 & 10)

 

 There is no more quantity of some materials that were in the inventory at last year end 

 

The reference used by the calculation of the coverage rate is the inventory at the end of the previous year.

It is recommended to count all inventories even if the quantity is equal to zero and follow this procedure :

  • Create the inventory document with MI13 and select "only materials with zero stock". If necessary you can change in the control section to the relevant "MA. no. items/doc"
  • In MI04 (inventory count) click on "set zero count" ==> All item ZC box will be checked
  • Validate with MI07
  • Create a new inventory document with MI31 and select materials "only materials w/o zero stock" and complete the procedure

 

 

 Inventory flag is updated in BW on saturday

 

The query reports the coverage rate as of last friday night.

 

Either you run the query as previously explained or you can receive automatically a monthly broadcast.

 

Template of the broadcast

 

Attach physical inventory report in the Excel template

 

 

  1. Choose "insert"
  2. Click on the "object" button
  3. This window will open
  4. Select "Create from file"
  5. Add you file by clicking on "Browse"
  6. Select "Display as icon"
  7. Select OK

 

E mail of validation from GCCO

 

  • By september coverage rate in value is above 80% of prior yeat-end value for the FI, and above 90% for other type of material knowing that each reference is counted every 3 years for manufacturing supplies and every year for all other types of materials.

  • In case of exceptions to the rules defining the physical coverage rate for year end, the FRA publishes last quarter physical inventory planning and require GCCO validation.

  • The validation mail is posted in the Electronic Control Evidence Depository 

 

 

SBS dashboard - Coverage rate indocator

 

Inventory coverage rates are followed using this indicator in SBS dashboard