Hi,
We have a number of accounts where the additional information i.e. the name of the house or the name of the business is listed in street2 when it would make more sense to be street1.
There are far to many that are all in the correct order to be able to simply switch the T_DEFAULT setting of ADDRESS_STREET_ORDER.
Has anyone else experienced a similar problem / have a solution?
Thanks,
Caspian
When we did our upgrade to v11 we changed the optional address, address1 to follow the street1, street2, street3 order which meant the majority of our addresses were then backwards.
We wrote a SQL script to take the data and move it to the correct fields so that all our address were in the correct format (once we made sure the website was also writing back correctly). As this was the majority of our database it took a long time to run and had to be run out of hours.
As I say our was probably an easier process as we did it with the v11 upgrade, so we knew the exact point in time the change was happening and which accounts would be affected etc.
Caryl