This topic contains 2 replies, has 0 voices, and was last updated by dominicb 7 years, 6 months ago.

  • Author
    Posts
  • #4902

    dominicb

    I have a saved search which lists inventory items and want to add a column to display the cost price for the preferred vendor.

    I can get latest or average cost no problem, but can’t figure out how to get preferred vendor cost. Can anyone shed any light on how to do this?

    I can see using nlapiLoadRecord in a console that it’s in .linefields.itemvendor within an array, but am not sure how to get at this in a search?
    This is a cached copy. Click here to see the original post.

  • #4903

    torin@aminian.com

    You can do so by using the field Vendor Price. But you are also going to need to use a formula to remove vendors that are not preferred. Follow the criteria and results below. Let me know if you have any questions.

    On the Criteria Tab > Standard subtab : add the following:

    –Type > select types of items to include (Inventory, Assembly etc.)

    –Formula (Numeric) > Formula: case when {vendor} = {othervendor} then 1 else 0 end (on the dropdown below choose greater than or equal to 1)

    On the Results Tab > Columns subtab

    –Name

    –Description

    –Preferred Vendor

    –Vendor Price

    Torin Salerno

    Aminian Business Services

    NetSuite Support: support@aminian.com

    (949) 407-8416 | (888) 800-5207 x 16

  • #4904

    dominicb

    Thank Torin, that’s working great. I’d actually managed to get the {vendor} = {othervendor} bit, but hadn’t managed to figure out the logic to go with it.

You must be logged in to reply to this topic.