<body bgcolor=ffffff>
<table width=100%>
-<tr valign=bottom>
- <td width=10> </td>
- <td>
-
- <table width=100%>
<tr>
- <td>
- <h4>
- <%company%>
- <br><%address%>
- </h4>
- </td>
+ <td width=10> </td>
- <td align=right>
- <h4>
- Telephone: <%tel%>
- <br>Facsimile: <%fax%>
- </h4>
+ <td>
+ <table width=100%>
+ <tr>
+ <td>
+ <h4>
+ <%company%>
+ <br><%address%>
+ </h4>
+ </td>
+
+ <th><img src=http://www.sql-ledger.org/images/sql-ledger.png border=0 width=64 height=58></th>
+
+ <td align=right>
+ <h4>
+ Tel: <%tel%>
+ <br>Fax: <%fax%>
+ </h4>
+ </td>
+ </tr>
+
+ <tr>
+ <th colspan=3>
+ <h4>I N V O I C E</h4>
+ </th>
+ </tr>
+ </table>
</td>
</tr>
<tr>
- <th colspan=3>
- <h4>I N V O I C E</h4>
- </th>
- </tr>
-
- </table>
-
-
- <table width=100% callspacing=0 cellpadding=0>
-
- <tr>
- <td align=right>
- <table>
- <tr>
- <th align=right>Invoice Date</th><td width=10> </td><td><%invdate%></td>
- </tr>
-
- <tr>
- <th align=right>Due Date</th><td width=10> </td><td><%duedate%></td>
- </tr>
-
- <tr>
- <th align=right>Number</th><td> </td><td><%invnumber%></td></tr>
- </tr>
-
-<!--
- <tr>
- <th align=right>Clerk:</th><td> </td><td><%employee%></td>
- </tr>
--->
+ <td> </td>
- <tr>
- <td> </td>
- </tr>
+ <td>
+ <table width=100% callspacing=0 cellpadding=0>
+ <tr bgcolor=000000>
+ <th align=left width=50%><font color=ffffff>To</th>
+ <th align=left width=50%><font color=ffffff>Ship To</th>
+ </tr>
+
+ <tr valign=top>
+ <td><%name%>
+ <br><%address1%>
+ <%if address2%>
+ <br><%address2%>
+ <%end address2%>
+ <br><%city%> <%state%> <%zipcode%>
+ <%if country%>
+ <br><%country%>
+ <%end country%>
+ <br>
+
+ <%if contact%>
+ <br><%contact%>
+ <br>
+ <%end contact%>
+
+ <%if customerphone%>
+ <br>Tel: <%customerphone%>
+ <%end customerphone%>
+
+ <%if customerfax%>
+ <br>Fax: <%customerfax%>
+ <%end customerfax%>
+
+ <%if email%>
+ <br><%email%>
+ <%end email%>
+ </td>
+
+ <td><%shiptoname%>
+ <br><%shiptoaddress1%>
+ <%if shiptoaddress2%>
+ <br><%shiptoaddress2%>
+ <%end shiptoaddress2%>
+ <br><%shiptocity%> <%shiptostate%> <%shiptozipcode%>
+ <%if shiptocountry%>
+ <br><%shiptocountry%>
+ <%end shiptocountry%>
+ <br>
+
+ <%if shiptocontact%>
+ <br><%shiptocontact%>
+ <br>
+ <%end shiptocontact%>
+
+ <%if shiptophone%>
+ <br>Tel: <%shiptophone%>
+ <%end shiptophone%>
+
+ <%if shiptofax%>
+ <br>Fax: <%shiptofax%>
+ <%end shiptofax%>
+
+ <%if shiptoemail%>
+ <br><%shiptoemail%>
+ <%end shiptoemail%>
+ </td>
+ </tr>
+ </table>
</td>
- </table>
</tr>
+ <tr height=5></tr>
+
<tr>
+ <td> </td>
+
<td>
- <table width=100%>
- <tr bgcolor=000000>
- <th align=left><font color=ffffff>To:</th>
- <th align=left><font color=ffffff>Ship To:</th>
- </tr>
-
-<!--
- other variables which can be use:
- contact, shiptocontact, shiptophone, shiptofax
--->
-
- <tr valign=top>
- <td><%name%>
- <br><%addr1%>
- <br><%addr2%>
- <br><%addr3%>
- <br><%addr4%>
- </td>
-
- <td><%shiptoname%>
- <br><%shiptoaddr1%>
- <br><%shiptoaddr2%>
- <br><%shiptoaddr3%>
- <br><%shiptoaddr4%>
- </td>
- </tr>
- </table>
+ <table width=100% border=1>
+ <tr>
+ <th width=14% align=left nowrap>Invoice #</th>
+ <th width=14% align=left nowrap>Date</th>
+ <th width=14% align=left nowrap>Due</th>
+ <th width=14% align=left>Order #</th>
+ <th width=14% align=left nowrap>Salesperson</th>
+ <th width=14% align=left nowrap>Shipping Point</th>
+ <th width=14% align=left nowrap>Ship via</th>
+ </tr>
+
+ <tr>
+ <td><%invnumber%></td>
+ <td><%invdate%></td>
+ <td><%duedate%></td>
+ <td><%ordnumber%> </td>
+ <td><%employee%> </td>
+ <td><%shippingpoint%> </td>
+ <td><%shipvia%> </td>
+ </tr>
+ </table>
</td>
</tr>
<tr>
<td> </td>
- </tr>
- <tr>
<td>
- <table width=100%>
- <tr bgcolor=000000>
-<!-- <th align=right><font color=ffffff>No.</th> -->
- <th align=left><font color=ffffff>Number</th>
- <th align=left><font color=ffffff>Description</th>
- <th><font color=ffffff>Qt'y</th>
- <th> </th>
- <th><font color=ffffff>Price</th>
- <th><font color=ffffff>Disc</th>
- <th><font color=ffffff>Amount</th>
- </tr>
-
-<%foreach number%>
- <tr valign=top>
-<!-- <td align=right><%runningnumber%>.</td>
-adjust the colspan if you include this to shift subtotal one to the right
--->
- <td><%number%></td>
- <td><%description%></td>
- <td align=right><%qty%></td>
- <td><%unit%></td>
- <td align=right><%sellprice%></td>
- <td align=right><%discount%></td>
- <td align=right><%linetotal%></td>
- </tr>
-<%end number%>
+ <tr bgcolor=000000>
+ <th align=right><font color=ffffff>No.</th>
+ <th align=left><font color=ffffff>Number</th>
+ <th align=left><font color=ffffff>Description</th>
+ <th> </th>
+ <th align=right><font color=ffffff>Qt'y</th>
+ <th> </th>
+ <th align=right><font color=ffffff>Unit Price</th>
+ <th align=right><font color=ffffff>Disc %</th>
+ <th align=right><font color=ffffff>Extended</th>
+ </tr>
+
+ <%foreach number%>
+ <tr valign=top>
+ <td align=right><%runningnumber%>.</td>
+ <td><%number%></td>
+ <td><%description%></td>
+ <td><%deliverydate%></td>
+ <td align=right><%qty%></td>
+ <td><%unit%></td>
+ <td align=right><%sellprice%></td>
+ <td align=right><%discountrate%></td>
+ <td align=right><%linetotal%></td>
+ </tr>
+ <%end number%>
<!--
you can also use netprice instead of sellprice if you
netprice = sellprice - discount
-->
- <tr>
- <td colspan=7><hr noshade></td>
- </tr>
+ <tr>
+ <td colspan=9><hr noshade></td>
+ </tr>
- <tr>
-<%if taxincluded%>
- <th colspan=5 align=right>Total</th>
- <td colspan=2 align=right><%invtotal%></td>
-<%end taxincluded%>
-<%if not taxincluded%>
- <th colspan=5 align=right>Subtotal</th>
- <td colspan=2 align=right><%subtotal%></td>
-<%end taxincluded%>
- </tr>
-
-<%foreach tax%>
- <tr>
- <th colspan=5 align=right><%taxdescription%> on <%taxbase%> @ <%taxrate%> %</th>
- <td colspan=2 align=right><%tax%></td>
- </tr>
-<%end tax%>
-
-<%if paid%>
- <tr>
- <th colspan=5 align=right>Paid</th>
- <td colspan=2 align=right>- <%paid%></td>
- </tr>
-<%end paid%>
-
- <tr>
- <td colspan=3> </td>
- <td colspan=4><hr noshade></td>
- </tr>
-
- <tr>
- <td colspan=3>Terms Net <b><%terms%></b> days</td>
- <th colspan=2 align=right>Outstanding</th>
- <th colspan=2 align=right><%total%></th>
- </tr>
-
- <tr>
- <td> </td>
- </tr>
-
- </table>
+ <tr>
+ <%if taxincluded%>
+ <th colspan=7 align=right>Total</th>
+ <td colspan=2 align=right><%invtotal%></td>
+ <%end taxincluded%>
+
+ <%if not taxincluded%>
+ <th colspan=7 align=right>Subtotal</th>
+ <td colspan=2 align=right><%subtotal%></td>
+ <%end taxincluded%>
+ </tr>
+
+ <%foreach tax%>
+ <tr>
+ <th colspan=7 align=right><%taxdescription%> on <%taxbase%> @ <%taxrate%> %</th>
+ <td colspan=2 align=right><%tax%></td>
+ </tr>
+ <%end tax%>
+
+ <%if paid%>
+ <tr>
+ <th colspan=7 align=right>Paid</th>
+ <td colspan=2 align=right>- <%paid%></td>
+ </tr>
+ <%end paid%>
+
+ <tr>
+ <td colspan=5> </td>
+ <td colspan=4><hr noshade></td>
+ </tr>
+
+ <%if total%>
+ <tr>
+ <td colspan=5> </td>
+ <th colspan=2 align=right nowrap>Balance Due</th>
+ <th colspan=2 align=right><%total%></th>
+ </tr>
+ <%end total%>
+
+ <tr>
+ </table>
</td>
</tr>
-<tr>
- <td>
- <table width=100%>
- <tr valign=top>
-<%if notes%>
- <td>Notes</td>
- <td><%notes%></td>
-<%end notes%>
- <td align=right>
- All prices in <b><%currency%></b> Funds
- <br><%shippingpoint%>
- </td>
- </tr>
-
- </table>
- </td>
-</tr>
-
-<tr><td> </td></tr>
-
-<%if paid%>
-<tr>
- <td colspan=7>
- <table width=60%>
- <tr>
- <th align=left>Payments</th>
- </tr>
- <tr>
- <td colspan=4>
- <hr noshade>
- </td>
- </tr>
- <tr>
- <th align=left>Date</th>
- <th align=left>Account</th>
- <th align=left>Source</th>
- <th align=left>Amount</th>
- </tr>
-<%end paid%>
-
-<%foreach payment%>
- <tr>
- <td><%paymentdate%></td>
- <td><%paymentaccount%></td>
- <td><%paymentsource%></td>
- <td><%payment%></td>
- </tr>
-<%end payment%>
-
-<%if paid%>
- </table>
- </td>
-</tr>
-
-<tr>
- <td> </td>
-</tr>
-<%end paid%>
-
-<tr>
- <th colspan=7>
- <br>Thank you for your valued business!
- </th>
-</tr>
-
-<tr><td> </td></tr>
-
-<tr>
- <td>
- <table width=100%>
- <tr valign=top>
- <td><font size=-3>
- Payment due NET <%terms%> Days from date of Invoice.
- Interest on overdue amounts will acrue at the rate of 1.5% per month
- from due date until paid in full. 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.
- </font>
+ <tr>
+ <td> </td>
+
+ <td>
+ <table width=100%>
+ <tr valign=top>
+ <%if notes%>
+ <td><%notes%></td>
+ <%end notes%>
+
+ <td><%text_amount%> ***** <%decimal%>/100</td>
+
+ <td align=right nowrap>
+ All prices in <b><%currency%></b>
+ </td>
+ </tr>
+ </table>
</td>
- <td width=150>
- X <hr noshade>
+ </tr>
+
+ <%if paid%>
+ <tr>
+ <td> </td>
+
+ <td colspan=9>
+ <table width=60%>
+
+ <tr>
+ <th align=left>Payments</th>
+ </tr>
+
+ <tr>
+ <td colspan=4>
+ <hr noshade>
+ </td>
+ </tr>
+
+ <tr>
+ <th align=left>Date</th>
+ <th align=left>Account</th>
+ <th align=left>Source</th>
+ <th align=left>Amount</th>
+ </tr>
+ <%end paid%>
+
+ <%foreach payment%>
+ <tr>
+ <td><%paymentdate%></td>
+ <td><%paymentaccount%></td>
+ <td><%paymentsource%></td>
+ <td><%payment%></td>
+ </tr>
+ <%end payment%>
+
+ <%if paid%>
+ </table>
</td>
</tr>
- </table>
- </td>
-</tr>
+ <%end paid%>
+
+ <tr height=10></tr>
-<%foreach tax%>
<tr>
- <th colspan=7 align=left><font size=-2><%taxdescription%> Registration <%taxnumber%></th>
+ <td> </td>
+
+ <th>
+ Thank you for your valued business!
+ </th>
</tr>
-<%end tax%>
-<%if taxincluded%>
<tr>
- <th colspan=7 align=left><font size=-2>Taxes shown are included in price.</th>
+ <td> </td>
+
+ <td>
+ <table width=100%>
+ <tr valign=top>
+ <td width=60%><font size=-3>
+ Payment due by <%duedate%>.
+ 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.
+ </font>
+ </td>
+
+ <td width=40%>
+ X <hr noshade>
+ </td>
+ </tr>
+ </table>
+ </td>
</tr>
-<%end taxincluded%>
-<!-- business number
+ <%foreach tax%>
<tr>
- <th colspan=7 align=left><font size=-2>Business Number: <%businessnumber%></font></th>
+ <td> </td>
+
+ <th colspan=9 align=left><font size=-2><%taxdescription%> Registration <%taxnumber%></th>
</tr>
--->
+ <%end tax%>
-<!-- banking information
+ <%if taxincluded%>
<tr>
- <th colspan=7 align=left>Banking Information:
- <br>Bank
- <br>Transit No.
- <br>Account No.
- </td>
+ <td> </td>
</tr>
--->
-</table>
+ <tr>
+ <th colspan=8 align=left><font size=-2>Taxes shown are included in price.</th>
+ </tr>
+ <%end taxincluded%>
-</td>
-</tr>
</table>
</body>
projects / freeside.git / blobdiff