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.

susanncellier Rookie Asked on February 22, 2021 in SuiteBuilder.
Add Comment
2 Answers

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.

Advanced Answered on February 22, 2021.
Add Comment

Your Answer

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