9.1 Sales Tax Engine Hierarchy, Authorities & Settlement Periods
Key Takeaways
- The sales tax engine resolves tax from the intersection of the sales tax group on the transaction header and the item sales tax group on the line.
- A sales tax authority is the government body that receives the tax and is linked to a vendor account so settlement can generate an AP payment.
- Settlement periods define the reporting interval and hold the period intervals used by Settle and post sales tax.
- Each sales tax code is assigned to a settlement period, which in turn points at the authority.
9.1 Sales Tax Engine Hierarchy, Authorities & Settlement Periods
Quick Summary: In Microsoft Dynamics 365 Finance, the sales tax engine automates the calculation, posting, reporting, and settlement of indirect taxes—including standard sales tax, Value Added Tax (VAT), Goods and Services Tax (GST), and self-assessed Use Tax. To function seamlessly, the tax framework requires four foundational configuration pillars: Sales Tax Authorities (the government agencies collecting tax, linked to Accounts Payable vendors), Sales Tax Settlement Periods (the cyclic frequency of tax reporting and remittance), Ledger Posting Groups (the General Ledger balance sheet accounts where tax amounts accumulate), and Sales Tax Codes (the calculation rules, rates, limits, and marginal bases). Understanding this hierarchy is essential for passing the MB-310 exam and architecting statutory tax compliance across global legal entities.
1. Architectural Hierarchy of the Sales Tax Engine
Dynamics 365 Finance does not calculate taxes directly on individual master records. Instead, it utilizes an indirect, modular tax framework where operational transactions resolve tax amounts through interconnected configuration building blocks.
+---------------------------------------------------------------------------------------------------------+
| Sales Tax Engine Architectural Hierarchy |
+---------------------------------------------------------------------------------------------------------+
| |
| +--------------------------------+ +----------------------------------+ |
| | Ledger Posting Group | | Sales Tax Authority | |
| | - Sales Tax Payable (Output) | | - Government Agency Definition | |
| | - Sales Tax Receivable (Input)| | - Report Layout Format | |
| | - Use Tax Payable / Expense | | - AP Vendor Account Linkage | |
| | - Tax Settlement Account | | - Rounding Rules | |
| +--------------------------------+ +----------------------------------+ |
| | | |
| | v |
| | +----------------------------------+ |
| | | Sales Tax Settlement Period | |
| | | - Reporting Intervals (Monthly) | |
| | | - Terms of Payment | |
| | | - Period Status (Open / Closed) | |
| | +----------------------------------+ |
| | | |
| +----------------------+-----------------------+ |
| | |
| v |
| +--------------------------------------+ |
| | Sales Tax Code | |
| | - Calculation Method (Net / Gross) | |
| | - Rate Value / Percentage (%) | |
| | - Currency & Marginal Base Type | |
| | - Min / Max Limits & Reverse Charge | |
| +--------------------------------------+ |
| | |
| +-----------------------+-----------------------+ |
| v v |
| +------------------------------+ +------------------------------+ |
| | Sales Tax Group | | Item Sales Tax Group | |
| | (Assigned to Party / Header)| | (Assigned to Item / Line) | |
| | - Customer / Vendor Master | | - Released Product | |
| | - Exempt / Use Tax Toggles | | - Procurement / Sales Cat. | |
| +------------------------------+ +------------------------------+ |
| | | |
| +-----------------------+-----------------------+ |
| v |
| +--------------------------------------+ |
| | Tax Matrix Intersection | |
| | -> Common Codes Determine Tax Line | |
| +--------------------------------------+ |
+---------------------------------------------------------------------------------------------------------+
Foundational Setup Sequence
When implementing sales tax in a new legal entity, the functional consultant must follow a strict dependency sequence:
- Create AP Vendor Account for the tax authority (
Accounts payable > Vendors > All vendors). - Configure Sales Tax Authority and link the AP vendor (
Tax > Indirect taxes > Sales tax > Sales tax authorities). - Create Sales Tax Settlement Period and link the authority (
Tax > Indirect taxes > Sales tax > Sales tax settlement periods). - Create Ledger Posting Group with main account mappings (
Tax > Setup > Sales tax > Ledger posting groups). - Create Sales Tax Codes referencing the Settlement Period and Ledger Posting Group (
Tax > Indirect taxes > Sales tax > Sales tax codes). - Create Sales Tax Groups and Item Sales Tax Groups to establish the transaction tax matrix.
2. Sales Tax Authorities & Accounts Payable Vendor Integration
Sales Tax Authorities represent the federal, state, provincial, or municipal revenue agencies to which collected taxes must be reported and remitted (e.g., Internal Revenue Service, California Department of Tax and Fee Administration, HM Revenue & Customs, Finanzamt).
Navigation
- Path:
Tax > Indirect taxes > Sales tax > Sales tax authorities
Core Configuration Parameters
| Configuration Field | Functional Description | Implementation & Exam Significance |
|---|---|---|
| Authority | Unique alphanumeric code (e.g., CA_FTB, UK_HMRC, IRS_FED). | Primary key identifier referenced by settlement periods. |
| Name | Full legal name of the tax authority. | Printed on statutory tax declarations and reports. |
| Vendor account | Lookup to an active Accounts Payable Vendor record in the current legal entity. | Critical: During the periodic Settle and post sales tax process, the system automatically posts the net tax liability as an open AP vendor invoice against this vendor account. |
| Report layout | Statutory reporting layout format (e.g., Default, Standard, Norwegian, German, French, Form 380). | Dictates the data structure and field mappings of generated tax declaration reports. |
| Rounding rule | Decimal precision for tax rounding (e.g., 0.01, 1.00). | Governs rounding at the authority reporting level. |
| Rounding form | Method of rounding: Normal (arithmetic 0.5 round), Downward (floor/truncate), or Upward (ceiling). | Ensures reported amounts match local legislative rounding guidelines. |
+---------------------------------------------------------------------------------------------+
| Sales Tax Authority to Vendor Integration Link |
| |
| [ Sales Tax Authority: CA_BOE ] |
| | |
| +---> Vendor Account Link: [ V-TAX-CA (California Dept of Tax & Fee Admin) ] |
| |
| * Periodic Settlement Run Execution: |
| Net Tax Liability: $14,250.00 |
| -> Automatically creates open Vendor Invoice in AP for Vendor V-TAX-CA ($14,250.00) |
| -> Ready for automated Vendor Payment Proposal disbursement processing! |
+---------------------------------------------------------------------------------------------+
[!IMPORTANT] If the Vendor account field on the Sales Tax Authority is left blank, the Settle and post sales tax periodic routine will still clear the general ledger sales tax accounts to the configured Tax Settlement main account, but it will not create an open AP vendor invoice. Consequently, Accounts Payable cannot disburse payment to the authority via automated vendor payment proposals.
3. Sales Tax Settlement Periods & Period Lifecycle
Sales Tax Settlement Periods define the recurring time horizons across which indirect tax transactions are accumulated, audited, closed, and remitted to the associated authority.
Navigation
- Path:
Tax > Indirect taxes > Sales tax > Sales tax settlement periods
+---------------------------------------------------------------------------------------------+
| Sales Tax Settlement Period Structure |
+---------------------------------------------------------------------------------------------+
| Settlement Period: [ MONTHLY ] Authority: [ US_IRS ] |
| Description: Monthly Settlement Period Terms of Payment: [ Net 30 ] |
| Unit: [ Months ] Number of units: [ 1 ] |
+---------------------------------------------------------------------------------------------+
| PERIOD INTERVALS GRID: |
| From Date | To Date | Status | Description | Settled Date | Version |
| ------------ | ------------ | ------ | ------------------------ | ------------- | -------- |
| 01/01/2026 | 01/31/2026 | Closed | January 2026 Tax Period | 02/15/2026 | Original |
| 02/01/2026 | 02/28/2026 | Closed | February 2026 Tax Period | 03/15/2026 | Original |
| 03/01/2026 | 03/31/2026 | Open | March 2026 Tax Period | | |
| 04/01/2026 | 04/30/2026 | Open | April 2026 Tax Period | | |
+---------------------------------------------------------------------------------------------+
Core Settings on Settlement Periods
- Authority: Identifies the target Sales Tax Authority receiving the periodic declaration.
- Terms of payment: Determines the due date of the automatically generated AP vendor invoice relative to the settlement transaction date (e.g.,
Net 20,Net 30). - Interval unit & Number of units: Defines the time frequency of the period intervals: Months (e.g., 1 for Monthly, 3 for Quarterly), Years (1 for Annual), or Days.
- Period intervals tab: Contains the discrete chronological intervals (From Date / To Date) and tracks the lifecycle Status:
- Open: Active interval currently accepting new sales tax transaction postings from customer invoices, vendor bills, and general journals.
- Closed: Locked interval where the Settle and post sales tax routine has been executed with the Original payment version. Any subsequent retroactive postings into a closed period require a Correction settlement run.
A financial controller executes the periodic 'Settle and post sales tax' job for the monthly settlement period. The General Ledger sales tax payable and receivable accounts are successfully cleared to zero, and the tax settlement report prints correctly. However, when the Accounts Payable clerk creates a vendor payment proposal, the system cannot locate any open invoice for the tax authority. What is the root cause of this issue?
A consultant is configuring sales tax so that the periodic settlement process can generate a payment to the state revenue department. Which link makes the payment possible?