web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... How to get the sales t...

Finance | Project Operations, Human Resources, ...

Suggested Answer

How to get the sales tax percentage using X++ ?

(1) Share

Report

Report

Posted on by Voltes

596

Hi guys,

Using X++, how to retrieve the tax percentage value, if I know the Tax Group and Item Tax Group ?

Thanks,

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Martin Dráb 237,878 Most Valuable Professional on at

Like (0)

Report

Tax::calcTaxAmount() is likely what you need.

Was this reply helpful? Yes No
Voltes 596 on at

Like (0)

Report

Hi Martin,

I've been trying with this class, however this class doesn't support Price include sales tax scheme (unless I'm incorrectly use it). Which now I calculate it with my own function which that is why I need to retrieved the percentage value.

This is my function though:

private TaxValue getTaxPercent(TaxGroup _taxGroup, TaxItemGroup _taxItemGroup)
    {
        TaxGroupData    taxGroupData ;
        TaxOnItem       taxOnItem;
        TaxData         taxData;

        select firstonly TaxCode from taxGroupData
        index hint TaxGroupIdx
            where taxGroupData.TaxGroup == _taxGroup
            join taxOnItem
            where taxOnItem.TaxItemGroup == _taxItemGroup &&
                    taxOnItem.TaxCode == taxGroupData.TaxCode;

        select firstonly TaxValue from taxData where taxData.TaxCode == taxGroupData.TaxCode
            && taxData.TaxFromDate <= systemDateGet() && taxData.TaxToDate >= systemDateGet() ;
        return taxData.TaxValue;

    }

By this then I calculate my Tax amount with consideration of Price include sales tax (Yes or No).

This post is related to this -> https://community.dynamics.com/forums/thread/details/?threadid=18148da0-141f-ee11-9cbe-000d3a4fe8f7

Thanks,

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Martin Dráb 646 Most Valuable Professional

#2

André Arnaud de Cal... 529 Super User 2025 Season 2

#3

Sohaib Cheema 285 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans