BeyondERP.Newsletter
Menu

Setup step on the Sales origin page · Sales and marketing

Set up Sales origin

Use this page to track the origin of 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
SalesOrigin
Main table
SalesOrigin
Data entity
SalesOrderOriginEntity
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 setup list of sales origin codes that record how a sales order came in. A code can be given an origin type (Origin type assignment) so integrations can recognize their orders, for example orders created from Field Service work orders or from Dynamics 365 Sales.
What you do hereUse this page to track the origin of sales orders.
ExampleBEAT creates origin WORKORDER with Origin type assignment selected and Sales origin type Work order integration. Every sales order created from a Field Service work order, such as SO-001251 for 640.00 of spare parts, gets WORKORDER, shows the External work order status field, and isn't synchronized back to Field Service as a new work order.
Sales origin 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 Sales origin1 screen

Use this page to track the origin of sales orders.

  1. Screen 1

    Create a sales origin

    Go to Sales and marketing > Setup > Sales orders > Sales origin

    1. Select New
    2. Enter the sales origin code and description
    3. Select Save
    4. Select the origin on sales orders to track where they came from
    1Sales originBEAT-ORG
    DescriptionSales origin
    Sales origin typeNot specified
    Create a sales origin (zoomed on the outlined fields)
    Show the full screenCreate a sales origin
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Sales and marketing > Setup > Sales orders > Sales origin.
  2. Select New and enter a Sales origin code, for example WORKORDER, and a Description, for example Field Service Work Order.
  3. For an integration origin, select Origin type assignment and set Sales origin type to Work order integration (or Sales order integration for Dynamics 365 Sales).
  4. Select Save, then open a sales order created by the integration and check its Sales origin.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Sales originThe code for the sales origin.Microsoft Learn WEBOriginId
DescriptionA description of where the order came from.Microsoft Learn Sales originDescription
Sales origin typeThe integration type of the origin, for example Work order integration or Sales order integration. Used only when Origin type assignment is selected.Microsoft Learn Work order integrationOriginType
Origin type assignmentSelect it to give the origin a Sales origin type that an integration uses to recognize its sales orders.Microsoft Learn Yes

Common errors and fixes

MessageWhat to do
Sales orders created from work orders are sent back to Field Service as new work ordersCreate the sales origin of type Work order integration; it's used to filter those orders out of the synchronization from Supply Chain Management to Field Service. Microsoft Learn

Test checklist

  1. Create sales origin WORKORDER with Origin type assignment = Yes and Sales origin type = Work order integration.
  2. Create a work order with products in Field Service and let it synchronize.
  3. Open the resulting sales order and check that the sales origin is WORKORDER.
  4. Check that the External work order status field shows one of its 4 values on the Setup tab of the sales order header.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Sales originIf you integrate with Field Service, one sales origin with Origin type assignment = Yes and Sales origin type = Work order integrationThe integration mapping selects the sales origin of type Work order integration for every sales order created from a work order, which lets you track those orders.Which sales origins are needed?Not keeping work-order sales orders identifiable; sales orders that originate from work orders must not be synchronized back to Field Service as work orders.Test: Work order sales orders get the integration origin

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: Origin codes can be changed at any time; orders keep the origin they were created with.
If you change it laterIntegrations select the origin by its type, so changing or removing the Work order integration origin changes which orders are filtered out of the Field Service synchronization and whether the External work order status field shows. Microsoft Learn
Technical architect

6Technical

Menu itemSalesOrigin Checked in Dynamics 365
FormSalesOrigin Checked in Dynamics 365
TableSalesOriginShown as “Order origin codes” in Record infoKey field: OriginIdChecked in Dynamics 365
Data entitiesSalesOrderOriginEntitySales order origin codes Microsoft data model
Who can open itPrivilegesMaintain sales origins SalesOriginMaintainView sales origins SalesOriginViewDutiesEnable 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=SalesOrigin
Integrate withSalesOrderOriginEntity data entity Microsoft data model
Data migrationSalesOrderOriginEntity (Sales order origin codes): loaded for each company, in Microsoft's default template 330 - Sales and marketing.Load order: Microsoft's default template 330 - Sales and marketing loads Sales order origin codes 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 definitionSalesOrigin columns and relations Microsoft data model
Everyone

8Sources