Monday, October 2, 2023

Calculate Sales Tax amount through X++ , D365

 This code demonstrate you how you can calculate sales tax using TaxGroup , TaxItemGroup fields



    public real calculateLineTaxAmount(TaxGroup _taxGroup , TaxItemGroup _taxItemGroup , Amount _lineAmount)
    {
        real TaxAmount=0 , TaxValue = 0;
        TaxOnItem TaxOnItem;
        TaxGroupData TaxGroupData;
        TaxTable TaxTable;
        while select TaxOnItem
                    where TaxOnItem.TaxItemGroup == _taxItemGroup
        {
             if(TaxOnItem)
             {
                 TaxGroupData.clear();
                 select TaxGroupData
                 where TaxGroupData.TaxGroup == _taxGroup && TaxGroupData.TaxCode == TaxOnItem.TaxCode;
                     if(TaxGroupData)
                     {
                          TaxTable.clear();
                          select * from TaxTable
                                where TaxTable.TaxCode == TaxGroupData.TaxCode;
               
                         if(TaxTable)
                          {
                                TaxValue  = TaxData::find(TaxTable.TaxCode, Systemdateget(), 0).TaxValue;
                                TaxAmount = TaxAmount + (_lineAmount * TaxValue) / 100;
                             //  tempTable.UnitPriceInc = TaxAmount;
                          }
                    }
             }
        }
        return TaxAmount;
    } 



No comments:

Post a Comment

Change SSRS Report Design Based On Condition , D365 ,X++

 To change Sales Invoice control document's design based on condition use following code. Here I have created COC of salesInvoiceControl...