Install
Download the Bot and follow the instructions to install it in your AAE Control Room.
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