Excise Schedule Transaction Importer Tool
This site is only for Avalara customers licensed for Returns Excise, AvaTax Excise and Government.
Documentation of operation, usage and release dates is confidential and proprietary information of Avalara.
This document applies only to Enterprise customers. Content last updated 2021-04-22.
Update URL/address before May 7, 2021
Avalara emailed all Support Contacts and added an explanation in the Home page Message Center about URL/address changes. Here's how to make those changes for the Schedule Transaction Importer (STI) Tool.
Note: This does not apply to Self-Hosted
customers.
- Click the Windows Start icon and type schedule transaction. Right click on the Schedule Transaction Importer and then click Open file location.
- Right click on the Schedule Transaction Importer and then click Properties at the bottom.
- Click Open File Location and in the File Explorer, move to the Configuration folder below.
- Replace the Old line with the New line:
Edit AppSettings.config with Notepad
Old: <add key="DataServices" value="PROD,UAT" /> New: <add key="DataServices" value="PROD,SBX" />
Old: <add key="UAT" value="https://exciseua.avalara.net" /> New: <add key="SBX" value="https://excisesbx.avalara.com" />
Old: <add key="PROD" value="https://excise.avalara.net" /> New: <add key="PROD" value="https://excise.avalara.com" />
Edit Avalara.Excise.DataServices.Properties.Settings.config with Notepad
Old: <!--zmsua.zytax.com--> New: <!-- Sandbox - excisesbx.avalara.com -->
Old: <value>https://excise.avalara.net/AvalaraAuthenticationService.asmx</value> New: <value>https://excisesbx.avalara.com/AvalaraAuthenticationService.asmx</value>
Old: <value>https://exciseua.avalara.net/Avalara...rtService.asmx</value> New: <value>https://excisesbx.avalara.com/AvalaraImportService.asmx</value>
Old: <value>https://exciseua.avalara.net/dataservice.asmx</value> New: <value>https://excisesbx.avalara.com/dataservice.asmx</value>
Old: <!--Avalara UA - exciseua.avalara.net--> New: <!--Avalara Prod - excise.avalara.com -->
Old: <value>https://excise.avalara.net/AvalaraAuthenticationService.asmx</value> New: <value>https://excise.avalara.com/AvalaraAuthenticationService.asmx</value>
Old: <value>https://excise.avalara.net/AvalaraImportService.asmx</value>
New: <value>https://excise.avalara.com/AvalaraImportService.asmx</value>
Old: <value>https://excise.avalara.net/dataservice.asmx</value> New: <value>https://excise.avalara.com/dataservice.asmx</value>
Schedule Transaction Importer (STI) tool
Avalara Excise has two Schedule Transaction Importer (STI) methods for importing records:
- The STI widget, built into the cloud-based Avalara Excise
- The STI tool, an optional external application.
| Feature | STI widget (runs in the cloud based Avalara Excise) | STI tool (runs on Windows) |
| Import transactions and master data (e.g. locations, business entities & accounts, etc.) | Yes | Yes |
| Import master data (e.g. locations, business entities & accounts, etc.) separately | Yes | Yes |
| Import records from Excel or CSV files | Yes | Yes |
| Use custom scenarios, profiles and mappers (additional fees) |
Yes (see Additional fees, below) | Yes (see Additional fees, below) |
| Connect to and import records from SQL databases | No | Yes |
| Can be called by other programs as part of a customer's automation. | No | Yes |
Additional fees
The STI tool is updated quarterly and routine version upgrades to custom scenarios, profiles and mappers are at no additional fee. Customization can be arranged with your Customer Account Manager or Professional Services Consultant.
Schedule Transaction Importer Tool
The STI tool looks like this:
Click on any subject to view the related document.
Import using the Schedule Transaction Importer Tool (external application)