BeyondERP.Newsletter
Menu

Master data page · Sales and marketing

All customers

The list of customer accounts of the legal entity. Each customer is an organization or a person and carries the defaults (customer group, terms of payment, credit limit, delivery and tax settings) that sales orders copy.

Business process
Manage (create, update, delete) contacts and accounts manually in Dynamics 365 finance and operations app
Menu item
CustTableListPage
Main table
CustTable
Data entity
CustCustomerV3Entity
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 isThe list of customer accounts of the legal entity. Each customer is an organization or a person and carries the defaults (customer group, terms of payment, credit limit, delivery and tax settings) that sales orders copy.
What you do hereUse this page to create and maintain customer accounts, set the credit limit the credit check uses, and start quotations and sales orders for a customer.
ExampleFor example, BEAT creates customer BEAT-000123 (Type Organization) in customer group WHOLESALE with terms of payment Net30 and a credit limit of 25,000.00, then starts sales order SO-001234 for it from the Sell tab.
All customers 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.

Setup steps on this page

Create and maintain customer accounts

Set up customer accounts so that orders copy the right defaults and the credit check works.

Steps from Microsoft

  1. Go to Sales and marketing > Customers > All customers.
  2. Select New, enter the Customer account (or let the number sequence fill it), and set Type to Organization or Person.
  3. Enter the Name and select the Customer group, then select Save.
  4. On the Credit and collections FastTab, enter the Credit limit; set Mandatory credit limit if the Credit limit type in the parameters is None but this customer must still be checked.
  5. On the Payment defaults FastTab, select the Terms of payment and Method of payment.
  6. On the Sell tab, select Sales order to create the first order for the customer.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Customer groupThe group the customer belongs to; groups supply shared defaults, and every new customer needs one.Microsoft Learn CustGroup
Credit limitThe most credit you extend to the customer. It must be higher than 0.00 to be used as the credit limit, and it's checked when documents are updated.Microsoft Learn 25,000.00CreditMax
Terms of paymentHow due dates are calculated for the customer's invoices; the terms are used on the customer's documents.Microsoft Learn PaymTermId
Invoicing and delivery on holdBlocks the customer; while it's set, shipments for the customer can't be confirmed.Microsoft Learn NoBlocked
Mandatory credit limitWhen the Credit limit type is None, selecting this makes the system still check this customer's credit limit against the balance.Microsoft Learn YesMandatoryCreditLimit
TypeOrganization for a commercial customer, Person for a consumer. Both are stored in the same customer table.Microsoft Learn Organization

Common errors and fixes

MessageWhat to do
Shipment %1 cannot be confirmed because customer is on hold for %2.Clear the reason for the hold, then on the customer's Credit and collections FastTab set Invoicing and delivery on hold to No and confirm the shipment again. Repeat for every blocked customer on the load. Microsoft Learn

Test checklist

  1. With Credit management blocking rules and checkpoints set up, open a test customer and on the Credit and collections FastTab set Credit limit to 0.00 and Mandatory credit limit to Yes.
  2. Create and confirm a sales order for that customer.
  3. Check that Message details shows 'Order has been sent to credit management' and that the order is on Credit and collections > Credit management hold list > All credit holds.
  4. Set Unlimited credit limit to Yes on the same customer, create and confirm another order, and check that it isn't put on hold.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Create and maintain customer accountsDecide the customer account numbering (number sequence) before go-live, and set Customer group, Terms of payment and Credit limit on every customer you sell to on credit.The customer account ID can only be changed later with Rename, which rewrites every reference to the old ID; the other defaults are copied to each new order.Should customer accounts be numbered automatically?Leaving the credit limit at 0.00 and assuming that means no credit: a credit limit is only used when it's higher than zero, so the check behaves differently from what users expect.Test: New customer with credit limit

Feature management and licence

Licence or add-inOn the live system, Sales clerk, Sales manager, Sales representative and Accounts receivable clerk use this page. Credit limit checks on this page follow the Credit management feature, which is on by default and needs blocking rules; the classic credit limit check applies only when that feature is off.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyPer company: each legal entity keeps its own customer accounts, unless cross-company data sharing is set up for customers. Microsoft Learn
Can it be undoneHard to reverse: Most fields can be edited at any time (with customer approvals on, fields enabled for approval go through the Proposed customer change workflow). The customer account ID is the exception: it can only be changed with Rename, which rewrites every reference to the old ID and can fail on large data volumes. If a rename stops halfway, the Customer account rename data maintenance page finishes the out-of-sync records. Pick the numbering scheme before go-live. Microsoft Learn
If you change it laterWhen customer approvals are turned on, changes to fields enabled for approval are held as proposed changes and only applied after the workflow is approved. Microsoft Learn
Technical architect

6Technical

Menu itemCustTableListPage Checked in Dynamics 365
FormCustTable Checked in Dynamics 365
TableCustTableShown as “Customers” in Record infoChecked in Dynamics 365
Data entitiesCustCustomerV3EntityCustomers V3 Microsoft data model CustCustomerBaseEntityCustomer definitions Microsoft data model CustCustomerDetailV2EntityCustomer details V2 Microsoft data model CustCollectionsBICustTableCustomers Microsoft data model DimAttributeCustTableEntityCustomers Microsoft data model
Roles to set it up and use itTo set it up or change itSales manager TradeSalesManagerRental manager RentalManagerAccounts receivable manager CustInvoiceAccountsReceivableManagerCredit management manager CredManManagerCredit management clerk CredManClerkTo use itRental coordinator agent RentalCoordinatorAgentAccounts receivable clerk CustInvoiceAccountsReceivableClerkSales clerk TradeSalesClerkSales representative TradeSalesRepresentativeRetail service RetailServiceGive people one of these roles. On this system, 38 roles can open this page.Checked in Dynamics 365
Actions on the pageCustomer: Accounts, Transactions, Balance, Forecast, Set up, Attachments, Catalogs, Customer service, Registration, PropertiesSell: New, Related information, Trade agreements, Set up, Approved customerInvoice: New, Set up, Journals, Related informationCollect: New, Collection letters, Interest note adjustment, Interest, Customer balances, Settle, DeductionsProjects: New, Project control, Related informationService: New, Related informationMarket: Campaigns, Telemarketing, MailingsCommerce: Related information, Media, Attributes, LoyaltyGeneral: New, Activities, Accounts, Set up, StatisticsOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=CustTableListPage
Integrate withCustCustomerV3Entity data entity Microsoft data model
Data migrationCustCustomerV3Entity Customers V3: loaded for each company.Load order: Load customer groups first (every new customer needs one) and terms of payment, then Customers V3, then any detail entities.Load first: Customer groups, Terms of paymentMicrosoft Learn
Table definitionCustTable columns and relations Microsoft data model
Everyone

8Sources