Solved

Finding contacts with override set but no address

  • 27 November 2023
  • 3 replies
  • 49 views

I have a number of customers with a contact that has Override set on the contact’s address, and the address itself is blank.  I want to unset the Override value so they inherit the customer address.  I’m trying to create a generic inquiry that looks for contacts that match this, but Contact.OverrideAddress never returns a value, even on records that I know are set.  Looking at the DAC, it says “nonexistent in DB” so I don’t know how to find it.  Where do I search for that override setting?

icon

Best answer by Laura02 4 December 2023, 18:24

View original

3 replies

Badge +16

Hello,

I experienced the same behavior as you with the Override checkbox. I attempted to create a GI that will allow you to compare addresses.  In the example, I used Override on the first two addresses, modifying the first and making the second billing address blank as you describe.  For those customers where Override Billing Address is NOT checked… the main address is populated:

Analyze Customers with blank override addresses

To create the above GI, I connected the Address table a second time with a different alias:

Add Address table as BillingAddress

Join that I used for Billing Address:

Result is attached. I hope this helps you!

I found your question intriguing and interesting. Thanks!

Laura

I understand what you are doing but it does not match the issue I am looking at.  It’s the contact address that has a blank entry, not the business address.  Since you are linking the address table to the customer, you will get the address record for the customer entity and not the address record for any of the contacts.  Or I misunderstand.

Badge +16

I see what you mean. 

Please consider joining Customer to Contact, then Contact to Address. I am showing Acumatica standard Contacts Preview List, screen CR3020PL.

 

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved