RE: How to create address table that keys off of a unique identifier
I am very new to creating custom records and would love some assistance. I am attempting to create a list of Amazon Vendor Central DC addresses, all of which have their own SAN address code. This SAN code is the only thing sent on the inbound PO from Amazon so I need to be able to query this list of addresses by keying off of this SAN code and populate the Ship To Address on the Sales Order. Can someone please walk me through how to make this happen or point me in the direction of some useful resources on the web? I have looked up all the Suite Answers I could find on Custom Records and done some extensive googling, but I can’t find any articles with my particular use case. Any help would be greatly appreciated. Thank you in advance.
I would recommend using the SAN code as your address label. That will let you pick a particular address based on the SAN code. If you are using the ODBC driver (suiteanalytics connect) you can easily pull the address information you need for the shipTo address.