D365 CustAccountStatementExt SSRS Customization

Hi,

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.

Parents
No Data
Reply Children
No Data
Related
Recommended