BeyondERP.Newsletter
Menu

Setup page · Sales and marketing

Order pools

A setup page where you create order pools, used to group sales orders.

Used by
Accounts receivable clerk, Accounts receivable manager, Accounts receivable centralized payments clerk and 6 more roles
Business process
Define order management policies for Dynamics 365 Supply Chain Management
Menu item
SalesPool
Main table
SalesPool
Data entity
SalesOrderPoolEntity
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 order pools, used to group sales orders.
What you do hereUse this page to group sales orders so you can filter and select them, for example to consolidate shipments.
ExampleBEAT creates order pool SHIPCONS and sets it as the Sales order pool on customers CUS-000214 and CUS-000233. A shipment consolidation policy filters on that pool, so the two orders SO-001234 and SO-001240 for CUS-000214 (1,250.00 and 860.00) go on one shipment when they are released to the warehouse.
Order pools 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 Order pools1 screen

Use this page to group sales orders so you can filter and select them, for example to consolidate shipments.

  1. Screen 1

    Create an order pool

    Go to Sales and marketing > Setup > Sales orders > Order pools

    1. Select New
    2. Enter the pool code and name
    3. Select Save
    4. Select the pool on sales orders, then filter by it, for example to consolidate shipments
    1PoolBEAT-POOL
    NameOrder pool
    Create an order pool (zoomed on the outlined fields)
    Show the full screenCreate an order pool
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Sales and marketing > Setup > Sales orders > Order pools.
  2. Create an order pool and enter a Pool value that isn't used by any other pool, for example SHIPCONS, and a Name.
  3. Open each customer in All customers and, on the Sales order defaults FastTab, set Sales order pool to the new pool.
  4. In the shipment consolidation policy, filter the query on Sales orders > Pool = SHIPCONS.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
PoolA short name that uniquely identifies the pool; it's set as the Sales order pool on customers and orders.Microsoft Learn SHIPCONSSalesPoolId
NameA name that fully describes the pool.Microsoft Learn Customers accepting consolidated shipmentsName

Common errors and fixes

MessageWhat to do
Orders of the same customer are not consolidated on one shipmentCheck that the orders carry the pool (it defaults from the customer to new orders) and that the consolidation policy query filters on that pool. Microsoft Learn

Test checklist

  1. Create order pool SHIPCONS and set it as Sales order pool on two customers.
  2. Create a shipment consolidation policy whose query filters Sales orders > Pool on SHIPCONS.
  3. Create two orders per customer and release them to the warehouse.
  4. In All shipments, check that there are 2 shipments, one per customer.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Order poolsCreate a pool for each group of orders you need to select together, such as customers that accept consolidated shipments, and set it as the Sales order pool on those customersA shipment consolidation policy can query the order pool to consolidate lines across orders, and the pool on the customer is used by default on the sales order header.What should order pools be used for?Creating the pool but not setting it on the customers, so new orders arrive without a pool and the consolidation policy skips them.Test: Pool defaults from customer and drives consolidation

Feature management and licence

Licence or add-inOn the live system, Sales manager, the Accounts receivable roles (clerk, manager, payments clerk, centralized payments clerk), Retail service and the Rental roles use 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 undoneReversible: Pools can be added or renamed at any time. Changing a customer's pool affects new orders; existing orders keep their pool unless you change it on the order. Microsoft Learn
If you change it laterThe pool on the customer defaults to new sales orders only; existing orders keep their pool unless changed on the order. Consolidation policies that query the pool start or stop grouping orders as soon as the pool changes. Microsoft Learn
Technical architect

6Technical

Menu itemSalesPool Checked in Dynamics 365
FormSalesPool Checked in Dynamics 365
TableSalesPoolShown as “Order pools” in Record infoChecked in Dynamics 365
Data entitiesSalesOrderPoolEntitySales order pools Microsoft data model
Who can open itPrivilegesMaintain order pools SalesPoolMaintainView order pools SalesPoolViewDutiesEnable quotation to sales order process RentalSalesQuotationToSlsOrdProcessEnableEnable quotation to sales order process SalesQuotationToSalesOrderProcessEnableInquire into quotation to sales order reference data SalesQuotationToSalesOrderRefDataInquir
9 security rolesAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable manager CustInvoiceAccountsReceivableManagerAccounts receivable centralized payments clerk PaymAccountsReceivableCentralPaymClerkAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerkRental coordinator agent RentalCoordinatorAgentRental manager RentalManagerRental sales manager RentalSalesManagerRetail service RetailServiceSales manager TradeSalesManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itSales manager TradeSalesManagerRental manager RentalManagerRental coordinator agent RentalCoordinatorAgentRental sales manager RentalSalesManagerAccounts receivable manager CustInvoiceAccountsReceivableManagerTo use itAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable centralized payments clerk PaymAccountsReceivableCentralPaymClerkAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerkGive people one of these roles. On this system, 9 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=SalesPool
Integrate withSalesOrderPoolEntity data entity Microsoft data model
Data migrationSalesOrderPoolEntity (Sales order pools): loaded for each company, in Microsoft's default template 140 - Accounts receivable.Load order: Microsoft's default template 140 - Accounts receivable loads Sales order pools at execution unit 1, level 30, sequence 10. 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 General ledger)Microsoft Learn
Table definitionSalesPool columns and relations Microsoft data model
Everyone

8Sources