You can subscribe to this list here.
| 2000 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(23) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2001 |
Jan
(68) |
Feb
(121) |
Mar
(59) |
Apr
(49) |
May
(110) |
Jun
(109) |
Jul
(146) |
Aug
(122) |
Sep
(83) |
Oct
(94) |
Nov
(90) |
Dec
(157) |
| 2002 |
Jan
(169) |
Feb
(186) |
Mar
(168) |
Apr
(353) |
May
(338) |
Jun
(278) |
Jul
(220) |
Aug
(336) |
Sep
(122) |
Oct
(183) |
Nov
(111) |
Dec
(265) |
| 2003 |
Jan
(358) |
Feb
(135) |
Mar
(343) |
Apr
(419) |
May
(277) |
Jun
(145) |
Jul
|
Aug
(134) |
Sep
(118) |
Oct
(97) |
Nov
(240) |
Dec
(293) |
| 2004 |
Jan
(412) |
Feb
(217) |
Mar
(202) |
Apr
(237) |
May
(333) |
Jun
(201) |
Jul
(303) |
Aug
(218) |
Sep
(285) |
Oct
(249) |
Nov
(248) |
Dec
(229) |
| 2005 |
Jan
(314) |
Feb
(175) |
Mar
(386) |
Apr
(223) |
May
(281) |
Jun
(230) |
Jul
(200) |
Aug
(197) |
Sep
(110) |
Oct
(243) |
Nov
(279) |
Dec
(324) |
| 2006 |
Jan
(335) |
Feb
(396) |
Mar
(383) |
Apr
(358) |
May
(375) |
Jun
(190) |
Jul
(212) |
Aug
(320) |
Sep
(358) |
Oct
(112) |
Nov
(213) |
Dec
(95) |
| 2007 |
Jan
(136) |
Feb
(104) |
Mar
(156) |
Apr
(115) |
May
(78) |
Jun
(75) |
Jul
(30) |
Aug
(35) |
Sep
(50) |
Oct
(44) |
Nov
(33) |
Dec
(35) |
| 2008 |
Jan
(90) |
Feb
(63) |
Mar
(47) |
Apr
(42) |
May
(72) |
Jun
(85) |
Jul
(25) |
Aug
(20) |
Sep
(14) |
Oct
(11) |
Nov
(25) |
Dec
(39) |
| 2009 |
Jan
(39) |
Feb
(46) |
Mar
(16) |
Apr
(27) |
May
(51) |
Jun
(66) |
Jul
(78) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2010 |
Jan
|
Feb
|
Mar
(5) |
Apr
|
May
(4) |
Jun
|
Jul
(1) |
Aug
|
Sep
(1) |
Oct
(2) |
Nov
|
Dec
|
| 2011 |
Jan
|
Feb
(2) |
Mar
|
Apr
(3) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2013 |
Jan
|
Feb
|
Mar
|
Apr
(1) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2014 |
Jan
|
Feb
|
Mar
|
Apr
(1) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2015 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(1) |
| 2016 |
Jan
(1) |
Feb
|
Mar
|
Apr
(1) |
May
(1) |
Jun
(1) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Kenneth G. <la...@th...> - 2002-02-26 02:11:30
|
usually this comes when for some reason the database cannot be opened. i could be wrong kg On Tuesday 26 February 2002 01:03, alta wrote: > I get the following error posted to the server log when I attempt to > add a service: > > [error] [client 127.0.0.1] Premature end of script headers: > /usr/local/sql-ledger/ic.pl > > Has anyone else seen this problem? > > The details... > > I am attempting to add a service called "Writing": > > Number: Writing > Description: Writing > Unit of measure: hr > List Price: 0 > Sell Price: 0 > Income: 4310--Writing > Expense--Purchases > 2310--GST: not checked > 2311--PST: not checked > > My setup for "4310--Writing": > > Account Number: 4310 > Description: Writing > Account Type: Income, Account > Is this a summary account to record: no, no, no > Include in drop-down lists: > Receivables: Income > Service Items: Income > Include this account...as taxable? no > > > Your help appreciated ... Reed |
|
From: Dieter S. <dsi...@sq...> - 2002-02-25 23:17:02
|
The id is unique. Table links are in the form of {table}_id, meaning if
you link table xyz to table customer one of the fields in table xyz is
called customer_id. This way you can almost always tell which tables are
linked by just looking at the schema.
If there are changes to the tables or new tables are being added, the
changes are in the upgrade scripts.
To avoid nameing conflicts reference your table with a variable. This
way you can rename the table in question and make one small change to
the backend.
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 Mon, 25 Feb 2002 mtr...@du... wrote:
> d for SQL-Ledger (and point to implementation talk on another list)
> From: MR
> To: <sql...@li...>
> X-Mailer: Sendmail by hand
>
> I want to add some additional account info, like bill rate, and how the data
> flow the the client is handled.
> The API section of the web site is a bit light, but is there any convention
> declared yet for table names that won't get stepped on in upgrades?
> Even though id or name are not set to unique, I'm going to go with the
> idea that they ARE unique, and use the ID to tie into the second table.
> (unless I missed something.)
>
> The accounting talk over on gn...@gn... is bringing up 'standards documents'
> for the design/implementation of accounting systems. Links to documents
> are all over the thread, so if you are NOT on the gnue list, and find
> accounting standards exciting, then go polk around on www.gnue.org
> and get the last 2 weeks of mail list archives.
>
> A couple of links from the thread:
> http://www.xbrl.org/gl/gl.htm
> >http://lists.ebtwg.org/archives/ebtwg-ccs/200111/msg00084.html
> >http://lists.ebtwg.org/archives/ebtwg-ccs/200111/msg00092.html
> >http://www.diffuse.org/0201-ec.html
>
|
|
From: alta <al...@al...> - 2002-02-25 19:25:19
|
I get the following error posted to the server log when I attempt to add a service: [error] [client 127.0.0.1] Premature end of script headers: /usr/local/sql-ledger/ic.pl Has anyone else seen this problem? The details... I am attempting to add a service called "Writing": Number: Writing Description: Writing Unit of measure: hr List Price: 0 Sell Price: 0 Income: 4310--Writing Expense--Purchases 2310--GST: not checked 2311--PST: not checked My setup for "4310--Writing": Account Number: 4310 Description: Writing Account Type: Income, Account Is this a summary account to record: no, no, no Include in drop-down lists: Receivables: Income Service Items: Income Include this account...as taxable? no Your help appreciated ... Reed -- Reed White - ALTA RESEARCH - www.alta-research.com Phone: 877-360-2582 - Email: al...@al... |
|
From: <mtr...@du...> - 2002-02-25 07:36:54
|
d for SQL-Ledger (and point to implementation talk on another list) From: MR To: <sql...@li...> X-Mailer: Sendmail by hand I want to add some additional account info, like bill rate, and how the data flow the the client is handled. The API section of the web site is a bit light, but is there any convention declared yet for table names that won't get stepped on in upgrades? Even though id or name are not set to unique, I'm going to go with the idea that they ARE unique, and use the ID to tie into the second table. (unless I missed something.) The accounting talk over on gn...@gn... is bringing up 'standards documents' for the design/implementation of accounting systems. Links to documents are all over the thread, so if you are NOT on the gnue list, and find accounting standards exciting, then go polk around on www.gnue.org and get the last 2 weeks of mail list archives. A couple of links from the thread: http://www.xbrl.org/gl/gl.htm >http://lists.ebtwg.org/archives/ebtwg-ccs/200111/msg00084.html >http://lists.ebtwg.org/archives/ebtwg-ccs/200111/msg00092.html >http://www.diffuse.org/0201-ec.html |
|
From: Guido B. <gd...@le...> - 2002-02-23 16:43:52
|
To resolv the problem on tax rounded I have change files bin/mozilla/io.pl SL/IR.pm SL/IS.pm SL/OE.pm in SQL-LEDGER Release 1.8.1 The patches are writed to the attach file. In this manner the TAX item have 6 decimals and the total is correct. best regards Guido Brugnara -- ing. Guido Brugnara tel.+39(461)390804 fax.396028 Leader.IT S.r.l. (Leader Information Technology) Strada della Pozzata, 41 www.leader.it/srl 38050 Villazzano TRENTO (ITALY) in...@le... |
|
From: Luke M. <luk...@ya...> - 2002-02-22 22:49:19
|
lee johnson wrote: >hi.. > > using opera6 ( which allows background printing) I get this error when >entering: http://localhost:8000/login.pl ( thx anyone for assistance) >-------------- > > Unknown terminal; > >lee >-==== > > > > > > >[ Note: When replying, please Reply to the list address. This way other members know if the issues have been resolved or not. Thanks! Your List administrator. ] > For a quick fix, go to your Opera network preferences and change "Browser Identification" to identify Opera as Mozilla or MSIE. -- Luke Kale Myers |
|
From: <ga...@es...> - 2002-02-22 22:39:11
|
I had this problem until I told opera to identify itself as another browser, IE I think. -Gary At 01:03 PM 2/22/02 -0800, lee johnson wrote: >hi.. > > using opera6 ( which allows background printing) I get this error when >entering: http://localhost:8000/login.pl ( thx anyone for assistance) >-------------- > > Unknown terminal; > >lee >-==== > > > > > > >[ Note: When replying, please Reply to the list address. This way other members know if the issues have been resolved or not. Thanks! Your List administrator. ] > > |
|
From: lee j. <le...@im...> - 2002-02-22 21:30:07
|
hi.. forgot to mention that yes I have dnhttpd.pl running and netscape can access this no trouble... thx again lee |
|
From: lee j. <le...@im...> - 2002-02-22 21:28:36
|
hi.. using opera6 ( which allows background printing) I get this error when entering: http://localhost:8000/login.pl ( thx anyone for assistance) -------------- Unknown terminal; lee -==== |
|
From: Dr D. <drd...@ho...> - 2002-02-22 08:57:41
|
The million dollar question is: where and when is the rounding done?
Does SQLedger really round at two decimals every line and is tax that
heavy in Italy that this would be a real life problem?! Would not the
rounding on other examples be on the other side so that on a totals/year
basis the difference would be near to I guess maximum one euro? If the
company cannot afford that, I suggest to close it down fast..
Follow-up question: If I would request 3 separate bills, would it be
allright then? If so, print an invoice per item would be a slution
(Although it's waisting perfectly good paper that is probably more
expensive)
PS: Italian Fiscal Authoraties must be no joking matter. In Holland we
are entitled to round amounts in all the official tax forms at whole
euros IN OUR FAVOUR. Then again, rounding of eurocents is more
substantial than rounding on lires used to be ;-)
Cheers,
Paul
-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of Guido
Brugnara
Sent: vrijdag 22 februari 2002 9:33
To: sql...@li...
Subject: TAX calculation is wrong for italian fiscal law
In Italy the TAX calculation is made on total of the same TAX, list of
articles. In SQL-LEGDER the TAX calculation is made on single detail
row.
Value TAX 20%
56,85 11,37
56,82 11,36
56,82 11,36
------------------
170,49 34,09
If you calculate the 20% of 170,49 the result is different for 1/100 Eur
170,49*0,2 = 34,10
=====================================================
This different value is wrong for italian fiscal law.
=====================================================
Is this a problem in another Country ?
I like to correct the problem but if the method of calculation is
different for every Country is necessary to define this with parameter
in the config file. Please talk me coordination to correct development
or your refusal, please.
best regards
Guido Brugnara
[ Note: When replying, please Reply to the list address. This way other
members know if the issues have been resolved or not. Thanks! Your List
administrator. ]
|
|
From: Guido B. <gd...@le...> - 2002-02-22 08:32:54
|
In Italy the TAX calculation is made on total of the same TAX, list of
articles.
In SQL-LEGDER the TAX calculation is made on single detail row.
Value TAX 20%
56,85 11,37
56,82 11,36
56,82 11,36
------------------
170,49 34,09
If you calculate the 20% of 170,49 the result is different for 1/100 Eur
170,49*0,2 = 34,10
=====================================================
This different value is wrong for italian fiscal law.
=====================================================
Is this a problem in another Country ?
I like to correct the problem but if the method of calculation is
different for every Country is necessary to define this with parameter in
the config file.
Please talk me coordination to correct development or your refusal,
please.
best regards
Guido Brugnara
|
|
From: Guido B. <gd...@le...> - 2002-02-22 08:31:47
|
SQL-LEDGER rel. 1.8.1 & 1.8.2 I have already insert "Account Receivables" with AR-->Add Transaction The TAX is correct in database! When I view the Account with AR-->Reports-->Transaction-->Continue--><I select the AR>-->"Account Receivable" The TAX input and TAX Select list are empty !! If I push [Update Form] the TAX input and TAX Select List contains corrected values. The problem don't depend on language or number format. The equivalent on AP is OK. best regards Guido Brugnara |
|
From: Sergio A. K. <ser...@ho...> - 2002-02-21 18:54:14
|
http://www.westciv.com.au/style_master/academy/css_tutorial/index.html is a good site for css learning... (I'm sure is not the only one tough) /sergio |
|
From: Sergio A. K. <ser...@ho...> - 2002-02-21 14:44:03
|
here is a css a little more complete... (but not complete in any way) now, sql-ledger should include the stylesheet on every page... /sergio ----- Original Message ----- From: "Dieter Simader" <dsi...@sq...> > Well, I guess we found a volunteer to write a new stylesheet. Thanks, > Sergio! You just let me know which markup tags should be added / changed > and I'll adjust the code. > > > 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 Tue, 19 Feb 2002, Sergio A. Kessler wrote: > > > actually, you can use the print button of your browser, > > but you don't want the form's buttons to print right ? > > > > the easy solution for this is to use css to define a > > non printable class, like this: > > > > @media print { > > .noprint { /* items with this class won't print */ > > display: none; > > } > > } > > > > then you modify the source to include > > <div class=noprint> > > ..... <form's buttons> ..... > > </div> > > > > hey, you even can define things that don't > > display on screen but print > > > > @media screen { > > .noscreen { /* items with this class won't display */ > > display: none; > > } > > } > > > > it would be good for sql-ledger to use more css... > > > > /sergio > > > > ----- Original Message ----- > > From: "Jeff Strope" <js...@en...> > > > > > > > I'm pretty sure this has been covered in the past, but I just want to make > > > sure. > > > > > > The "Print Invoice" & "Print Order" (etc) form buttons do not actually > > send > > > documents to printers installed on the server, correct? > > > > > > NOTICE: When replying, please Reply to the list address. This way other members know if the issues have been resolved or not. Thanks! Your List administrator. > > > > > > > NOTICE: When replying, please Reply to the list address. This way other members know if the issues have been resolved or not. Thanks! Your List administrator. > > |
|
From: Jim S. <JSt...@al...> - 2002-02-20 17:35:10
|
When creating AP transactions, I do not see any means to spread an invoice item to multiple accounts. For instance, if I have an Expense report for an employee I would enter that item as an AP transaction. A portion of this should be allocated to travel expenses, lodging, and meals. If I have a separate general ledger for each can I perform my AP transaction with only one transaction or do I need to create three transactions for my one expense report? What is the best way to handle transaction of this nature to prevent excess data entry? Jim |
|
From: Rob R. <ri...@me...> - 2002-02-20 17:27:48
|
On 20 Feb 2002, Jonny Birkelund wrote: > | > = AR_amount > | AR = accounts receivable > | amount = amount charged to "Accounts Receivable" general ledger account > Is this documented somewhere. There is quite a few others here, and > not very easy to understand (at least for me) As I recall your question, I'm not sure where you are getting these codes from. If from an accounting system, there should be some way to inspect/maintain/print the "chart of accounts" this should link these codes (or these variables values) to descriptive names, an ordering key, whether the account is a balance sheet account or not, whether it is a debit or credit account, and whether it is a controlling account. Learning bookkeeping from the source or behavior of a computer accounting program is futile. It appears that you need to come up to speed on accounting or need an "expert" at your elbow. To clarify some of the terms I've used. o- Chart of accounts is the list of all the general ledger accounts. There are conventions on the ordering of accounts, first liquid assets working to fixed assets. Then immediate liabilities phasing to long-term liabilities. Etc. You only need to set up the accounts you will use, but you need to have a plan for the accounts you will add later. The chart is the first thing you need. o- Accounting is just telling the tale of the money. o- A control account or controlling account is comprised of other accounts. The "Accounts Receivable" is the usually the total of all the customers' balances. o- A balance sheet tells what the entity owns and owes as of a certain date. The accounts in the chart are listed with their balances, and various sub-categories are totaled. Balance sheet accounts are the accounts which show these items. If you figure what you are worth you are building some kind of balance sheet. o- An expense sheet tells what the entity spent and recieved in a period of time. Expense and income accounts accumulate these amounts, when the books are "closed" these accounts are set to zero and the offsetting entry adjusts a balance sheet account. If you figure where all your money came from and went to in the last year you are making a expense report. o- Debit means left. Credit means right. For every credit entered, there needs to be an equivalent debit entered somewhere. o- It is convenient (w/ computers) to think of accounts as debit or credit accounts then a credit is added to a credit account, a debit is added to a debit account, otherwise the entry is subtracted from the account. Assets and expenses are debit accounts. Liabilities, revenues, and capital are credit accounts. Your bank may confuse you because they are the other party holding your money so things are reversed. o- A ledger contains a list of balances. o- A journal contains a list of transactions. o- The General Ledger is the ledger giving the top level summary of the state of the business. o- The General Journal is the miscellaneous journal. Everyday transactions don't belong here. In a small business the occasional bounced check would be recorded in the general journal. rob Live the dream. |
|
From: Kenneth G. <la...@th...> - 2002-02-20 14:48:52
|
listadmin - please either shift the list or dump the footer kg > NOTICE: When replying, please Reply to the list address. This way other > members know if the issues have been resolved or not. Thanks! Your List > administrator. |
|
From: Jim S. <JSt...@al...> - 2002-02-20 13:56:50
|
I am setting up the chart of accounts and would like to change an existing header. What is the best way to do this? Thank you, Jim |
|
From: Jonny B. <jo...@op...> - 2002-02-20 09:24:47
|
Rob Ransbottom <ri...@me...> writes: | On 18 Feb 2002, Jonny Birkelund wrote: | > = AR_amount | AR = accounts receivable | amount = amount charged to "Accounts Receivable" general ledger account Is this documented somewhere. There is quite a few others here, and not very easy to understand (at least for me) -- /Jonny Opera Software phone:+47-24164370 fax:+47-24164002 |
|
From: Nique N. <ne...@ta...> - 2002-02-20 08:10:59
|
---------- Forwarded Message ---------- Subject: Unable to delete database Date: Tue, 19 Feb 2002 16:19:58 -0500 From: Kirk VanNatter <kv...@ga...> To: sql...@li... New to using Sql-Ledger and look like it will suit my needs well. However, I am unable to delete databases or even a point where I can view database that could be removed. After login to admin module, I get to the page to create or delete datasets I am able to create datasets , however when I select DELETE DATASET I get the following error. FATAL 1: Database "template0" is not currently accepting connections the user is 'postgres' and Connect to is 'template1' at the administration page. Thanks for any help Kirk NOTICE: When replying, please Reply to the list address. This way other members know if the issues have been resolved or not. Thanks! Your List administrator. ------------------------------------------------------- Kirk, I suggest you bring up terminal and use the interactive postgres terminal to delete the database. Go to the postgres home page for instructions on this. It is a little to complex to give instructions via mail for this one.. Regards, Nicholas Tomlin |
|
From: Oscar B. <os...@el...> - 2002-02-20 07:45:17
|
Correct. Just use your browser button to print. Oscar Jeff Strope wrote: > I'm pretty sure this has been covered in the past, but I just want to make > sure. > > The "Print Invoice" & "Print Order" (etc) form buttons do not actually send > documents to printers installed on the server, correct? > > Thanks, > > Jeff Strope > > > > NOTICE: When replying, please Reply to the list address. This way other members know if the issues have been resolved or not. Thanks! Your List administrator. > > -- _____________________________________________________________ Oscar Buijten Tel: +33.4.67.57.97.45 Fax: +33.4.67.57.97.46 GSM: +33.6.20.84.15.22 Email: os...@el... Web: www.elbie.com |
|
From: Firman S. <fi...@in...> - 2002-02-20 03:56:03
|
Is there any way I can integrate sql-ledger with any POS module? NOTICE: When replying, please Reply to the list address. This way other members know if the issues have been resolved or not. Thanks! Your List administrator. |
|
From: Dieter S. <dsi...@sq...> - 2002-02-20 01:37:14
|
You have to upgrade to postgres 7+ subselects are not supported in pre 7 versions. 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 Wed, 20 Feb 2002, Craig Nunemaker wrote: > I checked psql and neither worked. After doing some reading on postgresql, I noticed > single quotes. The following worked in psql: > > SET DATESTYLE to 'ISO' > > I edited my user.conf in the dboptions line to use single quotes. It worked. > > However, now my AR and AP module give me the following parser error when trying to > Add a Transaction. > > SELECTcurrent_date AS transdate, current_date + 30 AS duedate, d.curr AS currencies, > (SELECT c.accno FROM chart c WHERE d.fxgain_accno_id = c.id) AS fxgain_accno, > (SELECT c.accno FROM chart c WHERE d.fxloss_accno_id = c.id) AS fxloss_accno > FROM defaults d > Parser error at or near "select" > > I ran it piecemeal through psql and ran into problems at the subquery. > > BTW, I am using a Debian Woody default installation with Perl DBI. > > > 2/19/02 1:27:33 PM, Dieter Simader <dsi...@sq...> wrote: > > >Hi Craig! > > > >load psql and type in > > > >SET DATESTYLE to ISO > >SET DATESTYLE to "ISO" > > > >let me know which one works. > > > > > >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 Mon, 18 Feb 2002, Craig Nunemaker wrote: > > > >> Has anyone ever gotten a DateStyle parse error? > >> > >> After logging in and clicking on any module action the screen displays the follwing > error: > >> Error: Set DateStyle to "ISO" > >> Parse error at or near ISO > >> > >> I checked my Apache error log and found the following entry. > >> DBD::Pg:db do failed: ERROR: parse error at or near "iso" at SL/Form.pm line > >> 431 > >> Error: set DateStyle to ISO<br>ERROR: parser: parse error at otr near "iso" > >> Database handle destroyed without explicit disconnect. > >> > >> I examined SL/Form.pm but could not figure out how the code itself would raise an > error. > >> > >> > >> > >> > >> > >> > >> NOTICE: When replying, please Reply to the list address. This way other members > know if the issues have been resolved or not. Thanks! Your List administrator. > >> > >> > > > > > > > > |
|
From: Craig N. <scr...@ea...> - 2002-02-20 01:18:28
|
I checked psql and neither worked. After doing some reading on postgresql, I noticed single quotes. The following worked in psql: SET DATESTYLE to 'ISO' I edited my user.conf in the dboptions line to use single quotes. It worked. However, now my AR and AP module give me the following parser error when trying to Add a Transaction. SELECTcurrent_date AS transdate, current_date + 30 AS duedate, d.curr AS currencies, (SELECT c.accno FROM chart c WHERE d.fxgain_accno_id = c.id) AS fxgain_accno, (SELECT c.accno FROM chart c WHERE d.fxloss_accno_id = c.id) AS fxloss_accno FROM defaults d Parser error at or near "select" I ran it piecemeal through psql and ran into problems at the subquery. BTW, I am using a Debian Woody default installation with Perl DBI. 2/19/02 1:27:33 PM, Dieter Simader <dsi...@sq...> wrote: >Hi Craig! > >load psql and type in > >SET DATESTYLE to ISO >SET DATESTYLE to "ISO" > >let me know which one works. > > >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 Mon, 18 Feb 2002, Craig Nunemaker wrote: > >> Has anyone ever gotten a DateStyle parse error? >> >> After logging in and clicking on any module action the screen displays the follwing error: >> Error: Set DateStyle to "ISO" >> Parse error at or near ISO >> >> I checked my Apache error log and found the following entry. >> DBD::Pg:db do failed: ERROR: parse error at or near "iso" at SL/Form.pm line >> 431 >> Error: set DateStyle to ISO<br>ERROR: parser: parse error at otr near "iso" >> Database handle destroyed without explicit disconnect. >> >> I examined SL/Form.pm but could not figure out how the code itself would raise an error. >> >> >> >> >> >> >> NOTICE: When replying, please Reply to the list address. This way other members know if the issues have been resolved or not. Thanks! Your List administrator. >> >> > > |
|
From: Dieter S. <dsi...@sq...> - 2002-02-20 00:45:20
|
Well, I guess we found a volunteer to write a new stylesheet. Thanks, Sergio! You just let me know which markup tags should be added / changed and I'll adjust the code. 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 Tue, 19 Feb 2002, Sergio A. Kessler wrote: > actually, you can use the print button of your browser, > but you don't want the form's buttons to print right ? > > the easy solution for this is to use css to define a > non printable class, like this: > > @media print { > .noprint { /* items with this class won't print */ > display: none; > } > } > > then you modify the source to include > <div class=noprint> > ..... <form's buttons> ..... > </div> > > hey, you even can define things that don't > display on screen but print > > @media screen { > .noscreen { /* items with this class won't display */ > display: none; > } > } > > it would be good for sql-ledger to use more css... > > /sergio > > ----- Original Message ----- > From: "Jeff Strope" <js...@en...> > > > > I'm pretty sure this has been covered in the past, but I just want to make > > sure. > > > > The "Print Invoice" & "Print Order" (etc) form buttons do not actually > send > > documents to printers installed on the server, correct? > > > NOTICE: When replying, please Reply to the list address. This way other members know if the issues have been resolved or not. Thanks! Your List administrator. > > |