ISPConfig 3 Billing Module

Discussion in 'General' started by till, Jul 7, 2011.

  1. go0ogl3

    go0ogl3 Member

    Invoice Template?


    Thank you for your great effort.
    I have a suggestion.
    I'm using some billing software which let me fully customize my invoices details, like logo position or watermark, header or footer, left, right, center, my informations, client informations, etc.. Do you plan to add such a template to the billing module? It's good for those who use multiple invoices for different products or services to the same client, so the invoices look the same.
  2. till

    till Super Moderator Staff Member ISPConfig Developer

  3. pititis

    pititis Member

    Hi admins,

    Best way to get updates? I'm running REV-1 yet. Is working in 1.0 or 1.1??

  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Rev 1 is the latest availble release. The next update will get released after ispconfig 3.0.4 has been released. The update package will be send to all owners of the rev 1 release by email as soon as it is available.
    Last edited: Oct 16, 2011
  5. radim_h

    radim_h Member HowtoForge Supporter

    Proforma invoices?

    Hello guys
    i have read briefly you manual for Billing module, bud i did't find key(for me) feature.
    Is there option to create proforma invoices? Which means - you create document called proforma, payment appeal, whatever which is not valid VAT invoice and AFTER client pays, then you create correct VAT invoice?
    This prevents messing with VAT for unpaid invoices and at least here in Czech it's common way for invoicing.

  6. till

    till Super Moderator Staff Member ISPConfig Developer

  7. Toucan

    Toucan Member

    ispconfig update broke billing module


    Since updating ispconfig to 3.0.4 the billing module is no longer working correctly.

    I ran the 'make invoices' function and it complained:

    Mail attachement does not exist /usr/local/ispconfig/interface/invoices/530019.pdf

    When I look at the invoices tab, of the three that were meant to be sent, it has created one, but failed to create the attachment, nor has it sent. If I click the pdf attachment it reports:
    No invoice PDF file found.

    The other two invoices that should have been sent are show but both with values of 0 and no invoice id numbers..

    Has anyone else experienced this and could someone help me through this please.
    Last edited: Nov 7, 2011
  8. till

    till Super Moderator Staff Member ISPConfig Developer

    Please contact me by email so that we can check what might cause this issue.
  9. neorom

    neorom New Member


    As Toucan our PDF generation isn't working anymore since we updated ISPConfig to the 3.0.4 version.

    When I click on the "pdf view" button I have this error : "No invoice PDF file found."

    Has anyone else an idea to solve this ?

    I have another question concerning the usage of the reminders emails. Is it possible with the billing module to send scheduled reminders to the customers (30 days before, 15 days before, 5 daye before)

    Thank you
  10. till

    till Super Moderator Staff Member ISPConfig Developer

    I guess that the ispconfig update might have reset the permissions of the folder where the invoices are stored. Please execute these commands as root on the shell to correct that:

    chmod 770 /usr/local/ispconfig/interface/invoices
    chown ispconfig:ispconfig /usr/local/ispconfig/interface/invoices

    There is no option for scheduled reminders available yet. I've added this to our feature request list.
    Last edited: Nov 7, 2011
  11. neorom

    neorom New Member

    Thanks you Till

    It is working now. The command line that's changed the situation was the first one :
    chmod 770 /usr/local/ispconfig/interface/invoices

    Do you think this line is missing in your update script (from to 3.0.4) ?

    Thank you

  12. till

    till Super Moderator Staff Member ISPConfig Developer

    I will see if we can integrate the permission handling for that directory in the ispconfig installer too. Currently this directory is managed by the billing module updater.
  13. Toucan

    Toucan Member

    Wow, what a great update - love the new dashboard look to the front showing my profits for the year!

    Thanks for the hardword - this help managing my bills so much easier
  14. pititis

    pititis Member


    +1 to this update. Great job.
  15. pititis

    pititis Member

    Something is missing in the sql update Till, company_name_short field don't exist in the invoice_company table.

    Can you check it please?
  16. till

    till Super Moderator Staff Member ISPConfig Developer

  17. jboud

    jboud Member

    Platform: Debian 5 lenny
    Ispconfig 3.0.4

    Updated the billing addon and everything seemed ok until I tried to create an invoice. This is a production server so I didn't test until required. Now I'm getting this error when finalizing a new invoice or a draft. Creation of a draft causes no problems but it's not summing up the prices.(not sure if it should)

    Did this:
    chmod 770 /usr/local/ispconfig/interface/invoices
    chown ispconfig:ispconfig /usr/local/ispconfig/interface/invoices

    Nothing changed.

    Warning: page_action::include(templates/pdf_invoice//make_pdf_invoice.php) [page-action.include]: failed to open stream: No such file or directory in /usr/local/ispconfig/interface/web/billing/invoice_edit.php on line 193

    Warning: page_action::include() [function.include]: Failed opening 'templates/pdf_invoice//make_pdf_invoice.php' for inclusion (include_path='.:/usr/share/php:/usr/share/pear') in /usr/local/ispconfig/interface/web/billing/invoice_edit.php on line 193

    Fatal error: Class 'PDFInvoice_' not found in /usr/local/ispconfig/interface/web/billing/invoice_edit.php on line 196

    Tried to dig it up a bit but can't be very careful now, not at home. I'm pretty sure that it's permission thingy.
  18. till

    till Super Moderator Staff Member ISPConfig Developer

  19. jboud

    jboud Member

    Thanks man, billing just got epic :D
  20. pititis

    pititis Member

    I get this error AFTER apply this update(task 1861). This update work well but I think is not compete because 'company_name_short' is missing in invoice_company.

    Unknown column 'company_name_short' in 'field list'

Share This Page