BeyondERP.Newsletter
Menu

Master data page · Procurement and sourcing

All vendors

The list page of vendor accounts, where each vendor record holds the information the system uses to fill in documents and track activity with that vendor.

Used by
Accounts payable clerk, Accounts payable manager, Purchasing agent and 19 more roles
Business process
Maintain vendors in Dynamics 365 Supply Chain Management
Menu item
VendTableListPage
Main table
VendTable
Data entity
VendVendorV2Entity
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isThe list page of vendor accounts, where each vendor record holds the information the system uses to fill in documents and track activity with that vendor.
What you do hereUse this page to create, edit, and manage vendor accounts, including the vendor group, hold status, bank information, tax, delivery, invoice and payment settings, and default financial dimensions.
ExampleSet up banking information for a vendor so that payments can be sent to it electronically.
All vendors 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

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 All vendors.
  2. On the Action Pane, select New.
  3. In the Vendor account field, enter a unique value, unless it fills in automatically.
  4. In the Name field, enter or select the vendor name.
  5. In the Group field, select a vendor group.
  6. Enter the Number of employees and the Organization number.
  7. In the Addresses section, select Add, choose a Purpose, enter the address and select OK.
  8. In the Contact information section, select Add and enter the contact details.
  9. Select Save.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
Vendor accountThe unique number that identifies the vendor; it can be numbered automatically.Microsoft Learn AccountNum
NameThe vendor's name; picking an existing party copies its address and contact details.Microsoft Learn Name
GroupThe vendor group, which supplies shared settings such as payment terms and posting accounts.Microsoft Learn VendGroup
Organization numberThe vendor's legal organization number.Microsoft Learn OrgNumber
PurposeWhat an address is used for, such as Invoice, Remit-to or SWIFT.Microsoft Learn
Vendor holdBlocks the vendor for chosen transaction types, such as invoices, payments, purchase orders or all.Microsoft Learn Blocked
Invoice accountThe account credited with the invoice amount when it differs from the vendor, for example a third party.Microsoft Learn InvoiceAccount

Test checklist

  1. Create a vendor of type Organization, assign a Group and fill the purchase, invoice and payment defaults.
  2. Create a purchase order for the vendor and check that the terms of payment, delivery terms and financial dimensions default from the vendor.
  3. Enter an Invoice account on a second vendor, create a vendor invoice from its purchase order and check the invoice is credited to the invoice account.
  4. Set Vendor hold to Purchase order and check that a new purchase order can't be created but an open invoice can still be processed.
  5. Try to delete a vendor that has a contact and confirm the system refuses.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Number sequences

ReferenceShared or per companyNote
Vendor accountPer companyNew records on this page take their Vendor account from the VendAccount reference; BEAT uses number sequence Acco_99. Checked in Dynamics 365
Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneHard to reverse: Settings such as terms of payment, delivery, tax and default financial dimensions are copied to new documents, so a later change only affects new documents. A vendor that is associated with other records, such as contacts or products, can't be deleted; put it on hold instead. Microsoft Learn
If you change it laterA vendor can't be deleted once other records, such as contacts or products, are linked to it. Microsoft Learn
Technical architect

6Technical

Menu itemVendTableListPage Checked in Dynamics 365
FormVendTable Checked in Dynamics 365
TableVendTableShown as “Vendors” in Record infoKey field: AccountNumChecked in Dynamics 365
Data entitiesVendVendorV2EntityVendors V2 Microsoft data model DimAttributeVendTableEntityVendors Microsoft data model VendPaymentBIVendTableVendors Microsoft data model VendPaymentBIVendTableV2Vendors Microsoft data model
Who can open itPrivilegesMaintain vendors VendTableMaintainView vendors VendTableViewDuties InvoiceCaptureMaintainInquire into vendor positive payments PaymVendPositivePayInquireInquire into vendor master VendVendorMasterInquireMaintain vendor master VendVendorMasterMaintain
22 security rolesAuditor AuditPolicyManagerChief executive officer CompanyChiefExecutiveOfficerChief financial officer CompanyChiefFinancialOfficerInvoice capture operator InvoiceCaptureOperatorLanded cost agent ITMAgentLanded cost manager ITMManagerAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialControllerAccounts payable centralized payments clerk PaymAccountsPayableCentralPaymClerkAccounts payable payments clerk PaymAccountsPayablePaymentsClerkAccounts payable positive payment clerk PaymPositivePaymentClerkTreasurer PaymTreasurerProject assistant ProjProjectClerkBuying agent TradeBuyingAgentPurchasing manager TradePurchasingManagerAccounts payable clerk VendInvoiceAccountsPayableClerkAccounts payable manager VendInvoiceAccountsPayableManagerPurchasing agent VendPurchasingAgentPurchasing Agent - Public Sector VendPurchasingAgent_PSNVendor account manager VendVendorAccountManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itPurchasing manager TradePurchasingManagerAccounts payable manager VendInvoiceAccountsPayableManagerPurchasing agent VendPurchasingAgentPurchasing Agent - Public Sector VendPurchasingAgent_PSNAccounting manager LedgerAccountingManagerTo use itBuying agent TradeBuyingAgentAccountant LedgerAccountantProject assistant ProjProjectClerkAccounts payable clerk VendInvoiceAccountsPayableClerkLanded cost agent ITMAgentGive people one of these roles. On this system, 22 roles can open this page.Checked in Dynamics 365
Actions on the pageVendor: Maintain, Copy, Set up, Transactions, Tax information, Related information, Registration, PropertiesProcurement: New, Related information, Agreements, Set upInvoice: New, Set up, Settle, Related information, PrepaymentGeneral: Activities, Set up, New, Accounts, Market, StatisticsChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=VendTableListPage
Integrate withVendVendorV2Entity data entity Microsoft data model
Data migrationVendVendorV2Entity (Vendors V2): loaded for each company, in Microsoft's default template 120 - Accounts payable.Load order: Microsoft's default template 120 - Accounts payable loads Vendors V2 at execution unit 1, level 120, sequence 35. Lower levels load first, and entities at the same level load in sequence order.Load first: the default templates at lower levels (System setup to Bank)Microsoft Learn
Table definitionVendTable columns and relations Microsoft data model
Everyone

8Sources