Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Pricing Matrix
Hi,
I used to use the following code to retrieve a price for an item, based on the currency, quantity and price level.
With the release of 2009.2 I think that the new 'matrix' APIs are a better way to do this, but I'm not sure how to go about figuring out the column that I would need to populate the API.
Below is the existing code which returns the item value:
var filter = new Array() filter[0] = new nlobjSearchFilter('maximumquantity','pricing','greaterthan',seats) filter[1] = new nlobjSearchFilter('minimumquantity','pricing','lessthanorequalto',seats) filter[2] = new nlobjSearchFilter('currency','pricing','anyof',currency) filter[3] = new nlobjSearchFilter('internalid',null,'anyof',item) filter[4] = new nlobjSearchFilter('pricelevel','pricing','anyof',pricelevel) var results = nlapiSearchRecord('item',null,filter,new nlobjSearchColumn('unitprice','pricing')) 0