You can schedule In Transit Report Snapshots to capture the report at regular Intervals.
Go to Store Settings > Inventory > Inventory Configuration > Advance > In Transit Inventort Snapshot
During setup, you can choose to receive snapshots via email, through the Export Log Report, or both.
Once generated, the snapshot preserves the report exactly as it was at that moment, even if transfer orders are received or inventory changes later.