News and Announcements icon

Dynamics 365 CommunityForums Business Central forum Requisition Worksheet ...

Business Central forum

Answered

Requisition Worksheet ( 'Vendor No.' and 'Supply From' Lookup table)

(1) Share

Report

Report

Posted on by jack

23

Good Afternoon,

I am experiencing a behavior with the requisition worksheet where if I try to select a vendor from the Vendor No. field, the lookup table opens the Item Vendor Catalog page instead of the vendor list. In my below example there is no applicable item variant for the specified item. Any assistance is appreciated.

Categories:

All responses Img

All responses (2)

Answers Img

Answers (1)

Suggested answer

Ben Baxter 4,591 Super User 2024 Season 2 on at

Like (0)

Report

Requisition Worksheet ( 'Vendor No.' and 'Supply From' Lookup table)

This is standard functionality, in both Req. and Planning Worksheets. Think of the Item Vendor Catalog as your list of Approved Vendors for a specific Item. The lookup goes here to help avoid Users from selecting a Vendor that either doesn't supply that Item or isn't approved by purchasing. If you know your Vendor No., the system allows you to type any Vendor Number on the Req. Worksheet Line.

As Zhu pointed out, this can be customized to pull the Vendor List rather than the Item Vendor Catalog.

Best Regards,

Ben Baxter

Accent Software Inc
Verified answer

YUN ZHU 70,124 Super User 2024 Season 2 on at

Like (1)

Report

Requisition Worksheet ( 'Vendor No.' and 'Supply From' Lookup table)

Hi, I tested it briefly, it's the same as yours., this is a standard behavior.

The following is the standard code:

table 246 "Requisition Line":

You can force the vendor page to open with a little customization.

LookupThroughItemVendorCatalog := not ItemVend.IsEmpty() or PreferItemVendorCatalog;

PS: This content is maintained on the following pages.

Hope this can give you some hints.

Thanks.

ZHU

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,564 Super User 2024 Season 2

#2

Martin Dráb 228,651 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans