Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

Cannot delete unposted purchase invoice....

(1) ShareShare
ReportReport
Posted on by
We have a few unposted purchase invoices where the number is the same as a purchase invoice that was posted (different vendor).  The system will not allow us to delete the unposted purchase invoice as it is saying the number corresponds to an invoice that has been posted.  How can we change the invoice number in the unposted purchase invoice to allow us to delete it?
  • Verified answer
    Sacha E Profile Picture
    Sacha E 156 on at
    Cannot delete unposted purchase invoice....
    I know this is an old post but I have had this exact issue quite recently and have found a way to delete the duplicate lines via a Configuration Package. 
     
    We had a mix of invoice numbers where someone had previously attempted to delete them by adding an A to the end of the invoice thinking it wouldn't recognise the original duplicated invoice number but the system still does so will not allow them to be deleted and the handful that were imported recently with duplicate invoice numbers. 
     
    The solution was via a Configuration Package export of the Sales Header Table (Table ID 36). This exported everything from this view and then on the lines that need to be removed you delete whatever is in the Posting No. Series columns so they are blank. Save this and import it back into BC and when you go back and check the Sales Invoices page these duplicate entries can now be deleted from the list.
  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,962 Super User 2024 Season 2 on at
    Cannot delete unposted purchase invoice....
    I assume this is related with No. Series for Purchase invoices and posted purchase invoices.
    When trying to delete, first message You see is - System will post an empty posted purchase invoice, to keep the No. Serie in line.  This is because the purchase header (table 38) has the Posted No. Serie in there. And when trying to post - You get an error that such Number already exists.
    You can update this field in table 38 through configuration packages and then You will be able to delete this Purchase Invoice.
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 74,115 Super User 2024 Season 2 on at
    Cannot delete unposted purchase invoice....
    This does not appear to be a standard issue.
    You can debug in the Sandbox environment to see what the problem is.
    And as far as I know, unless customized, you cannot change the number of unposted purchase invoice.
     
    In addition, I'm not sure if it has something to do with Posting No., you can check it.
     
     
    Thanks.
    ZHU
  • Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    Cannot delete unposted purchase invoice....
    Can you please share a screenshot of the exact error messages that is displayed?
    That will make it easier to assist you.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans