The file is composed by four tabs. 

Only the tabs "base" and "pivot" have to be updated. 

I open a SAP transaction MB51.

Fill in the:

  1. Plant
  2. Movement types copy from the IAC template
  3. Period being controlled

 

 

 

  1. Select the detail list 

 

 

 

Being in the detail list

  1. Select the correct layout
  2. Layout: /IAC 03.07

 

 

Save to excel


  1. Go to list -> export - > Spreadsheet
  2. Select from all Available formats: 10Excel (in office 2007 xslx format)
  3. Confirm the location of the extraction in your PC

 

 

 

Copy data to IAC 03.07 to the template

Open the Excel template and copy paste in the “base” tab the data that you obtained in the SAP transaction as we have seen Step4

 

 

Refresh Pivot table

  1. Update the pivot table and comment if the amount is above 1 500 € 
  2. Check if inventory discrepancies are only validated by the FRA