Changes

The following is a example are examples that would could be used on the [[Web Page View Field|Web Page View]] a {{WPV}} to create a table listing all the timesheet items for the invoice, as well as the Subtotal, Total GST, PST and Invoice Total:

<prestyle="white-space: pre-wrap; white-space: -moz-pre-wrap; white-space: -pre-wrap; white-space: -o-pre-wrap; word-wrap: break-word;"><tablecellspacing=0 cellpadding=2 border=1> <tr> <tdth>Product CodeStaff</tdth> <tdth>Item DescriptionDetails</tdth> <tdth>QuantityDate</tdth> <tdth>Unit CostEffort</tdth> <tdth>Total CostStatus</tdth> <tdth>GSTBillable</tdth> <tdth>PSTBilled</tdth></tr>

<form name=frmsubact>[#(?object=itemstimesheet;orderby=actiondate)

<tr> <tdnowrap>$Product Code$~username~</td> <td>~descriptionitemdescription~</td> <td> ~qtyactiondate~ </td> <td> ~amounttotalhours~ </td> <td> ~fullamountstatus~ </td> <td> ~taxbillable~ </td> <td> ~tax2if(tsinvoiceid>0,'Yes','No') as billed~ </td></tr>

<tr/table> <td><b>Sub-Total:</b></td> <td>@amount@</tdtable cellspacing=0 cellpadding=2 border=0></tr><tr> <td><b>Total GST:</bth>Billable Hours</td> <tdth>@tax@</tdth>Not Billable Hours</tr><tr> <tdth><bth>Total PST:Billed Hours</bth></td> <tdth>@tax2@Unbilled Hours</tdth></tr> <tr> <tdth><b>Total:[#(?object=timesheet;criteria=isagainstjob=1;groupfunction=sum)~totalhours~#]</b></tdth> <tdth>@invtotal@[#(?object=timesheet;criteria=isagainstjob=0;groupfunction=sum)~totalhours~#]</td></trth>

</tableth> [#(?object=timesheet;criteria=tsinvoiceid>0 and isagainstjob=1;groupfunction=sum)~totalhours~#]</preth>