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

Tasks

  • Login into QAD
  • Creates CIM file for bulk data upate 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
Applications
Business Process
Category
Vendor
Automation Type
Bot
Last Updated
July 24, 2020
First Published
January 7, 2020
Enterprise Version
11.3.3
ReadMe
ReadMe
Support

See the Bot in Action

TaskFile Snapshot - 1
TaskFile Snapshot - 2
TaskFile Snapshot - 3
PREV NEXT
TaskFile Snapshot - 1
TaskFile Snapshot - 2
TaskFile Snapshot - 3

Setup Process

Install

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

Configure

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

Run

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