Dynamics Community Forum Thread Details

Hi guys,

If I want to calculate my sales order tax by code, is there an existing function in F&O to calculate it with considering the Price Include Sales Tax ?

I currently using the method in Tax class -> calcTaxAmount(), which is the code is like this :

static TaxAmountCur calcTaxAmount(TaxGroup               _taxGroup,
                                             TaxItemGroup           _taxItemGroup,
                                             TransDate              _taxDate,
                                             CurrencyCode           _sourceCurrencyCode,
                                             AmountCur              _baseAmountCur,
                                             TaxModuleType          _taxModuleType,
                                             TaxBase                _baseQty          = 0,
                                             UnitOfMeasureSymbol    _baseUnit         = '',
                                             ItemId                 _itemId           = '',
                                             TaxDirection           _taxDirection     = TaxDirection::OutgoingTax,
                                             GSTHSTTaxType_CA       _gsthstTaxType_CA = GSTHSTTaxType_CA::None)
    {
        Tax             tax = Tax::construct();
        TaxAmountCur    taxAmountCur;
        ;
        taxAmountCur = tax.taxCalcWithoutSource(_taxGroup,
                                                _taxItemGroup,
                                                _taxDate,
                                                _sourceCurrencyCode,
                                                _baseAmountCur,
                                                _taxModuleType,
                                                _baseQty,
                                                _baseUnit,
                                                _itemId,
                                                _taxDirection,
                                                _gsthstTaxType_CA);

return taxAmountCur;
}

If I'm not mistaken by reading this method, it does not have parameter to know that I have a condition that the price is Include Sales Tax.

Which mean if I'm giving the parameter value of the /_baseAmountCur/ of 100, and the TaxGroup and TaxItemGroup which is set to 8%, the result value will be 8, whereby the expected should be 7.41

How to get the correct result of my tax calculation ? Is there other existing method that I can use to calculate my sales order to get the correct tax amount ?

Thanks,