How To: Mark Address Active or Inactive

Marking an address as inactive stops an address being displayed when creating/amending a Sales Order and prevents it being shown on reports. It is commonly used when a customer has moved address or the address is no longer required (such as a customer moving departments within a large organisation).

Deactivate an address

To deactivate an address shown in the active view:

  1. Open a Customer screen (show me how).
  2. Load the required customer record.
  3. Open the [ Detail | Address ] tab.
  4. Click 'All Addresses - Detail' icon on the top pane's action buttons to open the All Address Details dialog box.
  5. Focus on one address or green-select multiple addresses to deactivate more than one.
  6. Click on the BtnDeactivate.jpg button in the bottom right of the dialog. This action sets the selected address's inactivate_date field to today's date.
  7. Enter a tracking reason in the popup and click on OK.
  8. Click the OK button to close the dialog.

Activate an address shown in the inactive view

  1. Open a Customer screen (show me how).
  2. Load the required customer record.
  3. Open the [ Detail | Address ] tab.
  4. Click 'All Addresses - Detail' icon on the top pane's action buttons to open the All Address Details dialog box.
  5. Click on the BtnInactiveX.jpg button to show all inactive addresses.
  6. Focus on one address or green-select multiple addresses to activate more than one.
  7. Click on the BtnActivate.jpg button in the bottom right of the dialog. This action resets the selected address's inactivate_date field to zero (i.e. 30 Dec 1899).
  8. Enter a tracking reason in the popup and click on OK.
  9. Click the OK button to close the dialog.

Data Query

When run in the Data Query screen, the following will list all Customers/Suppliers with inactive addresses:

SELECT co.company_code, co.company_name
 , CASE ad.atype_id
 WHEN '1' THEN 'Invoice'
 WHEN '2' THEN 'Delivery'
 WHEN '3' THEN 'Statement'
 WHEN '4' THEN 'Other'
 ELSE 'Unrecognised'
 END AS 'address_type'
 , ad.address1, ad.address2, ad.locality, ad.town, ad.postcode 
 , cy.country, ad.hide_address, ad.inactivate_date
 FROM address AS ad
INNER JOIN company AS co ON co.company_id = ad.company_id
INNER JOIN country AS cy ON cy.country_id = ad.country_id
WHERE ad.inactivate_date <> '1899-12-30 00:00:00.000'
ORDER BY co.company_code, ad.address_id
/************************************************************
 Address - List Deactivated Addresses

 This data query is provided as a teaching aid and is not
 covered by your support agreement

 09-Jun-2011 Created (GKS)
************************************************************/


WARNING icon
Data Query is an Advanced User feature.

See Also


Did you find this article helpful?