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