During manual reconciliation we found rows in inventoryitemlocations that don't have a matching row in netsuite db. Before opening a formal case, wanted to check if this is a known/common pattern.
- Is this expected behavior in certain scenarios (e.g., a location with zero balance, an inactive item, a timing gap between pipeline refreshes)?
- Has anyone else run into this, and what turned out to be the root cause?
Environment: NSAW premium, last full refresh: 2023