sql-ledger-users — SQL-Ledger users

RE: Some Urgent User Questions

[<wm...@ne...>]

Hi all,

I have some question from a newbie.

If we have a sales but if the customer had not pay yet, eg at the end of the financial year, how can we make the SQL-ledger recognise the transaction as a sales?


Can Sql-Ledger handle accounting beyond one financial year?

I would like to check on how to enter partial payments directly into the AR module? I have a separate invoicing system and did not use the one from SQL-Ledger. I have entered the transactions directly into the AR module thru Add Transaction.

For payment, again I add it directly into the AR module bypassing the receipt module as I have an SQL error " delete on acc_trans with an empty
account number" if I use the receipt module.

I would also like to enquire on the entry of credit notes for the accounting system?

Would appreciate very much your answer.

Thanks

Richard Thai



__________________________________________________________________
Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/

Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/

new user hi and some questions

[csaunders <csa...@da...>]

Hi all,

what an intreguing product, whilst i thoroughly enjoyed the product once it 
was installed, the installation process was a trial-by-fire! we have had 
PostgreSQL installed for about 12 months, and perl too, and getting DBI 
installed was a no brainer with MCPAN.

however getting DBD:Pg to install took me over 4 hours, mostly due to the 
fact that i had to hunt out what the exact variables should be , and then 
determine why the test script wouldn't work (it couldn't log on because it 
couldn't determine the postgres user and pwd for some reason so i ended up 
setting the POSTGRES_USERNAME and POSTGRES_PASSWORD in the environment). My 
background is not perl (half the problem!), however I am a reasonably 
experienced SCO admin and INFORMIX dba and I believe that unless the 
installation procedure went perfectly it would be an impossible ride for a 
less technically minded user.

I appreciate that nobody in this list may be the maintainers for DBD:Pg but 
judging by the user postings I am not the only person to have these similar 
install problems with the DBD:Pg module. It would be a shame to have the 
difficult install problems of DBD:Pg reflect on sql-ledger (unless of 
course the install problems all reflect my lack of knowledge and are not 
indicative of the typical user!!!)

however the features list is impressive!

questions:

1) is there any documentation at all, whether technical or user orientated?
2) is there an ERD or similar? i am keen to consider porting our data from 
our current package into SQL ledger to test its functionality
3) I assume because its all PERL that i have all the source, is there any 
docs on how the mods fit together so i can consider customisation? in 
particular i am keen to add reports etc
4) I suspect i will want to add fields to tables etc, will i wreck the 
current scripts or can they cope with more fields than was originally 
planned?
5) for these extra fields, how easy is it to modify the data entry forms to 
accomodate the extra fields?
6) the up and comming features look neat, can i get rough ideas on the 
timelines for them to be implemented or when the next version ETA is?

sorry for the heaps of questions, i appreciate they may not be all easy to 
answer!

ta
cs



Kind Regards

Colin Saunders
Director
DataByte Software Ltd
************************************************************************
Ph : 025 290 5093 Fax : 08 326 4187 Email : csa...@da...
DataByte Software Ltd, P O Box 98817, S.A.M.C, AUCKLAND, New Zealand

invoice generation, part 2

[Brent K. <br...@ke...>]

Hi again,

One more thing; 

If I click the (AR) 'reports' link, search by vendor, choose an
invoice, the email in the email feild of the 'Edit Customer Invoice'
form is the email address of the customer.  This is expected.
However, the invoice generated puts that same email address in the
header, along with my own mailing address, etc - as if it were my own
email address.  It seems that there is a mix up.  The invoice
generation is printing the customers email address instead of my own.

Thanks,

Brent

invoice generation

[Brent K. <br...@ke...>]

Hi,

The generated invoices print "@ %" 3 times, regardless of wether only
one tax is applicable.  For example, if only GST is appropriate, the
subtotal will have:

Subtotal	<some amount>
@ %
GST @ 7%	<some amount>
@ %
------------------------
Total		<total amount>


Same goes for the registration numbers info at the bottom of the
invoice.  

Is there any way to fix this?

Thanks!

Brent

Re: apparent bug with multiple similar parts

[Jonas S. <jo...@jo...>]

On Sat, 29 Sep 2001, peter green wrote:

> BTW, I was able to add the new routine to save and HTML invoice *and*
> email the text version of the invoice, inserted a link to the HTML in
> the text. I *did* end up using a couple of add'l variables
> (invoicespath and invoicesurl in sql-ledger.conf, $form->{invoiceurl}
> for the form) because that seemed more elegant than hardcoding a
> location in the script and templates. It's working great! :-)

Could you post a diff?

 - Jonas

-- 
Jonas Smedegaard <jo...@jo...> http://dr.jones.dk/~jonas/ +45 40843136
Spiff ApS (aka. IT-guide dr. Jones ApS) <dr...@jo...> http://dr.jones.dk/
Debian GNU/Linux <js...@de...> http://www.debian.org/ fngrprn: C02440B8

YES! I found it: http://www.shibumi.org/eoti.htm (by way of ot...@jo...)

apparent bug with multiple similar parts

[peter g. <pc...@ai...>]

Trying to enter an invoice, enter part 101, which bring up the selection
screen with parts 101, 1011, and 1012. Select 101, which is what I want, and
hit continue. The resulting page has no header, and is raw HTML, starting
with ``<H2></H2>'' (with no title).

I've looked in the code, but can't figure it out off-hand. Any thoughts on
how to isolate and test this?

BTW, I was able to add the new routine to save and HTML invoice *and* email
the text version of the invoice, inserted a link to the HTML in the text. I
*did* end up using a couple of add'l variables (invoicespath and invoicesurl
in sql-ledger.conf, $form->{invoiceurl} for the form) because that seemed
more elegant than hardcoding a location in the script and templates. It's
working great! :-)

Thanks,

/pg
-- 
Peter Green : Architekton Internet Services, LLC : pc...@ai...
-------------------------------------------------------------
chmod a+x /bin/laden

Re: Sql-Ledger Installation

[Robert A. M. <rm...@nc...>]

I found that I had to put a SetEnv directive in my httpd.conf that set 
up the postgres library path for the LD_LIBRARY_PATH or I go the error 
you described.  (This was on a RH6.2 box.)

Rob.

Peter Dabrowski wrote:

> Hi
>
> I've installed all postgresql modules and dependencies on RH6.2 I 
> think without any problems.
>
> I started Sql-Ledger Administration and try to create Database.
>
> I've got a masage: Connect DB()-connect()failed: Connection Refused
>
> What I've done wrong? I filled Localhost and Port rest was default, 
> I've not fill any pasword at this stage
>
> Regards
>
> Peter Dabrowski
>
>
>

-- 
Quoting Steven in Illinois:
"On the side of the software box, in the 'System Requirements' section, 
 it said 'Requires Windows 95 or better'. So I installed Linux." 
 "Let the source be with you" -Tux

Re: Sql-Ledger Installation

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

* Leave host and port field empty unless you want to make a remote
connection *


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

On Fri, 28 Sep 2001, Peter Dabrowski wrote:

> Hi
> I've installed all postgresql modules and dependencies on RH6.2 I think 
> without any problems.
> I started Sql-Ledger Administration and try to create Database.
> I've got a masage: Connect DB()-connect()failed: Connection Refused
> What I've done wrong? I filled Localhost and Port rest was default, I've 
> not fill any pasword at this stage
> Regards
> Peter Dabrowski
> 

Sql-Ledger Installation

[Peter D. <mer...@ma...>]

Hi
I've installed all postgresql modules and dependencies on RH6.2 I think =

without any problems.
I started Sql-Ledger Administration and try to create Database.
I've got a masage: Connect DB()-connect()failed: Connection Refused
What I've done wrong? I filled Localhost and Port rest was default, I've=
=20
not fill any pasword at this stage
Regards
Peter Dabrowski

Re: Compliment from French accountant

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

Thanks Oscar.

While I got you here. I created links from all the features in the feature
list to list them individually. My next webpage project was to add some
screenshots on the feature pages. Would you like to work on that.


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

On Wed, 26 Sep 2001, Oscar Buijten wrote:

