Jump to content
  • 0

Download Invoices in Bulk


Jolo35

Question

2 answers to this question

Recommended Posts

  • 0

The simplest way to do this is to piggy back off the print queue feature. To start, you can add existing invoices to the print queue with a query like this:

INSERT INTO invoice_delivery (invoice_id, method)
SELECT invoices.id, 'paper' FROM invoices WHERE invoices.date_billed >= '2019-07-01 00:00:00' AND invoices.date_billed <= '2019-08-31 23:59:59';

Just change the dates, keeping in mind that the times are in UTC (adjust accordingly), and go to Billing > Print Queue.

If you want to show a lot of invoices at a time, rather than the default 20, you can edit  config/blesta.php and change:

Configure::set('Blesta.results_per_page', 20);

To

Configure::set('Blesta.results_per_page', 2000);

To show 2000 instead of 20. This controls lists throughout Blesta, so you'll definitely want to change it back when you're done.

When done downloading the PDF of your invoices, click the button to "Mark as Printed" to remove them from the queue.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...