We have identified examples where orders were fully shipped in WMS but only partially reported to M3. As part of the analysis, the team is looking for a report or query that can compare:
- WMS shipped quantity
- M3 delivery quantity
- Delivery number
- Delivery line
- Item
and identify mismatches between the systems.
Before we build something new, do we already have an existing report, Data Lake dataset, Data Fabric flow, Birst report, SQL query, or reconciliation tool that performs this comparison?
The ideal output would allow us to review historical shipments and quickly identify exceptions where WMS and M3 quantities do not match.
If something similar already exists, can you point me to the report, owner, or documentation?
