sql-ledger-users

Re: [SL] Invoice with full details?

[Jeff K. <jt...@ya...>]

----- Original Message ----=0AFrom: Tony Fraser <to...@sy...>=0ATo: =
sql...@li...=0ASent: Friday, July 14, 2006 8:05:0=
9 PM=0ASubject: Re: [SL] Invoice with full details?=0A> > ... I have a nice=
 summary of my notes from the related time cards. =0A> > Is there any easy =
way to get those notes onto the printed Invoice? =0A> =0A> You'd have to mo=
dify your invoice template but the field your talking =0A> about is availab=
le withing the =0A>   <%foreach number%> .... <%end number%> part as =0A>  =
 <%itemnotes%>=0A=0ACan anyone suggest a tex syntax for handling long itemn=
otes? When I make the following change to invoice.tex, get whitespace where=
 the itemnotes (a few hundred characters long) should be. Omitting <%itemno=
tes%> does display the item numbering, so it seems the loop can be reused. =
I don't generally put linebreaks in the timecard descriptions, so they may =
not be linewrapping.=0A=0A@@ -178,6 +178,9 @@=0A \vspace{12pt}=0A =0A <%not=
es%>=0A+<%foreach number%>=0A+  <%runningnumber%>) & <%itemnotes%> \\=0A+<%=
end number%>=0A }=0A =0A \vfill=0A=0AI'd also like to make sure the itemnot=
es pagebreak properly, if they run that long or are that numerous. Thanks.=
=0A=0A=0A=0A=0A

Re: [SL] Invoice with full details?

[Mark B. <ma...@ga...>]

On Wed, Oct 18, 2006 at 10:26:04PM -0700, Jeff Kowalczyk wrote:
> ----- Original Message ----
> From: Tony Fraser <to...@sy...>
> To: sql...@li...
> Sent: Friday, July 14, 2006 8:05:09 PM
> Subject: Re: [SL] Invoice with full details?
> >
> > > ... I have a nice summary of my notes from the related time
> > > cards.  Is there any easy way to get those notes onto the
> > > printed Invoice? 
> > 
> > You'd have to modify your invoice template but the field your
> > talking about is available withing the 
> >   <%foreach number%> .... <%end number%> part as 
> >   <%itemnotes%>
> 
> Can anyone suggest a tex syntax for handling long itemnotes?
> When I make the following change to invoice.tex, get whitespace
> where the itemnotes (a few hundred characters long) should be.
> Omitting <%itemnotes%> does display the item numbering, so it
> seems the loop can be reused. I don't generally put linebreaks
> in the timecard descriptions, so they may not be linewrapping.
> 
> @@ -178,6 +178,9 @@
>  \vspace{12pt}
>  
>  <%notes%>
> +<%foreach number%>
> +  <%runningnumber%>) & <%itemnotes%> \\
> +<%end number%>
>  }

There's a wierd close paren after runningnumber field.  Although
I don't think that should cause the whitespace problem.

Don't know why you would get whitespace.  You didn't include the
tabledef, but maybe it doesn't work properly when the field is
blank.  Test a table with other field values that you know are
blank to see how it get's laid out.  

So far, I've just stuck the item notes after the item description
right on the line item.  But I like your approach better b/c it
seems easier to wrap it in a different font.  For long notes,
it's nice to have smaller font and use more of the page width.

Re: page wrapping, you'll have to experiment.  I know Form.pm
does have logic that handles page breaks, so hopefully it will
just work.

m

Re: [SL] Invoice with full details?

[Jeff K. <jt...@ya...>]

----- Original Message ----=0AFrom: Mark Bucciarelli <ma...@ga...>=
=0ATo: sql...@li...=0ASent: Thursday, October 19,=
 2006 9:49:27 AM=0ASubject: Re: [SL] Invoice with full details?=0A=0A> Ther=
e's a wierd close paren after runningnumber field.=0A=0AIt was just to get =
1) itemnotes... formatting, which is what I used when I manually copied ite=
mnotes into =0Anotes to get them to print. It doesn't affect anything, I gu=
ess ) doesn't need to be escaped in tex.=0A=0A\vspace{12pt}=0A=0A<%notes%>=
=0A<%foreach number%>=0A  <%runningnumber%> & <%itemnotes%> \\=0A<%end numb=
er%>=0A}=0A=0A> Don't know why you would get whitespace. You didn't=0A> inc=
lude the tabledef, but maybe it doesn't work properly=0A> when the field is=
 blank.  Test a table with other field values=0A> that you know are blank t=
o see how it get's laid out.=0A=0AI wanted it to act just like notes, a wra=
pping paragraph, with a simple linebreak for each itemnotes. I expected tha=
t's what the templating above would do.=0A=0AIts strange, but the length of=
 the itemnotes (when used, none are short, and none are blank) seems to be =
causing rendering failure. My pdfviewer is linux evince, windows Acrobat ha=
s the same behavior. itemnotes text is not contained in a select-all text c=
opy-paste.=0A=0ALong notes on invoices with no itemnotes wordwrap corectly,=
 but the presence of <%itemnotes%> as above white-out the whole text block,=
 although the block does take up enough vertical whitespace to make me thin=
k that it's getting rendered (improperly).=0A=0A> your approach (...) seems=
 easier to wrap it in a different font. For=0A> long notes, it's nice to ha=
ve smaller font and use more of the=0A> page width.=0A=0AThat's the objecti=
ve. I want to make the itemnotes visible for review, but in relatively smal=
l sized pagebreaking text after the invoice-level notes.=0A=0A=0A=0A

Re: [SL] Invoice with full details?

[Jeff K. <jt...@ya...>]

Another strange observation: <%description%> works perfectly in this slot, =
but <%itemnotes%> does not.=0A=0Ainvoice.tex: renders notes and description=
 (duplicated in detail table) correctly=0A=0A\vspace{12pt}=0A=0A<%notes%>=
=0A<%foreach number%>=0A  <%runningnumber%>. & <%description%> \\=0A<%end n=
umber%>=0A}=0A=0Ainvoice.tex: output page(s) have enough white space for no=
tes and runningnumber + itemnotes, but no text is rendered there.=0A=0A\vsp=
ace{12pt}=0A=0A<%notes%>=0A<%foreach number%>=0A  <%runningnumber%>. & <%it=
emnotes%> \\=0A<%end number%>=0A}=0A=0A=0A=0A

Re: [SL] Invoice with full details?

[Mark B. <ma...@ga...>]

On Thu, Oct 19, 2006 at 07:30:30AM -0700, Jeff Kowalczyk wrote:
 
> I wanted it to act just like notes, a wrapping paragraph, with
> a simple linebreak for each itemnotes. I expected that's what
> the templating above would do.

Could you post more of the tex file?  I still don't see the
tabledef.

> Its strange, but the length of the itemnotes (when used, none
> are short, and none are blank) seems to be causing rendering
> failure. My pdfviewer is linux evince, windows Acrobat has the
> same behavior. itemnotes text is not contained in a select-all
> text copy-paste.
 
?!

> Long notes on invoices with no itemnotes wordwrap corectly, but
> the presence of <%itemnotes%> as above white-out the whole text
> block, although the block does take up enough vertical
> whitespace to make me think that it's getting rendered
> (improperly).

What happens if you replace the <%itemnotes%> field with some
hard-coded text, as a test?

What happens if you take out the close paren?

What happens if you do both of the above?

Get it rendering properly then add stuff back one piece at a
time.

m

Re: [SL] Invoice with full details?

[Angus J. <ang...@gm...>]

Hi all,

>From what I can read of the pagebreak code in the Form.pm package, it is
this code that is causing this white space.

It looks like it counts the amount of line items in an invoice, and then
makes breaks based on them.  It does not include the %notes% variable in
it's calculation.

There is some sort of logic that includes the itemnotes variable, but it
does not appear to be working correctly, or it works in a way I cannot see
at the moment.

It is rendering the page incorrectly because it doesn't know to make a
pagebreak if there are lots of itemnotes to be printed.

I have successfully made the itemnotes print out by forcing the pagebreak
variable to the following statement:

<%pagebreak 90 7 37%>

This is dependent on the amount of line items in your invoice though, and
it's not a solution...it's just interesting that it worked for me.

Perhaps the pagebreak code can be modified to better handle lots of item
notes...I am not enough of a Perl programmer to tackle this, although I'd
love to use it! ;)

Hope this has been of some help to someone.

Regards,
Angus





On 10/19/06, Mark Bucciarelli <ma...@ga...> wrote:
>
> On Thu, Oct 19, 2006 at 07:30:30AM -0700, Jeff Kowalczyk wrote:
>
> > I wanted it to act just like notes, a wrapping paragraph, with
> > a simple linebreak for each itemnotes. I expected that's what
> > the templating above would do.
>
> Could you post more of the tex file?  I still don't see the
> tabledef.
>
> > Its strange, but the length of the itemnotes (when used, none
> > are short, and none are blank) seems to be causing rendering
> > failure. My pdfviewer is linux evince, windows Acrobat has the
> > same behavior. itemnotes text is not contained in a select-all
> > text copy-paste.
>
> ?!
>
> > Long notes on invoices with no itemnotes wordwrap corectly, but
> > the presence of <%itemnotes%> as above white-out the whole text
> > block, although the block does take up enough vertical
> > whitespace to make me think that it's getting rendered
> > (improperly).
>
> What happens if you replace the <%itemnotes%> field with some
> hard-coded text, as a test?
>
> What happens if you take out the close paren?
>
> What happens if you do both of the above?
>
> Get it rendering properly then add stuff back one piece at a
> time.
>
> m
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job
> easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] Invoice with full details?

[Angus J. <ang...@gm...>]

Hi again,

I have just had a revelation.  From looking at the Form.pm file, I saw that
if I defined the countitemnotes variable in a custom script it may help me
out.  I added this to my custom_io.pl file:

$form->{countitemnotes} = 1;

Now my items print out correctly, at least as far as I have tested they seem
to work great now!

Hope this helps someone else...

Regards,
Angus Jordan


On 10/20/06, Angus Jordan <ang...@gm...> wrote:
>
> Hi all,
>
> From what I can read of the pagebreak code in the Form.pm package, it is
> this code that is causing this white space.
>
> It looks like it counts the amount of line items in an invoice, and then
> makes breaks based on them.  It does not include the %notes% variable in
> it's calculation.
>
> There is some sort of logic that includes the itemnotes variable, but it
> does not appear to be working correctly, or it works in a way I cannot see
> at the moment.
>
> It is rendering the page incorrectly because it doesn't know to make a
> pagebreak if there are lots of itemnotes to be printed.
>
> I have successfully made the itemnotes print out by forcing the pagebreak
> variable to the following statement:
>
> <%pagebreak 90 7 37%>
>
> This is dependent on the amount of line items in your invoice though, and
> it's not a solution...it's just interesting that it worked for me.
>
> Perhaps the pagebreak code can be modified to better handle lots of item
> notes...I am not enough of a Perl programmer to tackle this, although I'd
> love to use it! ;)
>
> Hope this has been of some help to someone.
>
> Regards,
> Angus
>
>
>
>
>
> On 10/19/06, Mark Bucciarelli <ma...@ga...> wrote:
> >
> > On Thu, Oct 19, 2006 at 07:30:30AM -0700, Jeff Kowalczyk wrote:
> >
> > > I wanted it to act just like notes, a wrapping paragraph, with
> > > a simple linebreak for each itemnotes. I expected that's what
> > > the templating above would do.
> >
> > Could you post more of the tex file?  I still don't see the
> > tabledef.
> >
> > > Its strange, but the length of the itemnotes (when used, none
> > > are short, and none are blank) seems to be causing rendering
> > > failure. My pdfviewer is linux evince, windows Acrobat has the
> > > same behavior. itemnotes text is not contained in a select-all
> > > text copy-paste.
> >
> > ?!
> >
> > > Long notes on invoices with no itemnotes wordwrap corectly, but
> > > the presence of <%itemnotes%> as above white-out the whole text
> > > block, although the block does take up enough vertical
> > > whitespace to make me think that it's getting rendered
> > > (improperly).
> >
> > What happens if you replace the <%itemnotes%> field with some
> > hard-coded text, as a test?
> >
> > What happens if you take out the close paren?
> >
> > What happens if you do both of the above?
> >
> > Get it rendering properly then add stuff back one piece at a
> > time.
> >
> > m
> >
> >
> > -------------------------------------------------------------------------
> > Using Tomcat but need to do more? Need to support web services,
> > security?
> > Get stuff done quickly with pre-integrated technology to make your job
> > easier
> > Download IBM WebSphere Application Server v.1.0.1 based on Apache
> > Geronimo
> > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >
>
>

Re: [SL] Invoice with full details?

[Stroller <lin...@my...>]

On 20 Oct 2006, at 17:58, Angus Jordan wrote:
>> From what I can read of the pagebreak code in the Form.pm package,  
>> it is
>> this code that is causing this white space.
>
> It looks like it counts the amount of line items in an invoice, and  
> then
> makes breaks based on them.  It does not include the %notes%  
> variable in
> it's calculation.

Further to my previous posting to the list on this thread:
     is it actually necessary for SL to count the number of line  
items in an invoice?

It's kinda late here, so please just throw caffeine at me if I'm  
waaaaay off base with this, but it seems to me that SL does this  
because the "\begin{tabularx} ... <%foreach number%>  ... <%end number 
%> \end{tabularx}" table (ie the list of items being invoiced) might  
span multiple pages. The impression I get is that LaTeX can handle  
this natively using the longtable package.

I think that if the main invoicable items table is ported to  
longtable then <%itemnotes%> could be properly printed by SL. The  
itemnotes could be as long as the user wishes and there is no need to  
count them. More details will surely be in longtable.dvi, which I  
find to be installed on my system; I'll have a look at this & try  
using it tomorrow.

Any thoughts?

Stroller.

Re: [SL] Invoice with full details?

[Dr E. W L. <el...@li...>]

It is always helpful to read the archives, if they can be found.

I indeed use longtable and leave the page breaks to LaTeX.

greetings, el

Stroller wrote:
> On 20 Oct 2006, at 17:58, Angus Jordan wrote:
>>> From what I can read of the pagebreak code in the Form.pm package,  
>>> it is
>>> this code that is causing this white space.
>> It looks like it counts the amount of line items in an invoice, and  
>> then
>> makes breaks based on them.  It does not include the %notes%  
>> variable in
>> it's calculation.
> 
> Further to my previous posting to the list on this thread:
>      is it actually necessary for SL to count the number of line  
> items in an invoice?
> 
> It's kinda late here, so please just throw caffeine at me if I'm  
> waaaaay off base with this, but it seems to me that SL does this  
> because the "\begin{tabularx} ... <%foreach number%>  ... <%end number 
> %> \end{tabularx}" table (ie the list of items being invoiced) might  
> span multiple pages. The impression I get is that LaTeX can handle  
> this natively using the longtable package.
> 
> I think that if the main invoicable items table is ported to  
> longtable then <%itemnotes%> could be properly printed by SL. The  
> itemnotes could be as long as the user wishes and there is no need to  
> count them. More details will surely be in longtable.dvi, which I  
> find to be installed on my system; I'll have a look at this & try  
> using it tomorrow.
> 
> Any thoughts?
> 
> Stroller.
> 
> 
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Invoice with full details?

[Angus J. <ang...@gm...>]

Hi there,

It is always helpful to read the archives, if they can be found.
>
> I indeed use longtable and leave the page breaks to LaTeX.
>
>

Any chance you could post the applicable excerpts from your invoice.texfile?

I'd love to see how this works...

Thanks in advance,
Angus Jordan

Re: [SL] Invoice with full details?

[Dieter S. <dsi...@sq...>]

\usepackage{longtable}

\begin{document}

\begin{longtable}[l]{@{}rlp{\descrwidth}rl@{\extracolsep\fill}lrrr@{}}
  \textbf{Pos} & \textbf{Number} & \textbf{Description} & \textbf{Req'd} &
\textbf{Qt'y} & \textbf{Unit} & \textbf{Price} & \textbf{Disc \%} &
\textbf{Amount} \\
\endhead
  \hline \multicolumn{9}{r}{\emph{Continued on next page ...}}
\endfoot
\endlastfoot
<%foreach number%>
  <%runningnumber%> & <%number%> & <%description%> & <%deliverydate%> &
<%qty%> & <%unit%> & <%sellprice%> & <%discountrate%> & <%linetotal%> \\
  <%if itemnotes%>& & <%itemnotes%> \\[1em]<%end itemnotes%>
<%end number%>
\end{longtable}


-- 
Dieter Simader       http://www.sql-ledger.com   Tel: (780) 472-8161
DWS Systems Inc.        Accounting Software      Fax: (780) 478-5281
============== On a clear disk you can seek forever ================


On Tue, 7 Nov 2006, Angus Jordan wrote:

> Hi there,
>
> It is always helpful to read the archives, if they can be found.
> >
> > I indeed use longtable and leave the page breaks to LaTeX.
> >
> >
>
> Any chance you could post the applicable excerpts from your invoice.texfile?
>
> I'd love to see how this works...
>
> Thanks in advance,
> Angus Jordan
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] Invoice with full details?

[Jeff K. <jt...@ya...>]

Good news, looking forward to trying that. Is that with or without your cha=
nge:=0A=0A<%pagebreak 90 7 37%>=0A=0AIs there any chance you could post you=
r invoice.tex in terms of changes from the default. diff -u is nice if you =
know how to create diffs.=0A=0A----- Original Message ----=0AFrom: Angus Jo=
rdan <ang...@gm...>=0ATo: sql...@li...=
=0ASent: Friday, October 20, 2006 1:17:45 PM=0ASubject: Re: [SL] Invoice wi=
th full details?=0A=0AHi again,=0A=0AI have just had a revelation.  From lo=
oking at the Form.pm file, I saw that=0Aif I defined the countitemnotes var=
iable in a custom script it may help me=0Aout.  I added this to my custom_i=
o.pl file:=0A=0A$form->{countitemnotes} =3D 1;=0A=0ANow my items print out =
correctly, at least as far as I have tested they seem=0Ato work great now!=
=0A=0AHope this helps someone else...=0A=0ARegards,=0AAngus Jordan=0A=0A=0A=
On 10/20/06, Angus Jordan <ang...@gm...> wrote:=0A>=0A> Hi all,=
=0A>=0A> From what I can read of the pagebreak code in the Form.pm package,=
 it is=0A> this code that is causing this white space.=0A>=0A> It looks lik=
e it counts the amount of line items in an invoice, and then=0A> makes brea=
ks based on them.  It does not include the %notes% variable in=0A> it's cal=
culation.=0A>=0A> There is some sort of logic that includes the itemnotes v=
ariable, but it=0A> does not appear to be working correctly, or it works in=
 a way I cannot see=0A> at the moment.=0A>=0A> It is rendering the page inc=
orrectly because it doesn't know to make a=0A> pagebreak if there are lots =
of itemnotes to be printed.=0A>=0A> I have successfully made the itemnotes =
print out by forcing the pagebreak=0A> variable to the following statement:=
=0A>=0A> <%pagebreak 90 7 37%>=0A>=0A> This is dependent on the amount of l=
ine items in your invoice though, and=0A> it's not a solution...it's just i=
nteresting that it worked for me.=0A>=0A> Perhaps the pagebreak code can be=
 modified to better handle lots of item=0A> notes...I am not enough of a Pe=
rl programmer to tackle this, although I'd=0A> love to use it! ;)=0A>=0A> H=
ope this has been of some help to someone.=0A>=0A> Regards,=0A> Angus=0A>=
=0A>=0A>=0A>=0A>=0A> On 10/19/06, Mark Bucciarelli <ma...@ga...> wro=
te:=0A> >=0A> > On Thu, Oct 19, 2006 at 07:30:30AM -0700, Jeff Kowalczyk wr=
ote:=0A> >=0A> > > I wanted it to act just like notes, a wrapping paragraph=
, with=0A> > > a simple linebreak for each itemnotes. I expected that's wha=
t=0A> > > the templating above would do.=0A> >=0A> > Could you post more of=
 the tex file?  I still don't see the=0A> > tabledef.=0A> >=0A> > > Its str=
ange, but the length of the itemnotes (when used, none=0A> > > are short, a=
nd none are blank) seems to be causing rendering=0A> > > failure. My pdfvie=
wer is linux evince, windows Acrobat has the=0A> > > same behavior. itemnot=
es text is not contained in a select-all=0A> > > text copy-paste.=0A> >=0A>=
 > ?!=0A> >=0A> > > Long notes on invoices with no itemnotes wordwrap corec=
tly, but=0A> > > the presence of <%itemnotes%> as above white-out the whole=
 text=0A> > > block, although the block does take up enough vertical=0A> > =
> whitespace to make me think that it's getting rendered=0A> > > (improperl=
y).=0A> >=0A> > What happens if you replace the <%itemnotes%> field with so=
me=0A> > hard-coded text, as a test?=0A> >=0A> > What happens if you take o=
ut the close paren?=0A> >=0A> > What happens if you do both of the above?=
=0A> >=0A> > Get it rendering properly then add stuff back one piece at a=
=0A> > time.=0A> >=0A> > m=0A> >=0A> >=0A> > ------------------------------=
-------------------------------------------=0A> > Using Tomcat but need to =
do more? Need to support web services,=0A> > security?=0A> > Get stuff done=
 quickly with pre-integrated technology to make your job=0A> > easier=0A> >=
 Download IBM WebSphere Application Server v.1.0.1 based on Apache=0A> > Ge=
ronimo=0A> > http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D2=
63057&dat=3D121642=0A> > _______________________________________________=0A=
> > sql-ledger-users mailing list=0A> > sql...@li...urceforge.=
net=0A> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users=0A>=
 >=0A>=0A>=0A--------------------------------------------------------------=
-----------=0AUsing Tomcat but need to do more? Need to support web service=
s, security?=0AGet stuff done quickly with pre-integrated technology to mak=
e your job easier=0ADownload IBM WebSphere Application Server v.1.0.1 based=
 on Apache Geronimo=0Ahttp://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D12070=
9&bid=3D263057&dat=3D121642=0A_____________________________________________=
__=0Asql-ledger-users mailing list=0As...@li...=
=0Ahttps://lists.sourceforge.net/lists/listinfo/sql-ledger-users=0A=0A=0A=
=0A=0A

Re: [SL] Invoice with full details?

[Angus J. <ang...@gm...>]

Hi Jeff,

On 10/20/06, Jeff Kowalczyk <jt...@ya...> wrote:
>
> Good news, looking forward to trying that. Is that with or without your
> change:
>
> <%pagebreak 90 7 37%>
>
> Is there any chance you could post your invoice.tex in terms of changes
> from the default. diff -u is nice if you know how to create diffs.
>
>

Here's a diff from the original Default-invoice.tex and the simple change I
mentioned above:

--- invoice.tex Fri Oct 20 11:14:33 2006
+++ invoice.tex.orig    Fri Oct 20 11:14:17 2006
@@ -24,7 +24,7 @@

 <%include letterhead.tex%>

-<%pagebreak 65 7 37%>
+<%pagebreak 65 27 37%>
 \end{tabularx}

   \rule{\textwidth}{2pt}


But, as I mentioned this is not a resolution...it was simply an interesting
observation.  I think adding this into your bin/mozilla/custom_io.pl file
helps more:

$form->{countitemnotes} = 1;

Without the template modification, it counts the items better...Although I
have just noticed there are still some issues when there are *lots* of line
items, itemnotes, and notes...it can get kind of messy sometimes.  Hopefully
I will find a balance somewhere playing with some of the variables in the
template, etc...

Regards,
Angus

Re: [SL] Invoice with full details?

[Stroller <lin...@my...>]

On 20 Oct 2006, at 19:20, Angus Jordan wrote:
> ...adding this into your bin/mozilla/custom_io.pl file
> helps more:
>
> $form->{countitemnotes} = 1;
>
> ... it counts the items better...Although I
> have just noticed there are still some issues when there are *lots*  
> of line
> items, itemnotes, and notes...it can get kind of messy sometimes.   
> Hopefully
> I will find a balance somewhere playing with some of the variables  
> in the
> template, etc...

Did you get any further with this, please?

I too have just unexpectedly run into this feature and since I was  
planning for itemnotes to be important to me I'd prefer the best work- 
around possible.

At the moment I am "practising" with SQL-Ledger by entering a couple  
of years' worth of archived invoices, but I'd like to go live quite  
soon - really, as soon as I have finished my invoice.tex. To date  
when I have entered "Part: 001, Technical support - per hour" I have  
added an itemnote explaining "server setup" or "virus removal" or  
whatever; since I might have two separate entries on an invoice, for  
different visits to a site each for a different activity, I would  
prefer the item notes to be shown underneath each entry.

Basically, I have at least one itemnote on each invoice, and often  
several because about half of the items I sell have itemnotes. Often  
the itemnotes run to several lines. Without a clean way of printing  
itemnotes I don't know how I'll proceed.

Stroller.

Re: [SL] Invoice with full details?

[Shawn <sg...@op...>]

I have been encouraged by this thread to try to get my itemnotes =

printing as well.  In my case though I want the notes to print on a =

separate page as they are only supporting detail for the invoice =

numbers.  To that end, I've added the following to my invoice.tex file =

