web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Requisition Worksheet ...
Small and medium business | Business Central, N...
Answered

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

(1) ShareShare
ReportReport
Posted on by jack 13
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
  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 103,280 Super User 2026 Season 2 on at
    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
  • Suggested answer
    Ben Baxter Profile Picture
    Ben Baxter 7,224 Super User 2026 Season 2 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 715 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 452 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 371 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans