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

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Deleting Sales Invoice
Small and medium business | Business Central, N...
Suggested Answer

Deleting Sales Invoice

(5) ShareShare
ReportReport
Posted on by BBBCMAN 419
Hi All,
 
I have an invoice which I wanted to delete it, I am getting the following error.
 
 
I can see this header details is available in Sales Header table just one record of this.  Did any of you come across this situation and what was the solution.
 
Thanks
 
 
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • AndrewThomas81 Profile Picture
    AndrewThomas81 2,220 on at
    Are you using the same number series for sales invoices and posted sales invoices?
     
    If you are then the posted sales invoice number will be assigned when you create the invoice which can cause issues with deleting.
     
    Kind Regards
     
    Andrew Thomas FCCA MCP
    YouTube - Use Business Central
    LinkedIn
     
  • BBBCMAN Profile Picture
    BBBCMAN 419 on at
    Thanks Andrew,
     
    Just to confirm are you asking whether the invoice number on sales header and unposted sales invoice are same.  Yes both are same invoice numbers and I cannot delete or remove them at all.
  • Suggested answer
    AndrewThomas81 Profile Picture
    AndrewThomas81 2,220 on at
    It is always recommended to use a different number series for Sales Invoices and Posted Sales Invoices in the Sales & Receivables Setup.
     
    If Posting No. is now populated on the sales invoices, preventing deleting, you could try using a configuration package to modify/remove the data
     
    Kind Regards
     
    Andrew Thomas FCCA MCP
    YouTube - Use Business Central
    LinkedIn
     
  • Suggested answer
    Nimsara Jayathilaka. Profile Picture
    Nimsara Jayathilaka. 5,128 Super User 2026 Season 1 on at
    Hi
    you are sharing the exact same Number Series for both unposted "Sales Invoices" and "Posted Sales Invoices" within your Sales & Receivables Setup, causing the system to immediately assign a posted document number upon creation that locks the record from being deleted. To resolve this and clean up the existing stuck invoice, you must use a Configuration Package targeting the Sales Header table to manually clear or remove the locked record, and then update your Sales & Receivables Setup to assign completely separate, distinct number series for unposted versus posted invoices moving forward to prevent the lock from happening again.
     
  • BBBCMAN Profile Picture
    BBBCMAN 419 on at
    Yes I have already exported the sales header and deleted the record and import it back but still its not deleted from BC.  Please let me know any other way to fix this.
  • Suggested answer
    AndrewThomas81 Profile Picture
    AndrewThomas81 2,220 on at
    Configuration packages don't delete records, remove the posting no and posting number series from the sales header, not the sales header record.
     
    Kind Regards
     
    Andrew Thomas FCCA MCP
    YouTube - Use Business Central
    LinkedIn
     
  • BBBCMAN Profile Picture
    BBBCMAN 419 on at
    Sorry Andrew can you please explain this.  Do you want me to go to no. series and remove the starting number and last number used or something else you are referring to
  • Suggested answer
    AndrewThomas81 Profile Picture
    AndrewThomas81 2,220 on at
    On the configuration package, remove those values.  You might be able to also use edit in excel.
     
    If it won't allow you to do this you will need a script written to amend the data
     
    Kind Regards
     
    Andrew Thomas FCCA MCP
    YouTube - Use Business Central
    LinkedIn
     
  • BBBCMAN Profile Picture
    BBBCMAN 419 on at
    Thanks Andrew I exported the sales header into excel which has just one row will i delete the whole row and import it back or just remove invoice number and import it back 
  • Suggested answer
    AndrewThomas81 Profile Picture
    AndrewThomas81 2,220 on at
    Just remove the posted no 
     
    Kind Regards
     
    Andrew Thomas FCCA MCP
    YouTube - Use Business Central
    LinkedIn
     

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,050 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,441 Super User 2026 Season 1

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 1,175 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans