[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]
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. 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. 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. If you want examples of Db schema or web pages just say. On Sun, 2007-01-28 at 11:09 +0000, Neil Williams wrote: > On Sun, 28 Jan 2007 10:47:50 +0000 > Kevin Lucas <kevin.lucas@xxxxxxxxxxxxxxxxxx> wrote: > > > I hope all goes well with the convert. I run the Village Shop & PO in > > Minions Cornwall. We use Fedora for all except one application which is > > the Samms ER308 Till, This has some MS only SW to access the data on the > > Till which produces reports which I am unable to import in to MySql > > database. So I have Win98 to do this! Every thing else is run from > > within a browser and MySql. I do the Vat, Wages, Ordering, Fax, Accounts > > and Cashing up all on Linux. > > Do you use custom spreadsheets for VAT, payroll and ordering or are > there dedicated applications that you can use? What software do you use > for the accounts? If you use spreadsheets, which application and what > formats do you use for import/export etc.? > > I'm always interested in these small business solutions in order that > my own programming can take into account existing methods and provide > some form of coordination, automation, import/export or filters. > > See http://www.data-freedom.org/ > > -- > > > Neil Williams > ============= > http://www.data-freedom.org/ > http://www.nosoftwarepatents.com/ > http://www.linux.codehelp.co.uk/ > -- 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