RMS Data integrity between ITEM_LOC_SOH and TRAN_DATA_HISTORY

I’m validating the data between ILS* and TDH** & found something which is not reconciling to my understanding.

Now, I have taken Location # 3752 as example (there are many locations, but let’s get one location as example).

1. 1. I have extracted the TDH** (including the tran_data if any) and Item Loc SOH at the Item level as 17^th June 2015 early day of the business.
2. 2. In TDH**, I have kept only those tran codes which affects the ILS* and deleted other tran codes which are not required to keep it for analysis (eg: tran code # 11, 13, 15, 25, etc).
3. 3. Then, I have added 2 columns (Column X and Y) in TDH** to convert the Units and Total Cost as per stock ledger logic (eg: Tran Code # 1, would be positive in TDH** sheet but I have converted that to negative so that ILS* would be matched).