Dynamics Community Forum Thread Details

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

Categories:

Development / Customization / SDK

Quick Links

Leaderboard