Associating address with an account

snehapatel
Tera Contributor

2 hours ago

Hi,

 

I want to associate multiple addresses with an account like billing address, shipping address, site address etc. The OOTB table provided for the same is account_address_relationship table. However, whenever I try to create an entry into that table from the table form, the location reference field is always showing empty results.  On further investigation, I found that the reference qualifier for location field is set to javascript:new global.AddressMgmtUtils().getAccountLocationsRefQual(current.account) which in turn does the following

1) Lookup the locations in account_address_relationship table across account hierarchy

2) Lookup the locations in account_address_relationship table for the given address

3) Display the locations that are in list derived in point 1) but not present in list derived in point 2)

 

This logic will not allow to associate a location which is not associated with account hierarchy with given account. Could you please help in understanding is there any other OOTB way to achieve the same.

 

Thanks,

Sneha

 

0 Helpfuls
  • 100 Views
1 REPLY 1

pavani_paluri
Tera Guru

an hour ago

Hi @snehapatel ,

 

Out of the box, ServiceNow only lets you tie addresses to accounts if the location is already part of that account’s hierarchy. If you want to link “any location” (like a random site address not in the hierarchy), you’ll need to customize the reference qualifier.

 

Otherwise, the OOTB way is: add the location to the account hierarchy first, then create the address relationship.

 

Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for
Kind Regards,
Pavani P
0 Helpfuls