Hi everyone,
I'm extending query called TaxTrans, to added one more field ->
This query is being used in a DP class "TaxTransDP", some screenshot is like this :
in processReport method:
May I know is there something need to do right after adding that 1 field in the query, Build+Synchronize ?
Since when I debug this, I can see the query is not with the additional field (TaxBaseAmount) ->
{Query TaxTrans object 470176b0: SELECT Source, SourceCurrencyCode, TaxCode, TransDate, Voucher, SUM(TaxAmount), SUM(SourceRegulateAmountCur), SUM(TaxInCostPriceMST) FROM TaxTrans(TaxTrans) GROUP BY TaxTrans.Source, TaxTrans.SourceCurrencyCode, TaxTrans.TaxCode, TaxTrans.TransDate, TaxTrans_W.VatDueDate_W, TaxTrans.Voucher ORDER BY TaxTrans.Voucher ASC, TaxTrans.TransDate ASC, TaxTrans_W.VatDueDate_W ASC, TaxTrans.SourceCurrencyCode ASC, TaxTrans.TaxCode ASC WHERE ((TransDate = {ts '2023-07-31 00:00:00.000'})) OUTER JOIN VatDueDate_W FROM TaxTrans_W(TaxTrans_W_1) ON TaxTrans.RecId = TaxTrans_W.TaxTrans}
This is why when I display this in my DP class extension, this field TaxTrans.TaxBaseAmount always zero.
May I know how to get this amount ?
Thanks
