You use this program to import a file (veratax.txt) containing all the rates for the entire United States, based on the ZIP code. It eliminates the need to enter and maintain every rate manually - useful if you sell to customers in many locales.
The program can be accessed using the -> option of the Browse on Extended Tax Codes program, provided you have enabled the USA AVP sales tax system (Tax Options). When maintaining customer details, the AVP system automatically inserts the city name and state code into the address fields.
| Field | Description |
|---|---|
| Effective date | The date from which the rates must be used. |
| State selection | The state(s) for which to import the tax rates (i.e. the specific states for which you are defining the rates). |
| Sales tax ledger code | |
| Enter G/L code at state break | If sales tax integration to General Ledger is defined
at tax code level (Tax Options) then this is the
ledger account to use to integrate sales tax to the General
Ledger for each state rate defined. During the import process, when the system detects a change of state it requests a new ledger code to use for the new state which is used to create the record on the file. |
| Ledger code | If sales tax integration to General Ledger is defined at tax code level (Tax Options) then this is the ledger account to which tax entries must be posted for all states. |
| Import | Imports the tax codes according to your selections. |
The import file (veratax.txt) must reside in your SYSPRO Work folder.
It comprises state record lines (where the zip code is blank) followed by the city/county information and rates for the cities/counties within the state.
For example: The following file indicates the state record lines and the city/county record lines:
![[Note]](images/note.png)
|
|
|
The spacing of fields/columns in this example are not accurate. Refer to the file layout for the correct start position and length for each field/column. |
|
AL ALABAMA 040000 04000
AL3190500FORT BENNING 00000 00000 00000 00000RUSSELL 03000 00000 03000 00000 07000 07000 113 AL3500400ACMAR 00000 00000 00000 00000SAINT CLAIR 02000 00000 02000 00000 06000 06000 1115
AR ARKANSAS 04625 04625
AR7185400TEXARKANA 02000 00500 02000 00500MILLER 01000 00000 01000 00000 081250.08125 091
IN INDIANA 05000 05000
IA IOWA 05000 05000
IA5100400ANTHON 01000 01000 00000 00000WOODBURY 00000 00000 00000 00000 070000.05000 193
The state code record (i.e. where the zip code is blank) is held in memory until the state code changes and is used to subtract from the combined use rate, along with county rate to work out the rate that is written to the FirstRate31 filed in the SYSPRO AdmUsaTax file.
|
|
|
|
|
| Field | Start Position | Field Length, Type, Notes |
|---|---|---|
| State code | 1 | 2 Alphanumeric This is the state code (e.g. CA for California). |
| Zip code | 3 | 5 Alphanumeric This must be left blank for a state line. |
| Geocode | 8 | 2 Numeric |
| State City Name | 10 | 26 Alphanumeric This indicates the state name for a state line and the city name for a city line. |
| Filler | 36 | 2 Spaces (not zeroes) |
| St City Sales Rate | 38 | 5 Numeric This indicates the state sales rate for a state line and the city sales rate for a city line. |
| Filler | 43 | 2 Spaces (not zeroes) |
| City Transit Rate | 45 | 5 Numeric |
| Filler | 50 | 2 Spaces (not zeroes) |
| St City Use Rate | 52 | 5 Numeric This indicates the state use rate for a state line and the city use rate for a city line. |
| Filler | 57 | 2 Spaces (not zeroes) |
| City Transit Use Rate | 59 | 5 Numeric |
| County Name | 64 | 26 Alphanumeric This indicates the county name. |
| Filler | 90 | 2 Spaces (not zeroes) |
| County Sales Rate | 92 | 5 Numeric This indicates the county sales rate. |
| Filler | 97 | 2 Spaces (not zeroes) |
| City Transit Sales Rate | 99 | 5 Numeric |
| Filler | 104 | 2 Spaces (not zeroes) |
| Count Use Rate | 106 | 5 Numeric This indicates the county use rate. |
| Filler | 111 | 2 Spaces (not zeroes) |
| City Transit Use rate | 113 | 5 Numeric |
| Filler | 118 | 2 Spaces (not zeroes) |
| Combined Sales Rate | 120 | 5 Numeric |
| Filler | 125 | 2 Spaces (not zeroes) |
| Combined Use Rate | 127 | 5 Numeric |
| City Admin Code | 132 | 1 Alphanumeric |
| County Admin Code | 133 | 1 Alphanumeric |
| County Code | 134 | 3 Alphanumeric |