6 <td width=10> </td>
18 <th><img src=http://www.sql-ledger.org/images/sql-ledger.png border=0 width=64 height=58></th>
30 <h4>I N V O I C E</h4>
41 <table width=100% callspacing=0 cellpadding=0>
43 <th align=left width=50%><font color=ffffff>To</th>
44 <th align=left width=50%><font color=ffffff>Ship To</th>
53 <br><%city%> <%state%> <%zipcode%>
65 <br>Tel: <%customerphone%>
69 <br>Fax: <%customerfax%>
78 <br><%shiptoaddress1%>
80 <br><%shiptoaddress2%>
81 <%end shiptoaddress2%>
82 <br><%shiptocity%> <%shiptostate%> <%shiptozipcode%>
94 <br>Tel: <%shiptophone%>
98 <br>Fax: <%shiptofax%>
116 <table width=100% border=1>
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>
128 <td><%invnumber%></td>
131 <td><%ordnumber%> </td>
132 <td><%employee%> </td>
133 <td><%shippingpoint%> </td>
134 <td><%shipvia%> </td>
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>
150 <th align=right><font color=ffffff>Qt'y</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>
159 <td align=right><%runningnumber%>.</td>
161 <td><%description%></td>
162 <td><%deliverydate%></td>
163 <td align=right><%qty%></td>
165 <td align=right><%sellprice%></td>
166 <td align=right><%discountrate%></td>
167 <td align=right><%linetotal%></td>
172 you can also use netprice instead of sellprice if you
173 don't want to show the discount
174 netprice = sellprice - discount
178 <td colspan=9><hr noshade></td>
183 <th colspan=7 align=right>Total</th>
184 <td colspan=2 align=right><%invtotal%></td>
187 <%if not taxincluded%>
188 <th colspan=7 align=right>Subtotal</th>
189 <td colspan=2 align=right><%subtotal%></td>
195 <th colspan=7 align=right><%taxdescription%> on <%taxbase%> @ <%taxrate%> %</th>
196 <td colspan=2 align=right><%tax%></td>
202 <th colspan=7 align=right>Paid</th>
203 <td colspan=2 align=right>- <%paid%></td>
208 <td colspan=5> </td>
209 <td colspan=4><hr noshade></td>
214 <td colspan=5> </td>
215 <th colspan=2 align=right nowrap>Balance Due</th>
216 <th colspan=2 align=right><%total%></th>
235 <td><%text_amount%> ***** <%decimal%>/100</td>
237 <td align=right nowrap>
238 All prices in <b><%currency%></b>
253 <th align=left>Payments</th>
263 <th align=left>Date</th>
264 <th align=left>Account</th>
265 <th align=left>Source</th>
266 <th align=left>Amount</th>
272 <td><%paymentdate%></td>
273 <td><%paymentaccount%></td>
274 <td><%paymentsource%></td>
291 Thank you for your valued business!
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.
319 <th colspan=9 align=left><font size=-2><%taxdescription%> Registration <%taxnumber%></th>
329 <th colspan=8 align=left><font size=-2>Taxes shown are included in price.</th>