Skip to Content

Looking up Items Based on Vendor

Hello:

Where in SAP Business One can you configure looking up items in a purchasing document based on vendor?

If this is not possible, that means hunting through every inventory item upon entering a purchase order.

By being able to look up by vendor, you would have a smaller list of items to "wade through".

Thank you!

John

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Jan 11 at 04:49 PM

    Hello John - you might look at the "List of Items" produced when you select the "Choose From List" icon under Item No. Column on the Purchase Order. You can use the Form Settings on the List of Items and select "Preferred Vendor" data field. Then "Group" by that field and the List of Item format will change. Play around with that a while and you will see what you can do...

    Regards, Zal

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 11 at 09:12 PM

    Hi Zal:

    I don't see "Preferred Vendor" in Forms Settings.

    John

    Add comment
    10|10000 characters needed characters exceeded

    • Hello John - this is the List of Items from the Purchase Order. Preferred Vendor is pretty far down the list.

      This field shows what you have entered on the Item Master Data record on the Purchasing Data Tab in the field titled "Preferred Vendor". The only way this is going to show is if you have that field filled out.

      Just make sure you select the "Group" on List of Items for Preferred Vendor - it will bring all Items which have the Preferred Vendor into one area for you to select...IF an item is not linked to a specific Preferred Vendor, it will be at the bottom of the groupings with a blank.

      Regards, Zal

  • Jan 12 at 03:54 AM

    Hi,

    Are you expecting items should be appeared as per selected vendor code into item no column?

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 13 at 11:33 PM

    Thank you, Zal!

    John

    Add comment
    10|10000 characters needed characters exceeded