cancel
Showing results for 
Search instead for 
Did you mean: 

Looking up Items Based on Vendor

former_member594505
Active Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

zal_parchem2
Active Contributor
0 Kudos

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

Answers (3)

Answers (3)

former_member594505
Active Participant
0 Kudos

Thank you, Zal!

John

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

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

Regards,

Nagarajan

former_member594505
Active Participant
0 Kudos

Hi Zal:

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

John

zal_parchem2
Active Contributor
0 Kudos

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