RE: Address Ship to Internal ID in saved search

Trying to create a saved search that will include the ‘address ID’ from the Address ship to lines

The saved search will concatenate the customer ID – Address Ship to ID (example customer ID 1234, shipping address 5678. ((1234 – 5678))

Was wondering if anyone knew how to bring in the address ship to ID. I tried {shippingaddress.internalID} and {shippingaddress.exteralID} but that did not work.

Was wondering if someone knows the string text to access this address ID.

RE: Address Ship to Internal ID in saved search

yoantny Rookie Asked on March 10, 2020 in Saved Searches.
Add Comment
3 Answers

Address records have 2 ID fields. The one you want is named Address Internal ID in search columns. {shippingaddress.addressinternalid}

RE: Address Ship to Internal ID in saved search

Intermediate Answered on March 11, 2020.

I thought for sure that would work…

I tried {shippingaddress.addressinternalid} and it did not work. I received an ‘ERROR : Field Not Found’ error.

That was a really good idea – and I appreciate your help.

RE: Address Ship to Internal ID in saved search

on March 11, 2020.

Ok, new information: If I run a customer search, then {shippingaddress.addressinternalid} works! Thanks for your help. However, I am running a transaction / sales order search. When I do this, {shippingaddress.addressinternalid} returns an ERROR : Field Not Found.

Any ideas why that is?

on March 11, 2020.

I’m not sure that you can get the address internal id from transactions. Its not a field in the shipping address join.

on March 12, 2020.

You seem really smart on the subject, and I really appreciate your input.

I am writing a sales order/transaction search and {shippingaddress.internalid} returns a value, but it does not appear to be the ‘address internal id’. I was wondering, what field do you think that ties to {shippingaddress.internalid}? Any ideas on how to pull the shipping address internal ID into this order transaction saved search?

on March 12, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.