right before the \enddocument line at the bottom:

\newpage
  \vspace{12pt}
  Supporting Notes:

  <%notes%>
<%foreach number%>
   <%runningnumber%>) & <%itemnotes%> \\
<%end number%>

This works in some cases, but not in others.  When it does work, it's =

plenty good enough for my purposes.  But when it fails, I get no =

document at all when printing a PDF to screen.  Printing postscript to =

screen gives me some output, but that looks odd compared to the PDFs =

that work.  Any tips or suggestions?  (I also created my custom_io.pl =

file with the line specified in this thread.)

I have customized my invoice.tex file in the past, so there is a chance =

I've messed it up.  I'm trying to attach it here, but don't know if the =

list supports attachements.  If not, I can mail it directly to anyone =

who may like to take a look at it.

Thanks for any feedback.

Shawn

Angus Jordan wrote:
> Hi Jeff,
> =

> On 10/20/06, Jeff Kowalczyk <jt...@ya...> wrote:
>> Good news, looking forward to trying that. Is that with or without your
>> change:
>>
>> <%pagebreak 90 7 37%>
>>
>> Is there any chance you could post your invoice.tex in terms of changes
>> from the default. diff -u is nice if you know how to create diffs.
<snip>

Re: [SL] Invoice with full details?

[Dr E. W L. <el...@li...>]

In message <19b...@ma...>, "Angus
 Jordan" writes:
> Hi there,
> 
> It is always helpful to read the archives, if they can be found.
> >
> > I indeed use longtable and leave the page breaks to LaTeX.
> >
> >
> 
> Any chance you could post the applicable excerpts from your invoice.texfile?
> 
> I'd love to see how this works...


You have been warned :-)-O

el

Re: [SL] Invoice with full details?

[Dr E. L. <el...@li...>]

Attachment doesn't seem to have made it, so here it comes in line.



on 11/8/06 2:07 PM Dr Eberhard W Lisse said the following:
> In message <19b...@ma...>, "Angus
>  Jordan" writes:
>> Hi there,
>>
>> It is always helpful to read the archives, if they can be found.
>>> I indeed use longtable and leave the page breaks to LaTeX.
>>>
>>>
>> Any chance you could post the applicable excerpts from your invoice.texfile?
>>
>> I'd love to see how this works...
> 
> 
> You have been warned :-)-O
> 
> el

\documentclass[9pt,oneside,english]{scrartcl}
\usepackage[T1]{fontenc}
\usepackage[latin1]{inputenc}
\usepackage[urlcolor=blue,a4paper,colorlinks=true]{hyperref}
\usepackage{array}
\usepackage{babel}
\usepackage{bookman}
\usepackage{geometry}
\usepackage{graphicx}
\usepackage{ifthen}
\usepackage{numprint}
\usepackage{substr}
\usepackage{longtable}

\geometry{portrait,a4paper,tmargin=2cm,bmargin=2cm,lmargin=2cm,rmargin=2cm}

\setlength\parskip{\medskipamount}
\setlength\parindent{0pt}

\makeatletter
\makeatother

\begin{document}
\pagestyle{empty}

\begin{center}

%
% make sure the numprint package doesn't put '.' every three digits 
before the decimal
%
\npthousandsep{}
\noindent
\setlength\LTleft{0pt}
\setlength\LTright{0pt}

\begin{longtable}{lllrlrrr}
    \multicolumn{8}{l}{
        \begin{minipage}[t]{0.5\textwidth}
            \textsf{\large\textbf{<%company%>\newline
            <%address%>\newline
            VAT--Registration Nr: 3785142-01-5}}
        \end{minipage}
        \hspace*{\fill}
        \begin{minipage}[t]{0.5\textwidth}
            \textsf{\large\textbf{\hspace*{\fill}<%invdate%>,}}
            \textsf{\large Page \textbf{\thepage}}
            \newline\newline\newline\newline
         \end{minipage}
    }\tabularnewline
    &&&&&&&\tabularnewline
    &&&&&&&\tabularnewline
    \multicolumn{8}{b{\textwidth}}{
        <%name%>\par
        <%address1%>\par
        <%address2%>\par
        <%city%>\par
        <%state%> <%zipcode%>\par
        <%country%>\par
<%if contact%>
        \textbf{\underline{Attn:}} <%contact%>
<%end contact%>
    }\tabularnewline
    &&&&&&&\tabularnewline
    \multicolumn{8}{c}{\textsf{\textbf{\LARGE 
\ifthenelse{\lengthtest{<%subtotal%>pt<0pt}}
	{C R E D I T\ \ N O T E}{T A X\ \ I N V O I C E}}}}\tabularnewline	
    &&&&&&&\tabularnewline
    \textbf{Number} & \multicolumn{7}{l}{<%invnumber%>} \tabularnewline
<%if order%>
    \textbf{Order} & \multicolumn{7}{l}{<%ordnumber%>} \tabularnewline
<%end order%>
%   \textbf{Clerk} & \multicolumn{7}{l}{<%employee%>} \tabularnewline
<%if notes%>
    \textbf{Domain} & \multicolumn{7}{l}{<%notes%>}\tabularnewline
