Improved the Vertex Geo Code Generation for Customer and Ship-To Records

Improved the Vertex Geo Code Generation for Customer and Ship-To Records

Release date: 9/30/2021

Version: 8.5 and Up

The Vertex option will calculate the tax rates for each customer and ship-to record in Elliott.  This is achieved by assigning a Geo Code to each record and the Geo Code is used to find the appropriate rates in the Vertex Rate Table.  Rates and Geo Codes are updated on a monthly basis from Vertex.  Utilities are provided to import that data into Elliott and tax rates are calculated with that data. Elliott has two utilities to generate the Geo Codes, one for the AR Customer file and one for the COP Ship-To file. The previous utilities only used the state and zip code to generate the Geo Code and the report provided little information.



Unless you knew to investigate incomplete Geo Codes, some records may be left with invalid Geo Codes, and a Geo Code of zeros would make the tax rates zero.

The new report gives a lot more information, including: the city, state, and zip code in the record; the city and state of the Elliott zip code lookup; the old Geo Code; the new Geo Code; and the status of the Geo Code generation.



We improved the utilities to use several methods to generate a valid Geo Code.  If the state and zip code produce a valid Geo Code and the new code is different from the one in Elliott, the record is printed with a status of ERROR.  Vertex uses the state for the calculation when a 5-digit zip code is provided.  When a 10-digit (5 plus 4) zip code is provided, the state is ignored.  For this reason, we also provide the city and state from the Elliott Zip Codes file using the base 5-digit zip code.  The Elliott data has no bearing on the calculation, but is provided as a reference.  That way you can make sure the city and state in the record are consistent with the ones found in the Elliott Zip Codes file.  If the zip code does not have a record in the Elliott Zip Codes file, the Zip Lookup City will be printed as "*** NOT FOUND ***".

If Vertex returns an invalid Geo Code for a 10-digit zip code, the utility will remove the zip extension and try with the base 5-digit zip code.  Even if the base zip returns a valid Geo Code, the record preserves the full 10-digit zip for reference.  The status is given as "Update: Zip extension ignored."  In these cases, you should review the record to make sure the full zip code is correct.

If Vertex returns an invalid Geo Code for a 5-digit zip code, the utility will use just the state.  This will return a partial Geo Code with the county and city as zero, but the result will be closer than all zeros.  The status is given as an error so you can easily identify the problem record.

If a record does not have a city, state, and zip code, the warehouse location is used as the Geo Code.  It is assumed that customers without an address are point-of-sale customers and the selling location should be used for the tax calculation.

Records that are updated will have the new Geo Code saved.  Running the report again should have those records removed from the report since the calculated Geo Code should now match the one that was saved.  That way you can run the report again to see just the errors.  Because of this, we now make the report mode the same as a post, requiring you to either print to a printer or spool the report to disk.

Modified Programs: CUSGEOSN, CUSGEOGF, SHPGEOSN, SHPGEOGF
MAD





    • Related Articles

    • ARSHPMNT Accounts Receivable Ship Via Code File Maintenance

      Ship Via Code File Maintenance Application Overview When you are setting up your Customer file, you will be asked to enter for each customer a Ship Via Code. This code will designate the usual method that you use for shipping purchased goods to this ...

    • CP0200 Customer Order Processing Print Pick/Pack Tickets and Ship Labels

      Print Pick/Pack Tickets & Ship Labels Application Overview Picking Tickets are documents that list all the items in the order that are eligible to be taken from stock (picked) and shipped from a particular warehouse. These items are listed in order ...

    • AP1901 Accounts Payable Ship Via Code File Maintenance

      Ship Via Code File Maintenance Application Overview The Ship Via Code File represents the method of shipment normally used by the vendor. It is used in the Purchase Order and Receiving package when purchase orders are being entered. Whenever the Ship ...

    • CP1001 Customer Order Processing Ship-To File Maintenance

      Price Code File Maintenance Application Overview The pricing system is based on price break tables. For example, you could set up a table such that when over 100 of an item are ordered, there is a 5% discount, when over 200 are ordered, there is a ...

    • Can I Delete a Ship-To Location in COP?

      Release Date: 05/08/2024 Version: 7.x & Up Q - Does it cause an integrity issue if we delete a ship-to and go back to using the customer file address only? They have some customers who never needed a ship-to but one had been added when they first ...