edit invoice history

  • Resolved rqb

    (@indivarus)


    3 years, 7 months ago

    Hello,

    I need to delete an update into the invoice history, but directly from the plugin seems not possible.

    I tried looking for the db at myphpadmin and I couldn’t find any table related to WP-Invoice. So I am wondering where is all these data going…

    Any ideas how can I edit/delete an entry in an invoice history.
    Particularly, the case is there is a double payment input, so I need to delete one.

    Thank you

Viewing 8 replies - 1 through 8 (of 8 total)

  • The table you’re looking for is “wp_wpi_object_log”

    The invoice is a wp_post and wp_postmeta, and it links to the object log for activity (payments, adjustments, etc).

    Thread Starter rqb

    (@indivarus)

    Thank you for your reply.

    I deleted one of the paymentes in the table, but it is still reflecting a double payment in the post and in the pdf. How can I delete one payment there too?

    Thank you again!

    Did you also look in the wp_postmeta? There is a meta_key called ‘total_payments’ that may need to be adjusted as well.

    Thread Starter rqb

    (@indivarus)

    Thank you dfreeman33, you have been really helpful.

    Just one more doubt…if you can.
    I couldn’t find the entry for other adjustments…

    Thank you, have a good week!!

    Glad to help.

    I’m not sure what you mean by other adjustments.

    Thread Starter rqb

    (@indivarus)

    I mean the row after discounts.
    Thanks

    All of those will be in the wp_postmeta table. Look for a meta_key “adjustments” and “net”

    Thread Starter rqb

    (@indivarus)

    Dear dfreeman33,

    Thank you very much.
    Have a great week!

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘edit invoice history’ is closed to new replies.