AR Opening balance query - Customer Site Wise( Aging Report)

Hello Friends ,

Hope everyone is safe and healthy .

I have an urgent requirement of to extract opening balance by  customer location . Now , I have a query that gives me accurate results customer wise ( when I pass customer_id)  . My query total matches with aging - 7 bucket Report Total . But if I pass customer_site_use_id to that query then location wise , output doesnt match with aging report .

For eg - total balance as on 31 dec 2018 for Customer X is 50, 000. Aging Report says location wise - 15 , 10 , 25 . and my report says 12 , 18 , 20  but total matches in both cases .

Below is the query for your reference :