Inventory Extension Report is not matching the monthly count values

The Inventory Extension Report value is not showing the same quantity entered on the Monthly count for June.
The Restaurant started the Monthly count at 11:07 am but didnt apply it until 10:33 pm.
There was a Spot count applied at 5:50 pm that the IER is pulling values from.
Can you confirm that the IER is using the latest Inventory Count from the last day of the month and not the Monthly count type.
Example:
Waffle Fries counted on Monthly count = 54.33
Spot Count at 5:50 pm = 35
Extension qty = 35

The Monthly count does display 35 cases counted when looking at the count details.
However the Ending Inventory Count on the IAR shows the value of 54.33 cases.

select * from tbTransactionStockCount with (nolock) where TransactionStockCountLocationID = 7608764 and itemid = 883
select * from tbTransactionStockCountLocationDetail with (nolock) where TransactionStockCountLocationID = 7608764 and itemid = 883