Physical Inventory Update For QAD

Thirdware bot automates the physical inventory update process in QAD through Automation Anywhere.

Top Benefits

  • Enhances the total number of transactions
  • Minimizes error in validating unposted transactions thereby producing optimum results
  • Reduces the time consumption in processing and eliminates monotonous manual activities
  • Avoids massive manual work which can be productively utilised for other critical activities
  • Accurate decisions can be made out of the comprehensive reports generated and delivers realtime information to the users


  • Login into QAD
  • Creates CIM file for bulk data update and loads it into QAD
  • Freezes/unfreezes the inventory balances as per requirements
  • Generates reports of processed data with errors and unprocessed data
  • Updates the inventory balance post processing the data

Physical inventory is a process of determining that the inventory quantities are exact, or if there are differences in quantity mentioned physically present and that mentioned in the system. Basically, after the user is finished with physical inventory, the system and physical stock levels must be the same. It is a time consuming and laborious activity.
Thirdware bot automates this process in QAD through Automation Anywhere.

Start 30-Day Free Trial

$2000 USD per bot
Annual Subscription

Request quote for more purchase options

Bot Security Program
Level 3
Business Process
Automation Type
Last Updated
December 3, 2020
First Published
January 7, 2020
Enterprise Version

See the Bot in Action

TaskFile Snapshot - 1
TaskFile Snapshot - 2
TaskFile Snapshot - 3
TaskFile Snapshot - 1
TaskFile Snapshot - 2
TaskFile Snapshot - 3

Setup Process


Download the Bot and follow the instructions to install it in your AAE Control Room.


Open the Bot to configure your username and other settings the Bot will need (see the Installation Guide or ReadMe for details.)


That's it - now the Bot is ready to get going!

Requirements and Inputs

  • QAD Enterprise Applications EE
  • Microsoft Excel 2010 or above
  • Credential Variables to be created
  • ConfigFile.xlsx: Defines QAD Application Path, Email addresses for Notifications, QAD specifications and menu details
  • MasterInputFile.xlsx: Defines the input data to be loaded into QAD for execution of Bots
  • Cim200.xla: An add-in file, required for converting master input file into CIM file that can be loaded into QAD