BeyondERP.Newsletter
Menu

Job page · Sales and marketing

Correct sales order lines manually

A data-correction tool that shows the lines of one sales order above the inventory transactions of the selected line, so a trained user can correct line data that doesn't match its transactions.

Business process
Manage sales order changes
Menu item
SalesLineManualCorrection
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 data-correction tool that shows the lines of one sales order above the inventory transactions of the selected line, so a trained user can correct line data that doesn't match its transactions.
What you do hereUse it only to repair a sales order whose line quantities or status no longer match its inventory transactions, after the problem has been analysed and tested in a copy.
ExampleFor example, on BEAT order SO-001234 line 2 shows Deliver remainder 5.00 although its inventory transactions are all sold; support confirms the cause, the fix is tried in a copy, then the line is corrected here and the old values are logged in the change ticket.
Correct sales order lines manually 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 › Manage sales order changes
Menu pathSales and marketing › Periodic tasks › Clean up › Correct sales order lines manually
Set up firstAll sales orders Checked in Dynamics 365
Used next byAll sales orders Checked in Dynamics 365
Related pagesPick sales lines manually 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.

When to run it

When to run itOnly when a sales order line shows a quantity or status that doesn't match its inventory transactions and can't be fixed through the normal order process.
How oftenOn demand, only for the order with the data problem.

Source: Checked in Dynamics 365

Setup steps on this page

Restrict and control manual sales line correction

Repair sales order lines whose data no longer matches their inventory transactions, without creating new inconsistencies.

Steps from Microsoft

  1. Go to Sales and marketing > Periodic tasks > Clean up > Correct sales order lines manually.
  2. Reproduce the problem in a copy of production first and agree the correction with the person who owns the data.
  3. In the Sales order field, select the order, and compare Quantity, Line status, Deliver remainder and Invoice remainder of each line with the Inventory transactions tab below.
  4. Note the current values, correct the line, use Recalculate if you need it, and select Save.
  5. Reopen the sales order and check that line status and remaining quantities now match the inventory transactions.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Sales orderThe sales order whose lines you want to check.Checked in Dynamics 365SO-001234
Item numberThe item on the sales order line.Checked in Dynamics 365
QuantityThe quantity on the sales order line.Checked in Dynamics 36510.00
Line statusThe status of the sales order line.Microsoft Learn
Deliver remainderThe quantity still to be delivered on the line.Microsoft Learn 5.00
Invoice remainderThe quantity still to be invoiced on the line.Microsoft Learn
Issue statusThe issue status of each inventory transaction of the selected line.Checked in Dynamics 365
WarehouseThe warehouse of each inventory transaction of the selected line.Checked in Dynamics 365

Common errors and fixes

MessageWhat to do
The order status doesn't change after a line was corrected.The order status follows the line quantities: it becomes Invoiced only when Invoice remainder and Deliver remainder are 0 for all lines. Check every line, not only the corrected one. Microsoft Learn

Test checklist

  1. In a copy, open the order with the mismatch and note the line values.
  2. Correct the line and select Save.
  3. Check that Deliver remainder and Line status now fit the issue status of the transactions.
  4. Post the next document for the order and check it posts without error.

Source: Checked in Dynamics 365

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Restrict and control manual sales line correctionGive the duty only to named support users; reproduce the problem in a copy, log the old values, then correct one line and reopen the order.Saves go directly to the order line outside the normal process, and the line status and remainders decide what the next posting does.Who may correct sales order lines manually?Changing a line in production without noting the old values, so the change can't be put back.Test: Corrected line matches its transactions

Feature management and licence

Licence or add-inOn the live system, no standard role holds the Correct sales order lines manually duty; give it only to the few users who repair order data.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyOne sales order at a time, in the current legal entity. Microsoft data model
Can it be undoneHard to reverse: Changes are saved directly on the line and there is no undo on the page. Note the original values before you change them so you can put them back by hand, and try the fix in a copy first. Checked in Dynamics 365
If you change it laterSaves changes directly on the sales order line, outside the normal order process; line status and remainders drive what the next posting does. On the live system no standard role has the Correct sales order lines manually duty, so access must be granted on purpose. Checked in Dynamics 365
Technical architect

6Technical

Menu itemSalesLineManualCorrection Checked in Dynamics 365
FormSalesLineManualCorrection 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 ReturnOrderLineEntityReturn order lines Microsoft data model ProjSalesItemRequirementEntityProject item requirements Microsoft data model
Who can open itPrivilegesCorrect sales order lines manually SalesLineManualCorrectionDutiesCorrect sales order lines manually SalesLineManualCorrectionChecked in Dynamics 365
Actions on the pageSales order: InventoryOptions: Page options, Edit, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=SalesLineManualCorrection
Integrate withSalesOrderLineV2Entity data entity Microsoft data model
Data migrationSalesOrderLineV2Entity Loads sales order lines; it isn't a way to correct them.Load order: This page corrects existing lines; load sales order lines with Sales order lines V2 after the sales order headers.Checked in Dynamics 365
Table definitionSalesLine columns and relations Microsoft data model
Everyone

8Sources