SAP РEasy MRP and coordinating 

Check out our SAP MRP tool, it combines material requirements for upcoming process orders (COOISPI / IW33) with the current stock on hand in multiple SLOCS (MB52).

The data is extracted and combined for easy viewing with one click of your mouse. You can easily see shortages, or plan material movements between storage locations in time for your production or planned work.


SAP stocktaking process

Here is the SAP stocktaking process using the AVB – Import SAP Stocktake Excel program.

The first step is to create a PID (physical inventory document) in SAP.  There are a few ways to do this, below shows the method using transaction MI31.  Enter the materials you wish to count, the SLOC, and whether you want Unrestricted Stock only etc.

MI31 Setup a count

When you have made your selections, press the execute button to proceed.  Highlight all the lines you want to count and press the ‘Create Documents Directly’ button, they should all turn green and the ‘PhysInvDoc’ column will populate with the PID number.  Take note of this number, or press CTRL+Y and highlight the number, then press CTRL+C to copy it into your memory.

2 - MI31 Create a count

Open the AVB – Import SAP Stocktake Excel spreadsheet.  Right-Click anywhere in the PID tab and click on ‘Download PID’.

3 - Right-Click in PID tab

The sheet will clear itself of any existing data, and present the following pop-up box:

3 - Enter SAP PID number

Enter the PID number into the pop-up box, and press ok.  The PID details will now be imported into the spreadsheet (the below example has its data blurred out).

4 - Print the count sheet and perform the inventory count

You can now treat the document as a regular spreadsheet, the print margins will be setup automatically as well as a formula to calculate the difference qty.  You can apply filters to sort by the storage bin, or any other way you wish.

5 - Apply a filter

Print the sheet, and perform the count of the materials.  When you have the sheet back, enter the results into the ‘Counted Qty’ column, noting the running totals in column L and adding comments as you go.

6 - Enter the count results

When you are satisfied with the count, right click anywhere in the PID tab and click ‘Upload PID’

7 - Right-Click in PID tab

The counted qty will now be uploaded to SAP.

8 - Count is uploaded

Go to transaction MI20 and post the count.

9 - MI20 check and post the results

10 - post

The count is then complete, with the posted differences the same.

SAP MIGO move to delivery note field after entering purchase order

This is a free app that uses SAP scripting to move from the purchase order field straight to the delivery note field after pressing enter in MIGO.

This is very handy for speeding up goods receipts and also doubles as a check to see if your system can run AVB’s other SAP scripting tools.

Download now, remember to comment with your feedback.

SAP stocktake Demo

Here is the demo version of the AVB Sap stocktake tool.

With it you can download a PID into excel, so use it to check you have the settings required to run the full version before purchasing it.

AVB SAP Import Stocktake DEMO

You may have to reopen the file if you get the below message come up after opening it for the first time:


Click on ‘Enable Editing’, close the file and then re-open it.  This is due to an event that happens on the opening of the workbook, which sets up the menu command for the program.

You also need to enable scripting in SAP, details are here.

Simply right click on any cell and select ‘Download PID’. This will then start to draw down the details of the stocktake into the spreadsheet.

This app is for SAP MM (not WM), non-batched managed stocktakes.

For more info, check out the following link:

SAP stocktaking process

Here is the SAP stocktake procedure using the AVB upload tool.

The first step is to create your count in SAP which will give you a PID number.

There is a good guide here showing how to do this.  Scripting also needs to be turned on, here is a guide on this.

Once you have a PID number, open the spreadsheet. On the ‘Options’ tab, set you plant, slot, fiscal year, and whether you want a blind count or not.

Head back to the ‘PID’ tab and right click on a cell. Select ‘Download PID’. The details of the count you set up will be extracted into the tab.

Print the sheet, and use this as your count sheet and perform the stocktake.

Enter the result directly into the ‘Counted Qty’ column. Perform any recounts or double checks, and when you are happy with the result, right click in a cell and select ‘Upload PID’.

Cancel multiple Transfer Orders in SAP

This excel app cancels multiple TO’s in SAP WM.¬† Just paste or key in the TO numbers that you want to cancel and click ‘Cancel TO’s’.¬† This will start a script that will delete the TO’s if they are open.

System Requirements:

SAP Scripting enabled (here is a guide)

Excel 2007 or newer

Access to trannsaction LT15