sql-ledger-users — SQL-Ledger users

Re: [SL] Poll - What do you want to see?

[<ma...@hu...>]

>
> Anybody else?
>

1. Cash-based financials (e.g., income statement) that don't require
invoice date to be in same period as cash receipt.

2. remote_user and/or openId authentication support.

A distant third: fastcgi support.

m

Re: [SL] Poll - What do you want to see?

[ATM L. <atm...@km...>]

> After my last post I got to thinking...  It seems (to me) 
> that the same items come up over and over on the list.  There 

SL does all we need and more...  About the only wish I could ever want to
see is perhaps an ISO of a small, secure Linux Distro with SL built in,
capable of updateing Latex etc without breaking itself...  However this
would really only save me about a hour or so once every 3 years when I make
enough changes that I require a reinstall of SL

[SL] (no subject)

[Ing. R. G. T. <rg...@so...>]

I'm protected by SpamBrave
http://www.spambrave.com/

Re: [SL] Output reports to csv

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

Please don't try to be an idiot.

el

on 3/2/07 12:40 PM david said the following:
> On Fri, 2007-03-02 at 12:18 +0200, Dr Eberhard Lisse wrote:
>> It is almost trivial, to put this statement of mine into a perl script,
>> and using the appropriate CPAN module, to generate Excell or OpenOffice
>> spreadsheets.
>>
>
>
> It's NOT trivial. I'm sure I could manage it, and I'm sure you, being
> the ultimate renaissance man, could manage it too.. but I have to say
> that CSV export is a very sensible addition to the wish list.
>
> By your reasoning, there shouldn't be an invoice function in SL because
> anyone could do their own. Please try not to be a pompous ass.

Re: [SL] Poll - What do you want to see?

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

On Fri, 2 Mar 2007, C. Duncan Hudson wrote:

> After my last post I got to thinking...  It seems (to me) that the same
> items come up over and over on the list.

Dunc,

   SL does very much more than we need, so there's nothing I could contribute
to a wish list.

   However, your observation certainly argues for a wiki where a FAQ, various
HOWTOs, and examples of setting up and using SL in different industries and
companies can be documented by all users.

   This wiki would be a resource to answer the questions that keep repeating
like onions on a cheap hamburger.

Rich

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

[SL] Poll - What do you want to see?

[C. D. H. <Du...@Du...>]

