Upload USPS Zip Code for Site in Munis

Owned by Knowledge Assistant
Last updated: Dec 04, 2024
2 min read



Description of Issue

How to import the USPS City State Product into Enterprise ERP

How to enable programs to automatically complete City and State values according to ZIP codes



Context

  • ZIP Codes

  • General Billing 

  • Accounts Receivable



Cause

An updated USPS City State Product needs to be imported into Enterprise ERP



Resolution

  1. Navigate to Enterprise ERP > System Administration > Miscellaneous Administration > Zip Codes 

  2. Click Administration from the ribbon

  3. Click  Settings to modify the Zip Code Settings checkboxes as desired

  4. Click Accept to save changes

  5. Click Import

  6. Click Choose import preferences radio buttons as desired

  7. Click the magnifying glass in the Import file field to launch the Choose the USPS City State Product File to Import window

  8. Drag and drop or click to upload the USPS City State Product file (must be in .txt format)

  9. Click Accept

  10. Click Yes in the Records Ready to Import window to import ZIP codes or No to return to ZIP Code Administration

  11. Click OK in the Import Complete window and/or click View Report to see the Warning Report. Note that ZIP codes will not import if they already exist in the database.



Additional Information

See below for a sample USPS City State Product file in .txt format, as provided by the USPS:


C     COPYRIGHT(C) 06-20 USPS 001
A37214  DONELSON                    PLZ     OLD LEBANON                 RD    O2007062700000026000000002799B
A37214  ELM HILL                    PIKE    TRAILS END                  LN    O2003110500000031550000003299B
A37214  PENNINGTON BND              RD      PENNINGTON BEND             RD    A20110825
A37214  PERIMETER PL                DR      PERIMETER PLACE             DR    A20110908
A37214  PLEASANT HILL               RD      BELL                        RD    O2007062700000031000000003799B
A37214  STEWARTS FERY               PIKE    STEWARTS FERRY              PIKE  A20110908
A37214  WOODLAND PT                 DR      WOODLAND POINTE             DR    A20110908
A37215    21ST                      AVE S   HILLSBORO                   PIKE  O2007062700000030000000003002E
A37215    21ST                      AVE S   HILLSBORO                   PIKE  O2007062700000031000000004098E
A37215    21ST                      AVE S   HILLSBORO                   PIKE  O2007062700000042000000004398E
A37215    21ST                      AVE S   HILLSBORO                   PIKE  O2007062700000050000000006398E
A37215    21ST                      AVE S   HILLSBORO                   PIKE  O2007062700000029110000002913O
A37215    21ST                      AVE S   HILLSBORO                   PIKE  O2007062700000030010000003937O
A37215    21ST                      AVE S   HILLSBORO                   PIKE  O2007062700000040010000004039O
A37215    21ST                      AVE S   HILLSBORO                   PIKE  O2007062700000041010000004399O
D35748Y10559 GURLEY                                   PYY10559GURLEY                      NC 013800AL089MADISON
D35749Y10574 HARVEST                                  PYY10574HARVEST                     YD 013940AL089MADISON
D35750Y10586 HAZEL GREEN                              PYY10586HAZEL GREEN                 ND 013990AL089MADISON
D35751Y10610 HOLLYTREE                                PYY10610HOLLYTREE                   NC 014150AL071JACKSON
D35752Y10611 HOLLYWOOD                                PYY10611HOLLYWOOD                   NC 014160AL071JACKSON
D35754Y10685 LACEYS SPRING                            PYY10685LACEYS SPRING               NC 014660AL103MORGAN
D35755Y10691 LANGSTON                                 PYY10691LANGSTON                    NC 014740AL071JACKSON
D35756Y10737 MADISON                                  PYY10737MADISON                     ND 015180AL083LIMESTONE
D35757Y10737 MADISON                                  PYY10737MADISON                     ND 015180AL089MADISON
D35758Y10737 MADISON                                  PYY10737MADISON                     YD 015180AL089MADISON
D35758Y11191 TRIANA                                   NYY10737MADISON                     YD 015180AL089MADISON
D35759Y10785 MERIDIANVILLE                            PYY10785MERIDIANVILLE               NC 015460AL089MADISON
D35760Y10866 NEW HOPE                                 PYY10866NEW HOPE                    NC 015990AL089MADISON
D35761Y10867 NEW MARKET                               PYY10867NEW MARKET                  NC 016000AL089MADISON
D35762Y10015PALABAMA A AND M                          NNY10874NORMAL                      NC 016060AL089MADISON
N00653NNNNNNNNNNNY
N00659NNNNNYYNNNNN
N00773NNNNNYYYNNNN
N00791NNNNNNYNNNNN
N01240NNNNNYYYYNNN
N01886NNNNYYYYYYNN
N01966NNNNNYYNNNNN
N02532NNNNNYYYNNNN
N02535NNNNNYYYYNNN
N02536NNNNNYYYNNNN
N02539NNNNNYYYNNNN
N02540NNNNNYYYNNNN
N02543NNNNNYYYNNNN
N02554NNNNNYYYNNNN
N02558NNNNNYYYNNNN
P00611
P00744
P00775
P00786
P01009
P01029
P01037
P01066
P01074
P01079
P01083
P01092
P01093
P01094
P01229
Z09008C52409754C52420200402
Z09017C00009103C00020200220
Z09520C34996649C34920191015
Z09582C24796692C24720181206
Z09583C30234087C30220200414
Z09591C11034085C11020181206
Z09755C16009015C16020200302
Z09852C00009803C00020200311
Z11413C00611437C00620190520
Z11437C00611413C00620190612
Z11437C00611413C00620190613
Z11518C00311557C00820191224
Z11518C00311557C00820191226
Z13365R00313339R00120200409
Z17033R00117022R00620200407