Cost Rollup

This bot logs into QAD and fetches items which do not have lower level cost

Top Benefits

  • Proactively detects items which do not have lower level cost
  • Reduces cost variance Issues
  • Decreases time for cost variance reconciliation

An inventory management team creates/modifies multiple BOMs/items. This process is often cumbersome and sometimes leads to situations where standard costs for new items are not updated. This leads to cost variances which are very difficult to explain during an audit.

This bot logs into QAD and fetches raw material items which do not have lower level cost.  The proactive detection of these situations helps avoid variances.

Notes on usage:   See the ReadMe for details -

  • Provide inputs into "QAD_NoLowLevel_Input.xlsx" as the String data type
    • Username for QAD
    • Password for QAD
    • Item type (raw or purchased parts).  In case of both, separate each with a comma.
  • Configure the metabot to log into QAD by providing inputs for user ID and password

 

Get Bot

Free

Bot Security Program
Level 1
Applications
Business Process
Category
Downloads
66
Vendor
Automation Type
Bot
Last Updated
February 2, 2021
First Published
March 20, 2019
Enterprise Version
11.1
ReadMe
ReadMe
Support

See the Bot in Action

PREV NEXT

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

  • Automation Anywhere Enterprise v11.1.2.0
  • MS Office
  • QAD Enterprise Edition Client
  • Inputs: QAD_NoLowLevel_Input.xlsx. See the ReadMe for more details.