BeyondERP.Newsletter
Menu

Page · Sales and marketing

Open return orders

A list page that shows return orders with a return status of Open, with their RMA number, customer, invoice account, return reason code and deadline.

Business process
Process customer returns and exchanges
Menu item
ReturnTableListPage_Open
Main table
SalesTable
Data entity
ReturnOrderHeaderEntity
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 return orders with a return status of Open, with their RMA number, customer, invoice account, return reason code and deadline.
What you do hereUse this page to find and work on return orders that are still open, create a new return order, and use the Return order tab for actions on the selected order.
ExampleFor example, on Monday BEAT's customer service filters Open return orders on Deadline and finds RMA-000041 for BEAT-000077 (3.00 pcs) expiring Wednesday, and calls the customer to ship it.
Open return 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 › Process customer returns and exchanges
Menu pathSales and marketing › Sales returns › Open return orders
Set up firstAll return orders Microsoft Learn
Used next byArrival overview Microsoft Learn
Related pagesClosed return orders 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

Follow up open return orders

Make sure open returns arrive before the deadline.

Steps from Microsoft

  1. Go to Sales and marketing > Sales returns > Open return orders.
  2. Sort by Deadline to see returns about to expire.
  3. Check the Return reason code of each.
  4. Open the return order to see its lines and arrival status.
  5. Register the arrival on Arrival overview when the goods come in.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
DeadlineThe last date the item can be returned: creation date plus the period of validity.Microsoft Learn 2026-11-12
Return statusFiltered to Open on this page.Microsoft Learn Open

Common errors and fixes

MessageWhat to do
The packing slip can't be generated for the return line.A return packing slip can be generated only for lines with Return status Registered and only for the full line quantity. Register the arrival (and disposition code) first, or split the line. Microsoft Learn

Test checklist

  1. Create a return and add a line.
  2. Check it appears when its status is Open.
  3. Register, post and invoice it.
  4. Check it leaves the list.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Follow up open return ordersSort by Deadline first.Expired returns need a decision.What happens to expired returns?Expecting to cancel open returns: only Created returns can be canceled.Test: Open return listed

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 laterReturn orders that are already Open can no longer be canceled. Microsoft Learn
Technical architect

6Technical

Menu itemReturnTableListPage_Open Checked in Dynamics 365
FormReturnTableListPage Checked in Dynamics 365
TableSalesTableShown as “Sales orders” in Record infoKey field: SalesIdChecked in Dynamics 365
Data entitiesReturnOrderHeaderEntityReturn order headers Microsoft data model SalesOrderHeaderV2EntitySales order headers V2 Microsoft data model SalesOrderHeaderV2ExistAddrReadOnlyEntitySales order headers V2 readonly with the delivery address 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, 29 roles can open this page.Checked in Dynamics 365
Actions on the pageReturn order: New, Maintain, Return, Charges, Send, Generate, Journals, Deductions, Attachments, Manage qualityGeneral: Intercompany tracing, Related information, NewOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=ReturnTableListPage_Open
Integrate withReturnOrderHeaderEntity data entity Microsoft data model
Data migrationReturnOrderHeaderEntity Return order headers: loaded for each company.Load order: Load return reason codes and disposition codes, customers and released products first, then Return order headers, then Return order lines (ReturnOrderLineEntity).Load first: Return reason codes, Customers V3Microsoft Learn
Table definitionSalesTable columns and relations Microsoft data model
Everyone

8Sources