Incoming payment Query Help

Due Date

Invoice amount

Receipt Number

Payment Date

Paid amount.

For all Receipt I tried to link Invoice. RCT2 ORCT and OITR and ITR1 table to get all invoices and receipt including reconciled one. but my query is not linking reconciled invoices

Please help me to fix this issue.