[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]
On Sun, 28 Jan 2007 11:47:17 +0000 Kevin Lucas <kevin.lucas@xxxxxxxxxxxxxxxxxx> wrote: > I just set up a Web form for each job Say "invoices" then input the data > to MySql, then write reports to be viewed in a browser, as most things > are repetitive. My coding gets refined as time goes on but the basic > frame work stays the same. It could be useful if the files were managed by CVS or subversion. The history of a change is sometimes more useful than the fix itself. > If you catch all the data required for the > Vat accounts on a form you can do pretty much anything if your sql > reporting is good enough. I shadowed My VAT accountant for two years > just to be sure and was surprised at how he implemented some schemes and > just how much data was "averaged" just to fit in the Vat Ball Park, not > necessarily to my advantage. I have had a vat audit and was confident > that all the "evidence" was there and in order to support my Vat > returns. I do some manipulation using OOCalc for the vat as I need to > Split some C&Carry invoices down to Category's to get the retail markup > for each product. That can probably be scripted in something like Perl. Making the code public at this early stage can encourage new developers - release early, release often. > I have to account for Zero, Std, Low, and Exempt Vat. > I haven't got yet round to getting a web host with a MySql option but my > intention was to provide this service to Small business's on the Web. You may not have to deploy a working website of your own, if you package the scripts and use CVS or subversion via a public repository (like SourceForge), people can use the code directly. What language do you use for the scripts? Bash? Perl? Python? > If you want examples of Db schema or web pages just say. > Yes, please. Please ensure that when you send them in, you select a free software licence that covers all the files. Scripts should include a licence declaration at the top of each file, webpages and text/sql files can be covered using a file called COPYING which usually just includes a verbatim copy of the licence. You can find the GPL at /usr/share/automake-1.10/COPYING (adjust to whichever version of automake you have installed). I can then assign copyright to you and use them (modified as necessary) in my own packages so that everyone can benefit. You can see how to assign a licence to a script using a comment here: http://buildd.emdebian.org/repos/tools/em_make/em_make You'll need the section from "Copyright ..." to "You should have received ..." inclusive - adjusted to your copyright details. Also ensure there are no passwords embedded in the files. ;-) -- Neil Williams ============= http://www.data-freedom.org/ http://www.nosoftwarepatents.com/ http://www.linux.codehelp.co.uk/
Attachment:
pgpzpBnLO2GVp.pgp
Description: PGP signature
-- The Mailing List for the Devon & Cornwall LUG http://mailman.dclug.org.uk/listinfo/list FAQ: http://www.dcglug.org.uk/linux_adm/list-faq.html