Hello all...
I am creating a Customer Saved Search to include Address Internal ID and Addresses.
I want to include all the Customer Addresses including the Address Internal ID.
I started with a simple Saved Search from the Customer record and selected the Address Internal ID
Intending to validate data, I also joined to the Address... table and selected the Internal ID and noticed, an additional field within the Address... table, Address Internal ID so I selected it as well.
I expected them all to be the same Address Internal ID.
Search columns from the Customer record
Search results for one Customer
Customer>Address subtab
The defaultaddress is 72947
Can anyone explain or point me to a SuiteAnswer that explains the difference between the fields:
Address Internal ID (Address Internal ID field without join)
Address : Internal ID (Internal ID field selected from join to Address...)
Address : Address Internal ID (Address Internal ID field selected from join to Address...)
I particularly can't find where the Address : Internal ID (Internal ID field selected from join to Address...) gets the value "55" from any address on this Customer.
I am going to rely on the "Address : Address Internal ID" (Address Internal ID field selected from join to Address...) simply because it is constant and matches the Customer>Address subtab, but I am interested to understand the differences...
Thanks all