R4 Patch Back CLONE - Inventory Activity Report, Actual usage is not calculating correctly

Description

IAR is not calculating correctly

Environment : PROD 
Store : All Stores, example 01014, 01942

Results :

Calculating the IAR totals Begin Inventory + Purchases + Transfer In - Transfer Out - Ending Inventory = Actual Usage does not add up for the majority of items 

Examples are Macaroni & Cheese, Icedream Mix, Oil Canloa, Potato Waffle Fries, Chicken Filets

Expected : For the IAR totals Begin Inventory + Purchases + Transfer In - Transfer Out - Ending Inventory = Actual Usage to calculate correctly for all items

 There are no negative purchase amounts in the given time period

SELECT *
FROM tbtransactionreceivelog WITH (NOLOCK)
WHERE itransaction_num in (5072801,5069045,5074950,5078600,5078592,5078588,5078524,5078520,5078517,5078512,5078496,5065276,5066871,5061692,5057699,5063095,5054009,5060353,5049802,5051830,5046234,5042340,5046264,5038704,5040561,5034919,5044927,5044917,5044914,5037035,5031137,5026559,5029090,5025444,5029179,5029173,5029165,5019305,5020999,5008656,5015564,5011992,5017662,5019021,5015042,5004438,5006333,5000604,5009897,5009891,4996981,4998370,4993444,4989101,4998585,4998583,4995783)
AND PurchaseAmt < 0

I have also verified that the purchase totals are correct in the following example this is for Macaroni & Cheese

SELECT SUM(fShipped_qty) AS 'Macaroni & Cheese'
FROM tbTransactionSupplyOrderDetail WITH (NOLOCK)
WHERE iTransaction_num IN
(
SELECT iTransaction_num
FROM tbTransactionSupplyOrder WITH (NOLOCK)
WHERE EntityID = 582
AND iReceived_dt BETWEEN '2021-11-01 15:10:00' AND '2021-11-23 15:35:00'
)
AND ItemID IN (3528)

What is causing the IAR to not calculate correctly?