Hi Everyone,

I am trying to create a GridView to see the new customer fields from AR 9.0A. At the moment, I do not seem to be able to see the new address fields (Street1, Street2 and Street3).

I would like to know if it is possible to create a gridView that will allow me to view these fields.

The idea here is to quickly view and sort customers based on the Formatted Address Fields and allow one of our employees to clean up some of the data.

When AR 9.0A does the conversion, it does a really good job but because all our customers were not all done properly, we need to clean up the mess left behind.

Thanks in advance
Yann

Hi, Yann,

Basically, when you look at the addresses in GridView, a formatted address would use Address1, Address2, Address3, City, State/Prov, Country and Zip/Postal.

However, if you look at the Address4 field, you'll see more of what the unformatted address would look like. The unformatted addresses use Address1, Address2, Address3, Address4 and Zip/Postal. They do not use the City, State/Prov or Country fields.

You are also able to see the Formatted Address field which should tell you whether the address was formatted on conversion or not. (Note that if the address was formatted at conversion and the flag is subsequently turned off, the City, State/Prov and Country fields are still populated.)