From: Roderick A. A. <raa...@ti...> - 2001-03-10 03:57:55
|
Did I miss them? I can't find out how to run a customer statement - out standing invoices and receipts for a period. If it's not there yet I'd be willing to take on the coding. Rod -- |
From: Mark W. <ma...@ma...> - 2001-03-10 05:06:49
|
On Fri, Mar 09, 2001 at 07:59:41 -0800, Roderick A. Anderson wrote: > Did I miss them? I can't find out how to run a customer statement - out > standing invoices and receipts for a period. > > If it's not there yet I'd be willing to take on the coding. There is no statements at the moment, another thing that is missing is part payment, recording payment type (cash, cheque or creditcard) etc, cheque numbers etc.. Say if someone was to purchase something then pay back in 3 part payments, it's extremely hard record all 3 part payments.. May be I have missed something as well.. Other than that, Sql-Ledger is great, the above problems are the main reasons that we are not using it at moment. Cheers Mark Williamson |
From: Paolo B. <p.b...@ic...> - 2001-03-10 11:16:30
|
Hi, > There is no statements at the moment, another thing that is missing is > part payment, recording payment type (cash, cheque or creditcard) etc, > cheque numbers etc.. > > Say if someone was to purchase something then pay back in 3 part > payments, it's extremely hard record all 3 part payments.. May be I > have missed something as well.. > Agreed. I am interested in this feature as well, and available to provide some support for its development. How can we proceed ? Ciao Paolo -- Paolo Bizzarri Icube S.r.l. |
From: Martin L. <ma...@li...> - 2001-03-10 17:43:38
|
Paolo Bizzarri wrote: > > Say if someone was to purchase something then pay back in 3 part > > payments, it's extremely hard record all 3 part payments.. May be I > > have missed something as well.. > > > Agreed. I am interested in this feature as well, and available to provide > some support for its development. > > How can we proceed ? You can start at: http://www.lillepuu.com/sql-ledger/uml/sql-ledger-db.png http://www.lillepuu.com/sql-ledger/uml/sql-ledger-code.png These diagrams reflect current stucture and some relations of the sql-ledger code and database. As far as I can tell, the code structure will change in next major version but the database will be more-or-less intact. These diagrams were created with dia http://www.lysator.liu.se/~alla/dia/ . diagram source files are available at beforementioned location. anyway, for part payments, I think you should add new table to record each payment amount and date, and some field to AR and AP tables to mark the payment as part payment. then you need to modify payment processing interface to support part payments and record transactionfin acc_trans for each payment. thais would be generally it. -- Martin Lillepuu | E-mail: ma...@li... | GSM: 051 56 450 |
From: Dieter S. <dsi...@sq...> - 2001-03-10 18:17:49
|
There is nothing at the moment to produce customer statements. The AR transaction report lists outstanding invoices for a customer for a time period. Receipts can also be limited to one customer for a time period. 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, 9 Mar 2001, Roderick A. Anderson wrote: > Did I miss them? I can't find out how to run a customer statement - out > standing invoices and receipts for a period. > > If it's not there yet I'd be willing to take on the coding. > > > Rod > |
From: Roderick A. A. <raa...@ti...> - 2001-03-14 13:17:46
|
On Sat, 10 Mar 2001, Dieter Simader wrote: > There is nothing at the moment to produce customer statements. > > The AR transaction report lists outstanding invoices for a customer for > a time period. I might be missong something here but I can't find an 'AR Transaction Report' persay. A search in the A/R menu area allows me to select a customer. Is this what you're referring to? I do have version 1.2.10 but might have left a step off when setting it up. Rod -- |
From: Roderick A. A. <raa...@ti...> - 2001-03-15 16:03:00
|
On Sat, 10 Mar 2001, Dieter Simader wrote: > There is nothing at the moment to produce customer statements. Having heard no arguments against creating a customer statement I'll launch myself into it. Not being an account-type I'll have to start with my experiences with Peachtree (which is the package used where I used to work). Their statement basically has the regular header stuff, like the invoice, and then an itemized list of invoices and receipts with each invoice line containing the invoice number, invoice date, invoice amount, and running balance. The receipt lines (if I remember correctly) contain the receipt id, receipt date, receipt amount, and a running balance. I couldn't find an option to enter a receipt id (we used the check number or some other identifier) using SQL-Ledger so I'd suggest this as an enhancement - and possibly a note - to the receipts screen. I think adding the note, from the invoice (and later the receipt), before the invoice/receipt amount would be nice or helpful. This depends on what people are using it for. This could be changed in the template. Please let me know if this would meet the needs of others that expressed an interest in a customer statement report. Rod -- |