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?
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.
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.
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.
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.