After my last post I got to thinking...  It seems (to me) that the same 
items come up over and over on the list.  There is continued development 
of the application (and that's wonderful), but is it providing what 
people are really looking for, wanting, needing?  What are the two 
biggest things everyone wants fixed or added to SQL-Ledger?

My two biggest wants, needs are:  Sales tax flexibility - I need to be 
able to make a taxed customer tax free (on occasion) and vice versa.  My 
next wish would just make my life easier - I wish you could search (on 
POs, Sales Orders and Invoices) by Shipto.

Anybody else?


Dunc

Re: [SL] Output reports to csv

[C. D. H. <Du...@Du...>]

david wrote:
> On Fri, 2007-03-02 at 12:18 +0200, Dr Eberhard Lisse wrote:
>   
>> It is almost trivial, to put this statement of mine into a perl script,
>> and using the appropriate CPAN module, to generate Excell or OpenOffice
>> spreadsheets.
>>
>>     
>
>
> It's NOT trivial. I'm sure I could manage it, and I'm sure you, being
> the ultimate renaissance man, could manage it too.. but I have to say
> that CSV export is a very sensible addition to the wish list. 
>   
I believe it is sensible, and I would say should be required - because 
every other accounting package does it.  It has has been discussed many 
times on the list before, and we always get the 'Just cut and paste' 
responses.  And then eventually Dieter will chime in and say, "you have 
the source add it".

Dunc

Re: [SL] GAAP and fixed asset

[Joseph A. M. <ja...@jo...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi Enzo,

I am not sure what you mean by GAAP certification.  In the U.S.  we  use
different standards then  international standards.  Although they are
converging.  The IAASB may use terms I am not familiar.

Are you talking about an auditors report that your financial statements
are in accordance with GAAP? In the U.S. CPAs offer an opinion not a
certification (which implies a guarantee or a high level of assurance
then we provide) - this opinion states whether our financial statements
are fairly stated in accordance with generally accepted accounting
principles.
I assume your accountant needs to take your financial statement and
present them in a uniform format with the audit report, i.e. footnote,
fonts, title, page number, etc.  This is common for presentation purposes.

You can help your accountant reduce his time and therefore his fees if
you can present the financial statement in a spreadsheet so that he
would not have to manually re-enter the information. Lastly, you would
need to make sure that your G/L account titles are similar to what they
use in the financial statements. You should strive to mimic his report.
Talk to your accountant get his suggestions for changes. If your books
are not in order because you don't know bookkeeping then you should hire
a bookkeeper.

If your question is really - what is GAAP and how do I comply with it -
it would be more difficult to teach you. But as the Chairman I would not
suggest that you learn GAAP and bookkeeping. You should hire someone
familiar. I.e. GAAP requires you to capitalize certain assets that have
a useful life greater then one year. If you bought furniture you would
have to depreciate it over its useful life. You would have an asset
account with an accompanying contra asset account that accumulates
depreciation. As you can see it gets involved. In the U.S. GAAP is free.
You can get GAAP from the body that generates it from their website.
www. fasb.org ( this won't really help you as you don't know the
fundamentals) and  the  most countries have  joined an international
standard setting body  called  IFAC. Each country has joined and the
GAAP and audit standards would be covered by them. Good luck.

With respect to fixed assets, Sql doesn't have a subledger for fixed
assets that can maintain details about each piece of equipment,
machinery or furniture. Perhaps you can request it as a future project.

If I am totally off mark with your GAAP certification question- please
educate me.

Joe

www.joemaffia.com



Vincenzo Puliatti wrote:
> Good morning,
>
> My name is Enzo Puliatti. I am the Chairman of IT Synergy (
www.itsyn.com ). We have an ongoing project aimed to spread the usage of
SQL-Ledger for SMEs in Egypt and we are working on many localization and
customization issues. However, we have recently faced a bureaucratic
> issue and we are trying to find out if there is any experience on GAAP
certification for SQL-Ledger or at least a clear "how-to do". Have you
done anything in this sense in your  country or are you aware of any
successful or ongoing effort in this senses?
>
> I do understand that this may be different from country to country but
we would like to start from some established experience. If nobody has
collected these procedure we are most willing to collect all information
and share it with all you.
>
> For those of you that (like me) are not to familiar with accounting
procedures and rules, the  idea is to be able to completely replace
manual bookkeeping (or "hybrid") with a fully computerized one using
SQL-Ledger. I personally don't like the idea of using SL in my company
and then having the accountant manually copying the information in a
different format to present it to the relevant authorities.
>
> A second issue is related to management of fixed assets. I have seen
several scattered posting about this issue without a clearly defined
procedures. This topic is also not mentioned in the manual and other
documentation that I have found online.
>
> The basic question is: how to treat the purchasing, inventorying and
depreciation of fixed assets and other consumable that are meant to be
used for the company itself and not for resale?
>
> Thanks and regards,
> Enzo Puliatti
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org

iD4DBQFF6DBr1Zo2InkR90QRAragAJ40sWG9s82XRrz/ZlER1yRhDgKXFwCYpdmP
q/y6pk636GYLjuQxV3gkWQ=3D=3D
=3DEX0K
-----END PGP SIGNATURE-----

Re: [SL] Year end

[Roy N. <RNi...@NB...>]

While we are talking about year end, I asked a question a few weeks  
back which appears to have slipped through the cracks.

As quick refresher:  I setup a local running club to use SQL-Ledger  
for their books.  The experience has been generally positive with the  
exception of an inventory issue (which I am still trying to unravel)  
and problems trying to use the year-end functionality.

In addition to the general operations, the running club presents two  
large road races each year: a marathon in the
spring and a 10K in the autumn.

Each of these events operates as a separate 'profit centre', with its  
own bank account(s), from the Club's general operations and I have  
setup SQL Ledger such that the Marathon and 10K events are separate  
'Departments'.

As alluded above, this worked just wonderfully until we tried to  
perform a year end.   The "year end" function appear to work  
globally ... i.e. it
sweeps all departments/divisions together and drops the retained  
earnings into a single account.   Is there a way I can perform the
year end function on a per department basis?  ... or will I have to  
pull everything apart and re-implement them as separate 'companies' -  
which would be highly inconvenient and remove some of the benefits  
the Club has enjoyed with SQL Ledger.

Roy




On 01-Mar-2007, at 16:11, Dieter Simader wrote:

> The yearend generates an offsetting GL transaction to zero out  
> income and
> expenses, none of the transactions are affected by this.
>
> -- 
> 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, 1 Mar 2007, Antony Gelberg wrote:
>
>> Hi all,
>>
>> Does the year-end only remove P&L transactions before the year-end  
>> date
>> entered?  i.e. Can we enter transactions for next year without  
>> running
>> year-end, without losing data when we get round to running year-end?
>>
>> Antony
>>
>>
>
> ---------------------------------------------------------------------- 
> ---
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to  
> share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php? 
> page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Output reports to csv

[david <da...@ke...>]

On Fri, 2007-03-02 at 12:18 +0200, Dr Eberhard Lisse wrote:
> It is almost trivial, to put this statement of mine into a perl script,
> and using the appropriate CPAN module, to generate Excell or OpenOffice
> spreadsheets.
> 


It's NOT trivial. I'm sure I could manage it, and I'm sure you, being
the ultimate renaissance man, could manage it too.. but I have to say
that CSV export is a very sensible addition to the wish list. 

By your reasoning, there shouldn't be an invoice function in SL because
anyone could do their own. Please try not to be a pompous ass.



> el
> 
> on 3/2/07 8:22 AM Penguin Products said the following:
> 
> > What I do is highlight the HTML in the Firefox, Ctrl-C, then in Excel say
> > "Paste Special" and then "Text".
> > 
> > It might work with OpenOffice as well.
> > 
> > m
> > 
> > I can confirm it does in OpenOffice, You Paste though in unformatted text or
> > it fills your spreadsheet with (I think you call them) URL links to
> > Sql-Ledger (that in itself has uses in presentations and updating prices
> > etc..)
> > 
> > Tim
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> 

Re: [SL] Output reports to csv

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

on 3/2/07 7:48 AM david said the following:
> On Fri, 2007-03-02 at 07:12 +0200, Dr Eberhard Lisse wrote:
>> Of course you can do this from within SL. You (just) add
>> a line into the menu, doing something like I wrote.
>>
>> el
>>
>> "Use the source, Luke!"
>>
> 
> Do you do DIY brain surgery too?

No, I am an Obstetrician and Gynaecologist, so if you had asked about
Hysterectomies or Cesarean Sections I would have said yes :-)-O

el

Re: [SL] Output reports to csv

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

It is almost trivial, to put this statement of mine into a perl script,
and using the appropriate CPAN module, to generate Excell or OpenOffice
spreadsheets.

el

on 3/2/07 8:22 AM Penguin Products said the following:

> What I do is highlight the HTML in the Firefox, Ctrl-C, then in Excel say
> "Paste Special" and then "Text".
> 
> It might work with OpenOffice as well.
> 
> m
> 
> I can confirm it does in OpenOffice, You Paste though in unformatted text or
> it fills your spreadsheet with (I think you call them) URL links to
> Sql-Ledger (that in itself has uses in presentations and updating prices
> etc..)
> 
> Tim

[SL] Output reports to csv

[Penguin P. <pen...@gm...>]

Message: 27
Date: Thu, 1 Mar 2007 12:43:25 -0500 (EST)
From: ma...@hu...
Subject: Re: [SL] Output reports to csv
To: sql...@li...
Cc: sql...@li...
Message-ID:
       <297...@bi...>
Content-Type: text/plain; charset=iso-8859-1

> My bookkeeper wants to be able to crunch some numbers from my SQL Ledger
> database in a spreadsheet.  Is there any established way to output reports
> to a csv file or something similar?

What I do is highlight the HTML in the Firefox, Ctrl-C, then in Excel say
"Paste Special" and then "Text".

It might work with OpenOffice as well.

m

I can confirm it does in OpenOffice, You Paste though in unformatted text or
it fills your spreadsheet with (I think you call them) URL links to
Sql-Ledger (that in itself has uses in presentations and updating prices
etc..)

Tim

Re: [SL] Output reports to csv

[david <da...@ke...>]

On Fri, 2007-03-02 at 07:12 +0200, Dr Eberhard Lisse wrote:
> Of course you can do this from within SL. You (just) add
> a line into the menu, doing something like I wrote.
> 
> el
> 
> "Use the source, Luke!"
> 

Do you do DIY brain surgery too?


> 
> 
> on 3/2/07 7:06 AM C. Duncan Hudson said the following:
> > No, actually you're wrong.  The original post said there was probably a
> > means to build the file from within SQL-Ledger, and there is not.  I
> > indicated I use a tool to extract data, and you're showing us that you
> > use a tool (psql) too.  Unlike virtually every other Accounting package
> > there is no way, from within the application to export data to a file.
> >
> > Dunc

Re: [SL] Output reports to csv

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

Of course you can do this from within SL. You (just) add
a line into the menu, doing something like I wrote.

el

"Use the source, Luke!"



on 3/2/07 7:06 AM C. Duncan Hudson said the following:
> No, actually you're wrong.  The original post said there was probably a
> means to build the file from within SQL-Ledger, and there is not.  I
> indicated I use a tool to extract data, and you're showing us that you
> use a tool (psql) too.  Unlike virtually every other Accounting package
> there is no way, from within the application to export data to a file.
>
> Dunc

Re: [SL] Output reports to csv

[C. D. H. <Du...@Du...>]

No, actually you're wrong.  The original post said there was probably a 
means to build the file from within SQL-Ledger, and there is not.  I 
indicated I use a tool to extract data, and you're showing us that you 
use a tool (psql) too.  Unlike virtually every other Accounting package 
there is no way, from within the application to export data to a file. 

Dunc

Dr Eberhard Lisse wrote:
> Actually this is wrong.
>
> psql -AtF, databasename < gl.psql > gl.csv will produce CSV.
>
> and gl.psql looking like
>
> SELECT  c.accno, c.description, ac.transdate, g.id,
>     round(ac.amount::numeric,2) as Amount,
>     g.reference,
>     g.description, substr(g.notes,1,55) as Notes,
>     ac.memo
>
> FROM gl g
> JOIN acc_trans ac ON (g.id = ac.trans_id)
> JOIN chart c ON (ac.chart_id = c.id)
> LEFT JOIN department d ON (d.id = g.department_id)
> WHERE 1 = 1
>     AND ac.transdate >= '2005-06-01'
>     AND ac.transdate <= '2006-06-30'
>
> UNION ALL
>
> SELECT c.accno,  c.description, ac.transdate, a.id,
>     round(ac.amount::numeric,2) as Amount,
>     a.invnumber,
>     ct.name, substr(a.notes,1,55) as Notes,
>    ac.memo
> FROM ar a
> JOIN acc_trans ac ON (a.id = ac.trans_id)
> JOIN chart c ON (ac.chart_id = c.id)
> JOIN customer ct ON (a.customer_id = ct.id)
> LEFT JOIN department d ON (d.id = a.department_id)
> WHERE 1 = 1
>    AND ac.transdate >= '2005-06-01'
>    AND ac.transdate <= '2006-06-30'
>
> UNION ALL
>
> SELECT c.accno,  c.description, ac.transdate,  a.id,
>     round(ac.amount::numeric,2) as Amount,
>     a.invnumber,
>     ct.name, substr(a.notes,1,55) as Notes,
>    ac.memo
> FROM ap a
> JOIN acc_trans ac ON (a.id = ac.trans_id)
> JOIN chart c ON (ac.chart_id = c.id)
> JOIN vendor ct ON (a.vendor_id = ct.id)
> LEFT JOIN department d ON (d.id = a.department_id)
> WHERE 1 = 1
>    AND ac.transdate >= '2005-06-01'
>    AND ac.transdate <= '2006-06-30'
>
> ORDER BY 1, 3, 4;
>
> does it for my auditor :-)-O
>
> el
>
> on 3/1/07 10:42 PM C. Duncan Hudson said the following:
>   
>> David Boyle wrote:
>>     
>>> On Thu, 2007-03-01 at 09:17 -0800, Wray Cason wrote:
>>>   
>>>       
>>>> My bookkeeper wants to be able to crunch some numbers from my SQL Ledger
>>>> database in a spreadsheet.  Is there any established way to output reports
>>>> to a csv file or something similar?
>>>>     
>>>>         
>>> I imagine there is...but copy/paste works pretty well and is easy.
>>>
>>> David Boyle
>>> NAPCO (Northwest Arkansas Paper Company)
>>>
>>>   
>>>       
>> There isn't, actually, a way to output to any kind of file.  The 
>> technical solution is cut and paste, which I think leaves a lot to be 
>> desired.  I use Postgres SQL Manager to generate reports.  It would be 
>> nice if the functionality was built in, as that's not a tool I give to 
>> any of my users.
>>
>> Dunc
>>     
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>   

