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 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.
$2000 USD per bot
Annual Subscription
- Bot Security Program
-
Level 3
- Applications
-
- Business Process
- Finance & AccountingInventory Management
- Category
- Banking and Financial ServicesProductivity
- Vendor
- Automation Type
- Bot
- Last Updated
- December 3, 2020
- First Published
- January 7, 2020
- Platform
- 11.3.3
- ReadMe
- ReadMe
- Support
-
- Thirdware Solution
- +12486798771
- rpasupport@thirdware.com
- Bot Store FAQs
See the Bot in Action
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