<%end notes%>
    &&&&&&&\tabularnewline
    &&&&&&&\tabularnewline
    \textbf{Code}&
    \textbf{Description}&
    \ifthenelse{\lengthtest{<%subtotal%>pt<0pt}}{}{\textbf{Date}}&
    \textbf{Qt'y}&
    \textbf{Unit}&
    \textbf{Price}&
    \textbf{Disc}&
    \textbf{Amount}\tabularnewline
\endfirsthead
    \textbf{Code}&
    \textbf{Description}&
    \ifthenelse{\lengthtest{<%subtotal%>pt<0pt}}{}{\textbf{Date}}&
    \textbf{Qt'y}&
    \textbf{Unit}&
    \textbf{Price}&
    \textbf{Disc}&
    \textbf{Amount}\tabularnewline
\endhead
    \multicolumn{4}{r}{Subtotal} & 
\multicolumn{4}{r}{<%subtotal%>}\tabularnewline
    &&&&&&&\tabularnewline
    \multicolumn{8}{r}{\footnotesize Continued on next Page}\tabularnewline
\endfoot
&&&&&&&\tabularnewline
\multicolumn{3}{l}{} & 
\multicolumn{4}{l}{\textbf{Subtotal}}&\textbf{<%subtotal%>}\tabularnewline
<%foreach tax%>
\multicolumn{3}{l}{}&\multicolumn{4}{l}{<%taxdescription%> on 
<%taxbase%> } & <%tax%>\tabularnewline
<%end tax%>
<%if paid%>
\multicolumn{3}{l}{} & 
\multicolumn{4}{l}{\textbf{Paid}}&<%paid%>\tabularnewline
<%end paid%>
<%if total%>
    \multicolumn{3}{l}{} & 
\multicolumn{4}{l}{\textbf{Total}}&\textbf{<%total%>}\tabularnewline
<%end total%>
<%if not total%>
    \multicolumn{3}{l}{} & 
\multicolumn{4}{l}{\textbf{Total}}&0.00\tabularnewline
<%end total%>
&&&&&&&\tabularnewline
\multicolumn{8}{r}{All prices in \textbf{<%currency%>} 
funds.}\tabularnewline
\multicolumn{8}{l}{\ifthenelse{\lengthtest{<%subtotal%>pt<0pt}}{}{Due 
Date: \textbf{<%duedate%>}, Terms: Net \textbf{<%terms%>} 
days}}\tabularnewline
\endlastfoot
<%foreach number%>
   <%number%> &
   <%description%> &
   \ifthenelse{\lengthtest{<%subtotal%>pt<0pt}}{}{<%deliverydate%>} &
   <%qty%> &
   <%unit%> &
   \nprounddigits{2}\numprint{<%sellprice%>} &
   \nprounddigits{2}\numprint{<%discount%>} &
   <%linetotal%>\tabularnewline
<%end number%>
\end{longtable}
\par
\end{center}

\vspace*{\fill}

<%if paid%>
\vspace*{\fill}
\begin{longtable}[l]{@{}llllrr@{}}
\textbf{Payments}& & & &\tabularnewline
\hline
\textbf{Date}&\textbf{Account}&\textbf{Source}&\textbf{Memo}&\textbf{Amount}\tabularnewline
\endfirsthead
\textbf{Date}&\textbf{Account}&\textbf{Source}&\textbf{Memo}&\textbf{Amount}\tabularnewline
\endhead
\endfoot
\endlastfoot
<%end paid%>
<%foreach payment%>
   <%paymentdate%> & <%paymentaccount%> & <%paymentsource%> & 
<%paymentmemo%> &
   \nprounddigits{2}\numprint{<%payment%>}\tabularnewline
<%end payment%>
<%if paid%>
\end{longtable}
\vspace*{\fill}
<%end paid%>


{\footnotesize%
<%if total%>
Please note that this invoice is payable immediately, however action
may be taken after the Due Date listed above.
<%end total%>
Please take note that we do not wish to communciate by Telephone or
Fax due to record keeping purposes. Please communicate with us
\textbf{only} by \textbf{un}encoded \textbf{email} (no HTML etc, please)
to \href{mailto:acc...@on...}{\textbf{acc...@on...}}
and be sure to include the domain name \textbf{<%notes%>} in the
subject line for automatic filing purposes.}

\end{document}

-- 
Dr. Eberhard W. Lisse  \        / Obstetrician & Gynaecologist (Saar)
el...@li... el108-ARIN / *     |   Telephone: +264 81 124 6733 (cell)
PO Box 8421             \     /   Please do NOT email to this address
Bachbrecht, Namibia     ;____/        if it is DNS related in ANY way

Re: [SL] Invoice with full details?

[Stroller <lin...@my...>]

On 9 Nov 2006, at 04:21, Dr Eberhard Lisse wrote:
> on 11/8/06 2:07 PM Dr Eberhard W Lisse said the following:
>>>> I indeed use longtable and leave the page breaks to LaTeX.
>
> ...
> \begin{longtable}{lllrlrrr}
>    ...
>     \textbf{Code}&
>     \textbf{Description}&
>     \ifthenelse{\lengthtest{<%subtotal%>pt<0pt}}{}{\textbf{Date}}&
>     \textbf{Qt'y}&
>     \textbf{Unit}&
>     \textbf{Price}&
>     \textbf{Disc}&
>     \textbf{Amount}\tabularnewline
> \endhead
> ...
> \multicolumn{3}{l}{} &
> \multicolumn{4}{l}{\textbf{Subtotal}}&\textbf{<%subtotal%>}=20
> \tabularnewline
> <%foreach tax%>
> \multicolumn{3}{l}{}&\multicolumn{4}{l}{<%taxdescription%> on
> <%taxbase%> } & <%tax%>\tabularnewline
> <%end tax%>
> <%if paid%>
> \multicolumn{3}{l}{} &
> \multicolumn{4}{l}{\textbf{Paid}}&<%paid%>\tabularnewline
> <%end paid%>
> <%if total%>
>     \multicolumn{3}{l}{} &
> \multicolumn{4}{l}{\textbf{Total}}&\textbf{<%total%>}\tabularnewline
> <%end total%>
> <%if not total%>
>     \multicolumn{3}{l}{} &
> \multicolumn{4}{l}{\textbf{Total}}&0.00\tabularnewline
> <%end total%>
> &&&&&&&\tabularnewline
> \multicolumn{8}{r}{All prices in \textbf{<%currency%>}
> funds.}\tabularnewline
> \multicolumn{8}{l}{\ifthenelse{\lengthtest{<%subtotal%>pt<0pt}}{}{Due
> Date: \textbf{<%duedate%>}, Terms: Net \textbf{<%terms%>}
> days}}\tabularnewline
> \endlastfoot
> ...
> <%foreach number%>
>    <%number%> &
>    <%description%> &
>    \ifthenelse{\lengthtest{<%subtotal%>pt<0pt}}{}{<%deliverydate%>} &
>    <%qty%> &
>    <%unit%> &
>    \nprounddigits{2}\numprint{<%sellprice%>} &
>    \nprounddigits{2}\numprint{<%discount%>} &
>    <%linetotal%>\tabularnewline
> <%end number%>
> \end{longtable}

If the last item comes at the very foot of the page, and the page =20
breaks with only the lastfoot to display, is there any logic to =20
prevent the head being shown at the top of the next page?

I have not used your template verbatim - although it is quite =20
beautiful, it is not quite my style of formatting, so I started again =20=

from scratch and have used yours only for reference.

I have found one of my invoices has two pages.
On the first is:

   Part Description Price Quantity Amount
   101  Fangle      =A31    3        =A33
   237  Wonkle      =A32    1        =A32
   ...
   093  Chocolate   =A30.5  3        =A31.5

and on the second is only:

   Part Description Price Quantity Amount
                          Total    =A36.5

(I have laid out these examples so they make sense if viewed in a =20
fixed-width font).

I have been so impressed by your responses to my recent questions =20
that I cannot believe that you have missed this, yet I cannot quickly =20=

see how you have solved this problem regarding invoices of a certain =20
length.

Stroller.
 =20=

Re: [SL] Invoice with full details?

[Dr E. L. <el...@li...>]

I have noticed.

It happens extremely rarely. So the client gets two pages. So what
:-)-O? I'm more concerned that they pay the invoice :-)-O

Do you want to see my AR Aging Statement :-)-O?

el



on 11/10/06 2:28 AM Stroller said the following:

>> <%foreach number%>
>>    <%number%> &
>>    <%description%> &
>>    \ifthenelse{\lengthtest{<%subtotal%>pt<0pt}}{}{<%deliverydate%>} &
>>    <%qty%> &
>>    <%unit%> &
>>    \nprounddigits{2}\numprint{<%sellprice%>} &
>>    \nprounddigits{2}\numprint{<%discount%>} &
>>    <%linetotal%>\tabularnewline
>> <%end number%>
>> \end{longtable}
>=20
> If the last item comes at the very foot of the page, and the page =20
> breaks with only the lastfoot to display, is there any logic to =20
> prevent the head being shown at the top of the next page?
>=20
> I have not used your template verbatim - although it is quite =20
> beautiful, it is not quite my style of formatting, so I started again =20
> from scratch and have used yours only for reference.
>=20
> I have found one of my invoices has two pages.
> On the first is:
>=20
>    Part Description Price Quantity Amount
>    101  Fangle      =A31    3        =A33
>    237  Wonkle      =A32    1        =A32
>    ...
>    093  Chocolate   =A30.5  3        =A31.5
>=20
> and on the second is only:
>=20
>    Part Description Price Quantity Amount
>                           Total    =A36.5
>=20
> (I have laid out these examples so they make sense if viewed in a =20
> fixed-width font).
>=20
> I have been so impressed by your responses to my recent questions =20
> that I cannot believe that you have missed this, yet I cannot quickly =20
> see how you have solved this problem regarding invoices of a certain =20
> length.
>=20
> Stroller.


--=20
Dr. Eberhard W. Lisse  \        / Obstetrician & Gynaecologist (Saar)
el...@li... el108-ARIN / *     |   Telephone: +264 81 124 6733 (cell)
PO Box 8421             \     /   Please do NOT email to this address
Bachbrecht, Namibia     ;____/        if it is DNS related in ANY way