BeyondERP.Newsletter
Menu

Setup step on the Open sales orders page · Sales and marketing

Follow up open sales orders

Find orders that still have quantity to ship.

Business process
Manage sales orders
Menu item
SalesTableListPageOpen
Main table
SalesTable
Data entity
SalesOrderHeaderV2Entity
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 list page of sales orders filtered to the orders that are still open, with their customer, invoice account, channel, release status and hold flag.
What you do hereUse this page to follow up on sales orders that are still in progress and to open the next step for each.
ExampleFor example, at month end BEAT's sales manager filters Open sales orders on customer BEAT-000123 and finds SO-001198 still open with 3.00 pcs not shipped, worth 225.00, and asks the warehouse to ship it before closing.
Open sales orders 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

Business processManage sales orders
Menu pathSales and marketing › Sales orders › Open orders › Open sales orders
Set up firstAll sales orders Microsoft Learn
Used next byPost packing slip Microsoft Learn
Related pagesOpen sales order lines Microsoft Learn
In this process Push sales order totals to Dynamics 365 Sales · Follow up backorder lines
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

Follow up open sales orders

Find orders that still have quantity to ship.

Steps from Microsoft

  1. Go to Sales and marketing > Sales orders > Open orders > Open sales orders.
  2. Filter by Sales order, Customer account or Customer name.
  3. Check the Release status and Do not process columns to see which orders are released or held.
  4. Open an order to see which lines are still not delivered.
  5. From the Pick and pack tab, post the packing slip for what has shipped.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
StatusOpen order until all lines are fully shipped; a partly shipped order stays Open order.Microsoft Learn Open order
Document statusThe last document that was updated and printed for the order.Microsoft Learn
Do not processMarked when the order is on hold, so it can't be processed further.Microsoft Learn NoMCROrderStopped
Release statusHow much of the order is released to the warehouse; it applies only to lines whose items use warehouse management processes.Microsoft Learn Released

Common errors and fixes

MessageWhat to do
Unable to post packing slip when stopping a sales order line after confirming the outbound shipment A quantity cannot be picked.On the related lines set Stopped to No (Line details FastTab, General tab), post the packing slip, then handle the customer's cancellation as a return. Microsoft Learn

Test checklist

  1. Create an order of 10.00 pcs and post a packing slip for 4.00 pcs.
  2. Open Open sales orders and check the order is listed.
  3. Post a packing slip for the remaining 6.00 pcs.
  4. Check the order no longer shows as open (Status Delivered).

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Follow up open sales ordersFilter first on customer or on Do not process, so held orders and shippable orders are handled separately.Held orders can't be picked or packed, so mixing them with shippable orders hides what the warehouse can act on.Who follows up open orders?Reading Open order as not shipped at all: a partly shipped order is still Open order; Document status shows Packing slip.Test: Partly shipped order stays open

Feature management and licence

Licence or add-inOn the live system, Sales clerk, Sales manager, Sales representative and Accounts receivable clerk use this page.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: sales orders belong to the legal entity they're created in. An intercompany chain creates a separate order in each legal entity. Microsoft Learn
Can it be undoneReversible: The list changes no data.
If you change it laterA list only. An order leaves it when all lines are fully shipped and its status changes from Open order to Delivered. Microsoft Learn
Technical architect

6Technical

Menu itemSalesTableListPageOpen Checked in Dynamics 365
FormSalesTableListPage Checked in Dynamics 365
TableSalesTableShown as “Sales orders” in Record infoChecked in Dynamics 365
Data entitiesSalesOrderHeaderV2EntitySales order headers V2 Microsoft data model SalesOrderHeaderV2ExistAddrReadOnlyEntitySales order headers V2 readonly with the delivery address Microsoft data model ReturnOrderHeaderEntityReturn order headers Microsoft data model CustCollectionsBISalesOnHoldSales orders on hold for customers Microsoft data model
Roles to set it up and use itTo set it up or change itRental manager RentalManagerRental coordinator agent RentalCoordinatorAgentRental sales manager RentalSalesManagerSales representative TradeSalesRepresentativeSales clerk TradeSalesClerkTo use itSales manager TradeSalesManagerAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable manager CustInvoiceAccountsReceivableManagerRental representative RentalRepresentativeAccounts receivable centralized payments clerk PaymAccountsReceivableCentralPaymClerkGive people one of these roles. On this system, 28 roles can open this page.Checked in Dynamics 365
Actions on the pageSales order: Maintain, Payments, Copy, View, Functions, Attachments, Clean up, Engineering change requestSell: Credit note, Charges, Tax, Calculate, Generate, Actions, Process, Apply, Journals, PrepaymentManage: Customer, Bank document, Intercompany tracing, Coupons, Revenue recognitionPick and packInvoice: Generate, Bill, Settle, Journals, DeductionsCommerce: Attributes, Inquiries, AffiliationsGeneral: Set up, Customer, Maintain, Related information, CAPAWarehouse: Related information, Loads, ActionsTransportation: Rating, InvoiceOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=SalesTableListPageOpen
Integrate withSalesOrderHeaderV2Entity data entity Microsoft data model
Data migrationSalesOrderHeaderV2Entity Sales order headers V2: loaded for each company, before Sales order lines V2.Load order: Load customers, items and released products first, then Sales order headers V2, then Sales order lines V2 (SalesOrderLineV2Entity).Load first: Customers V3, Released productsMicrosoft Learn
Table definitionSalesTable columns and relations Microsoft data model
Everyone

8Sources