Suggested by Srikanth Pottabathini – New
When a field on a customer's address is changed, the system expires the old address and creates a new, active one. Both the new and old addresses are linked to the same location ID, and the old address is moved to the history tab. The problem is that addresses that are truly expired and no longer in use are also stored in the same history tab. As a result, there is no way to differentiate between a genuinely inactive address and an active address that has simply been modified. This makes it impossible to determine which addresses are truly inactive in our records.