Just noticed that new accounts created since our upgrade to v11 don't have a primary_address_no in t_customer. Is that the expected new behavior, or do I have a bigger problem here?
anxiously,
Brian
The new accounts are inheriting their addresses from their households, so don't actually have an address of their own.
Does that help?
Boann
Not entirely, unfortunately. Most of these new accounts are individuals, not households and are not affiliated with a household.
That is the correct behavior. Prior to v11 there were two ways of determining the primary address--one in T_CUSTOMER and the primary_ind column in T_ADDRESS. It's rarely a good idea to have two different ways of marking the same attribute so in v11 we stopped using the column in T_CUSTOMER.
Thanks Chuck. That makes sense (and I can rest a little easier now.)