So ive used the php toolkit alot, which is pretty similar to saved search, often i build up saved searches in netsuite before using them or emulating them in the php toolkit.

In the toolkit i can do a simple record search , customer , internal id, and get a bunch of basic colums. Including Pricing Groups and Pricing Level for that customer.

The key is it also provides internalId's for each, be that the internal ID for the product discounted or the internalId for the Pricing Group.

Now if i try to make a saved search on a customer and get this info the best i can find is the result fields/columns:

Pricing Group & Group Pricing Level

&

Pricing Item & Item Pricing Level & Item Pricing Unit Price

This i nice but its pretty much useless programmatically as Pricing Group Name and Pricing Item Name are not unique fields so there's not really a way to look up for example the pricing level discount …

Now ive looked into the pricing area saved search, and the join-able Pricing Fields… but this is not much help as then you are dealing with every product and its price and the search times are too long.

Can there be away to get this info ? or maybe do a join against priceevel or pricinggroup 'tables'/record types…
This is a cached copy. Click here to see the original post.