Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / How to retrieve delete...
Small and medium business | Business Central, N...
Suggested answer

How to retrieve deleted posted sales invoice from production or can we use the number again

(0) ShareShare
ReportReport
Posted on by himanshu rawat 24
Hi everyone,
we have deleted some posted sales invoice from the production environment and we want those invoice back in our system can anybody help what solution we can do to make it possible. Or there is any option so that we can create the invoice with the same number we have tried my disabling the auto number but it was not working. 
Categories:
Dynamics 365 Business Central
  • Suggested answer
    Inkey Solutions Profile Picture
    Inkey Solutions 1,900 on at
    How to retrieve deleted posted sales invoice from production or can we use the number again
    As per standard functionality, you can update the Last Used No. field in the number series, but the system will not allow posting a repeated number again because that invoice number already exists as a posted invoice number in the General Ledger entries, which will result in an error when attempting to post it as a new sales invoice.
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 76,516 Super User 2024 Season 2 on at
    How to retrieve deleted posted sales invoice from production or can we use the number again
    Hi, hope the following helps.
    Dynamics 365 Business Central: Manual number for Posted Sales invoice and Posted Purchase invoice (Use the same number in Sales Order and Posted Sales Invoice?)
     
    Thanks.
    ZHU
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 25,565 Super User 2024 Season 2 on at
    How to retrieve deleted posted sales invoice from production or can we use the number again

    This depends on a few factors. How are posted invoices created - from sales orders or sales invoices?

    • From Sales Orders: You can adjust the last number in the posted invoices number series.
    • From Sales Invoices (and you have the same number series for unposted and posted invoices): Adjusting the last number isn’t possible. When you delete an invoice, the system creates an empty posted invoice with the same number, meaning that number is already used.
    • From Sales Invoices (different number series for unposted and posted): You can adjust the last number in the posted invoices number series.
    In either case, I would ensure the number you want to re-use does not exist as a posted invoice or in the general ledger entries on posted entries. 
     
  • Suggested answer
    Yi Yong Profile Picture
    Yi Yong 1,704 Super User 2024 Season 2 on at
    How to retrieve deleted posted sales invoice from production or can we use the number again
    Hello,
     
    You can't post back with the same number because the number already existed on ledger entries.
     
    You may want to restore the Production before the deletion happened to a sandbox and export the Sales Invoice Header/Line tables.
    Then do a custom codeunit to import them to Production.
    I don't think Configuration Package will work for this.
  • gdrenteria Profile Picture
    gdrenteria 13,350 Most Valuable Professional on at
    How to retrieve deleted posted sales invoice from production or can we use the number again
    Hi
    When you delete the historical document, you do not necessarily delete all its documentation and entries. Please review the following:
    Best
    GR
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 7,144 on at
    How to retrieve deleted posted sales invoice from production or can we use the number again
  • Suggested answer
    Kamal Khakhkhar Profile Picture
    Kamal Khakhkhar 313 on at
    How to retrieve deleted posted sales invoice from production or can we use the number again
    Hii there,
    As per requirement you can update the no series field "last no used".  In this you can update the before posted no which you deleted. It can add the record if you not use any custom extension.
     
    Thank you.
    Kamal Khakhkhar 

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Share Your Event with the Community

Jump start your event engagement! 📢

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,961 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,717 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans