- This topic has 3 replies, 2 voices, and was last updated 6 years, 11 months ago by
.
-
Posts
-
-
I 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?
-
You 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 🙂
-
Thanks 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 🙂
-
Thanks a lot for your suggestion.
We will surely keep your thoughts in mind while fixing this.Cheers 🙂
-
- The forum ‘Accounting’ is closed to new topics and replies.
