How to Install 2023 Zip Codes, Cities, and County Code Updates

How to Install 2023 Zip Codes, Cities, and County Code Updates

Release Date: 09/07/2023
Version: 8.5 & Higher

In Elliott 8.5d.907 and 8.63.907 and after, the Zip Codes, Cities, and County Code tables are updated to Post  Office's 2023 August data. The following are Elliott's affected tables:
  • SYZIPCDS.BTR - Zip Code Table
  • SYCITY.BTR - City Table
  • ARCOUNTY.BTR - County Code Table
The last Elliott update of these tables was in 2016. 

Once you install Elliott 8.5d.907 and 8.63.907 releases or after, the three new tables (dated 09/07/2023) will be installed into the following Elliott folders:
  • <ElliottRoot> - e.g., M:\Elliott7
  • <ElliottRoot>\Bin85\NewData - For Elliott 8.5 Installation
  • <ElliottRoot>\Bin86\NewData - For Elliott 8.6 Installation
  • <ElliottRoot>\Tutorial - If this is a new installation
These three tables also reside in each DATA* folder. However, since you may have modified these tables in the DATA folder, it is advised that you do not directly copy these three tables over to your DATA* folders.  Instead, you should choose "Synchronize" to merge the tables in the DATA* folder with the new tables just installed the <ElliottRoot> directory.

To synchronize, after installing the proper Elliott 8.5 and 8.6 updates, you can launch either Elliott 8.5 or 8.6 and choose the company that you wish to update then perform the following steps:

Zip Code Table
Go to System Utilities -> Zip Code File -> Synchronize. Answer "Y" to proceed. See sample screen below:


The output is not important, so you can choose to print to screen. See sample result below:  

City Table

Go to System Utilities -> System Files Setup -> Maintenance ->  City File -> Synchronize. Answer "Y" to proceed. See sample screen below:  


The output is not important, so you can choose to print to screen. See sample result below:  

County Code Table

Go to A/R -> Maintenance -> County Tax Code File -> Synchronize. Answer "Y" to proceed. See sample screen below:


The output is not important, so you can choose to print to screen. See sample result below:



Modified Programs: SYZIPCDS.BTR, SYCITY.BTR, ARCOUNTY.BTR

EMK


    • Related Articles

    • Auto Assigned Sales Tax Code by State and County

      Q: Recently we have set up sales offices in several states, and we'd like to let the system assign sales tax codes by state and county automatically in order to reduce human error. A: Solutions: 1. Global Setup/A/R Global Control: Fields #1, 5 and 13 ...

    • ARCNTMNT Accounts Receivable County Tax Code File Maintenance

      County Tax Code File Maintenance Application Overview This feature allows you to automatically assign sales tax codes during Customer File Maintenance, and COP Ship-to File Maintenance. The Tax Code Fields are set up to accommodate additional taxing ...

    • Arizona Cities Not in Elliott for Sales Tax Code Auto Assign

      Q - I finished our tax code setup for the state of Arizona. But I am having an issue with a few cities that have a city level sales tax that are not listed as Arizona cities in Elliott. I just synced my city list this week. The cities that have a ...

    • How Does Elliott Determine Sales Tax Codes?

      Release Date: 08/24/2018 Q - I’m noticing that some of the cities in Elliott are not populating the correct tax codes. In the screenshot below, Elliott is prompting me to add tax code WN4- but this city should not have that code. The correct codes ...

    • Feature - Validate 9-Digit Zip Code in Avalara Address Validation

      Release Date: 8/9/23 Version: 8.6 and Above This feature allows the user to control how zip codes are treated during address validation. A new flag is available in Global Setup-> Add-ons-> Avalara Sales Tax Interface-> 4. Validate Addresses. 4. ...