Template Variables: Difference between revisions

Jump to navigation Jump to search
Line 227: Line 227:


[INVOICEBALANCE:-100] - invoice balance with offset amount
[INVOICEBALANCE:-100] - invoice balance with offset amount
[INVOICEBALANCENUM] - As per [INVOICEBALANCE] but the value is displayed with a decimal point and no thousands separator.
[INVOICEBALANCENUM:] - As per [INVOICEBALANCE:] but the value is displayed with a decimal point and no thousands separator.


[INVOICEPARTBALANCE:status1,status2,status4:10%] - Calculate the balance of all invoice items with matching status and apply optional multiplier or offset. The status items can be a comma separated list. To exclude status items prefix them with an exclamation mark, for example !status1. The offset optional and can be specified after a second colon (:) and it can be a percentage by ending the number with the percent (%) symbol or a numeric value offset.
[INVOICEPARTBALANCE:status1,status2,status4:10%] - Calculate the balance of all invoice items with matching status and apply optional multiplier or offset. The status items can be a comma separated list. To exclude status items prefix them with an exclamation mark, for example !status1. The offset optional and can be specified after a second colon (:) and it can be a percentage by ending the number with the percent (%) symbol or a numeric value offset.
[INVOICEPARTBALANCENUM:status1,status2,status4:10%] - As per INVOICEPARTBALANCE but the value is displayed with a decimal point and no thousands separator.


[INVOICECHARGES] - invoice sum of all charges  
[INVOICECHARGES] - invoice sum of all charges  
Line 235: Line 241:


[INVOICECHARGES:-100] - invoice sum of all charges with offset  
[INVOICECHARGES:-100] - invoice sum of all charges with offset  
[INVOICECHARGESNUM] - As per [INVOICECHARGES] but the value is displayed with a decimal point and no thousands separator.
[INVOICECHARGESNUM:] - As per [INVOICECHARGES:] but the value is displayed with a decimal point and no thousands separator.


[INVOICEPAYMENTS] - invoice sum of all payments  
[INVOICEPAYMENTS] - invoice sum of all payments  
Line 241: Line 251:


[INVOICEPAYMENTS:-100] - invoice sum of all payments with offset  
[INVOICEPAYMENTS:-100] - invoice sum of all payments with offset  
[INVOICEPAYMENTSNUM] - As per [INVOICEPAYMENTS] but the value is displayed with a decimal point and no thousands separator.
[INVOICEPAYMENTSNUM:] - As per [INVOICEPAYMENTS:] but the value is displayed with a decimal point and no thousands separator.


[INVOICECREDITS] - invoice sum of all credit items (negative items)
[INVOICECREDITS] - invoice sum of all credit items (negative items)
Line 247: Line 261:


[INVOICECREDITS:-100] - invoice sum of all credit items with offset  
[INVOICECREDITS:-100] - invoice sum of all credit items with offset  
[INVOICECREDITSNUM] - As per [INVOICECREDITS] but the value is displayed with a decimal point and no thousands separator.
[INVOICECREDITSNUM:] - As per [INVOICECREDITS:] but the value is displayed with a decimal point and no thousands separator.


[INVOICEDEBITS] - invoice sum of all debit items (positive items)
[INVOICEDEBITS] - invoice sum of all debit items (positive items)
Line 253: Line 271:


[INVOICEDEBITS:-100] - invoice sum of all debit items with offset
[INVOICEDEBITS:-100] - invoice sum of all debit items with offset
[INVOICEDEBITSNUM] - As per [INVOICEDEBITS] but the value is displayed with a decimal point and no thousands separator.
[INVOICEDEBITSNUM:] - As per [INVOICEDEBITS:] but the value is displayed with a decimal point and no thousands separator.


[INVOICEVAT] - invoice sum of all vat value
[INVOICEVAT] - invoice sum of all vat value