Tax codes in Dynamics 365 Field Service
Set up tax codes in Dynamics 365 Field Service and specify how much tax will be applied to your products, agreements, and services.
Enabling tax calculation in Dynamics 365 Field Service
Field Service v220.127.116.11 introduced the Calculate Tax field in Field Service Settings. By default, for all new installations of Field Service v18.104.22.168 or higher, this field will be set to No. For many Field Service organizations, tax calculation is not an important factor because:
- The services are not being provided to an external customer.
- The tax calculation and application rules are complex enough that they are handled in a related ERP system.
When an organization needs to calculate tax and the Field Service tax logic is sufficient, set the Calculate Tax field to Yes for all tax fields to be visible and all calculation logic to be enabled.
When toggled, this will hide/show and disable/enable logic for the following tables and fields:
|Work Order||Taxable, Tax Code, Tax Amount, Subtotal Amount|
|Work Order Type||Taxable|
|Work Order Product||Taxable|
|Work Order Service||Taxable|
|Account||Tax Exempt, Tax Exempt Number, Sales Tax Code|
|Agreement||Taxable, Tax Code|
|Purchase Order Bill||Tax Amount, Tax Code|
|RMA||Taxable, Tax Code|
|Quote Detail||Taxable, Tax Code|
Set up tax codes
Each tax code may contain multiple child tax codes; in that case, the tax rate will be determined by the total of all children.
If an area has more than one type of tax, for example, state and county tax, then use the Tax Group option to combine several tax codes into one group.
For example, if the state of California has a state and county tax, then you might have a tax group called "California, Alameda County." The tax group will have two tax codes: one for overall California state tax and one for Alameda County local tax.
From the main menu, go Field Services > Administration, and then choose Tax Codes.
On the Active Tax Codes screen, select +New in the upper left corner.
Use the tooltips to help fill in your information, and then select Save.
If Act as tax Group is set to Yes:
Go to the Tax Code Details section and select +Add Tax Code Detail record.
Specify the Tax Code.
If the government agency charges tax above the local tax then set Tax on tax to Yes.
For example, the Canadian government charges Provincial Sales Tax (PST) and Goods and Services Tax (GST). You will need to set a tax on tax.
For instance, if the work order total equals $100, the first tax code in the group is calculated on the $100. If the tax code is 5%, then the total is now $105. If the second code in the tax group is 10%, and it is marked as a tax on tax, the 10% is calculated on $105 instead of $100, which makes the total $110. However, if the second code is not flagged as a tax on tax, then the 10% is calculated on the initial work order amount, of $100.
In the Line Order field, enter the order of how the system should calculate the multiple tax codes.