How to create address table that keys off of a unique identifier

Hello,

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.

Rookie Asked on February 22, 2021 in SuiteBuilder.
Add Comment
2 Answer(s)

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.

Intermediate Answered on February 22, 2021.
Add Comment

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.

Rookie Answered on February 26, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor