The file is composed by four tabs. 

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

STEP 1

I open a SAP transaction MB51.

Fill in the:

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

 

 

 

STEP 2

  1. Select the detail list by clicking on 

 

 

 

STEP 3

Being in the detail list

  1. Select the correct layout
    1a. Settings
    1b. Layout
    1c. Choose
  2. Select the following layout: /IAC 03.07
  3. Validate by clicking on 

 

 

STEP 4

Save to excel


  1. Go to 
    1a. List 
    1b. Export 
    1c. Spreadsheet
  2. Select from all Available formats: 10Excel (in office 2007 xslx format)
  3. Confirm the location of the extraction in your PC
  4. Name the file
  5. Validate

 

 

 

STEP 5

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 Step 4

 

 

STEP 6

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

  • No labels