> Dieter,
> 
> Last week I have had a visit from my accountant here in France.
> He was impressed with the way SQL-ledger is setup.
> He REALLY liked it!!
> 
> Regards,
> 
> Oscar
> 

RE: Suggestion: Using SAX->XML->FOP for formatted printing

[Jim M. <jim...@wo...>]

Let me preface this with the fact that we like sql-ledger a lot.
Have a look at GNUe and then we should all discuss.
GNUe was missing a backend accounting package, focus has been on the overall
developement environment for XML based forms.
Merging the GNUe frontend with a sql-ledger based backend is probably
easier.
We are currently looking at wrapping some session around sql-ledger for some
related processing of sql-ledger forms. In essence the implementation of a
session surrounding the existing *.pl & *.pm code.

> -----Original Message-----
> From: sql...@li...
> [mailto:sql...@li...]On Behalf Of Don
> Wellington
> Sent: Tuesday, September 25, 2001 4:16 PM
> To: sql...@li...
> Subject: Re: Suggestion: Using SAX->XML->FOP for formatted printing
>
>
> Hi Jeff-
>
> I have been developing my knowledge of XML, XSL,
> XALAN, and FOP with respect to documentation.  It is
> extremely easy to use perl to output XML, the
> formatting to PDF could be done by just having the
> perl call the command line version of FOP with an XSL
> stylesheet.
>
> Not only would this work for check printing.  It could
> result in much prettier and better laid out invoices.
>
> Alternatively, rather than having the perl scripts
> output XML, and then make external command line.
> Cocoon could be used and Java embedded in the
> stylesheet using XSP (special language for embedding
> code in Cocoon) to access the database, generate an
> XML DOM object.  Then, that object would be formatted
> using an XSL stylesheet to create formatted PDF.
> Cocoon can be integrated with Apache, so what would
> happen is that PDF creation buttons point to a URL
> that Cocoon handles.
>
> If we really want to get pie in the sky, SQL Ledger
> could be completely ported to Java, XML and Cocoon...
>
> Regards,
> Don
>
>
>
>
> --- Jeff Kowalczyk <jt...@ad...> wrote:
> > I came across this article today that would offer
> > one possible path for
> > SQL ledger to offer the formatted printing features
> > that are currently
> > being discussed.
> >
> >
> http://www.xml.com/pub/a/2001/09/19/sax-non-xml-data.html
> >
> > I found it interesting because the subject discussed
> > would be something
> > that could be grafted on top of SQL ledger, rather
> > than requiring large
> > changes in the perl scripts themselves.
> >
> > Specifically, the article introduces some techniques
> > that can be used to
> > output perl structures as XML. From there, we could
> > leverage the FOP
> > library to produce formatted PDF output. The current
> > implementation of
> > the FOP libarary is Java-based, but that may not be
> > a permanent
> > limitation.
> >
> > There are a number of other benefits to having XML
> > output of
> > sql-ledger's perl variables, as one can imagine.
> >
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Get email alerts & NEW webcam video instant messaging with Yahoo!
> Messenger. http://im.yahoo.com
>

Compliment from French accountant

[Oscar B. <os...@el...>]

Dieter,

Last week I have had a visit from my accountant here in France.
He was impressed with the way SQL-ledger is setup.
He REALLY liked it!!

Regards,

Oscar

Re: Checkbook application

[Oscar B. <os...@el...>]

Hi,

As it seems that we are now starting to create a document to transfer money
from one to another, may I suggest that this document would be flexible
enough to be used to send to a bank for cross-border transactions.

In Europe lots of money is being transfered to the different countries (and
also to outside EC countries ofcourse) using SWIFT.

In many cases it means that you endup faxing a document to your bank.
Critical info on this document:
sender: sender address, bank, accountn°, currency of the account, amount to
send, currency of amount send, costsplit (sender/receiver/50-50), text
field, reason for transfer (money laundring issues).

receiver: receiver address, receiver bank address, account n°, SWIFT-code.


Regards,

Oscar

----- Message d'origine -----
De : <nea...@nz...>
À : <sql...@li...>
Envoyé : mardi 25 septembre 2001 23:20
Objet : Re: Checkbook application


