Menu
▾
▴
sql-ledger-users
|
From: Roderick A. A. <raa...@ti...> - 2001-09-24 19:46:01
|
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
--
Let Accuracy Triumph Over Victory
Zetetic Institute
"David's Sling"
Marc Stiegler
|
|
From: Dieter S. <dsi...@sq...> - 2001-09-24 21:53:58
|
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 > |
|
From: Roderick A. A. <raa...@ti...> - 2001-09-25 14:47:32
|
On Mon, 24 Sep 2001, Dieter Simader wrote:
> Multiple payments will be added for version 1.8
Type slowly I'm accounting challenged! You do mean Payments - not
Receipts?
> 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.
My thoughts were to use pdf or - when local machine software matures -
XML with the user providing the XSLT to match their 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.
^^^^^^^
Bill? Vendor 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.
So we're still needing the other checkbook functionality. Cleared
transactions - from the statement, balance to date, notes/comments, etc.
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
--
Let Accuracy Triumph Over Victory
Zetetic Institute
"David's Sling"
Marc Stiegler
|
|
From: Dieter S. <dsi...@sq...> - 2001-09-25 19:13:06
|
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 > |
|
From: Jeff K. <jt...@ad...> - 2001-09-25 19:58:38
|
[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. |
|
From: Don W. <das...@ya...> - 2001-09-25 20:35:05
|
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 |
|
From: Dieter S. <dsi...@sq...> - 2001-09-25 23:11:02
|
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. > > > |
|
From: Don W. <das...@ya...> - 2001-09-25 19:58:47
|
--- "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 |
Thanks for helping keep SourceForge clean.
X