*This post is locked for comments
You can add the Address ID field to the SmartList but if you need the full address, that will require a custom SmartList using SmartList Builder that pulls in the Address detail from the Address Master.
Yes all I need is the address ID, what is that field called in the colums to add it?
Hi Janice,
The column name is ‘Primary Bill To Address Code’. You will require to change the column option All Columns to add this column.
Rubal, we have serveral address ID for each customer so it is not always the primary ID. Is there not just a Bill to or Shipto?
Janice, I think what you're looking for is 'Address ID'. This field is available to add in the Receivables Transaction SmartList.
Frank is right. If you are using the Receivable Transactions, Address Code column has the main address ID for the invoice.
If you are using the Sales transactions, ‘Primary Billto Address Code’ has the main Bill to address. Even though the column name is ‘Primary Billto Address Code’. However, it does not show PRIMARY address. This column has the address ID which you specified as Bill To address in the invoice. If you are looking for the Bill Address Code from customer card and not from the invoice, you can add column is ‘Primary Billto Address Code from Customer Master ’
Similarly, ship address columns are ‘Primary Shipto Address Code’ and ‘Primary Shipto Address Code from Customer Master ’
You can try adding all address codes columns in the smartlist and test to decide which one you need.
Rubal,
http://www.dynamicsgphelp.com/
Thank you all for you help with this
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