Re: [SL] Output reports to csv

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

Actually this is wrong.

psql -AtF, databasename < gl.psql > gl.csv will produce CSV.

and gl.psql looking like

SELECT  c.accno, c.description, ac.transdate, g.id,
    round(ac.amount::numeric,2) as Amount,
    g.reference,
    g.description, substr(g.notes,1,55) as Notes,
    ac.memo

FROM gl g
JOIN acc_trans ac ON (g.id = ac.trans_id)
JOIN chart c ON (ac.chart_id = c.id)
LEFT JOIN department d ON (d.id = g.department_id)
WHERE 1 = 1
    AND ac.transdate >= '2005-06-01'
    AND ac.transdate <= '2006-06-30'

UNION ALL

SELECT c.accno,  c.description, ac.transdate, a.id,
    round(ac.amount::numeric,2) as Amount,
    a.invnumber,
    ct.name, substr(a.notes,1,55) as Notes,
   ac.memo
FROM ar a
JOIN acc_trans ac ON (a.id = ac.trans_id)
JOIN chart c ON (ac.chart_id = c.id)
JOIN customer ct ON (a.customer_id = ct.id)
LEFT JOIN department d ON (d.id = a.department_id)
WHERE 1 = 1
   AND ac.transdate >= '2005-06-01'
   AND ac.transdate <= '2006-06-30'

