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