Where the variables live on the invoice
Each amount below is replaced by the name of the variable that produces it. Use these in the reservation template and product descriptions.
| Items | Nights | Price/night | Tax % | Discount | Amount |
|---|---|---|---|---|---|
|
New Reservation
Taxed line total = form.RowTotal (550)
|
form.RowQty 5 |
form.RowPrice 100 |
10 % |
0 | form.RowAmount 500 |
|
Commission 10%
= 10% × form.NetExcl (10% × 500 = -50)
|
1 | -50 | — | — | -50 |
|
Extra (e.g. cleaning)
Not a reservation line → excluded from form.NetExcl
|
1 | 200 | — | — | 200 |
| Subtotal: | form.Subtotal (700) |
| Tax: | +50 |
| Total: | 750 |
| Amount Due: | form.AmountDue (750) |
Variable reference
- form.RowAmount
- qty × price of the imported line
- form.RowTotal
- this line total: (qty × price − discount) + tax
- form.Subtotal
- sum of all invoice rows (before discount and taxes)
- form.SubtotalExcl
- Subtotal minus the current line — avoids circular references when a line computes its own price
- form.NetExcl
- Amount of the reservation line(s) only — discount applied, before tax, extras excluded (commission base, no circular reference)
- form.AmountDue
- invoice grand total (sum of rows − discount + taxes − paid)