BeyondERP.Newsletter
Menu

Master data page · Procurement and sourcing

Approved vendor list by item

An inquiry page that gives an overview of all products and the vendors that are approved for them.

Used by
Accounts payable manager, Purchasing agent, Purchasing Agent - Public Sector and 2 more roles
Business process
Manage supplier relationships
Menu item
PdsInventInquiryApprovedVendorListByItem
Main table
PdsApprovedVendorList
Data entity
PurchProductApprovedVendorEntity
Show what matters for
PAGE GUIDEWhat the page does and how to use it7 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isAn inquiry page that gives an overview of all products and the vendors that are approved for them.
What you do hereUse this page to see which vendors are approved for an item, optionally for a specific period.
Approved vendor list by item page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processManage supplier relationships
Menu pathProcurement and sourcing › Vendors › Vendor/item relations › Approved vendor list by item
Set up firstApproved vendors (released product) Microsoft Learn
Related pagesApproved vendor list expiration Microsoft Learn Approved vendor list by vendor Microsoft Learn Approved vendor check method Microsoft Learn
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Steps from Microsoft

  1. Go to Procurement and sourcing > Vendors > Vendor/item relations > Approved vendor list by item.
  2. In the Item number field, select the product.
  3. To see vendors approved for a certain period, enter dates in the Effective and Expiration fields.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
Item numberThe item to show approved vendors for.Microsoft Learn
VendorThe account of the approved vendor.Microsoft Learn PdsApprovedVendor
EffectiveShow vendors approved on or after this date.Microsoft Learn

Common errors and fixes

MessageWhat to do
Vendor code %1 is not authorized for %2 on %3.The item's Approved vendor check method is Warning only or Not allowed and the vendor has no valid approval on that date. Approve the vendor for the item with the right Effective and Expiration dates, or change the check method on the released product. Microsoft Learn
Cannot create a record in Approved supplier list (PdsApproveVendorList). The 'Expiration' value needs to be greater than or equal to the 'Effective' value.You can only extend the approved period. To shorten it, delete or modify the existing records in the UI rather than through data management. Microsoft Learn

Test checklist

  1. On a released product, under Purchase > Approved vendor > Setup, add an approved vendor with an expiration date a few months ahead.
  2. Set the product's Approved vendor check method to Not allowed.
  3. Open Approved vendor list by item and check the vendor and dates are shown for the item.
  4. Add the item to a purchase order for a vendor that isn't approved and confirm the order line is blocked.

Source: Microsoft Learn

Solution architect

4Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneHard to reverse: You can always extend an approval period, but shortening it means deleting or editing the existing approval records in the UI. Through data management you can only extend periods, or use truncate, which deletes all approved vendor records. Microsoft Learn
Technical architect

5Technical

Menu itemPdsInventInquiryApprovedVendorListByItem Checked in Dynamics 365
FormPdsApprovedVendorList Checked in Dynamics 365
TablePdsApprovedVendorListShown as “Approved vendor list” in Record infoChecked in Dynamics 365
Data entitiesPurchProductApprovedVendorEntityApproved vendor list by products Microsoft data model
Who can open itPrivilegesMaintain approved vendor list PdsApprovedVendorListMaintainView approved vendor list PdsApprovedVendorListViewDutiesMaintain approved vendors PdsApprovedVendorsEnableEnable purchasing process ProcPurchasingProcessEnableInquire into purchasing policies ProcPurchasingProcessInquire
5 security rolesAuditor AuditPolicyManagerPurchasing manager TradePurchasingManagerAccounts payable manager VendInvoiceAccountsPayableManagerPurchasing agent VendPurchasingAgentPurchasing Agent - Public Sector VendPurchasingAgent_PSN
Checked in Dynamics 365
Roles to set it up and use itTo use itPurchasing manager TradePurchasingManagerAccounts payable manager VendInvoiceAccountsPayableManagerPurchasing agent VendPurchasingAgentPurchasing Agent - Public Sector VendPurchasingAgent_PSNAuditor AuditPolicyManagerGive people one of these roles. On this system, 5 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=PdsInventInquiryApprovedVendorListByItem
Integrate withPurchProductApprovedVendorEntity data entity Microsoft data model
Data migrationPurchProductApprovedVendorEntity (Approved vendor list by products): loaded for each company, in Microsoft's default template 320 - Procurement and sourcing.Load order: Microsoft's default template 320 - Procurement and sourcing loads Approved vendor list by products at execution unit 1, level 320, sequence 20. Lower levels load first, and entities at the same level load in sequence order.Load first: Vendors V2, Released products V2, the default templates at lower levels (System setup to Product management)Microsoft Learn
Table definitionPdsApprovedVendorList columns and relations Microsoft data model
Everyone

7Sources