sql-ledger-users — SQL-Ledger users

Re: [SL] Project details for each timecard

[Paul W. <pa...@pw...>]

That simple??  I will try this out on the demo system.
Thanks Tom.

Paul W

Tom Diehl wrote:

>On Thu, 9 Nov 2006, Paul Wrightson wrote:
>
>  
>
>>Hi everyone,
>>I bill work hourly as a consultant to some of my clients. I use the
>>project and timecard system to enter time and dates. Once a month I
>>generate a sales order and generate an invoice from it.
>>During the process, the time worked on each of the dates gets merged and
>>the timecard notes also get merged together.
>>What I would like is for individual timecards to appear as separate line
>>items on the invoice so that inidiviual blocks of time billed can be
>>differentiated. If more than one consultant works the project, I need to
>>show that, and if we made visits on numerous days, I need to show that.
>>Sometimes, the client is not present, or I work remotely, so I need the
>>invoice to accurately represent the times and days worked as well as the
>>number of hours in total.
>>
>>Has anybody done anything like this?
>>    
>>
>
>Yep, This is my exact situation. When you generate the sales order click 
>the details button and you will get entries on the sales order for each
>timecard.
>
>Regards,
>
>  
>

Re: [SL] Accounting for fuel inventory in a small power generator

[Oscar A. V. <ov...@en...>]

