Upload USPS Zip Code for Site in Munis
- Knowledge Assistant
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
ZIP Codes
General BillingÂ
Accounts Receivable
An updated USPS City State Product needs to be imported into Enterprise ERP
Navigate to Enterprise ERP > System Administration > Miscellaneous Administration > Zip CodesÂ
Click Administration from the ribbon
Click Settings to modify the Zip Code Settings checkboxes as desired
Click Accept to save changes
Click Import
Click Choose import preferences radio buttons as desired
Click the magnifying glass in the Import file field to launch the Choose the USPS City State Product File to Import window
Drag and drop or click to upload the USPS City State Product file (must be in .txt format)
Click Accept
Click Yes in the Records Ready to Import window to import ZIP codes or No to return to ZIP Code Administration
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.
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