Dynamics Community Forum Thread Details

Electronic reporting - record list filter

Hi everyone,

I’m working on electronic reporting for invoices in XML, and I have a problem with filtering in a CodeTax record list.

The CodeTax list contains fields TaxCd and TaxV, which point to TaxCode and the showTaxValue() method. This list is inside the invoice line (LigneClient).

Here is my CodeTax reference:

@.'>Relations'.TaxItemGroup.'<Relations'.TaxOnItem

For TaxCd, I’m using:

if(@.TaxCode = "TVA19", "TVA19",
if(@.TaxCode = "TVA19-TPE", "TVA19",
if(@.TaxCode = "ECOFILTER", "ECOFILTER",
if(@.TaxCode = "TPE", "TPE", ""))))

And for TaxV:

IF(@.TaxCode = "TVA19", 19.0,
IF(@.TaxCode = "TPE", @.'showTaxValue()',
IF(@.TaxCode = "ECOFILTRE", @.'showTaxValue()',
IF(@.TaxCode = "TVA19-TPE", 19.0, 0.0))))

The issue is that when I try to filter specific taxes, the other taxes remain in the list, but their TaxCd is empty and TaxV is 0. I want these other taxes to not exist at all in the filtered list instead of showing empty or 0 values.

How can I achieve this?

Thanks in advance!