Understated purchase Qty in DSB causing the IAR report to be inaccurate

-The IAR is displaying negative variances due to understated purchases qty

-IAR Report criteria 9/11/2022 5:20 PM to 9/18/2022 1:14 PM , Restaurant # 04143

-Many items are affected, example below 

Potato, Waffle Fries IAR states they purchased 100 - Receive Detail shows they purchased 145.

Select EntityID,ItemID, sDescription, SUM(fOrdered_qty) as Total_Ordered_Qty, SUM(fShipped_qty) as Total_Shipped_Qty, SUM(OriginalReceivedQty) as Total_Received_Qty ,SUM(fReturned_qty) AS Total_Returned_QtySelect EntityID,ItemID, sDescription, SUM(fOrdered_qty) as Total_Ordered_Qty, SUM(fShipped_qty) as Total_Shipped_Qty, SUM(OriginalReceivedQty) as Total_Received_Qty ,SUM(fReturned_qty) AS Total_Returned_Qtyfrom tbTransactionSupplyOrderDetail with (nolock) where ItemID = 883 and EntityID =  5247and iTransaction_num in (select iTransaction_num from tbTransactionSupplyOrder with (nolock) where EntityID =   5247 and iApply_dt between '2022-09-11 17:20:00.000' and '2022-09-18 13:14:00.000'      )Group by  EntityID,ItemID, sDescription 

In the tbTransactionReceiveLog the purchase qty for that period is 145 as well

Select * from tbTransactionReceiveLog with ( nolock) where EntityID = 5247 and ItemID = 883 and applyDate between '2022-09-11 17:20:00.000' and '2022-09-18 13:14:00.000' order by 1

in Daily stock balance table, I don't see purchases for 09/12 or 09/12 

Select * from tbDailyStockBalance where EntityID = 5247 and ItemID = 883 and BusinessDay between '2022-09-11' and '2022-09-18'