Per the latest NCOA update, I've 1) inactivated the primary address 2) changed the type to NCOA update type, and 3) made the new uploaded addresses the new primary addresses.
However, several customers are showing the inactivated addresses in the general tab (in the envelope area), rather than the new primary ones. My question is, what exactly makes a given address show up on the envelope in the general tab?
I've already tried adjusting the Label column to no positive effect. Any thoughts or should I open a ticket?
Thanks, Tessiturians.
There's an address field in t_customer. If I recall that's what populates the general tab. That gets automatically updated when you update the primary from the client, but if you did it from sql server, you might have to update that as well.
A-HA! You are quite right. One wonders why the need for a primary_ind field in T_ADDRESS, if it has to be noted in T_CUSTOMER as well. Can I assume there's a sort of clean-up procedure to fix this in T_CUSTOMER or should I write my own?
I don't think there's a clean up proc. I would do a search in sql on t_address where primary_ind = 'Y' and address_no not in(select address_no from t_customer)
just to see what you're dealing with, then edit the query into an update statement.
Oh yeah - also what Amanda said. I'd check to see if you have addresses where the primary_ind = 'Y' and inactive = 'Y'