UNION ALL

SELECT c.accno,  c.description, ac.transdate,  a.id,
    round(ac.amount::numeric,2) as Amount,
    a.invnumber,
    ct.name, substr(a.notes,1,55) as Notes,
   ac.memo
FROM ap a
JOIN acc_trans ac ON (a.id = ac.trans_id)
JOIN chart c ON (ac.chart_id = c.id)
JOIN vendor ct ON (a.vendor_id = ct.id)
LEFT JOIN department d ON (d.id = a.department_id)
WHERE 1 = 1
   AND ac.transdate >= '2005-06-01'
   AND ac.transdate <= '2006-06-30'

ORDER BY 1, 3, 4;

does it for my auditor :-)-O

el

on 3/1/07 10:42 PM C. Duncan Hudson said the following:
> David Boyle wrote:
>> On Thu, 2007-03-01 at 09:17 -0800, Wray Cason wrote:
>>   
>>> My bookkeeper wants to be able to crunch some numbers from my SQL Ledger
>>> database in a spreadsheet.  Is there any established way to output reports
>>> to a csv file or something similar?
>>>     
>> I imagine there is...but copy/paste works pretty well and is easy.
>>
>> David Boyle
>> NAPCO (Northwest Arkansas Paper Company)
>>
>>   
> There isn't, actually, a way to output to any kind of file.  The 
> technical solution is cut and paste, which I think leaves a lot to be 
> desired.  I use Postgres SQL Manager to generate reports.  It would be 
> nice if the functionality was built in, as that's not a tool I give to 
> any of my users.
> 
> Dunc

