When creating a CloudExtend Excel template, the display name that appears on the record in NetSuite may be different than the field ID. The field ID is what is initially displayed in the template field list. If you are not sure of the field ID open the record in NetSuite.

To find the field ID simply click on the display name once you see the ? sign (1) and scroll down to the bottom. The field ID will be displayed (2). Once your template is loaded you can change the name of the field in the table header to make this easier for your end-users.

The display name is Entry No. but the field ID is a Tran ID. You would search for the Tran ID (not display name) when looking for the field in the template builder.

If you do not see the field IDs when you click on the display name, refer to this article on how to expose the field IDs.

Did this answer your question?