Timesheet Variables
The following variables can be used when creating a Web Page View or in other custom fields when referencing Timesheets: On the Web Page View you can refer to each Timesheet field using special terminology which allows them to be generated as a list:
Syntax
- [#(?object=timesheet)~variablename~#]
where variablename is one of:
- Date: ~actiondate~
- User: ~username~
- Status: ~status~
- Client: ~client~
- Project: ~project~
- Duration: ~totalhours~
- Billable: ~billable~
- Notes: ~itemdescription~
Example
The following is a example that would be used on the Web Page View to create a table listing all the items for the invoice, as well as the Subtotal, Total GST, PST and Invoice Total:
<table>
<tr>
<td>Product Code</td>
<td>Item Description</td>
<td>Quantity</td>
<td>Unit Cost</td>
<td>Total Cost</td>
<td>GST</td>
<td>PST</td>
</tr>
<form name=frmsubact>
[#(?object=items)
<tr>
<td>$Product Code$</td>
<td>~description~</td>
<td> ~qty~ </td>
<td> ~amount~ </td>
<td> ~fullamount~ </td>
<td> ~tax~ </td>
<td> ~tax2~ </td>
</tr>
#]
</form>
<tr>
<td><b>Sub-Total:</b></td>
<td>@amount@</td>
</tr>
<tr>
<td><b>Total GST:</b></td>
<td>@tax@</td>
</tr>
<tr>
<td><b>Total PST:</b></td>
<td>@tax2@</td>
</tr>
<tr>
<td><b>Total:</b></td>
<td>@invtotal@</td>
</tr>
</table>
The code between the [#(?object=items) and closing #] will be repeated for each line item to be included on the invoice.