El jue, 09-11-2006 a las 21:49 -0600, Jeff Vian escribi=F3:
> On Thu, 2006-11-09 at 09:00 -0600, Oscar A. Valdez wrote:
> > We are a small power generator that purchases fuel and converts it in=
to
> > electrical and heat energy for sale.
> >=20
> > I've looked at the manual's section on Inventory, and it doesn't seem
> > like I can have a fuel inventory and periodically consume it to produ=
ce
> > energy for immediate sale (can't be inventoried). That would seem lik=
e a
> > Job Costing or WIP functionality that doesn't seem to be there in
> > SQL-Ledger.
> >=20
> > Am I wrong?
> >=20
> Just a thought from a layman. IANAA
>=20
> Fuel used in operations is an expense item.  You may buy it, and have
> some quantity on hand, but it is consumed as overhead in the production
> of energy.  It should not be treated as inventory for this purpose.
>=20
> Energy can be treated as a service, since it is not tangible inventory.
> It can be sold by the unit, similar to service hours, and cannot be
> stored. Invoicing goes to AR.

But what we do is transform fuel into electricity and heat. It's an
industrial transformation. So fuel is our raw material, and electricity
and heat our end products.
--=20
Oscar A. Valdez
Energ=EDa Borealis Ltda. de C.V.

Re: [SL] Accounting for fuel inventory in a small power generator

[Jeff V. <jv...@ch...>]

On Thu, 2006-11-09 at 09:00 -0600, Oscar A. Valdez wrote:
> We are a small power generator that purchases fuel and converts it into
> electrical and heat energy for sale.
> 
> I've looked at the manual's section on Inventory, and it doesn't seem
> like I can have a fuel inventory and periodically consume it to produce
> energy for immediate sale (can't be inventoried). That would seem like a
> Job Costing or WIP functionality that doesn't seem to be there in
> SQL-Ledger.
> 
> Am I wrong?
> 
Just a thought from a layman. IANAA

Fuel used in operations is an expense item.  You may buy it, and have
some quantity on hand, but it is consumed as overhead in the production
of energy.  It should not be treated as inventory for this purpose.

Energy can be treated as a service, since it is not tangible inventory.
It can be sold by the unit, similar to service hours, and cannot be
stored. Invoicing goes to AR.
Overhead (consumables, labor, etc.) OTOH, is an operating expense that
should be treated as expended as soon as it is received/paid for.  Its
usage impacts profit and detracts from income revenues.  It goes to AP
then gets paid from income. 


> If I am right (i.e., I can't do what I want), I'd appreciate suggestions
> on how to account for my fuel inventory and my energy sales.
> 
> Thanks in advance.

Re: [SL] sql-ledger-users Digest, Vol 7, Issue 3

[Margot R. <mri...@pa...>]

Oops , I take that back, there is a classified income statement under 
Reports>Income Statement. If you do not have ic_cogs specified in the 
chart, then the account does not show up in the cost of goods sold 
classification. You definately want it to show up there ( from an 
accounting standpoint) so that you can get an accurate gross margin. So 
you need to leave it in. Sorry for the first response.
Margot

Margot Ritcher wrote:

> Response to #5
>
> 5. COGS and expense accounts (Phil Ross)
>
> Hi Phil, I am an accountant and working with SQL Ledger. We have 
> several cost of good sold accounts with out the IC_COGS. I haven't 
> found any reports that seem to key off of the IC_COGS. It does not  
> effect any of the drop down menus or reporting functions, so I would 
> say that you could safely omit it and it is not going to do any harm.  
> Margot 
> sql...@li... wrote:
>
>> Send sql-ledger-users mailing list submissions to
>>     sql...@li...
>>
>> To subscribe or unsubscribe via the World Wide Web, visit
>>     https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>> or, via email, send a message with subject or body 'help' to
>>     sql...@li...
>>
>> You can reach the person managing the list at
>>     sql...@li...
>>
>> When replying, please edit your Subject line so it is more specific
>> than "Re: Contents of sql-ledger-users digest..."
>>
>>
>> Today's Topics:
>>
>>   1. GIFI (Dave Stanley)
>>   2. Re: Invoice with full details? (Dr Eberhard W Lisse)
>>   3. GIFI (Dave Stanley)
>>   4. Re: GIFI (Ed W)
>>   5. COGS and expense accounts (Phil Ross)
>>   6. Re: Invoice with full details? (Angus Jordan)
>>   7. Re: Invoice with full details? (Dieter Simader)
>>   8. Re: Invoice with full details? (Dr Eberhard W Lisse)
>>   9. Can't Access "System/Chart of Accounts" Menu (Bill Thoen)
>>  10. Re: Can't Access "System/Chart of Accounts" Menu (Jeff Vian)
>>  11. Re: Can't Access "System/Chart of Accounts" Menu (Paul Tammes)
>>  12. Re: Can't Access "System/Chart of Accounts" Menu
>>      (Corporate Underground)
>>  13. Re: Can't Access "System/Chart of Accounts" Menu (Bill Thoen)
>>  14. Re: Can't Access "System/Chart of Accounts" Menu (Dieter Simader)
>>  15. Accounting for fuel inventory in a small power generator
>>      (Oscar A. Valdez)
>>  16. Re: Can't Access "System/Chart of Accounts" Menu
>>      (Mark Bucciarelli)
>>  17. Re: Can't Access "System/Chart of Accounts" Menu
>>      (Chuck Amadi Systems Administrator)
>>  18. Re: Can't Access "System/Chart of Accounts" Menu (Rich Shepard)
>>  19. Project details for each timecard (Paul Wrightson)
>>  20. Re: Invoice with full details? (Dr Eberhard Lisse)
>>  21. Re: Can't Access "System/Chart of Accounts" Menu (David Ratte)
>>  22. Re: Accounting for fuel inventory in a small power generator
>>      (Dieter Simader)
>>  23. Re: Can't Access "System/Chart of Accounts" Menu (Bill Thoen)
>>  24. Re: Can't Access "System/Chart of Accounts" Menu (Jeff Kowalczyk)
>>  25. Re: Can't Access "System/Chart of Accounts" Menu (Bill Thoen)
>>  26. Re: Project details for each timecard (Tom Diehl)
>>  27. Re: Invoice with full details? (Stroller)
>>
>>
>> ----------------------------------------------------------------------
>>
>> Message: 1
>> Date: Mon, 6 Nov 2006 12:59:39 +0000
>> From: "Dave Stanley" <da...@sc...>
>> Subject: [SL] GIFI
>> To: sql...@li...
>> Message-ID:
>>     <a19...@ma...>
>> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>>
>> Hi,
>>
>> am setting up SL for use in the UK we do not have an equivalent of a 
>> GIFI is
>> there an easy way of removing the references from forms within SL?
>>
>> Thanks in advance
>>
>> Dave
>>
>>
>> ------------------------------
>>
>> Message: 2
>> Date: Mon, 06 Nov 2006 13:44:23 +0200
>> From: Dr Eberhard W Lisse <el...@li...>
>> Subject: Re: [SL] Invoice with full details?
>> To: sql...@li...
>> Cc: lin...@my...
>> Message-ID: <454...@li...>
>> Content-Type: text/plain; charset=ISO-8859-1
>>
>> 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
>>>   
>>
>>
>>
>>
>> ------------------------------
>>
>> Message: 3
>> Date: Mon, 6 Nov 2006 12:59:39 +0000
>> From: "Dave Stanley" <da...@sc...>
>> Subject: [SL] GIFI
>> To: sql...@li...
>> Message-ID:
>>     <a19...@ma...>
>> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>>
>> Hi,
>>
>> am setting up SL for use in the UK we do not have an equivalent of a 
>> GIFI is
>> there an easy way of removing the references from forms within SL?
>>
>> Thanks in advance
>>
>> Dave
>>
>>
>> ------------------------------
>>
>> Message: 4
>> Date: Mon, 06 Nov 2006 18:54:48 +0000
>> From: Ed W <li...@wi...>
>> Subject: Re: [SL] GIFI
>> To: sql...@li...
>> Message-ID: <454...@wi...>
>> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>>
>> Dave Stanley wrote:
>>  
>>
>>> Hi,
>>>
>>> am setting up SL for use in the UK we do not have an equivalent of a 
>>> GIFI is
>>> there an easy way of removing the references from forms within SL?
>>>  
>>>   
>>
>>
>> I think that you could use GIFI as a general aggregation mechanism 
>> for your own reporting purposes?
>>
>> If you object to the word GIFI then I suspect that it's possible to 
>> use the translation feature to give it some other name?
>>
>> Just a thought?
>>
>> Ed W
>>
>>
>>
>> ------------------------------
>>
>> Message: 5
>> Date: Mon, 06 Nov 2006 23:33:50 +0000
>> From: Phil Ross <ph...@bu...>
>> Subject: [SL] COGS and expense accounts
>> To: sql...@li...
>> Message-ID: <454...@bu...>
>> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>>
>> Hi there,
>>
>> I have the following account to keep track of expenses in our cafe 
>> that are goods purchased for resale:
>>
>> 5009 - Cafe Supplies for Resale        AP_amount,IC_expense,IC_cogs
>>
>> Everything is normally done through AP transactions, with 
>> corresponding sales put through a separate "4001 - Cafe Sales" 
>> account that is configured as AR_amount, IC_income, and IC_sale.
>>
>> Do I need to have a COGS account in this case?   Is it safe for me to 
>> remove the IC_cogs from the account?
>>
>> I have asked my accountant for advice but unfortunately they can't 
>> give me advice on how to configure SL Ledger ;(
>>
>> I would appreciate any assistance anyone can provide..
>>
>> Regards
>> Phil
>>
>>
>>
>>
>>
>> ------------------------------
>>
>> Message: 6
>> Date: Tue, 7 Nov 2006 21:49:50 -0800
>> From: "Angus Jordan" <ang...@gm...>
>> Subject: Re: [SL] Invoice with full details?
>> To: sql...@li...
>> Message-ID:
>>     <19b...@ma...>
>> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>>
>> 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
>>
>>
>> ------------------------------
>>
>> Message: 7
>> Date: Wed, 8 Nov 2006 07:46:03 -0700 (MST)
>> From: Dieter Simader <dsi...@sq...>
>> Subject: Re: [SL] Invoice with full details?
>> To: sql...@li...
>> Message-ID: <200...@th...>
>> Content-Type: TEXT/PLAIN; charset=US-ASCII
>>
>> \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}
>>
>>
>>  
>>
>
>

Re: [SL] sql-ledger-users Digest, Vol 7, Issue 3

[Margot R. <mri...@pa...>]

Response to #5

 5. COGS and expense accounts (Phil Ross)

Hi Phil, I am an accountant and working with SQL Ledger. We have several cost of good sold accounts with out the IC_COGS. I haven't found any reports that seem to key off of the IC_COGS. It does not  effect any of the drop down menus or reporting functions, so I would say that you could safely omit it and it is not going to do any harm.  
Margot  

sql...@li... wrote:

>Send sql-ledger-users mailing list submissions to
>	sql...@li...
>
>To subscribe or unsubscribe via the World Wide Web, visit
>	https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>or, via email, send a message with subject or body 'help' to
>	sql...@li...
>
>You can reach the person managing the list at
>	sql...@li...
>
>When replying, please edit your Subject line so it is more specific
>than "Re: Contents of sql-ledger-users digest..."
>
>
>Today's Topics:
>
>   1. GIFI (Dave Stanley)
>   2. Re: Invoice with full details? (Dr Eberhard W Lisse)
>   3. GIFI (Dave Stanley)
>   4. Re: GIFI (Ed W)
>   5. COGS and expense accounts (Phil Ross)
>   6. Re: Invoice with full details? (Angus Jordan)
>   7. Re: Invoice with full details? (Dieter Simader)
>   8. Re: Invoice with full details? (Dr Eberhard W Lisse)
>   9. Can't Access "System/Chart of Accounts" Menu (Bill Thoen)
>  10. Re: Can't Access "System/Chart of Accounts" Menu (Jeff Vian)
>  11. Re: Can't Access "System/Chart of Accounts" Menu (Paul Tammes)
>  12. Re: Can't Access "System/Chart of Accounts" Menu
>      (Corporate Underground)
>  13. Re: Can't Access "System/Chart of Accounts" Menu (Bill Thoen)
>  14. Re: Can't Access "System/Chart of Accounts" Menu (Dieter Simader)
>  15. Accounting for fuel inventory in a small power generator
>      (Oscar A. Valdez)
>  16. Re: Can't Access "System/Chart of Accounts" Menu
>      (Mark Bucciarelli)
>  17. Re: Can't Access "System/Chart of Accounts" Menu
>      (Chuck Amadi Systems Administrator)
>  18. Re: Can't Access "System/Chart of Accounts" Menu (Rich Shepard)
>  19. Project details for each timecard (Paul Wrightson)
>  20. Re: Invoice with full details? (Dr Eberhard Lisse)
>  21. Re: Can't Access "System/Chart of Accounts" Menu (David Ratte)
>  22. Re: Accounting for fuel inventory in a small power generator
>      (Dieter Simader)
>  23. Re: Can't Access "System/Chart of Accounts" Menu (Bill Thoen)
>  24. Re: Can't Access "System/Chart of Accounts" Menu (Jeff Kowalczyk)
>  25. Re: Can't Access "System/Chart of Accounts" Menu (Bill Thoen)
>  26. Re: Project details for each timecard (Tom Diehl)
>  27. Re: Invoice with full details? (Stroller)
>
>
>----------------------------------------------------------------------
>
>Message: 1
>Date: Mon, 6 Nov 2006 12:59:39 +0000
>From: "Dave Stanley" <da...@sc...>
>Subject: [SL] GIFI
>To: sql...@li...
>Message-ID:
>	<a19...@ma...>
>Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
>Hi,
>
>am setting up SL for use in the UK we do not have an equivalent of a GIFI is
>there an easy way of removing the references from forms within SL?
>
>Thanks in advance
>
>Dave
>
>
>------------------------------
>
>Message: 2
>Date: Mon, 06 Nov 2006 13:44:23 +0200
>From: Dr Eberhard W Lisse <el...@li...>
>Subject: Re: [SL] Invoice with full details?
>To: sql...@li...
>Cc: lin...@my...
>Message-ID: <454...@li...>
>Content-Type: text/plain; charset=ISO-8859-1
>
>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
>>    
>>
>
>
>
>------------------------------
>
>Message: 3
>Date: Mon, 6 Nov 2006 12:59:39 +0000
>From: "Dave Stanley" <da...@sc...>
>Subject: [SL] GIFI
>To: sql...@li...
>Message-ID:
>	<a19...@ma...>
>Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
>Hi,
>
>am setting up SL for use in the UK we do not have an equivalent of a GIFI is
>there an easy way of removing the references from forms within SL?
>
>Thanks in advance
>
>Dave
>
>
>------------------------------
>
>Message: 4
>Date: Mon, 06 Nov 2006 18:54:48 +0000
>From: Ed W <li...@wi...>
>Subject: Re: [SL] GIFI
>To: sql...@li...
>Message-ID: <454...@wi...>
>Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
>Dave Stanley wrote:
>  
>
>>Hi,
>>
>>am setting up SL for use in the UK we do not have an equivalent of a GIFI is
>>there an easy way of removing the references from forms within SL?
>>  
>>    
>>
>
>I think that you could use GIFI as a general aggregation mechanism for 
>your own reporting purposes?
>
>If you object to the word GIFI then I suspect that it's possible to use 
>the translation feature to give it some other name?
>
>Just a thought?
>
>Ed W
>
>
>
>------------------------------
>
>Message: 5
>Date: Mon, 06 Nov 2006 23:33:50 +0000
>From: Phil Ross <ph...@bu...>
>Subject: [SL] COGS and expense accounts
>To: sql...@li...
>Message-ID: <454...@bu...>
>Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
>Hi there,
>
>I have the following account to keep track of expenses in our cafe that 
>are goods purchased for resale:
>
>5009 - Cafe Supplies for Resale		AP_amount,IC_expense,IC_cogs
>
>Everything is normally done through AP transactions, with corresponding 
>sales put through a separate "4001 - Cafe Sales" account that is 
>configured as AR_amount, IC_income, and IC_sale.
>
>Do I need to have a COGS account in this case?   Is it safe for me to 
>remove the IC_cogs from the account?
>
>I have asked my accountant for advice but unfortunately they can't give 
>me advice on how to configure SL Ledger ;(
>
>I would appreciate any assistance anyone can provide..
>
>Regards
>Phil
>
>
>
>
>
>------------------------------
>
>Message: 6
>Date: Tue, 7 Nov 2006 21:49:50 -0800
>From: "Angus Jordan" <ang...@gm...>
>Subject: Re: [SL] Invoice with full details?
>To: sql...@li...
>Message-ID:
>	<19b...@ma...>
>Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
>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
>
>
>------------------------------
>
>Message: 7
>Date: Wed, 8 Nov 2006 07:46:03 -0700 (MST)
>From: Dieter Simader <dsi...@sq...>
>Subject: Re: [SL] Invoice with full details?
>To: sql...@li...
>Message-ID: <200...@th...>
>Content-Type: TEXT/PLAIN; charset=US-ASCII
>
>\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}
>
>
>  
>

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] Project details for each timecard

[Tom D. <td...@ro...>]

On Thu, 9 Nov 2006, Paul Wrightson wrote:

> Hi everyone,
> I bill work hourly as a consultant to some of my clients. I use the
> project and timecard system to enter time and dates. Once a month I
> generate a sales order and generate an invoice from it.
> During the process, the time worked on each of the dates gets merged and
> the timecard notes also get merged together.
> What I would like is for individual timecards to appear as separate line
> items on the invoice so that inidiviual blocks of time billed can be
> differentiated. If more than one consultant works the project, I need to
> show that, and if we made visits on numerous days, I need to show that.
> Sometimes, the client is not present, or I work remotely, so I need the
> invoice to accurately represent the times and days worked as well as the
> number of hours in total.
>
> Has anybody done anything like this?

Yep, This is my exact situation. When you generate the sales order click 
the details button and you will get entries on the sales order for each
timecard.

Regards,

-- 
Tom Diehl		td...@ro...		Spamtrap address mt...@ro...

Re: [SL] Can't Access "System/Chart of Accounts" Menu

[Bill T. <bt...@gi...>]

On Thu, Nov 09, 2006 at 12:54:21PM -0800, Jeff Kowalczyk wrote:
> --- Bill Thoen <bt...@gi...> wrote:
> 
> > Ah ha! Bingo!! You got it. When I turned javascript off, everything worked.
> > Thank you! No where in the README does it mention this, and I guess I
> > wasn't familiar enough with the software yet to know about it.
> 
> A decent javascript blocker should notify with an icon the user that it has
> encountered javascript and is currently blocking it. Mozilla Firefox does this,
> perhaps Internet Explorer does not.

I wouldn't know; I'm using Firefox 1.5 on Fedora Core 5 Linux.

Re: [SL] Can't Access "System/Chart of Accounts" Menu

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

--- Bill Thoen <bt...@gi...> wrote:

> Ah ha! Bingo!! You got it. When I turned javascript off, everything worked.
> Thank you! No where in the README does it mention this, and I guess I
> wasn't familiar enough with the software yet to know about it.

A decent javascript blocker should notify with an icon the user that it has
encountered javascript and is currently blocking it. Mozilla Firefox does this,
perhaps Internet Explorer does not.


 
____________________________________________________________________________________
Yahoo! Music Unlimited
Access over 1 million songs.
http://music.yahoo.com/unlimited

Re: [SL] Can't Access "System/Chart of Accounts" Menu

[Bill T. <bt...@gi...>]

On Thu, Nov 09, 2006 at 10:10:59AM -0500, David Ratte wrote:
> On Thursday 09 November 2006 09:05, Bill Thoen wrote:
> ...
> >  when I login as that user I can't view
> > or edit any chart of accounts items and I don't know why. Am I doing the
> > right steps or is there something else I need to fully read?
> ...
> 
> do you have javascript enabled on the browser?

Ah ha! Bingo!! You got it. When I turned javascript off, everything worked.
Thank you! No where in the README does it mention this, and I guess I
wasn't familiar enough with the software yet to know about it.

Re: [SL] Accounting for fuel inventory in a small power generator

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

You have to set up heat as an assembly and add fuel as a component so it
will be recognized as COGS when you sell heat.

-- 
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 Thu, 9 Nov 2006, Oscar A. Valdez wrote:

> We are a small power generator that purchases fuel and converts it into
> electrical and heat energy for sale.
>
> I've looked at the manual's section on Inventory, and it doesn't seem
> like I can have a fuel inventory and periodically consume it to produce
> energy for immediate sale (can't be inventoried). That would seem like a
> Job Costing or WIP functionality that doesn't seem to be there in
> SQL-Ledger.
>
> Am I wrong?
>
> If I am right (i.e., I can't do what I want), I'd appreciate suggestions
> on how to account for my fuel inventory and my energy sales.
>
> Thanks in advance.
>

[SL] Project details for each timecard

[Paul W. <pa...@pw...>]

Hi everyone,
I bill work hourly as a consultant to some of my clients. I use the 
project and timecard system to enter time and dates. Once a month I 
generate a sales order and generate an invoice from it.
During the process, the time worked on each of the dates gets merged and 
the timecard notes also get merged together.
What I would like is for individual timecards to appear as separate line 
items on the invoice so that inidiviual blocks of time billed can be 
differentiated. If more than one consultant works the project, I need to 
show that, and if we made visits on numerous days, I need to show that.
Sometimes, the client is not present, or I work remotely, so I need the 
invoice to accurately represent the times and days worked as well as the 
number of hours in total.

Has anybody done anything like this?
Thanks in advance,
Paul W

Re: [SL] Can't Access "System/Chart of Accounts" Menu

[Rich S. <rsh...@ap...>]

On Thu, 9 Nov 2006, Mark Bucciarelli wrote:

> But it is not an accounting manual.

   Nor does it cover the myriad business and business environments in which
SL is applied. It cannot cover all cases.

Rich

-- 
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.(TM)    |            Accelerator
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

Re: [SL] Can't Access "System/Chart of Accounts" Menu

[Chuck A. S. A. <ch...@sm...>]

Hi Just adding my 50 cents

My Organisation Linux/SuSE shop)has been using SL for @ 18 Months and
also our spin off Company that is in the private sector (Window Shop) in
anger and I also run on both SL systems a test SL and live SL that I use
to update and test thus run pg_dump -v mycompany > /tmp/livemycompany
then pg_dump testmycompany -e < /tmp/livemycomany.

So when I am testing the test SL I get the Office Admin to run a few
things as a dry run and thus the live site is replicated and also
backup'd

I update both SL test and live, monthly without a hitch we paid are dues
to Dieter 
and on a few occasions on setting up of our accountancy system seeked
Dieter support which we paid for and got. Also used the SL manual to
setup our templates etc etc and found them informative and very useful
to say the least.

I DO NOT NO A THING ABOUT ACCOUNTANCY But I do know Linux, Apache and
Postgresql which is all I need to know to run my tasks.

If there is a issue like everyone else is to solve it by using the tools
available, SL Paid Support, Manual, Goooogle, and mailing lists/forums.
If not find a better accountancy software which is updated regularly if
you want too.

To the rest of SL users keep up the good work as the mailing list sorted
a few teething issues before running like dream (touch wood).

Cheers

On Thu, 2006-11-09 at 07:24 -0700, Dieter Simader wrote:
> If you need an accounting primer pick up a book and learn how to do
> accounting. The reference manual does not teach accounting, period.
> 
-- 
Unix/ Linux Systems Administrator
Chuck Amadi
The Surgical Material Testing Laboratory (SMTL), 
Princess of Wales Hospital 
Coity Road 
Bridgend, 
United Kingdom, CF31 1RQ.
Email chuck.smtl.co.uk
Tel: +44 1656 752820 
Fax: +44 1656 752830

Re: [SL] Can't Access "System/Chart of Accounts" Menu

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

On Thu, Nov 09, 2006 at 07:05:14AM -0700, Bill Thoen wrote:
> On Thu, Nov 09, 2006 at 07:50:51AM +0100, Paul Tammes wrote:
> > You could start out by reading the faq, as well as the readme
> > info in the tarball.  Although not exactly a step to step
> > howto, it should enable one to install and log into
> > SQL-Ledger.  The fact one starts at /login.pl instead of
> > /admin.pl suggests to me that neither info was fully read..
> 
> Well, I *have* read the README, several times, and I've looked
> at the FAQ.  I've also scanned the archives and seen that
> "getting started" with SL is a common problem. Since I didn't
> find the answer to my question in those references, I thought
> I'd try the mailing list. 

Ok, I guess you need to read _and understand_ the README.  

It's not a trivial setup.

Postgres permissions are probably the most common error
(different distros have different philosophies).  Although that
doesn't sound like your issue.

Also, distros deal with Perl packages differently.  Fortunately
most have the modules you need packaged so you should not have to
mess with CPAN.

You have to setup Apache to run CGI properly.  

Finally, the file permissions have to be correct in the proper
directories.  For example, the menu file is generated from a
file--are you sure the file permissions in your sql-ledger dir
are correct?

There's only so much you can do to make all these steps simple.

> And I still don't know why I can't access items in the chart of
> accounts after running login.pl short of directly going into
> psql and fooling around with the chart table.

Manually editing SQL entries is always the wrong answer when
working with a good app.  ;)

Is there any info in your apache logs that is relevant?

> The README, if you recall, says to start at admin.pl to set up
> a user. It sure looks to me that this is also where you enable
> or disable menus for the user you are currently modifying. Once
> you set up the user, then you run the program by starting
> login.pl. I've made the user an Administrator and all the menus
> are checked, but when I login as that user I can't view or edit
> any chart of accounts items and I don't know why. Am I doing
> the right steps or is there something else I need to fully
> read?

Something is messed up in your install.  By default, a user see's
all menu items.

I would suggest at a minimum dropping the Postgres DB and
creating a new db with admin.pl.

All the info you need really is in the README.

> Regarding buying the manual, I recognize that you're not just
> paying $190 for a PDF file; you're also supporting all the
> development that goes into the software. But I don't consider
> supporting Open Source a charity, either. The whole system --
> software and documentation -- has got to allow me to get things
> done. It's a little disturbing to hear here such emphatic
> confirmation of my suspicions about the usefulness of the
> manual. I'm moving from several years of using QuickBooks and
> my business is relatively simple, so I don't need training in
> book keeping or software that does much more than basic
> business accounting. But I do need enough help from a manual to
> actually understand how to use software beyond operating the
> controls in a data entry form.

The manual does it's job--that is, explain what the app does: for
example departments, projects, timecards, inventory control, part
transfers, logic customizations, latex templates, etc, etc.  It's
useful to have when you want to start using a new feature in the
app.

But it is not an accounting manual.

m

Re: [SL] Can't Access "System/Chart of Accounts" Menu

[David R. <dr...@ho...>]

On Thursday 09 November 2006 09:05, Bill Thoen wrote:
...
>  when I login as that user I can't view
> or edit any chart of accounts items and I don't know why. Am I doing the
> right steps or is there something else I need to fully read?
...

do you have javascript enabled on the browser?

[SL] Accounting for fuel inventory in a small power generator

[Oscar A. V. <ov...@en...>]

We are a small power generator that purchases fuel and converts it into
electrical and heat energy for sale.

I've looked at the manual's section on Inventory, and it doesn't seem
like I can have a fuel inventory and periodically consume it to produce
energy for immediate sale (can't be inventoried). That would seem like a
Job Costing or WIP functionality that doesn't seem to be there in
SQL-Ledger.

Am I wrong?

If I am right (i.e., I can't do what I want), I'd appreciate suggestions
on how to account for my fuel inventory and my energy sales.

Thanks in advance.
--=20
Oscar A. Valdez
Energ=EDa Borealis Ltda. de C.V.

Re: [SL] Can't Access "System/Chart of Accounts" Menu

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

If you need an accounting primer pick up a book and learn how to do
accounting. The reference manual does not teach accounting, period.

-- 
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 Thu, 9 Nov 2006, Corporate Underground wrote:

> On 11/8/06, Jeff Vian <jv...@ch...> wrote:
> > The manual provides a lot of detailed information on the inner workings
> > of the system with a lot of how-tos built in..  Buy it, it is cheap in
> > the long run.
>
>  Been lurking here a while and an SL user for a bit.  I don't agree, cheap
> is not what I would call it. I bought the manual and wasn't very happy with
> it. It's not horrible, but certainly not worth 190 bucks. Definitely not new
> user friendly - far too terse in most places and goes into details about
> things I don't need to know about. It's the sorta thing one would expect
> from free software that came with a free manual. Not something you would
> expect to be the core of the business model. I found a GNUCash manual to
> help me learn some accounting stuff from
> http://www.object-refinery.com/gnucash/index.html. I found this to be better
> written and more useful for a beginner.
>
> My $0.02.
>
> UC.
> -------------------------------------------------------------------------
> 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] Can't Access "System/Chart of Accounts" Menu

[Bill T. <bt...@gi...>]

On Thu, Nov 09, 2006 at 07:50:51AM +0100, Paul Tammes wrote:
> You could start out by reading the faq, as well as the readme info in 
> the tarball.
> Although not exactly a step to step howto, it should enable one to 
> install and log into SQL-Ledger.
> The fact one starts at /login.pl instead of /admin.pl suggests to me 
> that neither info was fully read..

Well, I *have* read the README, several times, and I've looked at the FAQ.
I've also scanned the archives and seen that "getting started" with SL is a
common problem. Since I didn't find the answer to my question in those
references, I thought I'd try the mailing list. And I still don't know why
I can't access items in the chart of accounts after running login.pl short 
of directly going into psql and fooling around with the chart table.

The README, if you recall, says to start at admin.pl to set up a user. It
sure looks to me that this is also where you enable or disable menus for
the user you are currently modifying. Once you set up the user, then you
run the program by starting login.pl. I've made the user an Administrator
and all the menus are checked, but when I login as that user I can't view
or edit any chart of accounts items and I don't know why. Am I doing the 
right steps or is there something else I need to fully read?

Regarding buying the manual, I recognize that you're not just paying $190
for a PDF file; you're also supporting all the development that goes into
the software. But I don't consider supporting Open Source a charity,
either. The whole system -- software and documentation -- has got to allow
me to get things done. It's a little disturbing to hear here such emphatic
confirmation of my suspicions about the usefulness of the manual. I'm
moving from several years of using QuickBooks and my business is relatively
simple, so I don't need training in book keeping or software that does much
more than basic business accounting. But I do need enough help from a
manual to actually understand how to use software beyond operating the
controls in a data entry form.

I'll keep poking at it because I don't want to stay with QuickBooks and
GNUCash isn't enough (but their documentation is great!) And thanks for the
pointers to alternate docs.

- Bill Thoen

Re: [SL] Can't Access "System/Chart of Accounts" Menu

[Corporate U. <und...@gm...>]

On 11/8/06, Jeff Vian <jv...@ch...> wrote:
> The manual provides a lot of detailed information on the inner workings
> of the system with a lot of how-tos built in..  Buy it, it is cheap in
> the long run.

 Been lurking here a while and an SL user for a bit.  I don't agree, cheap
is not what I would call it. I bought the manual and wasn't very happy with
it. It's not horrible, but certainly not worth 190 bucks. Definitely not new
user friendly - far too terse in most places and goes into details about
things I don't need to know about. It's the sorta thing one would expect
from free software that came with a free manual. Not something you would
expect to be the core of the business model. I found a GNUCash manual to
help me learn some accounting stuff from
http://www.object-refinery.com/gnucash/index.html. I found this to be better
written and more useful for a beginner.

My $0.02.

UC.

Re: [SL] Can't Access "System/Chart of Accounts" Menu

[Paul T. <pt...@wa...>]

Jeff Vian schreef:
> On Wed, 2006-11-08 at 16:57 -0700, Bill Thoen wrote:
>   
>> I'm just getting started with SQL-Ledger and I seem to have it all set up
>> okay on Fedora system. I downloaded the sample documentation (which is Chap
>> 4. System) and the first thing it shows me is how to change items in the
>> Chart of Accounts. However, that's not an available option on my menu under
>> "System". In fact, there seem to be a lot of menu items available under
>> System (when I log in as admin), and even though they are all checked for 
>> the user I want to work as, I see only Audit Controls, Defaults, Taxes and
>> Yearsend. I've tried setting up my user as Manager and Administrator, but I
>> still don't see all the menus. What am I missing?
>>
>> Also, I thinking I'd better buy the manual, but I'm a little hesitant. Is
>> it just screen shots and control descriptions or is there some overview
>> about how to do things at a higher level? ...Like, for example, how to set 
>> up taxes to handle state, county, special district and city sales tax, and
>> set up a report that contains all the relevant info I need to do sales tax 
>> reports? Or do I have to figure out on my own which menu commands I need to 
>> get this task accomplished?
>>
>> TIA,
>>
>>  - Bill Thoen
>>
>>     
> The manual provides a lot of detailed information on the inner workings
> of the system with a lot of how-tos built in..  Buy it, it is cheap in
> the long run.
>
> Where else can you get that kind of information for a mere $190?
>  
>
>
> -------------------------------------------------------------------------
> 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
>
>
>
>   
You could start out by reading the faq, as well as the readme info in 
the tarball.
Although not exactly a step to step howto, it should enable one to 
install and log into SQL-Ledger.
The fact one starts at /login.pl instead of /admin.pl suggests to me 
that neither info was fully read..

Hth
Paul

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] Can't Access "System/Chart of Accounts" Menu

[Jeff V. <jv...@ch...>]

On Wed, 2006-11-08 at 16:57 -0700, Bill Thoen wrote:
> I'm just getting started with SQL-Ledger and I seem to have it all set up
> okay on Fedora system. I downloaded the sample documentation (which is Chap
> 4. System) and the first thing it shows me is how to change items in the
> Chart of Accounts. However, that's not an available option on my menu under
> "System". In fact, there seem to be a lot of menu items available under
> System (when I log in as admin), and even though they are all checked for 
> the user I want to work as, I see only Audit Controls, Defaults, Taxes and
> Yearsend. I've tried setting up my user as Manager and Administrator, but I
> still don't see all the menus. What am I missing?
> 
> Also, I thinking I'd better buy the manual, but I'm a little hesitant. Is
> it just screen shots and control descriptions or is there some overview
> about how to do things at a higher level? ...Like, for example, how to set 
> up taxes to handle state, county, special district and city sales tax, and
> set up a report that contains all the relevant info I need to do sales tax 
> reports? Or do I have to figure out on my own which menu commands I need to 
> get this task accomplished?
> 
> TIA,
> 
>  - Bill Thoen
> 
The manual provides a lot of detailed information on the inner workings
of the system with a lot of how-tos built in..  Buy it, it is cheap in
the long run.

Where else can you get that kind of information for a mere $190?
 

[SL] Can't Access "System/Chart of Accounts" Menu

[Bill T. <bt...@gi...>]

I'm just getting started with SQL-Ledger and I seem to have it all set up
okay on Fedora system. I downloaded the sample documentation (which is Chap
4. System) and the first thing it shows me is how to change items in the
Chart of Accounts. However, that's not an available option on my menu under
"System". In fact, there seem to be a lot of menu items available under
System (when I log in as admin), and even though they are all checked for 
the user I want to work as, I see only Audit Controls, Defaults, Taxes and
Yearsend. I've tried setting up my user as Manager and Administrator, but I
still don't see all the menus. What am I missing?

Also, I thinking I'd better buy the manual, but I'm a little hesitant. Is
it just screen shots and control descriptions or is there some overview
about how to do things at a higher level? ...Like, for example, how to set 
up taxes to handle state, county, special district and city sales tax, and
set up a report that contains all the relevant info I need to do sales tax 
reports? Or do I have to figure out on my own which menu commands I need to 
get this task accomplished?

TIA,

 - Bill Thoen

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
>