Study guide
9.3 Sales Tax Groups, Item Sales Tax Groups & Tax Exemptions
Microsoft Certified: Dynamics 365 Finance Functional Consultant Associate MB-310
Track your progress as you read
Finished sections get a check mark.
1 Chapter 1: MB-310 Exam Overview & Financial Architecture
1.1 MB-310 Exam Structure, Skills Measured & Consultant Role 1.2 Dynamics 365 Finance Architecture, Legal Entities & Global Address Book 1.3 Hands-on Lab Strategy & Preparation Framework
2 Chapter 2: Chart of Accounts & Main Accounts
2.1 Designing Chart of Accounts & Main Account Types 2.2 Main Account Categories & Ledger Account Aliases 2.3 Balance Control Accounts & Year-End Opening Account Setup 2.4 Legal Entity Overrides for Main Accounts & Dimensions
3 Chapter 3: Financial Dimensions & Account Structures
3.1 Custom & Entity-Backed Financial Dimensions 3.2 Financial Tags: Limits, Storage & Ledger Settlement Use 3.3 Account Structures, Segment Criteria & Activation 3.4 Advanced Rules & Advanced Rule Structures 3.5 Derived Dimensions & Dimension Default Templates
4 Chapter 4: Ledgers, Calendars & Currencies
4.1 Fiscal Calendars, Period Statuses & Module Access Control 4.2 Posting Layers, Multi-GAAP Reporting & the Ledger Form 4.3 Currency Exchange Types, Rate Providers & Triangulation 4.4 Accounting & Reporting Currencies (Dual-Currency Architecture) 4.5 Foreign Currency Revaluation & Revaluation Posting Profiles
5 Chapter 5: General Ledger Journals & Allocations
5.1 Journal Names & Voucher Number Sequences 5.2 Journal Control & Posting Restriction Rules 5.3 Journal Entry, the One-Voucher Rule, Validation & Posting 5.4 Reversals, Storno Corrections & Excel Integration 5.5 Ledger Allocation Rules & the Four Allocation Methods 5.6 Allocation Processing & Periodic (Recurring) Journals
6 Chapter 6: Intercompany Accounting & Settlements
6.1 Intercompany Accounting Setup & Due-To / Due-From Postings 6.2 Intercompany Journal Processing & Multi-Company Vouchers 6.3 Ledger Settlements Configuration & Processing
7 Chapter 7: Cash and Bank Management
7.1 Bank Groups, Bank Accounts & Ledger Integration 7.2 Payment Formats, Bank FX Revaluation & Shared Payment Setup 7.3 Manual vs. Advanced Bank Reconciliation & Statement Formats 7.4 Matching Rule Sets, Reconciliation Execution & Reversals 7.5 Cash Flow Forecasting Setup & Automation 7.6 Customer and Vendor Netting
8 Chapter 8: Periodic Closing & Financial Consolidations
8.1 Financial Period Close Workspace, Closing Roles & Schedules 8.2 Year-End Close Configuration & General Ledger Balance Carryforward 8.3 Consolidations Online: Legal Entity Setup, COA Mapping & Currency Translation 8.4 Import Consolidations & Intercompany Elimination Rules
9 Chapter 9: Sales Tax & Withholding Tax
9.1 Sales Tax Engine Hierarchy, Authorities & Settlement Periods 9.2 Ledger Posting Groups, Sales Tax Codes & Calculation Methods 9.3 Sales Tax Groups, Item Sales Tax Groups & Tax Exemptions 9.4 Sales Tax Adjustments and Settle and Post Sales Tax 9.5 Withholding Tax & US 1099 Vendor Reporting
10 Chapter 10: Accounts Receivable Setup & Invoicing
10.1 Customer Master, Customer Groups & Shared Customers 10.2 Customer Posting Profiles & Account Code Precedence 10.3 Free Text Invoices, Recurring Invoice Templates & AR Charges 10.4 Sales Order Invoicing, Billing Classifications & Prepayments 10.5 Customer Payment Methods, Payment Processing & Customer Bank Accounts
11 Chapter 11: Credit Management & Collections
11.1 Credit Management Architecture & Customer Credit Groups 11.2 Risk Scoring, Credit Limits, Blocking Rules & Credit Holds 11.3 Aging Definitions, Collections Workspace & Customer Pools 11.4 Collection Letter Sequences & Interest Notes 11.5 Customer Write-Offs, Bad Debt & Write-Off Reversals
12 Chapter 12: Subscription Billing & Revenue Deferrals
12.1 Recurring Contract Billing, Billing Schedules & Milestones 12.2 Deferral Principles, Deferral Defaults & Schedule Calculation Methods 12.3 Recognition Processing, Expense Deferrals & Modifying Schedules 12.4 Multiple Element Revenue Allocation (MEA / ASC 606)
13 Chapter 13: Accounts Payable & Invoice Processing
13.1 Shared Vendors, Global Address Book & Vendor Groups 13.2 Vendor Posting Profiles, AP Parameters & Vendor Bank Accounts 13.3 Invoice Matching Setup (2-Way, 3-Way), Tolerances & Exceptions 13.4 Vendor Invoicing Methods, Journals & Invoice Automation
14 Chapter 14: Vendor Payments & Expense Management
14.1 Methods of Payment & the Vendor Payment Proposal Engine 14.2 Generating Payments, Centralized Payments & Check Lifecycle 14.3 Expense Management Configuration, Categories & Policies 14.4 Expense Reports Processing, Mobile Receipts & Intercompany Expenses
15 Chapter 15: Budgeting & Budget Control
15.1 Budget Models, Budget Codes & Allocation Terms 15.2 Budget Register Entries, Workflows & Budget vs. Actual 15.3 Budget Transfer Rules & Processing Budget Transfers 15.4 Budget Control Configuration, Cycles, Rules & Budget Groups 15.5 Budget Funds Available, Over-Budget Permissions & Document Budget Check 15.6 Budget Planning Framework, Organization Hierarchies & Planning Processes 15.7 Budget Plans, Scenarios, Allocations & Generating Register Entries
16 Chapter 16: Fixed Assets Configuration & Transactions
16.1 Fixed Asset Groups, Asset Records & Group/Book Mapping 16.2 Depreciation Profiles: Methods & Conventions 16.3 Fixed Asset Books, Derived Books & Posting Profiles 16.4 Fixed Asset Acquisition Pathways 16.5 Depreciation Proposals, Multi-Company Runs & Fixed Asset Budgets 16.6 Fixed Asset Disposals: Sale, Scrap & Disposal Accounting 16.7 Fixed Asset Splits, Transfers & Reclassification 16.8 Asset Leasing (IFRS 16 / ASC 842)
9.3 Sales Tax Groups, Item Sales Tax Groups & Tax Exemptions
Key Takeaways Explain This Topic AI
Dynamics 365 Finance determines applicable sales tax codes through the Tax Matrix concept: the system computes the exact mathematical intersection (shared codes) between the Sales Tax Group (Customer/Vendor/Ledger header) and the Item Sales Tax Group (Released Product/Category/Expense line).
If a transaction line contains Sales Tax Group [A, B, C] and Item Sales Tax Group [B, C, D], the posting engine calculates tax exclusively for the intersecting codes [B, C]; if no intersection exists, zero tax is calculated without a posting error.
Sales tax exemptions are configured at the Sales Tax Group line level via the 'Exempt' checkbox, associated with statutory Tax Exempt Codes and Exemption Certificate tracking to generate legally compliant zero-rated tax reporting.
Use Tax (self-assessed tax) is activated via the 'Use tax' checkbox on Sales Tax Group lines; when posted, it records equal Debit to Use Tax Expense (or capitalized into item cost) and Credit to Use Tax Payable without increasing the vendor liability balance.
Conditional Sales Tax (cash-basis tax/VAT) defers tax liability and input recovery until cash payment settlement, utilizing provisional balance sheet accounts that automatically clear to final tax accounts upon payment posting.
Last updated: August 2026
9.3 Sales Tax Groups, Item Sales Tax Groups & Tax Exemptions
Quick Summary: The core transaction calculation engine in Microsoft Dynamics 365 Finance operates on the Tax Matrix Principle . Tax is never determined solely by the customer or solely by the item; rather, it is calculated from the intersection of two distinct groups : the Sales Tax Group (attached to the party/header, representing where or with whom the transaction occurs) and the Item Sales Tax Group (attached to the product/line, representing what is being bought or sold). This section explores code intersection mechanics, tax exemptions, exemption certificate governance, self-assessed Use Tax accounting, and Conditional Sales Tax (cash-basis VAT).
1. The Dynamics 365 Finance Tax Matrix Engine
Every commercial document line—including Sales Orders, Purchase Orders, Free Text Invoices, Vendor Invoices, and General Journals—must determine which Sales Tax Codes apply. Dynamics 365 Finance solves this through a deterministic two-dimensional matrix evaluation: +---------------------------------------------------------------------------------------------------------+
- | The Dynamics 365 Finance Tax Matrix Engine |
- +---------------------------------------------------------------------------------------------------------+
- | |
- | PARTY / HEADER CONTEXT PRODUCT / LINE CONTEXT |
- | [ Customer / Vendor / GL Account ] [ Released Item / Category / GL Acct ] |
- | | | |
- | v v |
- | +------------------------------+ +------------------------------+ |
- | | Sales Tax Group | | Item Sales Tax Group | |
- | | e.g., 'US-IL' (Illinois) | | e.g., 'TAXABLE' (Full Tax) | |
- | | - IL_STATE (6.25%) | | - IL_STATE (6.25%) | |
- | | - COOK_CNTY (1.75%) | | - COOK_CNTY (1.75%) | |
- | | - CHI_CITY (1.25%) | | - CHI_CITY (1.25%) | |
- | | - REDUCE_FOOD (1.00%) | | - CA_STATE (7.25%) | |
- | +------------------------------+ +------------------------------+ |
- | | | |
- | +-----------------------------+-----------------------------+ |
- | v |
- | +------------------------------------------+ |
- | | MATHEMATICAL CODE INTERSECTION | |
- | | Intersection = { STG } ∩ { ISTG } | |
- | | | |
- | | - IL_STATE (6.25%) -> MATCH -> ACTIVE | |
- | | - COOK_CNTY (1.75%) -> MATCH -> ACTIVE | |
- | | - CHI_CITY (1.25%) -> MATCH -> ACTIVE | |
- | | - REDUCE_FOOD(1.00%) -> NO MATCH | |
- | | - CA_STATE (7.25%) -> NO MATCH | |
- | +------------------------------------------+ |
- | | |
- | v |
- | +------------------------------------------+ |
- | | Total Calculated Tax = 6.25 + 1.75 + 1.25| |
- | | = 9.25% Total Tax | |
- | +------------------------------------------+ |
- +---------------------------------------------------------------------------------------------------------+
- Defaulting Rules & Precedence
Sales Tax Group (Header / Party):
Defaults from the Customer master ( Sales order header > Setup > Sales tax group ) or Vendor master ( Purchase order header > Setup > Sales tax group ).
Can default from the Main Account in General Journal lines.
Overridden manually on document headers or line details when business conditions dictate (e.g., delivery address tax override).
Item Sales Tax Group (Line / Product):
Defaults from the Released Product ( Released products > Purchase / Sell FastTabs > Item sales tax group ).
Defaults from the Procurement Category or Sales Category for non-itemized category lines.
Defaults from the Main Account for ledger journal lines.
2. 2x2 Tax Matrix Intersection Model & Numeric Walkthrough
To see how the tax engine handles mixed product lines on a single customer invoice, consider an enterprise selling three types of products to a customer located in Chicago, Illinois ( Sales Tax Group: US-IL-CHI ):
Group Setup Definitions
Sales Tax Group US-IL-CHI contains: IL_STATE (6.25%), COOK_CNTY (1.75%), CHI_CITY (1.25%), FOOD_RED (1.00%).
Item Sales Tax Group FULL_TAX (Standard Goods) contains: IL_STATE , COOK_CNTY , CHI_CITY , CA_STATE , NY_STATE .
Item Sales Tax Group GROCERY (Reduced Rate Food) contains: FOOD_RED .
Item Sales Tax Group MED_EXEMPT (Prescription Drugs) contains: MED_EXEMPT .
Comprehensive Transaction Intersection Table
Invoice Line Product Description Line Net Amount Sales Tax Group (Header) Item Sales Tax Group (Line) Intersecting Tax Codes Effective Rate (%) Total Line Sales Tax
Line 1 Enterprise Server Hardware $10,000.00 US-IL-CHI FULL_TAX IL_STATE (6.25%); COOK_CNTY (1.75%); CHI_CITY (1.25%) 9.25% $925.00
- Line 2 Employee Breakroom Groceries $1,000.00 US-IL-CHI GROCERY FOOD_RED (1.00%) 1.00% $10.00
- Line 3 First Aid Medical Supplies $500.00 US-IL-CHI MED_EXEMPT (None - Empty Intersection) 0.00% $0.00
TOTALS — $11,500.00 — — — — $935.00 +-----------------------------------------------------------------------------+
- | Invoice Voucher Ledger Distribution |
- +-----------------------------------------------------------------------------+
- | Account Description | Main Account | Debit Amount | Credit Amount |
- | ------------------------------------ | ------------ | --------------- | ------------------- |
- | Accounts Receivable (Customer) | `130100` | $12,435.00 | |
- | Revenue - Hardware Sales (Line 1) | `401100` | | $10,000.00 |
- | Revenue - Grocery Sales (Line 2) | `401200` | | $1,000.00 |
- | Revenue - Medical Supplies (Line 3) | `401300` | | $500.00 |
- | Sales Tax Payable - State (6.25%) | `220110` | | $625.00 |
- | Sales Tax Payable - County (1.75%) | `220120` | | $175.00 |
- | Sales Tax Payable - City (1.25%) | `220130` | | $125.00 |
- | Sales Tax Payable - Food Tax (1.00%) | `220140` | | $10.00 |
- | **TOTAL BALANCED VOUCHER** | | **$12,435.00** | **$12,435.00** |
- +-----------------------------------------------------------------------------+
Note
Notice Line 3: Because MED_EXEMPT exists in the Item Sales Tax Group but does not exist in Sales Tax Group US-IL-CHI , the intersection is null. Dynamics 365 Finance calculates $0.00 tax and successfully posts the transaction without generating errors or blocks.
3. Sales Tax Exemptions, Exempt Codes & Exemption Certificates
In many commercial scenarios, certain customers (e.g., non-profit organizations, educational institutions, wholesale resellers, government bodies) are legally exempt from sales tax.
Configuring Tax Exemptions in Sales Tax Groups
Exemptions are configured under Tax > Indirect taxes > Sales tax > Sales tax groups on the Setup FastTab: +---------------------------------------------------------------------------------------------+
- | Sales Tax Group Setup: [ WHOLESALE_EXEMPT ] |
- +---------------------------------------------------------------------------------------------+
- | Sales Tax Code | Description | Exempt | Tax Exempt Code | Use Tax | Reverse Charge |
- | -------------- | ------------------- | :----: | --------------- | :-----: | :-------------: |
- | `IL_STATE` | Illinois State Tax | [X] | `RESALE_CERT` | [ ] | [ ] |
- | `COOK_CNTY` | Cook County Tax | [X] | `RESALE_CERT` | [ ] | [ ] |
- | `CHI_CITY` | Chicago City Tax | [X] | `RESALE_CERT` | [ ] | [ ] |
- +---------------------------------------------------------------------------------------------+
- Exemption Mechanics & Reporting Impact
The Exempt Checkbox: When marked [X] , the calculation engine evaluates the intersection normally, but sets the calculated tax amount to $0.00 .
Tax Exempt Code: Standardized statutory reason code (configured under Tax > Setup > Sales tax > Tax exempt codes , e.g., RESALE , GOVERNMENT , DIPLOMAT , MANUFACTURING_INPUT ).
Turnover Tracking: Unlike a missing code intersection (which generates no tax transaction record), an exempt code intersection records a complete sales tax transaction with Base Amount = $10,000 and Tax Amount = $0.00. This ensures accurate reporting of tax-exempt turnover on government tax declarations.
Customer Exemption Certificates
To support tax audit compliance, Dynamics 365 Finance provides structured Exemption Certificate Management ( Accounts receivable > Customers > All customers > Invoice and delivery FastTab > Exemption certificate ):
Stores Certificate ID number, issuing state/authority, effective date, and expiration date.
Can be configured to validate that an active, non-expired exemption certificate exists before allowing an exempt order to post.
4. Use Tax Mechanics & Self-Assessed Tax Accounting
Use Tax is a self-assessed indirect tax incurred when an organization purchases taxable goods or services from an out-of-state or unregistered vendor who does not charge sales tax on the invoice. The purchasing entity is legally required to assess the tax and remit it directly to its local revenue authority. +---------------------------------------------------------------------------------------------+
- | Use Tax Posting Architecture |
- +---------------------------------------------------------------------------------------------+
- | |
- | Vendor Invoice (Out-of-State Vendor: TX_SUPPLIER): |
- | - Equipment Purchase Amount: $20,000.00 (Vendor Invoice Total = $20,000.00) |
- | - Local Illinois State Tax Rate = 6.25% ($1,250.00 Use Tax) |
- | |
- | ACCOUNTING POSTING ENTRY (Self-Assessing Use Tax): |
- | |
- | 1. Credit Accounts Payable (Vendor): ........ $20,000.00 (Vendor paid ONLY net invoice) |
- | 2. Debit Fixed Asset / Expense: ............. $20,000.00 (Base asset cost) |
- | 3. Debit Use Tax Expense (or Asset cost): ... $1,250.00 (Self-assessed tax cost) |
- | 4. Credit Use Tax Payable (State Authority): . $1,250.00 (Tax remitted to Authority) |
- | |
- | -> Vendor Balance is NOT inflated ($20,000 net liability). |
- | -> State Tax Authority receives $1,250.00 during monthly settlement! |
- +---------------------------------------------------------------------------------------------+
- Configuring Use Tax in Dynamics 365 Finance
In Tax > Indirect taxes > Sales tax > Sales tax groups , select the vendor's Sales Tax Group (e.g., US-OUTOFSTATE ).
Add the buyer's local jurisdiction sales tax code (e.g., IL_STATE ).
Check the Use tax toggle ( [X] ) on the line.
In the linked Ledger Posting Group , ensure accounts are defined for Use tax payable (Liability) and Use tax expense (Expense or Cost of Goods).
5. Conditional Sales Tax (Cash-Basis VAT / Tax Accounting)
In many international jurisdictions (and for small businesses under cash-basis accounting regimes), businesses are not required to remit output VAT—and cannot claim input VAT deductions—until the invoice is actually paid in cash , rather than when the invoice is issued.
Conditional Tax Configuration Sequence
Enable Conditional Sales Tax: Navigate to General ledger > Ledger setup > General ledger parameters > Sales tax tab and set Conditional sales tax to Yes .
Configure Ledger Posting Group: Map main accounts for:
- Provisional sales tax payable (Interim Liability)
- Provisional sales tax receivable (Interim Asset)
Configure Sales Tax Codes: Assign both a standard Settlement period and a Conditional settlement period . +---------------------------------------------------------------------------------------------+
- | Conditional Sales Tax Two-Step Lifecycle |
- +---------------------------------------------------------------------------------------------+
- | STEP 1: POST CUSTOMER INVOICE ($1,000 Net + $100 Tax = $1,100 Total) |
- | - Debit Accounts Receivable (Customer): ............ $1,100.00 |
- | - Credit Revenue: ................................... $1,000.00 |
- | - Credit Provisional Sales Tax Payable (Interim): .... $100.00 |
- | *(Note: Final Sales Tax Payable is UNTOUCHED. No tax is due to the authority yet!)* |
- | |
- | STEP 2: POST CUSTOMER PAYMENT & SETTLE INVOICE ($1,100 Cash Received) |
- | - Debit Bank / Cash Account: ....................... $1,100.00 |
- | - Credit Accounts Receivable: ....................... $1,100.00 |
- | - [AUTOMATIC TAX RECLASSIFICATION VOUCHER]: |
- | - Debit Provisional Sales Tax Payable (Interim): ... $100.00 (Clears Interim) |
- | - Credit Sales Tax Payable (Final Liability): ....... $100.00 (Now ready to settle!) |
- +---------------------------------------------------------------------------------------------+
- 6. Exam Traps & Real-World Best Practices
Warning
Exam Trap: Use Tax Affecting Vendor Balance MB-310 exam questions frequently ask: "A company posts a $5,000 vendor invoice with a 6% Use Tax applied. What is the open balance on the vendor account?" Candidates often incorrectly answer $5,300. Remember: Use Tax never increases the vendor balance . The vendor balance remains exactly $5,000, while the $300 tax is credited to Use Tax Payable for direct remittance to the government.
Tip
Consultant Best Practice: Troubleshooting $0.00 Tax Calculations When users report that sales tax is not calculating on an order line, follow the diagnostic checklist:
Check the Sales Tax Group on the document header.
Check the Item Sales Tax Group on the document line.
Verify if the two groups share at least one identical Sales Tax Code.
Verify whether the Exempt box is checked on that code inside the Sales Tax Group.
Confirm that the current transaction date falls within the From date / To date range on the Sales Tax Code Values tab.