BeyondERP.Newsletter
Menu

Setup step on the Vendor groups page · Sales and marketing

Agree vendor groups shared with prospects

Agree the vendor groups that both Accounts payable and the prospect records use.

Used by
Accounts payable manager, Vendor account manager, Purchasing manager
Business process
Maintain contacts and accounts
Menu item
VendGroup
Main table
VendGroup
Data entity
VendVendorGroupEntity
Setup steps
2 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page for groups of vendors. It is the Accounts payable vendor groups page, also reached from the prospect setup because prospect records have a vendor group field.
What you do hereUse this page to create and maintain vendor groups whose members share important parameters for posting, settlement and payment, reporting, and forecasting.
ExampleBEAT uses the vendor groups DOMESTIC (NET30) and IMPORT (NET60). A distributor that is first entered as prospect PRO-000190 and also supplies spare parts is given vendor group DOMESTIC on the prospect record.
Vendor groups 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.

Step by step, with screenshots

Agree vendor groups shared with prospects

Agree the vendor groups that both Accounts payable and the prospect records use.

Define vendor groups1 screen

Group vendors that share posting, settlement, payment and reporting defaults.

  1. Screen 1

    Create the vendor group

    Go to Accounts payable > Vendors > Vendor groups

    1. Select New
    2. Enter the group code, description and terms of payment
    1Vendor groupBEAT
    DescriptionSuppliers
    Terms of paymentNET30
    Create the vendor group (zoomed on the outlined fields)
    Show the full screenCreate the vendor group
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Sales and marketing > Setup > Prospects > Vendor groups.
  2. Select New to add a vendor group, and enter the Vendor group code and a Description.
  3. Fill in columns such as Terms of payment and Default tax group.
  4. Select Posting on the Action Pane to set up the ledger posting for items, accounts and sales tax codes by vendor group.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
PostingOpens the ledger posting setup for items, accounts and sales tax codes by vendor group.Microsoft Learn
Vendor groupThe code of the vendor group. A vendor group must be specified when you create a vendor, so at least one group must exist.Microsoft Learn DOMESTICVendGroup
DescriptionA description of the vendor group.Checked in Dynamics 365SuppliersName
Terms of paymentThe terms of payment that new vendors in the group get by default.Microsoft Learn NET30PaymTermId

Common errors and fixes

MessageWhat to do
A new vendor can't be saved without a vendor group.Create at least one vendor group first; a vendor group must be specified when you create a vendor. Microsoft Learn

Test checklist

  1. Create a vendor group DOMESTIC with terms NET30.
  2. Create a vendor in DOMESTIC.
  3. Open the vendor.
  4. Check that the vendor's terms of payment are NET30.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Agree vendor groups shared with prospectsUse the vendor groups that Accounts payable already maintains; don't create sales-only vendor groups from this menu.This is the Accounts payable vendor groups page; groups drive vendor defaults and posting, and prospect records only refer to them.Who owns the vendor group list?Creating a vendor group from the Sales and marketing menu without the Accounts payable posting setup, so vendors in it post without a group posting rule.Test: Vendor group defaults terms of payment
Define vendor groupsGroups that separate vendors needing different posting, settlement or payment defaults (for example domestic trade, foreign trade, intercompany), each with its terms of paymentLearn defines vendor groups as vendors that share important parameters for posting, settlement and payment, reporting and forecasting, and vendor posting profiles can be set per group (Account code = Group).Creating groups by vendor name alone without checking whether they need distinct posting or payment defaults.Test: AP baseline defaults flow from setup to invoice and payment

Feature management and licence

Licence or add-inOn the live system, Purchasing manager, Accounts payable manager and Vendor account manager can maintain this page.

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: Moving vendors to another group later affects only new documents.
If you change it laterVendor groups supply defaults to new vendors and drive posting set up by group. Prospect records also store a vendor group (smmBusRelTable.VendGroup). Microsoft Learn
Technical architect

6Technical

Menu itemVendGroup Checked in Dynamics 365
FormVendGroup Checked in Dynamics 365
TableVendGroupShown as “Vendor groups” in Record infoKey field: VendGroupChecked in Dynamics 365
Data entitiesVendVendorGroupEntityVendor groups Microsoft data model DimAttributeVendGroupEntityMicrosoft data model
Who can open itPrivilegesMaintain vendor groups VendGroupMaintainDutiesEnable vendor process VendVendorProcessEnable
3 security rolesPurchasing manager TradePurchasingManagerAccounts payable manager VendInvoiceAccountsPayableManagerVendor 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 VendInvoiceAccountsPayableManagerVendor account manager VendVendorAccountManagerGive people one of these roles. On this system, 3 roles can open this page.Checked in Dynamics 365
Actions on the pageVendor groupsChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=VendGroup
Integrate withVendVendorGroupEntity data entity Microsoft data model
Data migrationVendVendorGroupEntity (Vendor groups): loaded for each company, in Microsoft's default template 120 - Accounts payable.Load order: Microsoft's default template 120 - Accounts payable loads Vendor groups at execution unit 1, level 40, sequence 20. Lower levels load first, and entities at the same level load in sequence order.Load first: Sales tax groups, Terms of payment, the default templates at lower levels (System setup to dependency bands 30 to 90)Microsoft Learn
Table definitionVendGroup columns and relations Microsoft data model
Everyone

8Sources