Menu
▾
▴
Re: [SL] sql-ledger-users Digest, Vol 7, Issue 3
|
From: Margot R. <mri...@pa...> - 2006-11-10 01:20:29
|
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} > > > > |
