ANS-0592 · PURCHASE & VENDOR MANAGEMENT
How to Display Vendor Part Numbers on NetSuite Purchase Orders
Understand how to configure NetSuite item records and customize purchase order forms to show vendor-specific product identifiers.
Short answer
While NetSuite allows storing a Vendor Part Number (or SKU) on an item record, displaying this information on a Purchase Order requires specific form customization. The Vendor Part Number does not automatically populate the standard 'Vendor Name' column, which is reserved for the vendor's company name. Users must add a custom field to the Purchase Order form to show the vendor-specific code.
Scenario
Users often need to include vendor-specific part numbers or SKUs on Purchase Orders to ensure accurate ordering and communication with suppliers. The challenge arises when attempting to display the 'CODE' (Vendor Part Number/SKU) stored on the item record directly onto the Purchase Order transaction form.
Solution
The Vendor Part Number (often referred to as 'CODE' or 'Vendor SKU') can be stored on the item record in NetSuite. However, to display this vendor-specific identifier on a Purchase Order, it is necessary to customize the transaction form. The 'Vendor Name' column on the Purchase Order is intended to display the vendor's company name and does not automatically populate with the item's Vendor Part Number.To include the Vendor Part Number on a Purchase Order:
Ensure the Vendor Part Number is correctly entered on the relevant item records. This is typically found in a field such as 'Vendor Part Number' or 'Vendor SKU' on the item record.
Customize the Purchase Order transaction form to add a custom field that sources the Vendor Part Number from the item sublist. This involves navigating to Customization > Forms > Transaction Forms, editing the desired Purchase Order form, and adding a custom column field to the 'Items' sublist.
Configure the custom column field to source its value from the item's Vendor Part Number field.
Expert NetSuite Support
Need help with this NetSuite issue?
Purchase & Vendor Management consulting and configuration support