8,849
edits
Changes
→Examples
* Billable: '''~billable~'''
* Notes: '''~itemdescription~'''
* Timecode: '''~timecode~'''
* Is Billable: '''~isagainstjob~''' - ''will return 1 when timecode used is marked as'' billable'', 0 when timecode is not''
==ExampleExamples==
The following are examples that could be used on a {{WPV}} to create a table listing timesheet items:
</table></pre>
<pre style="white-space: pre-wrap; white-space: -moz-pre-wrap; white-space: -pre-wrap; white-space: -o-pre-wrap; word-wrap: break-word;"><table cellspacing=0 cellpadding=2 border=1>
<table cellspacing=0 cellpadding=2 border=0>
<tr><th>Billable Hours</th><th>Not Billable Hours</th><th>Billed Hours</th><th>Unbilled Hours</th></tr>
<!--Billable Hours:-->
<tr><th> [#(?object=timesheet;criteria=isagainstjob=1;groupfunction=sum)~totalhours~#]</th>
<!--Not Billable Hours:-->
<th> [#(?object=timesheet;criteria=isagainstjob=0;groupfunction=sum)~totalhours~#]</th>
<!--Billed Hours:-->
<th> [#(?object=timesheet;criteria=tsinvoiceid>0 and isagainstjob=1;groupfunction=sum)~totalhours~#]</th>
<!--Unbilled Hours:-->
<th> [#(?object=timesheet;criteria=tsinvoiceid=0 and isagainstjob=1;groupfunction=sum)~totalhours~#]</th>
The code between the '''[#(?object=timesheet)''' and closing '''#]''' will be repeated for each timesheet item to be included.
Other examples include:
===Last Timesheet Entry Date===
<pre style="white-space: pre-wrap; white-space: -moz-pre-wrap; white-space: -pre-wrap; white-space: -o-pre-wrap; word-wrap: break-word;">[#(?object=timesheet;groupfunction=max)~actiondate~#]
</pre>
===Non-Invoiced Hours===
<pre style="white-space: pre-wrap; white-space: -moz-pre-wrap; white-space: -pre-wrap; white-space: -o-pre-wrap; word-wrap: break-word;"><!--@sscalculation((REPLACE("[#(?object=timesheet;criteria=tsinvoiceid=0 and isagainstjob=1;groupfunction=sum)~totalhours~#]",",",""))*1)-->
</pre>
===Invoiced===
<pre style="white-space: pre-wrap; white-space: -moz-pre-wrap; white-space: -pre-wrap; white-space: -o-pre-wrap; word-wrap: break-word;"><!--@sscalculation((REPLACE("[#(?object=timesheet;criteria=tsinvoiceid>0 and isagainstjob=1;groupfunction=sum)~totalhours~#]",",",""))*1)-->
</pre>
===Non-billable hours===
<pre style="white-space: pre-wrap; white-space: -moz-pre-wrap; white-space: -pre-wrap; white-space: -o-pre-wrap; word-wrap: break-word;"><!--@sscalculation((REPLACE("[#(?object=timesheet;criteria=isagainstjob=0;groupfunction=sum)~totalhours~#]",",",""))*1)-->
</pre>
===Billable Hours===
<pre style="white-space: pre-wrap; white-space: -moz-pre-wrap; white-space: -pre-wrap; white-space: -o-pre-wrap; word-wrap: break-word;"><!--@sscalculation((REPLACE("[#(?object=timesheet;criteria=isagainstjob=1;groupfunction=sum)~totalhours~#]",",",""))*1)-->
</pre>
===Actual Hours (total hours)===
<pre style="white-space: pre-wrap; white-space: -moz-pre-wrap; white-space: -pre-wrap; white-space: -o-pre-wrap; word-wrap: break-word;"><!--@sscalculation(REPLACE("[#(?object=timesheet;groupfunction=sum)~totalhours~#]",",","")*1)-->
</pre>
===Timecodes===
<pre style="white-space: pre-wrap; white-space: -moz-pre-wrap; white-space: -pre-wrap; white-space: -o-pre-wrap; word-wrap: break-word;">[#(?object=timesheet;)~timecode~<BR>#]
</pre>
<pre style="white-space: pre-wrap; white-space: -moz-pre-wrap; white-space: -pre-wrap; white-space: -o-pre-wrap; word-wrap: break-word;">Implementation Note: Saving timesheet records does not trigger the template formulas of Level 1 objects to which they are associated. To have fields summing timesheet items on the Level 1 record, use Read Only - System Variable fields.</pre>
==See Also==
* [[Invoice UTA|Invoice Configuration Page]]
* [[Invoice Module Variables]]
* [[Web Page View Field Variables]]
[[Category:Universal Tracking Application]][[Category:Variables]]
