BeyondERP.Newsletter
Menu

Setup page · Sales and marketing

External item description

A setup page where you create customer groups that share the same external item numbers, and keep those item numbers for each group.

Business process
Define order management policies for Dynamics 365 Supply Chain Management
Menu item
CustItemGroup
Main table
CustVendItemGroup
Data entity
PurchProductDescriptionVendorGroupEntity
Setup steps
1 on this page
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 isA setup page where you create customer groups that share the same external item numbers, and keep those item numbers for each group.
What you do hereUse this page to simplify the upkeep of customers' own item numbers when many customers use the same numbers.
ExampleFor example, BEAT sets up the group BUYASSOC for a buying association of 30 independent shops that all order BEAT-ITEM-001 as 'BA-7731', and sets Item - customer group BUYASSOC on the 30 shops instead of keeping 30 copies of the number.
External item description 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

Set up External item description1 screen

Use this page to simplify the upkeep of customers' own item numbers when many customers use the same numbers.

  1. Screen 1

    Create a customer group for external item descriptions

    Go to Sales and marketing > Setup > Items > External item description

    1. Select New
    2. Enter the group code and name
    3. Select Save
    4. Assign the group to customers, then use External item description to add the customers own item numbers for the group
    1External item description groupBEAT-EID
    NameExternal item group
    Create a customer group for external item descriptions (zoomed on the outlined fields)
    Show the full screenCreate a customer group for external item descriptions
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Sales and marketing > Setup > Items > External item description.
  2. Select New and enter the External item description group code and the Name.
  3. Select External item description on the Action Pane and add each item with the group's external item number and description.
  4. Set Item - customer group on each member customer's Sales order defaults FastTab.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
External item description groupThe ID of the customer group that shares the same external item numbers; customers join it through the Item - customer group field.Microsoft Learn BUYASSOCGroupId
NameThe name of the group.Checked in Dynamics 365Buying association shopsName

Common errors and fixes

MessageWhat to do
The group's external item number isn't found when you search a sales order line by it.Set Item - customer group on the customer's Sales order defaults FastTab to the group; without it, the group's numbers aren't used for that customer. Microsoft Learn

Test checklist

  1. Create an external item description group and add an item with its external item number and description.
  2. Set Item - customer group on a customer's Sales order defaults FastTab to the new group.
  3. Create a sales order for that customer, show the External column and search by the external item number.
  4. Check the Item number and Product name fill in from the selected external item.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up External item descriptionCreate a group only when several customers (for example a buying association) share the same item numbers; keep customer-specific numbers on the customer itselfGroups are there to simplify the upkeep of external item numbers when many customers use the same numbers; each customer joins a group through the Item - customer group field.Keep external item numbers per customer or per group?Creating the group and its item numbers but not setting Item - customer group on the customers' Sales order defaults FastTab. The group's numbers then aren't used for those customers.Test: Group number is found on a sales order line

Feature management and licence

Feature to turn onEnable lookup based search for Sales External Item Identifier field (Mandatory, on by default)
Licence or add-inOn the live system, Rental manager, Rental coordinator agent, Rental sales manager, Accounts receivable manager and Sales clerk can maintain this page, and Sales manager, Accounts receivable clerk, Sales representative, Customer service representative and Rental representative can use it.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: External item numbers are references, not inventory or ledger data. Note they are kept per legal entity, so changes must be made in each company. Microsoft Learn
If you change it laterExternal item numbers are used on external documents and in the External lookup on sales order lines for every customer in the group. Microsoft Learn
Technical architect

6Technical

Menu itemCustItemGroup Checked in Dynamics 365
FormCustVendItemGroup Checked in Dynamics 365
TableCustVendItemGroupShown as “External item description group” in Record infoChecked in Dynamics 365
Data entitiesPurchProductDescriptionVendorGroupEntityExternal item description vendor groups Microsoft data model SalesProductDescriptionCustomerGroupEntityExternal item description customer groups Microsoft data model
Roles to set it up and use itTo set it up or change itRental manager RentalManagerRental coordinator agent RentalCoordinatorAgentRental sales manager RentalSalesManagerAccounts receivable manager CustInvoiceAccountsReceivableManagerSales clerk TradeSalesClerkTo use itSales manager TradeSalesManagerAccounts receivable clerk CustInvoiceAccountsReceivableClerkSales representative TradeSalesRepresentativeCustomer service representative TradeCustomerServiceRepresentativeRental representative RentalRepresentativeGive people one of these roles. On this system, 25 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=CustItemGroup
Integrate withPurchProductDescriptionVendorGroupEntity data entity Microsoft data model
Data migrationSalesProductDescriptionCustomerGroupEntity (External item description customer groups): loaded for each company, in Microsoft's default template 330 - Sales and marketing.PurchProductDescriptionVendorGroupEntity (External item description vendor groups): the vendor groups kept in the same table, template 320 - Procurement and sourcing.Load order: Microsoft's default template 330 - Sales and marketing loads External item description customer groups at execution unit 1, level 30, sequence 10. Load the groups before the external item numbers and before the customers that point to them.Load first: the default templates at lower levels (System setup to General ledger), Released productsMicrosoft Learn
Table definitionCustVendItemGroup columns and relations Microsoft data model
Everyone

8Sources