D365 CustAccountStatementExt SSRS Customization


I have followed the documentation in order to customize the CustAccountStatement report, but when I get to the point of likinking the CustTrans table with the TempTable, I am not being able to find a strong consistent relation between them. Ex: the link is

while select tempTable{

     Select CustTrans where CustTrans.InvoiceID == tempTable.CustTrans_Invoice && CustTrans.TransDate == TempTable.transDate && CustTrans.AmountCur == Temptable.amountCur && Custtrans.txt == temTable.CustTrans_txt


(the recId of the custTrans table or any other unique value is not present in the TempTable).

Hope you got my point.

Thank you.