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