News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

Force Virtuemart to recreate invoices

Started by dylanphelan, May 31, 2021, 14:26:07 PM

Previous topic - Next topic

dylanphelan

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

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 https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 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
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

dylanphelan

Quote from: GJC Web Design 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?



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

dylanphelan

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.