2,864
edits
Changes
Jump to navigation
Jump to search
==== Custom Invoice Values====
You have the option to create a custom invoice variable to display a value from an invoice. Available content [INVOICEVAL with a selection of the following variables arespecifies the calculation:
CHA - charges
DP4 - 4 decimal places
DES - used as "DESsome description " - gives the sum of values with containing the description "some description"
INV - invoicee, add the invoicee number at the end. Example: INV20 to show invoicee number 20, INV0 will show items not assigned to an invoicee, INV-1 will show all items from the booking regardless of invoicee. You can combine INV[BOOKINGINVOICEEID]] to add the invoicee from the booking
[INVOICE:PRI_QTY_CUA_TOT_VAT_QTY_PAY_GRT_AMO_VAA] will create an invoice table with more information.
[INVOICE:SIN TRANSPORT] will create an invoice table with the Invoice item description for any items with the Status = Transport.
== Invoicee Variables ==
You can use IF variables inside other IF variables to create complex logic but the internal IF: must be processed before the external IF
There are special versions of each IF constructed with ^ and ~ separators like [IF=^this^this^same~different]
<span style="color: #f3e504; font-size: 150%;" >{{#fas:lightbulb}} </span>Only one IF of each type can be used to create complex logic.
The special versions are processed first so should be used as the internal IF so it's result can be processed by the outer if.
The special versions can also be used if you expect : or | characters within your data.
IF's are processed in the following order.
Expamles:
[INWORDS] 10 will write out then"ten"
[INWORDS] [INVOICEPAYMENTSNUM] will write out the invoice sum of all payments