>
> Hi Dieter
>
> >From my experiences with windows accounting packages, I would suggest you
> make the focus of the cheque writing
> capability be more towards sending electronic payments rather than
printing
> paper cheques.
>
> In New Zealand all banks now have this facility and it is cheaper for
> the banks to have their customers punching payments.
> (The unfortunate but probably unavoidable consequence of this, is that
> banks are closing their branch offices
> and retreating to locations in the centre of the larger cities.)
>
> Some banks operate this process via their web-sites, but my preference
> (given my conservative accounting background)
> is to run the bank software locally on a client PC and send payment
batches
> over a telephone connection.
>
> I presume that this technology is already used in the rest of the world?
>
> Regards and keep up the good work
>
> Neal Irwin
> Assurance and Business Advisory
>
> PricewaterhouseCoopers
> 119 Armagh Street
> PO Box 13244
> Christchurch, New Zealand
>
> http://www.pwcglobal.com/nz
>
> Telephone :+64 3 374 3000
> Facsimile :+64 3 374 3001
> Mobile :+64  25 361 948
> Mailto:nea...@nz...
>
>
> PS
> I hope you are making a good living from SQL-Ledger!
>
>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>
>
>
>
>
>
> Dieter Simader <dsi...@sq...>@lists.sourceforge.net on
> 25/09/2001 09:53:49 AM
>
> Please respond to sql...@li...
>
> Sent by:  sql...@li...
>
>
> To:   sql...@li...
> cc:
> Subject:  Re: Checkbook application
>
>
> Multiple payments will be added for version 1.8 This ties in with check
> printing, although the actual printing of checks has not been resolved
> yet, I'll probably opt for pdf to print checks.
>
> The way it will work is that you enter payments the way you do now with
> previous entries blocked. You then enter an amount, date and optionally a
> check number or let SQL-Ledger generate the number. You can also use same
> check number for more than one open invoice. When you process the payments
> I'll generate a report for now for the *check run* until I find something
> suitable for check printing.
>
>
> Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
> DWS Systems Inc.     Accounting Software       Fax: 478-5281
> =========== On a clear disk you can seek forever ===========
>
> On Mon, 24 Sep 2001, Roderick A. Anderson wrote:
>
> > Several months ago I asked about web-based checkbook applications.  I
> > got several good suggestions but then got busy and had to put it aside
> > for awhile.
> >
> > Well now I'm back and after my many-hour fiasco with guncash (Redhat 7.1
> > and Ximian updates broke it totally) I'm ready to roll my own.  Since I
> > will mostly be using it with SQL-Ledger I'm looking at how to make it
> > play nicely with SQL-Ledger.
> >    The two options I'd find useful is to pull a list of Invoices
> > outstanding when making a deposit slip and pulling Vendor names etc.
> > when writing checks.
> >
> > Anything else I can add to the want/wish list?
> >
> >
> > Cheers,
> > Rod
> >
>
>
>
>
>
>
>
>
> ----------------------------------------------------------------
> The information transmitted is intended only for the person or entity to
> which it is addressed and may contain confidential and/or privileged
> material.  Any review, retransmission, dissemination or other use of, or
> taking of any action in reliance upon, this information by persons or
> entities other than the intended recipient is prohibited.   If you
received
> this in error, please contact the sender and delete the material from any
> computer.

RE: Checkbook application

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

A better way to keep track of what users do is to send all queries to a
separate table or log file. This provides you with a complete audit trail
and also a means to restore deleted transactions.


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

On Tue, 25 Sep 2001, Jeff Kowalczyk wrote:

> [Dieter Simader] No new tables are required, I'll add a source and
> cleared field to the transaction table.
> 
> [jeff] Can I take this opportunity to suggest that the transaction table
> also include a column for 'posted' timestamp and 'postedby' user string.
> My original submitted patch included a second pair of 'updated' columns
> that I now realize were superfluous, but I do think that a single
> overwriteable timestamp/user pair per transaction is very useful and
> worth the space tradeoff. I have a need to track user responsibility for
> each transaction and time of entry.
>  
> I usually reapply this change to each new release, but it would be nice
> to get it into the source tree.
> 
> 
> 

