Versions Compared

Old Version 2

changes.mady.by.user Andrii Zinchenko

Saved on

compared with

New Version 3

changes.mady.by.user Anastasiia Kovalinas

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

SectionFields Description
General Information


General information about the invoice template
  • Name
Unique name to differentiate invoice templates
  • Reseller
Reseller who owns this invoice template
  • Anonymized Codes
Code Deck, whose codes and their respective names will be hidden in the invoice
  • Locale
Language for the text representation of totals in the invoice
  • Totals Calculation

The order of rounding while calculating the totals:

  • round then sum- raw values are rounded first according to the currency settings, then summed;
  • sum then round - raw values are summed first, then rounded.
  • Taxes Calculation

The way taxes will be calculated:

  • percent from total amount - taxes are calculated as a percentage from the total amount;
  • sum of individual taxes- taxes are calculated as a sum of respective taxes.
  • Attach xDRs list to the invoice checkbox

If enabled, creates an xDR file for the invoicing period and attaches it to the invoice. To view advanced settings, click the icon next to its name.

  • xDRs List Format
List of xDR file format (.csv, .xlsx or.xls)
  • Included Calls

Types of calls that will be included in invoices:

  • All payable - includes calls with any duration that have non-zero costs and use packages
  • Non-zero payable - permits including calls with a non-zero duration that either have any cost or use packages. 
  • Select Columns
List of columns which can be presented in the attached xDR file
  • Notes
Additional information concerning the invoice template
Excel Template ParametersSettings of an invoice template
  • Statistics Columns
List of statistics columns. If selected, the invoice will include summary statistics with selected columns
  • Include packages charges to invoice checkbox
If enabled, the invoice will include the data on ordered packages into a current invoice for the selected period
  • Template
Defined displaying format of xDRs list in a template

...

Panel
borderColor#ffffb3
bgColor#ffffb3
borderWidth2px

(warning)(warning)   Attention

  • xDRs table of the created invoice displays calls according to the settings of Attach xDRs list to the invoices settings.
  • Stats table of the created Invoice shows calls included in the xDRs table.

...

  1. Add a table to your workspace, right-click on it, choose Table Properties, and define the Classfield (stats, xDRs, packages, suretax_items, custom) in the General tab;

  2. Fill a table with relevant information, which should be present in invoices by using functional variables, which you can pick from a list provided in the same window on the right drop-down panels; 

  3. After an invoice template is created, fill in its Name and other fields in the General Information section, then click OK;

  4. Go to Management > Resellers and select your invoice template in the reseller's properties. It will ensure that all customers of this reseller will be using this template;

  5. When creating an invoice in Management > Invoices, you can use an invoice template prior to generating an invoice. JeraSoft Billing includes default .pdf templates, called default and default extended. 


Panel
borderColor#ffffb3
bgColor#ffffb3
borderWidth2px

(warning)(warning)   Attention

Please note:

  • You can select the Time Format (H:M:S) or (M:S) while creating a new invoice template. The default format is in minutes (M).
  • There is a package arrangement by numbers in Invoices and Invoices Templates. While generating invoices, the system sorts packages in invoices. The names of packages could include numerical symbols. Please use numerical symbols as 001 name, 002 name, etc. in the names of packages. Moreover, it's advisable to avoid names with special symbols like %001 name, -001 name.


Panel
borderColor#ffffb3
bgColor#ffffb3
borderWidth2px

(warning)(warning)   Attention

In VCS 3.16.0.:

  1. Taxes Table group of functional variables to display collected taxes in an invoice has been added. Taxes Table consists of the following variables:
    • {name} - Tax name
    • {value} - Tax value in percent
    • {effective_from} - Tax effective from date
    • {amount} - Tax amount
  2.  New default with taxes details template with included Taxes Table functional variables has been added to the section.

Method of Calculating and Rounding Values 

Panel
borderColor#ccffcc
bgColor#ccffcc
borderWidth2px
borderStylesolid

Tip

To help you avoid rounding issues with float numbers and missing cents, check out our Best practice example or read about round half to even algorithm, applied in the system, here.


...