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’.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s