sql-ledger/templates/Default-invoice.html

   1
   2 <body bgcolor=ffffff>
   3
   4 <table width=100%>
   5   <tr>
   6     <td width=10>&nbsp;</td>
   7
   8     <td>
   9       <table width=100%>
  10         <tr>
  11           <td>
  12             <h4>
  13             <%company%>
  14         <br><%address%>
  15             </h4>
  16           </td>
  17
  18           <th><img src=http://www.sql-ledger.org/images/sql-ledger.png border=0 width=64 height=58></th>
  19
  20           <td align=right>
  21             <h4>
  22             Tel: <%tel%>
  23         <br>Fax: <%fax%>
  24             </h4>
  25           </td>
  26         </tr>
  27
  28         <tr>
  29           <th colspan=3>
  30             <h4>I N V O I C E</h4>
  31           </th>
  32         </tr>
  33       </table>
  34     </td>
  35   </tr>
  36
  37   <tr>
  38     <td>&nbsp;</td>
  39
  40     <td>
  41       <table width=100% callspacing=0 cellpadding=0>
  42         <tr bgcolor=000000>
  43           <th align=left width=50%><font color=ffffff>To</th>
  44           <th align=left width=50%><font color=ffffff>Ship To</th>
  45         </tr>
  46
  47         <tr valign=top>
  48           <td><%name%>
  49           <br><%address1%>
  50           <%if address2%>
  51           <br><%address2%>
  52           <%end address2%>
  53           <br><%city%> <%state%> <%zipcode%>
  54           <%if country%>
  55           <br><%country%>
  56           <%end country%>
  57           <br>
  58
  59           <%if contact%>
  60           <br><%contact%>
  61           <br>
  62           <%end contact%>
  63
  64           <%if customerphone%>
  65           <br>Tel: <%customerphone%>
  66           <%end customerphone%>
  67
  68           <%if customerfax%>
  69           <br>Fax: <%customerfax%>
  70           <%end customerfax%>
  71
  72           <%if email%>
  73           <br><%email%>
  74           <%end email%>
  75           </td>
  76
  77           <td><%shiptoname%>
  78           <br><%shiptoaddress1%>
  79           <%if shiptoaddress2%>
  80           <br><%shiptoaddress2%>
  81           <%end shiptoaddress2%>
  82           <br><%shiptocity%> <%shiptostate%> <%shiptozipcode%>
  83           <%if shiptocountry%>
  84           <br><%shiptocountry%>
  85           <%end shiptocountry%>
  86           <br>
  87
  88           <%if shiptocontact%>
  89           <br><%shiptocontact%>
  90           <br>
  91           <%end shiptocontact%>
  92
  93           <%if shiptophone%>
  94           <br>Tel: <%shiptophone%>
  95           <%end shiptophone%>
  96
  97           <%if shiptofax%>
  98           <br>Fax: <%shiptofax%>
  99           <%end shiptofax%>
 100
 101           <%if shiptoemail%>
 102           <br><%shiptoemail%>
 103           <%end shiptoemail%>
 104           </td>
 105         </tr>
 106       </table>
 107     </td>
 108   </tr>
 109
 110   <tr height=5></tr>
 111
 112   <tr>
 113     <td>&nbsp;</td>
 114
 115     <td>
 116       <table width=100% border=1>
 117         <tr>
 118           <th width=14% align=left nowrap>Invoice #</th>
 119           <th width=14% align=left nowrap>Date</th>
 120           <th width=14% align=left nowrap>Due</th>
 121           <th width=14% align=left>Order #</th>
 122           <th width=14% align=left nowrap>Salesperson</th>
 123           <th width=14% align=left nowrap>Shipping Point</th>
 124           <th width=14% align=left nowrap>Ship via</th>
 125         </tr>
 126
 127         <tr>
 128           <td><%invnumber%></td>
 129           <td><%invdate%></td>
 130           <td><%duedate%></td>
 131           <td><%ordnumber%>&nbsp;</td>
 132           <td><%employee%>&nbsp;</td>
 133           <td><%shippingpoint%>&nbsp;</td>
 134           <td><%shipvia%>&nbsp;</td>
 135         </tr>
 136       </table>
 137     </td>
 138   </tr>
 139
 140   <tr>
 141     <td>&nbsp;</td>
 142
 143     <td>
 144       <table width=100%>
 145         <tr bgcolor=000000>
 146           <th align=right><font color=ffffff>No.</th>
 147           <th align=left><font color=ffffff>Number</th>
 148           <th align=left><font color=ffffff>Description</th>
 149           <th>&nbsp;</th>
 150           <th align=right><font color=ffffff>Qt'y</th>
 151           <th>&nbsp;</th>
 152           <th align=right><font color=ffffff>Unit Price</th>
 153           <th align=right><font color=ffffff>Disc %</th>
 154           <th align=right><font color=ffffff>Extended</th>
 155         </tr>
 156
 157         <%foreach number%>
 158         <tr valign=top>
 159           <td align=right><%runningnumber%>.</td>
 160           <td><%number%></td>
 161           <td><%description%></td>
 162           <td><%deliverydate%></td>
 163           <td align=right><%qty%></td>
 164           <td><%unit%></td>
 165           <td align=right><%sellprice%></td>
 166           <td align=right><%discountrate%></td>
 167           <td align=right><%linetotal%></td>
 168         </tr>
 169         <%end number%>
 170
 171 <!--
 172 you can also use netprice instead of sellprice if you
 173 don't want to show the discount
 174 netprice = sellprice - discount
 175 -->
 176
 177         <tr>
 178           <td colspan=9><hr noshade></td>
 179         </tr>
 180
 181         <tr>
 182           <%if taxincluded%>
 183           <th colspan=7 align=right>Total</th>
 184           <td colspan=2 align=right><%invtotal%></td>
 185           <%end taxincluded%>
 186
 187           <%if not taxincluded%>
 188           <th colspan=7 align=right>Subtotal</th>
 189           <td colspan=2 align=right><%subtotal%></td>
 190           <%end taxincluded%>
 191         </tr>
 192
 193         <%foreach tax%>
 194         <tr>
 195           <th colspan=7 align=right><%taxdescription%> on <%taxbase%> @ <%taxrate%> %</th>
 196           <td colspan=2 align=right><%tax%></td>
 197         </tr>
 198         <%end tax%>
 199
 200         <%if paid%>
 201         <tr>
 202           <th colspan=7 align=right>Paid</th>
 203           <td colspan=2 align=right>- <%paid%></td>
 204         </tr>
 205         <%end paid%>
 206
 207         <tr>
 208           <td colspan=5>&nbsp;</td>
 209           <td colspan=4><hr noshade></td>
 210         </tr>
 211
 212         <%if total%>
 213         <tr>
 214           <td colspan=5>&nbsp;</td>
 215           <th colspan=2 align=right nowrap>Balance Due</th>
 216           <th colspan=2 align=right><%total%></th>
 217         </tr>
 218         <%end total%>
 219
 220         <tr>
 221       </table>
 222     </td>
 223   </tr>
 224
 225   <tr>
 226     <td>&nbsp;</td>
 227
 228     <td>
 229       <table width=100%>
 230         <tr valign=top>
 231           <%if notes%>
 232           <td><%notes%></td>
 233           <%end notes%>
 234
 235           <td><%text_amount%> ***** <%decimal%>/100</td>
 236
 237           <td align=right nowrap>
 238           All prices in <b><%currency%></b>
 239           </td>
 240         </tr>
 241       </table>
 242     </td>
 243   </tr>
 244
 245   <%if paid%>
 246   <tr>
 247     <td>&nbsp;</td>
 248
 249     <td colspan=9>
 250       <table width=60%>
 251
 252         <tr>
 253           <th align=left>Payments</th>
 254         </tr>
 255
 256         <tr>
 257           <td colspan=4>
 258           <hr noshade>
 259           </td>
 260         </tr>
 261
 262         <tr>
 263           <th align=left>Date</th>
 264           <th align=left>Account</th>
 265           <th align=left>Source</th>
 266           <th align=left>Amount</th>
 267         </tr>
 268   <%end paid%>
 269
 270         <%foreach payment%>
 271         <tr>
 272           <td><%paymentdate%></td>
 273           <td><%paymentaccount%></td>
 274           <td><%paymentsource%></td>
 275           <td><%payment%></td>
 276         </tr>
 277         <%end payment%>
 278
 279   <%if paid%>
 280       </table>
 281     </td>
 282   </tr>
 283   <%end paid%>
 284
 285   <tr height=10></tr>
 286
 287   <tr>
 288     <td>&nbsp;</td>
 289
 290     <th>
 291     Thank you for your valued business!
 292     </th>
 293   </tr>
 294
 295   <tr>
 296     <td>&nbsp;</td>
 297
 298     <td>
 299       <table width=100%>
 300         <tr valign=top>
 301           <td width=60%><font size=-3>
 302           Payment due by <%duedate%>.
 303           Items returned are subject to a 10% restocking charge. A return authorization must be obtained from <%company%> before goods are returned. Returns must be shipped prepaid and properly insured. <%company%> will not be responsible for damages during transit.
 304           </font>
 305           </td>
 306
 307           <td width=40%>
 308           X <hr noshade>
 309           </td>
 310         </tr>
 311       </table>
 312     </td>
 313   </tr>
 314
 315   <%foreach tax%>
 316   <tr>
 317     <td>&nbsp;</td>
 318
 319     <th colspan=9 align=left><font size=-2><%taxdescription%> Registration <%taxnumber%></th>
 320   </tr>
 321   <%end tax%>
 322
 323   <%if taxincluded%>
 324   <tr>
 325     <td>&nbsp;</td>
 326   </tr>
 327
 328   <tr>
 329     <th colspan=8 align=left><font size=-2>Taxes shown are included in price.</th>
 330   </tr>
 331   <%end taxincluded%>
 332
 333 </table>
 334
 335 </body>
 336 </html>
 337