BeyondERP.Newsletter
Menu

Setup step on the Vendor groups page · Accounts payable

Define vendor groups

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

Used by
Accounts payable manager, Vendor account manager, Purchasing manager
Business process
Process supplier invoices
Menu item
VendGroup
Main table
VendGroup
Data entity
VendVendorGroupEntity
Setup steps
1 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 basic Accounts payable setup page for groups of vendors.
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.
ExampleFor example, Adventure Works Cycles, which has many vendors to monitor, set up several vendor groups to make managing those vendors simpler.
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

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

How to use it

  1. Go to Accounts payable > Vendors > Vendor groups.
  2. Select New to add a vendor group.
  3. Fill in the Vendor group code and Description.
  4. Choose the Terms of payment and, if needed, the Default tax group.
  5. Select Edit or Delete to change or remove the selected group.
  6. Select Save.

Source: Checked in Dynamics 365

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 groupDOMESTICVendGroup
DescriptionA short description of the vendor group.Checked in Dynamics 365SuppliersName
Terms of paymentThe default terms of payment for new vendors in this group.Microsoft Learn NET30PaymTermId

Test checklist

  1. Create a group with terms of payment.
  2. Add a Group row for it on Vendor posting profiles with its own summary account.
  3. Create a vendor in the group and post an invoice.
  4. Check the vendor balance posts to the group's summary account and the due date follows the group's terms.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
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
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: Changing a group's assignment after vendors and transactions exist requires an impact check on defaults and posting behavior.
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 itAccounts payable manager VendInvoiceAccountsPayableManagerPurchasing manager TradePurchasingManagerVendor 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