I am trying to map a few fields to the item label in WMS.
Following the instructions here: NetSuite Applications Suite - Creating Custom Print Templates and Files (oracle.com) it mentions mapping user fields.
—The standard source records may not include the data you want to use for your label or document. Note the following options when setting up additional data:
- You can use the ten additional fields, named User Field, included in the standard source records.
For example, the source record for the standard WMS item labels is the WMS Auto Printing Rule Evaluation Data record. It supplies the data for the item name and item description that appears on standard item labels. This source record also contains other preconfigured item and transaction data, such as the item quantity and transaction number. If you choose this source record for your template, you can use any of these available data.
If you want to show additional data that is not preconfigured on this record, you can map them to the User Field fields.
For example, you want to display the item’s vendor on your item label in ZPL format. You can use User Field 1, the name of the first blank field in the WMS Auto Printing Rule Evaluation Data record. To set up this field, you can do the following:
- Using the ZPL template editor of your choice, you can add a line for the label of the vendor field.
- Add another line for the data of the vendor field. In this line, you can include the following string to map the vendor to User Field 1:
${record.custrecord_wms_user_field_1}
—
But it doesn’t say how to map data to the user fields.
I need to know how I can map mpn from the item record and legacy product code from the legacy product code tables to the record.custrecord_wms_user_field_1 and record.custrecord_wms_user_field_2 fields.