Re: Checkbook application

[<nea...@nz...>]

Hi Dieter

From my experiences with windows accounting packages, I would suggest you
make the focus of the cheque writing
capability be more towards sending electronic payments rather than printing
paper cheques.

In New Zealand all banks now have this facility and it is cheaper for
the banks to have their customers punching payments.
(The unfortunate but probably unavoidable consequence of this, is that
banks are closing their branch offices
and retreating to locations in the centre of the larger cities.)

Some banks operate this process via their web-sites, but my preference
(given my conservative accounting background)
is to run the bank software locally on a client PC and send payment batches
over a telephone connection.

I presume that this technology is already used in the rest of the world?

Regards and keep up the good work

Neal Irwin
Assurance and Business Advisory

PricewaterhouseCoopers
119 Armagh Street
PO Box 13244
Christchurch, New Zealand

http://www.pwcglobal.com/nz

Telephone :+64 3 374 3000
Facsimile :+64 3 374 3001
Mobile :+64  25 361 948
Mailto:nea...@nz...


PS
I hope you are making a good living from SQL-Ledger!

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>





Dieter Simader <dsi...@sq...>@lists.sourceforge.net on
25/09/2001 09:53:49 AM

Please respond to sql...@li...

Sent by:  sql...@li...


To:   sql...@li...
cc:
Subject:  Re: Checkbook application


Multiple payments will be added for version 1.8 This ties in with check
printing, although the actual printing of checks has not been resolved
yet, I'll probably opt for pdf to print checks.

The way it will work is that you enter payments the way you do now with
previous entries blocked. You then enter an amount, date and optionally a
check number or let SQL-Ledger generate the number. You can also use same
check number for more than one open invoice. When you process the payments
I'll generate a report for now for the *check run* until I find something
suitable for check printing.


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

On Mon, 24 Sep 2001, Roderick A. Anderson wrote:

> Several months ago I asked about web-based checkbook applications.  I
> got several good suggestions but then got busy and had to put it aside
> for awhile.
>
> Well now I'm back and after my many-hour fiasco with guncash (Redhat 7.1
> and Ximian updates broke it totally) I'm ready to roll my own.  Since I
> will mostly be using it with SQL-Ledger I'm looking at how to make it
> play nicely with SQL-Ledger.
>    The two options I'd find useful is to pull a list of Invoices
> outstanding when making a deposit slip and pulling Vendor names etc.
> when writing checks.
>
> Anything else I can add to the want/wish list?
>
>
> Cheers,
> Rod
>








----------------------------------------------------------------
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material.  Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited.   If you received
this in error, please contact the sender and delete the material from any
computer.

RE: Checkbook application

[Don W. <das...@ya...>]

I would like to second that I also have a need for
tracking user responsibility.

Jeff - Could you resend the patch?

Thanks,
Don

--- Jeff Kowalczyk <jt...@ad...> wrote:
> [Dieter Simader] No new tables are required, I'll
> add a source and
> cleared field to the transaction table.
> 
> [jeff] Can I take this opportunity to suggest that
> the transaction table
> also include a column for 'posted' timestamp and
> 'postedby' user string.
> My original submitted patch included a second pair
> of 'updated' columns
> that I now realize were superfluous, but I do think
> that a single
> overwriteable timestamp/user pair per transaction is
> very useful and
> worth the space tradeoff. I have a need to track
> user responsibility for
> each transaction and time of entry.
>  
> I usually reapply this change to each new release,
> but it would be nice
> to get it into the source tree.
> 
> 


__________________________________________________
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com

Re: assistance

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

Try moveing the SL directory to your perl library tree.


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

On Tue, 25 Sep 2001, John S Smith wrote:

> Good evening everyone,
> 
> I am trying to get Sql-ledger set up and running but have come to a dead stop - no 
> doubt because I am not sure just what I should be doing.
> 
> The result is a request for assistance from the Sql-ledger users list.
> 
> I am using the new release of OS/2 now called eComStation and have downloaded 
> and 'untared' the following:
> 
> sql-ledger (v1.6) into \sql-ledger
> Perl-5.6.1 into \perl-5.6.1
> Postgresql-7.1.3 into \postgresql-7.1.3
> dbi-1.20   into \dbi
> dbd-pg-1_0 into \dbd 
> 
> I tried to run the dnhttpd but kept getting error messages so downloaded Apache 
> version 1.3.20
> 
> Has anyone the time (and patience) to assist me in setting things up?  If so, please 
> contact me direct and I will supply all additional information required.
> 
> I know that there are several other people on the OS/2 (sorry eCs) newsgroup who are 
> suffering similar problems and I would be pleased to pass on any setup info that is 
> available.
> 
> Many regards
> 
> John S Smith
> 
> 
> 
> -------------------------------------------------------------------------------------------------------------------------------
> ----------
> Joatamon Enterprises			Voice:  +44 (0) 1202 734701
> email:  ad...@jo...        	Fax:      +44 (0) 1202 716644
> 	
> 					         
> 
> 
> 
> 
> 
> 
> 
> 

Re: Suggestion: Using SAX->XML->FOP for formatted printing

[Don W. <das...@ya...>]

Hi Jeff-

I have been developing my knowledge of XML, XSL,
XALAN, and FOP with respect to documentation.  It is
extremely easy to use perl to output XML, the
formatting to PDF could be done by just having the
perl call the command line version of FOP with an XSL
stylesheet.

Not only would this work for check printing.  It could
result in much prettier and better laid out invoices.

Alternatively, rather than having the perl scripts
output XML, and then make external command line.
Cocoon could be used and Java embedded in the
stylesheet using XSP (special language for embedding
code in Cocoon) to access the database, generate an
XML DOM object.  Then, that object would be formatted
using an XSL stylesheet to create formatted PDF. 
Cocoon can be integrated with Apache, so what would
happen is that PDF creation buttons point to a URL
that Cocoon handles.

If we really want to get pie in the sky, SQL Ledger
could be completely ported to Java, XML and Cocoon...

Regards,
Don




--- Jeff Kowalczyk <jt...@ad...> wrote:
> I came across this article today that would offer
> one possible path for
> SQL ledger to offer the formatted printing features
> that are currently
> being discussed.
> 
>
http://www.xml.com/pub/a/2001/09/19/sax-non-xml-data.html
> 
> I found it interesting because the subject discussed
> would be something
> that could be grafted on top of SQL ledger, rather
> than requiring large
> changes in the perl scripts themselves.
> 
> Specifically, the article introduces some techniques
> that can be used to
> output perl structures as XML. From there, we could
> leverage the FOP
> library to produce formatted PDF output. The current
> implementation of
> the FOP libarary is Java-based, but that may not be
> a permanent
> limitation.
> 
> There are a number of other benefits to having XML
> output of
> sql-ledger's perl variables, as one can imagine.
> 
> 


__________________________________________________
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com

Re: Checkbook application

[Don W. <das...@ya...>]

--- "Roderick A. Anderson" <raa...@ti...>
wrote: 
> My thoughts were to use pdf or - when local machine
> software matures -
> XML with the user providing the XSLT to match their
> checks.

I was thinking about that myself, create an short XML
document containing the required information for a
check,  then use XSLFO to layout the XML in the
appropriate places for a check, and FOP to generate
the PDF. That should allow for customizable PDF checks
to be printed.

Any thought?

Don


__________________________________________________
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com

RE: Checkbook application

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

[Dieter Simader] No new tables are required, I'll add a source and
cleared field to the transaction table.

[jeff] Can I take this opportunity to suggest that the transaction table
also include a column for 'posted' timestamp and 'postedby' user string.
My original submitted patch included a second pair of 'updated' columns
that I now realize were superfluous, but I do think that a single
overwriteable timestamp/user pair per transaction is very useful and
worth the space tradeoff. I have a need to track user responsibility for
each transaction and time of entry.
 
I usually reapply this change to each new release, but it would be nice
to get it into the source tree.

Re: assistance

[John S S. <ad...@jo...>]

Good evening everyone,

I am trying to get Sql-ledger set up and running but have come to a dead stop - no 
doubt because I am not sure just what I should be doing.

The result is a request for assistance from the Sql-ledger users list.

I am using the new release of OS/2 now called eComStation and have downloaded 
and 'untared' the following:

sql-ledger (v1.6) into \sql-ledger
Perl-5.6.1 into \perl-5.6.1
Postgresql-7.1.3 into \postgresql-7.1.3
dbi-1.20   into \dbi
dbd-pg-1_0 into \dbd 

I tried to run the dnhttpd but kept getting error messages so downloaded Apache 
version 1.3.20

Has anyone the time (and patience) to assist me in setting things up?  If so, please 
contact me direct and I will supply all additional information required.

I know that there are several other people on the OS/2 (sorry eCs) newsgroup who are 
suffering similar problems and I would be pleased to pass on any setup info that is 
available.

Many regards

John S Smith



-------------------------------------------------------------------------------------------------------------------------------
----------
Joatamon Enterprises			Voice:  +44 (0) 1202 734701
email:  ad...@jo...        	Fax:      +44 (0) 1202 716644
	
					         

Suggestion: Using SAX->XML->FOP for formatted printing

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

I came across this article today that would offer one possible path for
SQL ledger to offer the formatted printing features that are currently
being discussed.

http://www.xml.com/pub/a/2001/09/19/sax-non-xml-data.html

I found it interesting because the subject discussed would be something
that could be grafted on top of SQL ledger, rather than requiring large
changes in the perl scripts themselves.

Specifically, the article introduces some techniques that can be used to
output perl structures as XML. From there, we could leverage the FOP
library to produce formatted PDF output. The current implementation of
the FOP libarary is Java-based, but that may not be a permanent
limitation.

There are a number of other benefits to having XML output of
sql-ledger's perl variables, as one can imagine.

Re: Checkbook application

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

No new tables are required, I'll add a source and cleared field to the
transaction table.


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

On Tue, 25 Sep 2001, Roderick A. Anderson wrote:
> 
> Would there be a new table to handle this check stuff?  Check number,
> date, to, notes/comments (Incoming check number/Invoice number), type
> (check, deposit, reconciliation - possibly handled by the sign of the
> amount), amount of check or deposit.
> 
> 
> TIA,
> Rod
> 

Re: Invoices

[Brian J. <bjo...@je...>]

In regards to some of the recent discussion about invoices ...

As mentioned, saving a copy of the invoice on the hard drive and maintaining
a link to the invoice file within sql-ledger would be great for record
keeping.

Also, a method to produce a draft invoice for review and then go back and
edit it prior to posting it in the accounts receivable would be great.  We
routinely have the project leader review invoices (and suggest
wording/amount modifications) prior to mailing them.

The ability to make a cron job to email invoice drafts to project leaders
once a month would be great too.

Re: Missing clauses....

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

Nothing to worry about.

There are a few queries which have no FROM clause and the server adds 
the tables. I'll take care of this in the next release.


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

On Tue, 25 Sep 2001, Paul Stavrides wrote:

> 
> First off, thanks to everyone who has made SQL-Ledger possible.  Very 
> nice code set....
> 
> We are considering incorporating the SQL-Ledger accounting system into 
> our Applicant Tracking System (manages resumes, contacts, jobs and what 
> not).  We are very interested in the multiple payments feature slated 
> for 1.8.   Hopefully, we can help at some point...
> 
> 
> Anyhow, after using SQL-Leder for a while, I've noticed that my Postgres 
> log file is filling up with the following and I wonder if it was 
> something I have set incorrectly...
> 
> 
> 
> NOTICE:  Adding missing FROM-clause entry for table "customertax"
> NOTICE:  Adding missing FROM-clause entry for table "partstax"
> NOTICE:  Adding missing FROM-clause entry for table "partstax"
> NOTICE:  Adding missing FROM-clause entry for table "customertax"
> NOTICE:  Adding missing FROM-clause entry for table "acc_trans"
> NOTICE:  Adding missing FROM-clause entry for table "acc_trans"
> NOTICE:  Adding missing FROM-clause entry for table "acc_trans"
> NOTICE:  Adding missing FROM-clause entry for table "acc_trans"
> 
> 
> 
> Regards,
> 
> -paul
> 
> 
>