This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hello, what is the field name for Address in Location record in Advanced PDF Template?

If you click on the field name while viewing (not editing) the record a little help popup will appear and one of the details it will have is the field id which you can then reference in your PDF template.

Thanks for your reply,
It works some records. but for "Location" record, it doesn't work.

Do you have a custom record for "Location"?
Commonly some form of "Address" is how you'll find/access the info. Depending on what record you are working with some of them they might have slightly different names.

If you search in Suitescript Records Browser -- or go to <https://system.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2020_1/script/record/account.html>

It should help direct you to what you're looking for.

There is a default location field in Purchase Order. and default location has mainaddress_text field on it.

But when I try to use that field in PO template,

The field may exist, but if there's no data in it, it will come back blank.

A way to see if the field contains data, is to view the record, then add `&amp;xml=t` to the end of the url and then load the new url, that will give you the more raw view of the information. Should help with debugging.

This blog post goes into using this technique a bit -- <https://timdietrich.me/blog/netsuite-xml-representation-entity-transaction-records/>

I tried all method to get that id of that field.

Hmm. Sorry <@U01E5CAGWM6> we have hit the limit of what I have any real experience with.
If I think of anything I'll drop it in here.