Re: [SL] Output reports to csv

[C. D. H. <Du...@Du...>]

David Boyle wrote:
> On Thu, 2007-03-01 at 09:17 -0800, Wray Cason wrote:
>   
>> My bookkeeper wants to be able to crunch some numbers from my SQL Ledger
>> database in a spreadsheet.  Is there any established way to output reports
>> to a csv file or something similar?
>>     
>
> I imagine there is...but copy/paste works pretty well and is easy.
>
> David Boyle
> NAPCO (Northwest Arkansas Paper Company)
>
>   
There isn't, actually, a way to output to any kind of file.  The 
technical solution is cut and paste, which I think leaves a lot to be 
desired.  I use Postgres SQL Manager to generate reports.  It would be 
nice if the functionality was built in, as that's not a tool I give to 
any of my users.

Dunc

Re: [SL] Year end

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

The yearend generates an offsetting GL transaction to zero out income and 
expenses, none of the transactions are affected by this.

-- 
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, 1 Mar 2007, Antony Gelberg wrote:

> Hi all,
>
> Does the year-end only remove P&L transactions before the year-end date
> entered?  i.e. Can we enter transactions for next year without running
> year-end, without losing data when we get round to running year-end?
>
> Antony
>
>

Re: [SL] Output reports to csv

[<ma...@hu...>]

