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

(1) Share

Report

Posted on by jack

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:

Dynamics 365 Business Central

All responses (2)

Answers (1)

Suggested answer

Ben Baxter 5,823 Super User 2025 Season 1 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 84,557 Super User 2025 Season 1 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