Author Topic: Force Virtuemart to recreate invoices  (Read 470 times)

dylanphelan

  • Jr. Member
  • **
  • Posts: 119
Force Virtuemart to recreate invoices
« on: May 31, 2021, 14:26:07 pm »
I need to send my last 3 months sales invoices to the taxman for VAT registration.

I realize that for some time now, my address is not displaying correctly on the customer invoice which is generated. My name is also included on the invoice below the company name.

I am busy fixing the layout of my invoice, but I need to figure out a way to get virtuemart to recreate the last 3 months invoices. Or at least the last months invoices.

Perhaps delete invoices in the folder, then would there be a db query I can run to tell VM that these invoices have not been created?  then re-create them all?

VM 3.8.2
J3.9.26


GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 10170
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.6.8
Re: Force Virtuemart to recreate invoices
« Reply #1 on: May 31, 2021, 16:30:30 pm »
you need to test but I would first delete the invoices in the folder
then disable the email ( set in admin no emails)
a query won't trigger the invoice creation .. it needs the function to run

if the number of invoices isn't huge maybe just click the pdf item of each order to force the invoice creation?

GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

dylanphelan

  • Jr. Member
  • **
  • Posts: 119
Re: Force Virtuemart to recreate invoices
« Reply #2 on: May 31, 2021, 16:48:33 pm »
you need to test but I would first delete the invoices in the folder
then disable the email ( set in admin no emails)
a query won't trigger the invoice creation .. it needs the function to run

if the number of invoices isn't huge maybe just click the pdf item of each order to force the invoice creation?



Thanks. Good point about the emails.
It's not a huge number of invoice, so I could manually force invoice creation.

dylanphelan

  • Jr. Member
  • **
  • Posts: 119
Re: Force Virtuemart to recreate invoices
« Reply #3 on: May 31, 2021, 16:55:08 pm »
Did a quick test.
Deleted invoice from the vmsafe folder.
Deleted relevant invoices in the DB table virtuemart_invoices
You can then force invoice creation again.