Differences in Inventory valuation report and GL Inventory account balance

I need some advise on what may be causing variance in value between Inventory valuation report and Inventory account in GL. Our stores team (inventory) and Finance team are producing different numbers for our inventory balances and movements.

Below are the steps i have taken.

1. Taken GL balances for Inventory account and calculated movement (from jan to jul 2021).
2. Extracted Material distribution for the same period and summed-up monthly movements.
3. Movement in GL balance (1) and material Distribution (2) are aligned and equal.
4. Run Inventory valuation for all end months from Jan to Jul 2021. Calculated the monthly movements from the valuation reports.
5. The movements in (4) above do not match with any of the movements in (1) and (2).