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.
Probably the most sane way to do this is to Create a Custom Address Field and use it to fill in your SAN codes. Pick the address that has the matching SAN code for your transactions’s address.
If you ever create your sales orders manually, you probably want the SAN code in the address label too. Creating an order via a customization like SuiteTalk or SuiteScript will probably involve a customer search that uses the address join to find a matching customer and address.
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.