Item VAT Code for Sales Invoice SSRS Report in AX7

Hi,

Fetch Item VAT Code for Sales Invoice SSRS Report

Logic by joining Sales Invoice and Posted VAT by LedgerVoucher, InvoiceDate, TaxItemGroup

Below statement fetchs Item VAT Code

Include below code in SalesInvoiceDP

      TaxTrans      localTaxTrans;
       
        localTaxTrans.clear();

        select firstOnly TaxCode from localTaxTrans
            where localTaxTrans.TransDate == _custInvoiceJour.InvoiceDate
            && localTaxTrans.Voucher == _custInvoiceJour.LedgerVoucher
             && localTaxTrans.TaxItemGroup == _custInvoiceTrans.TaxItemGroup;


        _salesInvoiceTmp.ItemVatCode =  localTaxTrans.TaxCode;