Calculate Sales Tax
As long as you enable tax calculation and select AvaTax as the tax calculation method in your business application, AvaTax automatically calculates a sales or use tax rate on a variety of transaction types according to the taxability rules of those products (exempt customers aren't charged sales tax).
Calculate sales tax
Depending on the Accounts Receivable or Project form you choose, you can see the tax represented in exactly the same way as when using the internal tax engine.
- To access Sales Order, Sales Quotation, Free Text Invoice, or Project Quotation forms, click Inquiries > Totals.
- To access Sales Order, Sales Quotation, Free Text Invoice, or Project Quotation forms, click Setup > Sales Tax.
- To access Project Invoice Proposal and Project Invoice forms, click Sales Tax
Additionally, sales tax is calculated after saving the forms and releasing the order, during the Microsoft Dynamics AX posting process.
To send Currency Code and Tax Registration Number, which is sent to AvaTax as the BIN for VAT calculation, in the transaction details:
- Go to Customers > All Customers and select a customer. In the Customer Account window:
- For the Currency Code:
- Go to the Sales demographics tab and set the Currency. The corresponding Currency Code is sent in all the transactions for this customer.
- Go to the Sales demographics tab and set the Currency. The corresponding Currency Code is sent in all the transactions for this customer.
- For the Tax Registration Number:
- Go to the Addresses tab and click Add to add a new address or click Edit to edit the address.
- In the Address window, go to Tax registration tab and click Add to add the registration details.
- Go to the Addresses tab and click Add to add a new address or click Edit to edit the address.
To calculate tax on a transaction such as a sales order, follow these steps:
- Go to Accounts Receivable > Common > Sales Orders > All Sales Orders.
- On the All Sales Orders page, go to Sales Order > New and then click the Sales Order button.
- On the Create Sales Order page, select a Customer Account and click OK.
- On the Sales Order page, select an Item Number.
- To add a discount for an item:
- Select the Item.
- In the bottom-half of the window, in the Line details section, click the Price and discount tab.
- Add the Discount amount or the Discount Percent.
- To calculate sales tax at the line-level, select the line and then go to Financials > Tax and click Sales Tax.
- To calculate sales tax at the header-level, go to Sell > Tax and click the Sales Tax.
- In the Sales Tax window, a table displays the sales tax details. Close the Sales Tax window.
- In the Sales Order window, go to the Invoice tab > General > Invoice button to create an invoice for the sales order.
- Click OK to post the invoice to AvaTax.
Calculate sales tax for many transactions
You can select documents and re-process them for tax calculation, when you upload a batch of sales orders. To calculate tax on a batch of sales orders, follow these steps:
- In the Utilities menu, click Batch Tax Calculation.
- In the Parameters section, click one of the following options:
- Quotation
- Sales Order
- Return Order
- Free Text Invoice
- Click Select.
- In the Criteria field, select the Document Type or the range of documents.
- Click OK.
Calculate sales tax on a line-level ship-to address
- Follow the usual steps to create a new transaction such as a sales order:
- In the Accounts Receivable module, at the upper left, click Sales Order.
- In the Create sales order dialog box, next to Customer account, select a customer and then click OK.
- In the Accounts Receivable module, at the upper left, click Sales Order.
- In the Sales Order pane, on the toolbar in the Show group, click Header view.
- In the Header view pane, under Setup, next to Sales tax group, select AVATAX, and then click Close.
- In the Sales Order pane, on the toolbar in the Show group, click Line view.
- Under Sales order lines, click Add line, and under Item number, select an Item.
- Under Site, select the Ship-from address.
- Fill in or select the other details for the line such as Warehouse and Unit Price, and then at the lower left, click Line details.
- In the Line details pane, click the Address tab, and next to Delivery address, select a Ship-to Address.
- Click the Delivery tab, and next to Mode of delivery, select a ship-to delivery mode such as Customer pickup. Connector for Microsoft Dynamics AX 2012 will make the delivery address (the ship-to address) the ship-from address.
- Click the Setup tab, and next to Sales tax group, select AVATAX-POD.
- On the Microsoft Dynamics AX toolbar, click Totals.
In the View sales order totals dialog box, next to Sales tax, you'll see a sales tax total based on the ship-to address that you selected in step 8.
Calculate sales tax using a tax override
The tax override feature lets you manually alter the tax amount on a specific transaction by either changing the transaction date or the transaction tax amount. This feature allows you to change the tax amount to something other than the value that was previously calculated. To use the tax override feature, ensure that the Enable credit note / return order tax override option is enabled in configuration.
Note:
The tax override feature is available only for credit notes and return orders
To override tax calculation, follow these steps:
- Go to Accounts receivable > Common > Sales Orders > All sales order.
- Select the Return Order for which you want to override tax calculation.
- Go to Sell > Calculate > Tax override
- In the Tax override section in the Tax override window, select either of the following and then click Tax override.
- Date: To override tax using date option, type the Date.
- Amount: To override tax using the amount option, type the Amount.
- Click Close.
- You can now post the sales order.
Calculate sales tax for latitude and longitude
If your customer has a location, such as an oil-rig, drilling platform or radio antenna, without a street address, you can still calculate sales tax for that location with latitude and longitude coordinates. To calculate sales tax using latitude and longitude, follow these steps:
- Go to Account Receivable > Common > Customer > All Customers.
- In the All Customer window, select the customer.
- In the Customer window, under the Address tab, click Add.
- Type the Name or description for the location.
- On the General tab, add the Latitude and Longitude values for the location and click Ok.
- Close the Customer form.
- Go to Accounts Receivable > Common > Sales Orders > All Sales Orders.
- In the All Sales Orders window, go to Sales Order > New and then click the Sales Order button.
- In the Create Sales Order window, select the Customer account that has the latitude and longitude details and click OK.
- In the Sales Order window, select the Item Number.
- Go to Sell > Tax and click the Sales Tax button.
- In the Sales Tax window, the table displays the sales tax details. Close the Sales Tax window.
- In the Sales Order window, on the Invoice tab, under the General section, click the Invoice button to create an invoice for the sales order.
- Click OK to post the invoice to AvaTax.
Calculate sales tax for a Free Text Invoice
To calculate tax on a transaction for a free text invoice in Microsoft Dynamics AX 2012, follow these steps:
- Go to Accounts Receivable > Common > Free text invoices > All free text invoices.
- In the All free text invoices window, go to Invoice > New and then click the Free text invoice button.
- Select the Customer Account and add invoice line details such as Description, Main account, Sales tax group, Item sales tax group, Quantity, and Unit Price.
- Click the Sales Tax button.
- Click the Post button to post the invoice to AvaTax.
Calculate sales tax for a Sales Quotation
To calculate tax on a sales quotation in Microsoft Dynamics AX, follow these steps:
- Go to Sales and marketing > Common > Sales quotations > All quotations.
- In the All quotations window, go to Quotation > New and click the Sales quotation button.
- Select the Account type as Customer and select the Customer Account and click OK.
- Click Add Line to add an item to the sales quotation.
- Click on Quotation > Tax > Sales Tax button.
Calculate sales tax for a Return Order
To calculate tax on a transaction for a Return Order in Microsoft Dynamics AX 2012, follow these steps:
- Go to Sales and marketing > Common > Return Order > All return order.
- In the All return order window, go to Return Order > New and then click the Return Order button.
- Select a Customer Account and click Ok.
- Click Add Line to add an item to the return order.
- Save the return order and click Close.
- Go to Inventory management> Periodic> Arrival Overview.
- Select the Setup name as Return Order and select the RMA number from the drop-down.
- Click Select All.
- Click Start Overview.
- Click Select All.
- Click Journal ->Show arrival from lines.
- In the Location journal window, click the Default values tab.
- Select the RMA number and the Disposition code.
- Click the Lines menu.
- In the Journal lines window, click the General tab.
- Select the Disposition code.
- Click Validate.
- Click OK.
- Click Post and then close all the windows.
- Go to Accounts Receivable > Common > Sales Orders > All Sales Orders.
- Scroll down to the end of the order list and select the order that you created. The Order type for this order is Returned order.
- Open the order that you have selected and save it.
- Go to Sell > Tax and click the Sales Tax button.
- In the Sales Order window, go to the Invoice tab > General > Invoice button to create an invoice for the sales order.
- Click OK to post the invoice to AvaTax.
Calculate sales tax for a Project Invoice
To calculate tax on a transaction for a Project Invoice in Microsoft Dynamics AX, follow these steps:
- Go to Project Management and Accounting > Projects > All Projects.
- Open an existing project.
- In the Projects window, go to the Manage tab and then click Item Task > Sales Order.
- In the Create Sales Order window, select the Customer Account and click OK.
- In the Sales Order window, select the Item Number, Quantity, and the Unit Price.
- Click Save to save the sales order and then click Close.
- In the Projects window, click Manage > Invoice Proposal.
- In the Create Invoice Proposal window, for the sales order transaction, select the Sales Order Lines and the Sales Order and then click OK.
- In the Invoice Proposal window, click Sales Tax to calculate the sales tax for this invoice.
- In the Invoice Proposal window, click Post to post the sales order.