I want to extract the Invocation Legal Number data to display in the Cash Receipt Edit List report. The standard only has the Cash Legal Number.
I’ve already created a relationship in RDD, but when I display it in the report, it looks like the image. Where do I need to edit it?
="SELECT T1.CheckRef,T1.OrderNum,T1.TranAmt,T1.DocTranAmt,T1.Rpt1TranAmt,T1.Rpt2TranAmt,T1.Rpt3TranAmt,T1.TranDate,T1.TranType,T1.HeadNum,T1.UnAppliedAmt,T1.DocUnAppliedAmt,T1.Rpt1UnAppliedAmt,T1.Rpt2UnAppliedAmt,T1.Rpt3UnAppliedAmt,T1.CurrencyCode,T1.ExchangeRate,T1.BankAcctID_BankName,T1.Calc_CustName,T1.Reference,T1.LegalNumber CashHead_LegalNumber,T1.Calc_CashDtlCounter,T1.Calc_Rpt1BookExRate,T1.Calc_Rpt2BookExRate,T1.Calc_Rpt3BookExRate,T1.Calc_DocDecimalsGeneral,T2.InvNum,T2.TranAmt Dtl_TranAmt,T2.DocTranAmt Dtl_DocTranAmt,T2.Rpt1TranAmt Dtl_Rpt1TranAmt,T2.Rpt2TranAmt Dtl_Rpt2TranAmt,T2.Rpt3TranAmt Dtl_Rpt3TranAmt,T2.Discount,T2.DocDiscount,T2.Rpt1Discount,T2.Rpt2Discount,T2.Rpt3Discount,T3.BookID,T3.Description,T3.CurrencyCode BookCurrencyCode,T3.Calc_CurrDesc,T3.Calc_DecimalsGeneral,T3.Calc_ReportCurrPos,T2.WriteOffAmount,T2.DocWriteOffAmount,T2.Rpt1WriteOffAmount,T2.Rpt2WriteOffAmount,T2.Rpt3WriteOffAmount,T4.LegalNumber CashDtl_LegalNumber
FROM CashHead_" + Parameters!TableGuid.Value + " T1
LEFT OUTER JOIN CashDtlTemp_" + Parameters!TableGuid.Value + " T2
ON T1.Company = T2.Company and T1.HeadNum = T2.HeadNum
LEFT OUTER JOIN GLBook_" + Parameters!TableGuid.Value + " T3
ON T1.Company = T3.Company LEFT OUTER JOIN CashDtl_" + Parameters!TableGuid.Value + " T4
ON T1.Company = T4.Company AND T1.GroupID = T4.GroupID AND T1.HeadNum = T4.HeadNum "
