Cannot delete unposted purchase invoice....

(1) Share

Report

Posted on by Community member

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?

Categories:

Dynamics 365 Business Central

All responses (4)

Answers (1)

Verified answer

Sacha E 156 on at

Like (1)

Report

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 3,962 Super User 2024 Season 2 on at

Like (0)

Report

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 74,115 Super User 2024 Season 2 on at

Like (0)

Report

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.

https://yzhums.com/21537/

Thanks.

ZHU
Inge M. Bruvik 32,748 Super User 2024 Season 1 on at

Like (0)

Report

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.