Delete invoices

More
2 years 9 months ago #144939 by LucaM
Delete invoices was created by LucaM
Hi, Is it possible to cancel all the invoices generated to start over with a different numbering? Thank you

Please Log in or Create an account to join the conversation.

  • Tuan Pham Ngoc
  • Away
  • Administrator
  • Administrator
More
2 years 9 months ago #144950 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Delete invoices
Hello

You would have to access to your site database via phpmyadmin, find the table #__osmembership_subscribers, run a SQL command to update invoice_number field to 0 and it should be fine

Something like

UPDATE jos_osmembership_subscribers SET invoice_number = 0

(Replace jos_osmembership_subscribers with the actual table name)

Tuan

Please Log in or Create an account to join the conversation.

More
2 years 9 months ago #144993 by LucaM
Replied by LucaM on topic Delete invoices
Thank you

Please Log in or Create an account to join the conversation.

  • Tuan Pham Ngoc
  • Away
  • Administrator
  • Administrator
More
2 years 9 months ago #145005 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Delete invoices
You're welcome !

Please Log in or Create an account to join the conversation.