[SL] Some questions regarding orders and invoices

[Alan M. <li...@mu...>]

Hello,

Now that I have some initial issues sorted out with regards to SQL-Ledger, I am able to really play around with it.

One thing I have noticed is that when printing an invoice (whether to  PDF, HTML, or printer), the "Description" field above the line items is not included (I am planning to use this as a reminder of what the particular service job was for).  I did edit the LaTeX template to add the "Description" heading, but I do not know the variable to use to actually include the text.  In the template, just above where it has "\textbf{I N V O I C E}", I added the following:

\textbf{Description: } <%description%>
\vspace{1cm}

When I print the invoice, however, I do see the "Description" above the "I N V O I C E" text, as it should be, but the text after it has something like "ARRAY(0x9d49670)" instead of the text I entered in SQL-Ledger.

Does anyone know the variable name I need to use to get that text included?

My second question is regarding order/invoice numbers.  I am wantingto use a variable for order/invoice numbers in the form of YYYYMM-xx, where "YYYY" is the four-digit year, "MM" is the two-digit month, and "xx" is an incremented number starting at 01.  So for example the 5th Sales Order generated for the month of November 2008 would have a number of "200811-05".  In the "System Preferences", I tried putting "YYYMM-01" in for the number, but this of course, creates incremented numbers of YYYYMM-01, YYYYMM-02, etc.  I can, of course, treat that as a placeholder and change YYYYMM" as appropriate on a per order/invoice basis, but if I can use variables for this, that would be better.

Any advice on that greatly appreciated.  Thanks! :-)

-Alan