If you run both ConnectWise and e-automate, keeping inventory records consistent between the two systems is a constant challenge. Discrepancies between what ConnectWise shows and what e-automate holds can create financial exposure, disrupt billing, and leave stock invisible to your EA system entirely.
ID452is a Power BI report that reconciles ConnectWise on-hand inventory against e-automate warehouse records at the item level. It gives inventory managers, IT asset coordinators, and finance teams a single dashboard that shows overall sync health, the financial value of discrepancies, where gaps are concentrated by item category, and which ConnectWise items have no matching record in e-automate at all.
Please note: ID452 requires a subscription to ID747 (ConnectWise Customer Module), as this is where the ConnectWise inventory data is sourced from. If ID747 is not running, there will be no data to populate your Power BI report.
We are actively looking for testers for this process - please get in touch if you can help!
When downloading template for first time (not subsequent updates/revisions), please allow up to 30 minutes before attempting to refresh to allow our background tables to populate.
You must be subscribed to ID747 for this report to install and run as we push needed support tables.
0 Comments