BeyondERP.Newsletter
Menu

Page · Sales and marketing

Open sales order lines

A list page that shows open sales order lines with the customer, sales order, item, ship date, deliver remainder and quantity.

Business process
Manage sales orders
Menu item
SalesLineOpenOrder
Main table
SalesLine
Data entity
SalesOrderLineV2Entity
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 list page that shows open sales order lines with the customer, sales order, item, ship date, deliver remainder and quantity.
What you do hereUse this page to see which sales order lines are still open across all customers and orders, and what quantity remains to be delivered.
ExampleFor example, BEAT's planner opens Open sales order lines on Friday, sorts by Ship date and finds 7 lines due Monday with a total Deliver remainder of 230.00 pcs, so the warehouse plans picking for them first.
Open sales order lines 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 order lines
Set up firstAll sales orders Microsoft Learn
Used next byGenerate picking list Microsoft Learn
Related pagesBackorder lines Microsoft Learn
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

Plan shipments from open sales order lines

See which open lines are due and how much remains to ship.

Steps from Microsoft

  1. Go to Sales and marketing > Sales orders > Open orders > Open sales order lines.
  2. Sort or filter by Ship date to see the lines due next.
  3. Compare Deliver remainder with Quantity to spot partly shipped lines.
  4. Select Display dimensions to show the site and warehouse of each line.
  5. Open the Sales order tab for the order and generate the picking list for the lines due.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Deliver remainderThe quantity on the line that is still to be delivered.Microsoft Learn 30.00
Ship dateThe date the line is planned to ship.Checked in Dynamics 3652026-11-16
QuantityThe ordered quantity of the line.Checked in Dynamics 36550.00

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 line of 50.00 pcs.
  2. Post a packing slip with Update 20.00.
  3. Open Open sales order lines and check Deliver remainder is 30.00.
  4. Ship the rest and check the line disappears.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Plan shipments from open sales order linesFilter by Ship date first and show the site and warehouse dimensions.Lines from different sites ship on separate packing slips, so planning per warehouse needs the dimensions shown.Which date drives the shipping plan?Reading Quantity as what is left: Deliver remainder is what still has to ship.Test: Deliver remainder after partial shipment

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: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: The list changes no data. Checked in Dynamics 365
If you change it laterA list only. Deliver remainder goes down as packing slips are posted. Microsoft Learn
Technical architect

6Technical

Menu itemSalesLineOpenOrder Checked in Dynamics 365
FormSalesLineOpenOrder Checked in Dynamics 365
TableSalesLineShown as “Order lines” in Record infoKey field: SalesId, LineNumChecked in Dynamics 365
Data entitiesSalesOrderLineV2EntitySales order lines V2 Microsoft data model ProjSalesItemRequirementEntityProject item requirements Microsoft data model ReturnOrderLineEntityReturn order lines 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 pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=SalesLineOpenOrder
Integrate withSalesOrderLineV2Entity data entity Microsoft data model
Data migrationSalesOrderLineV2Entity Sales order lines V2: loaded for each company.Load order: Load Sales order headers V2 first, then Sales order lines V2: the lines entity needs the header created first.Load first: Sales order headers V2Microsoft Learn
Table definitionSalesLine columns and relations Microsoft data model
Everyone

8Sources