Show tax rate (VAT rate) per line item on invoice
  • proneprone September 2011

    Hi

    In Belgium, we have different tax rates for different products, and we always have to show on the invoice the applied tax rate for each line item. Just the rate, not necessarily the calculated tax amount. There is only 1 tax rate per line item.

    Can this be configured so the tax rate shows up per line item?

    In the summary, we have to make the totals per tax rate, which is perfect as is.

    Thanks
    Prone

  • proneprone September 2011

    In the template, I can use {invoiceItem.tax_amount}. This is a field of table si_invoice_items

    Which file contains the SQL query to fetch this field and make it available in the template?

    If someone could tell me where to look, then I can add tax_rate (from si_invoice_item_tax) to the SQl query myself.

    Thanks

  • gortzengortzen January 24

    Hi,

    From Belgium too :)

    Did someone managed to show VAT rate in the invoice template?

  • proneprone January 24

    I did, but forgot how exactly. I remember that I created a View in MySQL to join 2 tables to include the tax details with lineitems. Then, in an SQL query in a php file, I replaced the 'from' table by that view, making the needed field available.

    It's a quick and dirty solution. It's probably better to fetch the field by just adapting the slq query in the php file.

  • gortzengortzen January 25

    Ok thanks. I found a solution by mixing the default and export template.

  • modirmodir January 26

    If you want you can add the template here: http://code.google.com/p/simpleinvoices/wiki/InvoiceTemplates Then others have something from it too.

Add a Comment

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership

Categories

Tagged