ANS-0717 · INVENTORY & ITEM MANAGEMENT
How to Access a Preferred Vendor’s Purchase Price in NetSuite Searches
Learn how to efficiently retrieve the purchase price from a preferred vendor using NetSuite's search functionalities.
Short answer
To access a preferred vendor's purchase price in NetSuite, utilize searches to find the "Vendor Price" field, identified by its internal ID "vendorcostentered". You can further refine your search results by applying a filter for "Is Preferred Vendor" to ensure only the relevant pricing from designated preferred vendors is displayed.
Scenario
Users often need to retrieve specific pricing information for items from their designated preferred vendors within NetSuite. The challenge lies in identifying the correct field and applying the appropriate filters to isolate this particular data point from potentially many vendor price records.
Solution
To access a preferred vendor's purchase price within NetSuite searches, follow these steps:
Locate and include the "Vendor Price" field in your search results. This field is internally identified as "vendorcostentered".
To ensure only the pricing from preferred vendors is returned, apply a filter for "Is Preferred Vendor" in your search criteria. This will narrow down the results to display only the desired values.
Expert NetSuite Support
Need help with this NetSuite issue?
Inventory & Item Management consulting and configuration support