Change invoice line item after generate

Prins · June 12, 2023, 3:01pm

Hi, is they any way we can change the invoice line item from phpMyadmin after an invoice has been created, and payment recorded?

hillel · June 12, 2023, 3:02pm

Hi,

You would need to use the API to update the invoice.

Prins · June 13, 2023, 8:49am

Hi, LOCK_SENT_INVOICES=false to the .env not going to help anymore? to edit sent invoices

hillel · June 13, 2023, 10:54am

Sorry, I don’t understand your question

Prins · June 13, 2023, 3:34pm

I wanted to edit paid invoices (just the line description). for this, I changed settings–>workflow–>lock invoices = off.
but this seems to not work. then I tried to add LOCK_SENT_INVOICES=false to the .env file. this also not working. it keep saying “Sent invoices are locked” is there any other way I can edit invoice line items without API to update the invoice?

hillel · June 13, 2023, 4:04pm

Which specific version of the app are you using?

Prins · June 13, 2023, 4:15pm

self-hosted
v5.5.118-C115

hillel · June 13, 2023, 4:17pm

@david do you have any suggestions?

david · June 13, 2023, 9:58pm

The lock invoices is not a .env variable,

It is found in Settings > Workflow Settings

cc @hillel

Prins · June 14, 2023, 8:22am

I did try this but didn’t work. but after some time it works.
also once save the changes I don’t have to send an email to the customer again right if they click the view invoice button from the previous email they will get the latest invoice right?