Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :

Get sales line tax percent to calculate GST / TAX on sales line in D365 F&O

Jayaprakash Reddy Profile Picture Jayaprakash Reddy 270

private Percent calcSalesLineTaxPercent(Salesline  _salesline)

{

    TaxOnItem       taxOnItem;

    TaxGroupData    taxGroupData;

    TaxValue        taxValue;

    if(_salesline.TaxItemGroup && _salesline.TaxGroup && _salesline.LineAmount != 0)

    {

       select firstonly TaxOnItem

            where TaxOnItem.TaxItemGroup == _salesline.TaxItemGroup

           join TaxGroupData

                    where TaxGroupData.TaxGroup == _salesline.TaxGroup

                    && TaxGroupData.TaxCode     == TaxOnItem.TaxCode;

        if(TaxGroupData)

        {

            TaxValue  =  TaxData::find(TaxOnItem.TaxCode, DateTimeUtil::getSystemDate(DateTimeUtil::getUserPreferredTimeZone()), 0).TaxValue;

        }

    }

    return TaxValue;

}



This was originally posted here.

Comments

*This post is locked for comments

Liquid error: parsing "/globalsearch/?q=site%3Aca.linkedin.com%2Fin%2F++++-%22compliance%22+-%22+manager%22+-%22+risk%22+-%22governance%22+-%22ethics%22" - Nested quantifier +.