Sales tax applicability and sales tax group determination logic

This article explains the logic for determining sales tax applicability and sales tax groups in the tax feature setup.

Matching logic

Before the 10.0.21 update, the Tax calculation service used straightforward logic to find a tax applicability rule in the tax applicability matrix:

1. Start at the first row of the matrix.
2. Check each row until a matching condition is found.
3. Stop the search.

In the 10.0.21 update, the applicability logic tries to match the condition that includes the most input fields. Each field that has a value has a weight of 10. A condition that has a higher total weight has a higher priority.

Example

The following example shows how the matching logic works.

In Regulatory Configuration Service (RCS), the Tax group applicability tab is configured as shown in the following table.

Business process	Currency	Item code	Tax group	Weight
Purchase	EUR		TG_A	20
Purchase	EUR	D0001	TG_B	30

For the first line in the table, two input fields are set. Therefore, the line has a weight of 20. For the second line, three fields are set. Therefore, the line has a weight of 30.

When sales tax is calculated for a purchase order that has the EUR currency and item D0001, the Tax calculation service uses the condition that has a higher weight. Therefore, it uses the second line in the table.

Note

On the Applicability rule tabs, line numbers aren't visible, and the Move up and Move down buttons are no longer available. After you save a setup and reopen the page, the lines are ordered according to their weight.

Even though line numbers aren't visible in the UI, they are still available in the table. If two lines have the same weight, the line that has the smaller line number is used.

Sales tax group and item sale tax group determination logic

Before the 10.0.21 update, the Sales tax group and Item sales tax group fields weren't editable. Instead, the field values were determined by the Tax calculation service, based on the condition that was met for the tax code applicability rule.

In the 10.0.21 update, the sales tax group and item sale tax group determination logic has been updated. When a document line is created on a business document, such as a sales order, purchase order, or vendor invoice, the Sales tax group and Item sales tax group fields are set to the values from the master data. Then, when tax is calculated, the fields are updated according to the conditions that are configured in the Tax feature setup on the Tax group applicability and Item tax group applicability tabs in RCS.

If no applicability rule is configured for the tax group or item tax group in the Tax feature setup in RCS, the Tax calculation service uses the default rules from the master data in Microsoft Dynamics 365 Finance.

Note

The sales tax group and item sales tax group must be created and maintained in RCS.

Override sales tax

You can update the tax groups that the Tax calculation service determined, without having to reconfigure the Tax feature. For example, you might have to update the tax groups because the rule is incorrectly set up, or some exception to the rule is required. By setting the Override sales tax option to Yes on the line details page for a document line, you can select the required sales tax group and item sales tax group.

The Sales tax group and Item sales tax group fields list only tax groups where the Source field is set to Tax calculation service. This value indicates that the tax groups were synchronized from the Tax feature setup in RCS.

The tax codes are calculated based on the intersection of the tax codes that are defined on the Tax group and Item tax group tabs in the Tax feature setup in RCS.

Note

If the Sales tax group or Item sales tax group field is left blank, and the Override sales tax option is set to Yes, the line won't be sent to the Tax calculation service for processing.

The Override sales tax check box is added to the Customer and Vendor master data on the Invoice and delivery FastTab. The check box is also added to the Sales order, Purchase order, Free text invoice header, and to the line level of those documents.

Update order lines

You can bulk update lines if the Override sales tax check box is changed on the header level and is added to the Update order lines parameters pages for Sales order, Sales quotation, and Purchase order. For example, if the option is set to Prompt, when the Override sales tax is changed on the header of the document, the dialog box opens and you can select whether the document lines should be updated.

Note

Header level and line level charges inherit the Override sales tax option from the header or line of the document respectively.

Current limitation: When updating Override sales tax checkbox on a header or line level the respective charges do not inherit this checkbox in case the charges were already created.

Reverse charge applicability rules

For information about the configuration for reverse charge rules, see Set up reverse charge rules.

When the document lines meet the reverse charge rules that are configured in Finance, the Override sales tax check box is set to Yes for the affected lines. The default value for Sales tax group comes from the Purchase order sales tax group or Sales order sales tax group field, respectively. These fields are specified on the General ledger parameters page, on the Reverse charge tab. For more information about these fields, see Set up default parameters.

Note

For reverse charges, the sales tax groups and item sales tax groups must be also created and maintained in RCS.