Period In-Transit Valuation amount is not matching with Trial Balance report

Summary:

We are running a standard report of "Period In-Transit Valuation Report" & Trial Balance report for the April month Period and the COSTED_INTRANSIT_AMOUNT does not match with TB ( Opening Balance-Closing Balance). We see there is a lot of variance between these two reports.

Verified all the cost distributions & receipt accounting distributions where there are no pending stuck records. Please help as we are doing the financial year-ending activity and reports need to be submitted for Auditing purposes.

TB Balance Report for the April month Period for In transit Account(Begining Bal- Ending Bal): 43,787,570.77

Period In Transit valuation for the April period (COSTED_INTRANSIT_AMOUNT): 187600970