Skip to main content



No record found.

Microsoft Dynamics SL forum

Tracking lost or deferred sales.

Posted on by Microsoft Employee

Is there a way to track line items that have been cancelled, deleted, closed, or reduced in quantity from a sales order? 

Our production department wants us to track "lost" sales as well as active backorders. A backorder report is easy and has been generated, but I can't see a way to track sales that are lost. 

Let me clarify what I mean by "lost" sales: A lost sale is a line item that is removed , or reduced in quantity, from a sales order due to short expiration dates, or stock on-hand issues. A lot of our customers don't want to have active backorders, so in the aforementioned situations, they will elect to either remove the line item or reduce the quantity ordered for that line item. A line item removed, or quantities removed would be the "lost sale" that we are trying to track and report. 

On a simlar note: is there a way to "backorder" a product due to short expiration dates? For example: if a customer would like a product, but does not want the lot that is currently in stock, is there a way to put that line item on hold until a new lot is available?

Any help would be appreciated. 


  • Tracking lost or deferred sales.
    I am looking to solve a similar problem, i wonder if this was ever solved through an app versus customization? 
  • Gray155 Profile Picture
    Gray155 7 on at
    Tracking lost or deferred sales.
    Did you every find a resolution to this problem? 

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .


André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,989 Super User

Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

nmaenpaa Profile Picture

nmaenpaa 101,148


Featured topics

Product updates

Dynamics 365 release plans