> My bookkeeper wants to be able to crunch some numbers from my SQL Ledger
> database in a spreadsheet.  Is there any established way to output reports
> to a csv file or something similar?

What I do is highlight the HTML in the Firefox, Ctrl-C, then in Excel say
"Paste Special" and then "Text".

It might work with OpenOffice as well.

m

Re: [SL] Output reports to csv

[David B. <dav...@sb...>]

On Thu, 2007-03-01 at 09:17 -0800, Wray Cason wrote:
> My bookkeeper wants to be able to crunch some numbers from my SQL Ledger
> database in a spreadsheet.  Is there any established way to output reports
> to a csv file or something similar?

I imagine there is...but copy/paste works pretty well and is easy.

David Boyle
NAPCO (Northwest Arkansas Paper Company)

> 
> 
> Wray Cason "Wrayman"
> Auxilium Computing
> www.auxiliumcomputing.com
> wr...@au...
> main: 206-595-2080
> fax:  425-895-9825
> msn: wr...@pi...
> aim: AuxiliumWrayman
> yahoo: wraycason
> skype: wrayman
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

[SL] Output reports to csv

[Wray C. <wr...@au...>]

My bookkeeper wants to be able to crunch some numbers from my SQL Ledger
database in a spreadsheet.  Is there any established way to output reports
to a csv file or something similar?


Wray Cason "Wrayman"
Auxilium Computing
www.auxiliumcomputing.com
wr...@au...
main: 206-595-2080
fax:  425-895-9825
msn: wr...@pi...
aim: AuxiliumWrayman
yahoo: wraycason
skype: wrayman

[SL] New Check format (June 2007) with enhanced security... Will SQL-Ledger support the new format?

[ATM L. <atm...@km...>]

We have not been using SL to print cheques... however have someone (basic
retail store, selling water) that wants to move to SL from MYOB..
 
Two quick questions... 
 
1.    Is thier any way to get the MYOB info into SL 
 
2.    This new security feature will SL be able to support this?  (Sorry,
first I heard of it, and I have not googled it yet)
 
Thanks for any info on either...

[SL] A couple of practical POS questions

[Matt J. <sir...@gm...>]

Hello, all.

I sell inventory items.

I assume this means my process, starting from the beginning is:

1. Add my vendors

2. Add my items

3. (confused here) Add items I have ordered and their prices *at that time*
(they change). I order 6 of this, 8 of that, etc. all on a single invoice
from my supplier. Can I enter these "orders" with their particular order
numbers/dates in that fashion in SQL Ledger? The only thing I was able to
find was under "Order Entry > Purchase Order" I could enter one
item/number/description, but not many. How does this work?


Next, when I sell an item:

1. Go to POS > Sale

2. Enter order info

BUT...

- why is there only the "Record In: Accounts Receivable" option? Why can't I
record it in checking account if I received a check? That is a different
sort of asset.

- Why is there only one "record" for an item number/description/quantity,
etc.? What if they order many items in one order? Is there a way to add more
lines for more items?

- Why do the "amount / source / memo" fields below that lead to my checking
and petty cash accounts? Does the money "technically" go from AR to the
asset account all within one invoice? Why not directly into cash or checking
acct?


Thanks,

Matt Jackson

[SL] Year end

[Antony G. <an...@wa...>]

Hi all,

Does the year-end only remove P&L transactions before the year-end date
entered?  i.e. Can we enter transactions for next year without running
year-end, without losing data when we get round to running year-end?

Antony

-- 
Mobile: 07747 533 543      | Cutting-Edge IT Consultancy
MSN: an...@wa... | Custom Business Software Systems
Skype: antonygelberg       | Website Content Management
Wengo: antonygelberg       | Thin Client Deployment
Yahoo: antonygelberg       | Open Source Migration