Using power query to create a pick list
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.
QuickDraw is a stocktaking solution that uses Bluetooth to transfer the data from barcode scanners back to a host computer.
This avoids the stops that can occur with traditional batch scanners and software.
The method can cut an hour off a physical stocktake, costing you less in labour and allows earlier opening times on morning of the stocktake.
It is available for Windows CE devices, and Windows embedded.
QuickDraw running on a CK71 device.
QuickDraw running on a 7535 G2.
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.
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: