web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Unanswered

Error: Cannot cancel lot reservation — Sales Line does not exist in BC

(1) ShareShare
ReportReport
Posted on by

Hi everyone,

I’m working with Dynamics 365 Business Central and have a situation where a specific lot shows as reserved, but when I try to use Cancel Reservation in the Reservation Entries page I receive the error:

 
 

“The Sales Line does not exist. Identification fields and values: Document Type=’1’, Document No.=’SO‑1310’, Line No.=’10000’”

 

Here’s what I know so far:

 

  •  

    The lot is reserved but cannot be used in a new sales order.


  •  

    The Reservation Status was changed to “Surplus” via configuration package and freed the availability list view, but the “reserved” indicator still shows in reports.


  •  

    The error points to a missing sales line, which suggests that either the original sales order was deleted or a link is broken.



  •  
 

My questions:

 

  1.  

    What is the safest way to fully clear or cancel this “orphaned” reservation entry without causing data integrity issues?


  2.  

    Has anyone encountered a scenario where manually deleting the record in the Reservation Entries table was required — and if so, what were the side‑effects or warnings you observed?


  3.  

    After cleanup, what steps or reconciliation processes do you recommend to ensure the system reports correctly and no residual inventory reservation remains?


     
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 2,568

#2
Sumit Singh Profile Picture

Sumit Singh 2,536

#3
YUN ZHU Profile Picture

YUN ZHU 2,015 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans