[b][/b]Here's the problem when our consultant upgraded us to the A/R 9.0A Level it was incorrectly done. Our A/R Customer Header Profile has our Customer Account's which we have over 40,000 in the database
If the conversion was done correctly the line 3 is the city and line 4 is the state.
Here's the Problem!
Mostly all of the Customers have Line Three as the City Correct BUT in Line Four added the City before the State with a comma in-between. Now the Question how can I fix this problem?
Lester Frischman
Best Buy Uniforms
Pittsburgh PA

Hi Lester,

I presume that you did not want the customer to have the addresses 'formatted' by the conversion process, but would prefer to have the old way with the City in address field 3 and the state in address field 4.

The way to fix this so that all (selected) customers have their addresses unformatted are:

- Get the Nov 11, 2009 hot fix for Receivables 90A as it fixes an issue with importing customer addresses
- Export your customers to an Excel spreadsheet - just the customer code, name and 4 address fields. Ensure that the 3rd and 4th address fields have the desired city and state information and make corrections as necessary, including the use of formulas or macros if needed to fix 40,000 records.
- Edit the company profile and on the 'System options' tab, ensure that the 'Format address' option is not selected.
- Ensure that you have a backup of your Receivables data.
- Re-import the customers using the Import Customer function, overwriting existing customers. Select only the same customer code, name and 4 address lines as fields to import.

Doing this will revert the customer addresses back to how they were. You may want assistance from your Adagio consultant if desired.

Hi Lester,

Just before you go to that trouble, you should probably clarify where exactly you are seeing the badly formatted addresses. When you call up a customer in Adagio Receivables to View or Edit, is their address correctly formatted? If so, and the bad formatting is on your printed invoices, credit notes or statement, then there is still some conversion work required in adjusting the address fields being used on your specifications. You won't have to import and export all your customers (although that is the easiest way of making mass changes to the way the addresses are presented).