Front Page › Forums › Accounting › Orphaned invoice can't be approved, void or deleted
- This topic has 3 replies, 2 voices, and was last updated 6 years, 11 months ago by
Shawon Chowdhury.
-
AuthorPosts
-
-
September 28, 2017 at 6:45 am #9871
juansh
ParticipantI was in the middle of creating an invoice an accidentally pressed return on one of the item fields. This caused the invoice to be created prematurely without being submitted for approval. As a result I am unable see any options for the invoice to be able to void it, I can only view it. The invoice is incomplete and has skewed my is there a way to void this invoice via mysql?
-
October 3, 2017 at 12:33 pm #9929
Shawon Chowdhury
ModeratorYou can remove this by deleting from the database.
Go to “wp_erp_ac_transactions” table and you will found all the invoices and payments listed here.
Just delete the unexpected one. That’s all.In future releases, we will fix this and set an way to delete or edit this kind of invoice/payment from WP Dashboard.
Thank you 🙂
-
October 3, 2017 at 10:54 pm #9944
juansh
ParticipantThanks for your help.
Just a quick note which may help with a fix for this issue. After adding “void” to the status field which was previously NULL in the database entry, I was able to see the delete option in WordPress Admin the same as other void invoices. I’m guessing that it is due to a string match query in the code for the status field. Maybe a quick fix would be to do the following check:
if (!status || status === “void”) { // then show delete option below invoice }I could be talking nonsense but hopefully it helps 🙂
-
October 11, 2017 at 1:50 pm #10106
Shawon Chowdhury
ModeratorThanks a lot for your suggestion.
We will surely keep your thoughts in mind while fixing this.Cheers 🙂
-
-
AuthorPosts
- You must be logged in to reply to this topic.