IQstock

Excel-Based SAP Stocktaking tool

Simplify your next stocktake by driving the entire process via Excel

IQstock is a Microsoft Excel add-in to assist Inventory Managers with the process of updating physical inventory stocktake results back into SAP. It manages the entire process directly from within familiar Excel.

Key Functions

Retrieve Physical Inventory Documents from SAP directly into Excel in order to prepare formatted count sheets
Suitable for Inventory and Warehouse Management
From within Excel, directly update physical inventory count results back into SAP
Review stocktake variances within Excel, and Post differences directly to SAP adjusting recorded inventory balances
IQstock supports flexible count sheet templates to be maintained for specific requirements thereby simplifying count administration and processing
IQstock requires absolutely no changes to your back-end SAP system
IQstock is fully secure, using your existing SAP login credentials
IQstock is future proof, accessing only published SAP BAPIs

Benefits

Try before you buy
No implementation effort
Reduce manual effort
Improves stocktake productivity and overall duration
Improves stocktake accuracy
Facilitates the automatic processing of stock counts and variances from Excel into SAP
Eliminates manual transcription errors
Is Cost-effective
Integrates with any Portable Data Terminal

Features

Format Count Sheets from within Excel for distribution and printing incorporating standard Excel presentation capabilities
Generate flexible count labels from Excel
Capture actual count results directly into Excel by location, collate data outside of SAP and aggregate using standard Excel formulas
Use generic Portable Data Terminals to support scanning solutions, using Excel as a low-cost SAP integration mechanism
Reconcile inventory counts outside of SAP to validate the accuracy of the count results prior to processing updated results
Use Excel as the high performance and intuitive data entry mechanism

IQX Business Solutions

See Share Do