00 Day
00 Hour
00 Min
00 Sec

Orphaned invoice can't be approved, void or deleted

Home Forums Accounting Orphaned invoice can't be approved, void or deleted

Viewing 3 reply threads
  • Author
    Posts
    • #9871
      juansh
      Participant

      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?

    • #9929
      Shawon Chowdhury
      Moderator

      @juansh,

      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 πŸ™‚

    • #9944
      juansh
      Participant

      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 πŸ™‚

    • #10106
      Shawon Chowdhury
      Moderator

      @Juansh,

      Thanks a lot for your suggestion.
      We will surely keep your thoughts in mind while fixing this.

      Cheers πŸ™‚

Viewing 3 reply threads
  • The forum ‘Accounting’ is closed to new topics and replies.

Contact Us

Reach out to us for any inquiry

You must enter full name
You must enter email
You must enter message

We received your query

We will reply to you very soon :)