Skip to main content



No record found.

Dynamics 365 Community / Forums / Finance forum / Sum sales tax amount p...
Finance forum
Suggested answer

Sum sales tax amount per tax code

Posted on by 2,430

Hello Experts,

Is it possible to show one line in posted sales tax per tax code which will be the sum of all sales tax on each sales order line provided sales tax on each line is same?

Suppose, Line 1 is having item A & sales tax group is XXX and Line 2 is having item B and sales tax group is XXX. As the sales tax group is same on both the lines, there should be one line created in posted sales tax which would be the same of line 1 & line 2 sales tax amounts.

Thanks & regards,

Raziq Ali

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Sum sales tax amount per tax code

    Hello Raziq,

    With the new grid control feature you can group the tax transactions in the online form by tax code.

    You can also calculate an overall total of each column but not by group. 

    At least I have not been able to get this work. 

    An alternative is exporting the data to excel and then doing the grouping and calculations e.g. in a pivot chart.

    Best regards, 


Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .


André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

nmaenpaa Profile Picture

nmaenpaa 101,148


Featured topics

Product updates

Dynamics 365 release plans