In Sales Order Import, City, State and Zip Code Is Incorrect
Release Date: 06/17/2021
In the 30-digit address line, the three areas are as follows: the City is 15 digits long, followed by 2 spaces, then 2 digits for the state, then 1 digit space, then 10 digits for the zip code.
Version: 7.0 & Up
Q - I use COP -> Utility -> Sales Order Import -> Import -> New Sales Order Import to import Sales Orders into Elliott. But the Bill To and Ship To City, State and Zip is incorrect. Any idea why the addresses are importing incorrectly? They appear to be correct in the import file. Below is how it looks like in Order Entry:
A - The address area in your import ASCII file is currently in free-form format like the following:
You should format it to fixed position format for city, state and zip as follows:
In the 30-digit address line, the three areas are as follows: the City is 15 digits long, followed by 2 spaces, then 2 digits for the state, then 1 digit space, then 10 digits for the zip code.
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 ...CPIMPMNU Customer Order Processing Sales Order Import
Sales Order Import Application Overview The Sales Order Import module is designed to import a pre-defined ASCII file to create COP sales orders. It is intended to provide an easy way for developers to create add-on solutions for creating sales ...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 ...ARECIMNT Accounts Receivable Customers and Contacts Import Utility
Last Update: 03/20/2024 Version: 8.0 & Higher Introduction This utility was the first utility we developed to handle the import and update of customers and contacts at the same time. Since then, we have developed a separate utility to import or ...CPSLSDSK Customer Order Processing Sales Desk
Sales Desk Application Overview Sales Desk is designed for companies who need versatile order entry functions and improved customer service. It is designed to be used by salespersons, order entry personnel and telemarketers. Sales Desk is extremely ...