Amount Settled in AP Payment

[PrisWine]

Hi,
I'm new to ACCPAC 5.5 version , just want to know how to find the Amount settled figure for a specific Invoice? , because in order to get the a report in crystal report I was trying to connect APIBH and APPYM tables together and found out only Supplier id is only link but that is not enough i.e. (APIBH.IDVEND = APPYM.IDVEND)
so the next question is how to conncet APIBH (Invoice Batch) and APPYM (Invoice Payment)

 

[Jay Converse]

APOBL.AMTDUEHC

 

[Jay Converse]

and APOBP

 

[PrisWine]

thanks , i'll try and see .... My SQL query was incomplete up to this time ... now there is some hope