Difference between revisions of "Timesheet Variables"

Revision as of 14:19, 24 July 2014

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.

See Also

• Invoice Configuration Page
• Web Page View Field Variables