List of invoice template merge fields

VOGSY provides a set of merge fields to use as part of an invoice template. The merge fields are mapped to project data. When the invoice is generated, the merge fields will be replaced with the associated data from the associated project. For example, client_name will be replaced with the name set in the Client field on the project’s Project page.

Here is a sample invoice template, which uses quite a few merge fields:

As the sample illustrates, each merge field must be placed between double braces.

Here is the complete list of merge fields that you can use to customize an invoice template:

• document_description

  Type of invoice: Draft, Invoice, or Credit invoice.

• invoice_heading

  Heading for invoice field from the Languages back office module.

• invoice_number

  Generated by VOGSY.

• invoice_date

  Generated by VOGSY.

• due_date

  Due date for payment of the invoice. Generated by VOGSY based on the payment_condition.

• invoice_description

  The extra text that you specify in ‘Draft invoices’.

• project_description

  Project name field on the Project page

• debtor_number

  Debtor number field on the Organization page

• client_name

  Client field on the Project page

• client_job_role

  The job role of the client of the customer

• client_job_title

  The job title of the client of the customer

• organization_name

  Organization name field on the Organization page

• organization_vat_number

  VAT number field on the Organization page

• total_vat

  Calculated by VOGSY.

• total_tax

  Calculated by VOGSY.

• subtotal

  Total amount of the previously listed deliverables or costs. Calculated by VOGSY.

• total

  Total amount of all deliverables and costs. Calculated by VOGSY.

• invoice_period The period that is invoiced

• payment_condition

  Payment condition field on the Organization page. See Payment conditions for more information.

• invoice_address

  Address field on the Organization page

• approved_by_name

  Generated by VOGSY

• approval_date

  Generated by VOGSY

• po_number

  PO number field on the Project page

• currency_symbol

  Currency field on the Project page

• print_date

  Generated by VOGSY

• project_manager

  Generated by VOGSY from the Project page based on the project team

• line_total

  Calculated by VOGSY

• project_order_value

  Order value from the project card

• project_client_name

  Client field on the Project page

• quote_date

  Generated by VOGSY

• contact_name

  Generated by VOGSY from the Project page

• quote_number

  Generated by VOGSY

• organization_address

  Address, Zip Code, City, and Country fields from the customer’s Organization page.

• account_manager

  Account manager from the customer’s Organization page.

Beside the normal merge fields, there are also several line blocks. The following blocks are available, each with there own merge fields

• lines

  normal invoice lines

  • line_description

    Main description field that contains the information about the invoice line

  • quantity

    This might refer to the number of hours registered by the resource against this deliverable, or it might refer to an allotment of materials used for the deliverable. Only applies to Time and Materials deliverables.

  • price

    This might refer to the hourly rate of the resource, or it might refer to the unit price of the allotment of materials. Only applies to Time and Materials deliverables.

  • amount

    This equals the quantity times the price.

  • amount_local_currency

  • line_vat_amount / line_tax_amount

    The vat/tax amount applicable for this line.

  • line_vat_percentage / line_tax_percentage

    The vat/tax percentage

  • line_vat_amount_local_currency / line_tax_amount_local_currency

  • line_vat_desc / line_tax_desc

    The (localized) description of the VAT / Tax type.

• vat_lines

  Contain the VAT / Tax specification on your invoice. Each VAT / Tax type the applies to the invoice is listed as a separate line.

  • vat_amount / tax_amount

    Calculated by VOGSY based on the option set in the VAT type field on the customer’s Organization page.

  • vat_desc / tax_desc

    Description field on the appropriate sales tax type on the VAT types back office module. See Sales tax types for more information.

  • net_amount

    The price after subtracting the vat_amount or tax_amount.

  • vat_amount_local_currency

• discount_lines

  Contain the discount specification on your invoice

  • discount_amount

    Calculated by VOGSY based on the discount_percentage.

  • discount_percentage

    Discount % field on the Deliverable page or the Project page. Only visible if you select the Add discount/surcharge checkbox.

  • net_amount

    The price after subtracting the discount_amount. Calculated by VOGSY.

  • discount_description

    The discount description field is on the Deliverable or Project pages. It is only visible if you select the Add discount/surcharge checkbox.

  • discount_amount_local_currency

  • net_amount_local_currency

• debit_invoice

  When a credit invoices is issued that references the original debit invoice the following merge fields are available to show information about the original invoice. This is a legal requirement in some areas

  • debit_invoice_number

  • debit_invoice_total_amount

  • debit_invoice_subtotal_amount

  • debit_invoice_total_tax / debit_invoice_total_vat

  • debit_invoice_correct_total_amount

  • debit_invoice_correct_subtotal_amount

  • debit_invoice_correct_total_tax / debit_invoice_correct_total_vat

  • debit_invoice_vat_percentage

  • credit_invoice_reason