Menu
▾
▴
sql-ledger-users
|
From: David J <ja...@in...> - 2007-03-04 04:24:11
|
Joe Your suggestion has my vote too. It has been my intention to write some simple code for this report, but just never seem to get around to it. David J "How to produce a traditional "General Ledger" transaction listing ? The kind of report that accountants and auditors have used for generations. Most GL systems permit the selection of transactions for this report by account range, and/or date range. The report then lists all filtered GL transactions (with ALL details), sorted by account number (separated by a line break, account code and description each time the account code changes). Transactions sorted into date order within each account. And the better systems also give a checkbox for separate page for each account." > A proper General ledger that is grouped by account and > then date by default. > > Joe > > > www.joemaffia.com > > |
|
From: David J <ja...@in...> - 2007-03-04 05:32:27
|
Poll or Wish list IMHO, SQL-L would be greatly enhanced by having the company name print on each and every report. Thoroughly, consistently, and system wide. We run SQL-L for multiple clients. Until we tweaked the reports (mostly in rp.pl), we had no way of knowing which printed report belonged to which company. Yes, it did cause confusion. Seems such a simple thing, and odd that no-one has mentioned this before. David J |
|
From: Dr E. L. <el...@li...> - 2007-03-04 20:01:12
|
This is a very good idea, can you submit a patch? I change the background color of the menus for this. el on 3/4/07 7:32 AM David J said the following: > Poll or Wish list > > IMHO, SQL-L would be greatly enhanced by having the company > name print on each and every report. Thoroughly, > consistently, and system wide. > > We run SQL-L for multiple clients. Until we tweaked the > reports (mostly in rp.pl), we had no way of knowing which > printed report belonged to which company. Yes, it did cause > confusion. > > Seems such a simple thing, and odd that no-one has mentioned > this before. > > David J > > ------------------------------------------------------------------------- > 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 -- Dr. Eberhard W. Lisse \ / Obstetrician & Gynaecologist (Saar) el...@li... el108-ARIN / * | Telephone: +264 81 124 6733 (cell) PO Box 8421 \ / Please do NOT email to this address Bachbrecht, Namibia ;____/ if it is DNS related in ANY way |
|
From: Rich S. <rsh...@ap...> - 2007-03-04 18:21:16
|
Poll or Wish list A menu item within SL that allows prior year data to be saved to a separate file and deleted from the current year. After a year-end close of books this would permit the old data to be stored but not be part of the current data set. It's a low priority since reports can always be limited by date. 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 |
|
From: Michael H. <mh...@it...> - 2007-03-08 16:37:21
|
#1 A "clean" way of handling overpayments and prepayments: - uninvoiced funds are associated with the customer - these amounts appear at the bottom of any new invoice as a payment (s) with the original date/memo etc - like a regular payment item though these can be edited in case the customer prefers a different application of funds - the current available balance shows up everywhere the current available credit does - the current remaining balance is shown on the invoice - prepayment amounts can be made taxable (or not) on a systemwide basis to handle countries where taxes are levied on receipt of funds - summary reporting of taxes is fixed(!) so that these amounts, and any adjustments due to nontaxable items being purchased, are rolled up properly #2 Fix the summary reporting of taxes!!!!!!!!!!!!!!!! This cost us quite a few man-hours and several hundred dollars in fines recently. :( |
|
From: Dr E. L. <el...@li...> - 2007-03-09 04:39:58
|
on 3/8/07 6:37 PM Michael Hasse said the following: > #1 > A "clean" way of handling overpayments and prepayments: I'd also like to have an easier way to do this. > #2 > Fix the summary reporting of taxes!!!!!!!!!!!!!!!! Yours truly, the pompous ass and idiot, has a little perl script that, collects all AR and AP transactions and generates a list of them in a LaTeX box, deducts one subtotal from the other into another box. And fills in the Namibian VAT form. Anyone wanting to to have a look at really horrid programming style, can email me. > This cost us quite a few man-hours and several hundred dollars in > fines recently. :( You just made my week! el |
|
From: Jeff R. <je...@jr...> - 2007-03-09 17:33:33
|
Hi All I'd like to be able to assign more than one group of items to a customer. My items are classified by areas of repair (telephone, cash register, computer) I have many customers that repair more than one category and it would be nice if the pricelist for them could include both categories (without having to print two separate sets out). It's not a big deal, I'll look into it myself when I get some time if it doesn't appear in an upcoming revision. Jeff Roberts |
|
From: David J <ja...@in...> - 2007-03-05 08:00:43
|
You can start by including the following at about line 95 of
rp.pl
$form->{title} = $myconfig{company}.' :
'.$locale->text($report{$form->{report}}->{title});
(above should be all on one line, but in this webmail its
not.)
Build on it from there.
- DJ
> This is a very good idea, can you submit a patch?
>
>
> el
>
> on 3/4/07 7:32 AM David J said the following:
> > Poll or Wish list
> >
> > IMHO, SQL-L would be greatly enhanced by having the
> > company name print on each and every report. Thoroughly
> > , consistently, and system wide.
> >
> > We run SQL-L for multiple clients. Until we tweaked the
> > reports (mostly in rp.pl), we had no way of knowing
> > which printed report belonged to which company. Yes, it
> > did cause confusion.
> >
> > Seems such a simple thing, and odd that no-one has
> > mentioned this before.
> >
> > David J
> >
> >
|
|
From: Ronald K. <rj...@ya...> - 2007-03-09 05:04:57
|
A management menu that will generate reports and help you to:=0A=0ASet ROP = based on sales=0ACreate parent child relationships for categories=0AUpdate = vendor cost as percent of list price=0ACreate PO based on sales=0ABest Sell= ers....Dollars / Margin=0A=0Aand..=0A=0Aallocate freight on Vendor invoice= =0A=0A=0A----- Original Message ----=0AFrom: C. Duncan Hudson <Duncan@Dunc-= IT.com>=0ATo: sql...@li...=0ASent: Friday, March = 2, 2007 9:49:47 AM=0ASubject: [SL] Poll - What do you want to see?=0A=0A=0A= After my last post I got to thinking... It seems (to me) that the same =0A= items come up over and over on the list. There is continued development = =0Aof the application (and that's wonderful), but is it providing what =0Ap= eople are really looking for, wanting, needing? What are the two =0Abigges= t things everyone wants fixed or added to SQL-Ledger?=0A=0AMy two biggest w= ants, needs are: Sales tax flexibility - I need to be =0Aable to make a ta= xed customer tax free (on occasion) and vice versa. My =0Anext wish would = just make my life easier - I wish you could search (on =0APOs, Sales Orders= and Invoices) by Shipto.=0A=0AAnybody else?=0A=0A=0ADunc=0A=0A=0A=0A------= -------------------------------------------------------------------=0ATake = Surveys. Earn Cash. Influence the Future of IT=0AJoin SourceForge.net's Tec= hsay panel and you'll get the chance to share your=0Aopinions on IT & busin= ess topics through brief surveys-and earn cash=0Ahttp://www.techsay.com/def= ault.php?page=3Djoin.php&p=3Dsourceforge&CID=3DDEVDEV=0A___________________= ____________________________=0Asql-ledger-users mailing list=0Asql-ledger-u= se...@li...=0Ahttps://lists.sourceforge.net/lists/listinfo/s= ql-ledger-users=0A=0A=0A =0A_______________________________________________= _____________________________________=0ASucker-punch spam with award-winnin= g protection. =0ATry the free Yahoo! Mail Beta.=0Ahttp://advision.webevents= .yahoo.com/mailbeta/features_spam.html |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X