From: Jess <je...@oz...> - 2001-06-09 15:01:19
|
Hi Dieter, Just to make this clear straight of the bat prior to version 1.4 of SQL-Ledger I had no problems running SQL-Ledger in the 1.2.* variety. I clean installed SQL ledger. Now I cleaned out all the SQL tables and downloaded SQL-Ledger 1.4.4 from your Web Site unpacked it and recreated the tables from the acc-PG.sql file. I removed any traces of the previous SQL-LEDGER 1.2.* which was working. I then move the SQL-Ledger directory with the login.pl and sql-ledger.conf file and all subdirectories to the web document root called /www/websites/bookmen/sqll I also created any directories that where called in the sql-ledger.conf file so that it could find anything it was looking for. I read the FAQ and the README and it said to: SETUP A USER: ------------- Load your web browser and enter the URL http://localhost/cgi-bin/sql-ledger/admin.pl and add a user. If you specify a different database then the one you just created in the previous step, make sure the database and tables exist. (see previous step) LOAD THE ACCOUNTING PROGRAM: ---------------------------- Load your web browser and enter the URL http://localhost/cgi-bin/sql-ledger/login.pl Now there is no http://localhost/cgi-bin/sql-ledger/admin.pl in that directory there is only login.pl and am.pl If I open the admin.pl in the "bin/mozilla" directory the is no shebang line or "require" command for the .conf file on any of these files which leads me to believe that these files are read into a calling .pl file probably login.pl. How do you add or create a user? What .pl file in what directory needs to be run and what needs to be entered in the Browser URL to call it? There is something fundamental I am not aware of that must be causing these problems? Your assistence is needed. SQL Ledger is being run on W2K Pro with PG 703 and perl5, apache 1.3.14. Regards Jess ----- Original Message ----- From: "Dieter Simader" <dsi...@sq...> To: <sql...@li...> Sent: Tuesday, 05 June, 2001 5:22 AM Subject: Re: NEED taxes on taxes here > Tax on tax can be managed by adding the tax to the tax. > > i.e first tax @ 7% second tax @ 8% > 8% would effectively be 8.56% > > If taxes are tax on tax as well as tax included you'll have to adjust the > tax rates accordingly. > > Tax included applies to all taxes and not just one or the other. > > > 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 Sat, 2 Jun 2001, Andre Felipe Machado wrote: > > > Hello, Dieter: > > I just had send out messages to many brazilian linux lists asking for > > accountant help and found your message below. > > > > Here, in Brazil, we have a real tax hell. > > We have TAXES ON TAXES at different points of price setup process, > > feeding multiple taxes accounts to balance at month end. > > > > I am not an accountant, so I can not explain right this complex subject. > > But in order to other people help to customize tables, sql-ledger will > > have to allow multiple taxes on taxes, included and on top, at different > > points of price. > > > > Two significant taxes here: IPI is "on top", aaaaaaannnnnd ICMS "is > > included". > > And they are only two of many, many other taxes, some included, other on > > top of others! > > Cascading taxes!!! > > And these taxes depends on WHAT product or service is to be invoiced. > > > > Please, are there other brazilian people in this list? > > Any accountant to help? > > Many thanks. > > Andre Felipe Machado > > > > > > > > >>>>>>>>>>>>>>>>>> Mensagem anterior <<<<<<<<<<<<<<<<<< > > > > No dia 28/05/01, 13:58:06, Dieter Simader <dsi...@sq...> > > escreveu o seguinte sobre o tema About Taxes: > > > > > > > Taxes are calculated differently if included in price or shown on top. > > > i.e. $100 item, taxable at 7% > > > tax included -> net price is 93.46, tax portion is 6.54 > > > tax on top -> net price is 100.00, tax is 7.00 > > > > > multiple taxes are always additive and not calculated tax on tax. > > > So, the same $100 item at 7% and 8% > > > tax included -> net price is 86.96, tax is 13.04 > > > tax on top -> net price is 100.00, tax is 15.00 > > > > > > > > > > > |