web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Sales Tax State, count...
Microsoft Dynamics AX (Archived)

Sales Tax State, county , city, zip code

(0) ShareShare
ReportReport
Posted on by Samkh 6

Hi,

We need to define a separate tax code by State, county , city, zip code. Tax rates can be different at the city level (by State, county , city).

 As well we need to generate a report every month where it shows tax code, State, county , city, zip code, taxable amount.

So far it seems that the only way is to define one tax group for every Tax code , which can turn to be around 45k records of each. Did anyone had another way to minimize the number of records?

Thanks

*This post is locked for comments

I have the same question (0)
  • Andrew Xu Profile Picture
    Andrew Xu 3,877 on at

    Not every city/county has its own tax. For those cities, you don't have to create records for all of them, insteadly you can just let them share the same tax group. So simply speaking, only need to make sure the data covers all of the possibilities, and use that primary key as a foreign key in your city table.

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Sam,

    If you have to maintain a lot of tax codes allover the US it might be smart looking at a third party integration that can handle the setup and maintenance of those codes for you.

    Best regards,

    Ludwig

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Andrew Jones a1x Profile Picture

Andrew Jones a1x 2

#3
GL-01081504-0 Profile Picture

GL-01081504-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans