sql-ledger-users — SQL-Ledger users

Re: [SL] Corporate taxes account?

[Rich S. <rsh...@ap...>]

On Wed, 10 Oct 2007, Stuart Luppescu wrote:

> This should be a quick one: In what account do I put the corporate income
> taxes that the company pays? It would not be correct to put it in 5510 -
> Inc Tax Exp - Federal, right? (That's where employee Social Security and
> Medicare taxes get taken out of.) Should I just make a new account, such
> as 5570 - Corporate Income Tax - Federal?

Stuart,

   This is a question that your accountant should answer for you.

Rich

-- 
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |         Accelerators(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

[SL] Corporate taxes account?

[Stuart L. <sl...@cc...>]

This should be a quick one: In what account do I put the corporate
income taxes that the company pays? It would not be correct to put it in
5510 - Inc Tax Exp - Federal, right? (That's where employee Social
Security and Medicare taxes get taken out of.) Should I just make a new
account, such as 5570 - Corporate Income Tax - Federal?

TIA.
-- 
Stuart Luppescu -=- s-luppescu .at. uchicago.edu        
University of Chicago (^_^)/ CCSR 
才文と智奈美の父 -=-=- Kernel 2.6.20-gentoo-r
ASHes to ASHes, DOS to DOS. 

Re: [SL] Invoice number Offset

[Adrien L. <ad...@mo...>]

That's perfect, thanks a lot.

On 10/9/07, Armaghan Saqib <sa...@le...> wrote:
> Just change the current invoice number to the last one you want in the
> System->Default screen.
>
> For example if you want the invoice number to start with 1000, put 999
> in the 'Sales Invoice/AR Transaction Number' on defaults screen.
>
>
> Regards
> ---
> Purpose built SQL-Ledger Hosting. Secure and reliable.
>
> http://www.ledger123.com
>
>
> On 10/9/07, Adrien Laurent <ad...@mo...> wrote:
> > Hi,
> >
> > The automated invoice number are not "sync" with my real invoice number.
> >
> > I've found this old post regarding the automated invoice number:
> > http://www.freelists.org/archives/sql-ledger-users/07-2003/msg00025.html
> >
> > I'd like to know what's the status now of this problem, is there any
> > quick fix available to "sync" the invoice number ? In my case I just
> > need to increase it.
> >
> > Thanks a lot,
> >
> > Adrien
> >
> >
> >
> > --
> > Adrien Laurent
> > (514) 284-2020 x 202
> > http://www.modulis-groupe.com
> >
> > -------------------------------------------------------------------------
> > This SF.net email is sponsored by: Splunk Inc.
> > Still grepping through log files to find problems?  Stop.
> > Now Search log events and configuration files using AJAX and a browser.
> > Download your FREE copy of Splunk now >> http://get.splunk.com/
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>


-- 
Adrien Laurent
(514) 284-2020 x 202
http://www.modulis-groupe.com

Re: [SL] Invoice number Offset

[Armaghan S. <sa...@le...>]

Just change the current invoice number to the last one you want in the
System->Default screen.

For example if you want the invoice number to start with 1000, put 999
in the 'Sales Invoice/AR Transaction Number' on defaults screen.


Regards
---
Purpose built SQL-Ledger Hosting. Secure and reliable.

http://www.ledger123.com


On 10/9/07, Adrien Laurent <ad...@mo...> wrote:
> Hi,
>
> The automated invoice number are not "sync" with my real invoice number.
>
> I've found this old post regarding the automated invoice number:
> http://www.freelists.org/archives/sql-ledger-users/07-2003/msg00025.html
>
> I'd like to know what's the status now of this problem, is there any
> quick fix available to "sync" the invoice number ? In my case I just
> need to increase it.
>
> Thanks a lot,
>
> Adrien
>
>
>
> --
> Adrien Laurent
> (514) 284-2020 x 202
> http://www.modulis-groupe.com
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

[SL] Invoice number Offset

[Adrien L. <ad...@mo...>]

Hi,

The automated invoice number are not "sync" with my real invoice number.

I've found this old post regarding the automated invoice number:
http://www.freelists.org/archives/sql-ledger-users/07-2003/msg00025.html

I'd like to know what's the status now of this problem, is there any
quick fix available to "sync" the invoice number ? In my case I just
need to increase it.

Thanks a lot,

Adrien



-- 
Adrien Laurent
(514) 284-2020 x 202
http://www.modulis-groupe.com

Re: [SL] Displaying Balance Sheet report in different currencies?

[Bob G. <bo...@rc...>]

Yes, I have a USD account where I did as you suggested. And there are
(not so little) shadow transactions generated to pull the balance down
to the correct number in EUR.

This is using addition and subtraction
to get the account balance to read in EUR;

-------------------------------

I don't think I am expecting a miracle though. Just a multiplication
between numbers that are already in the system:

  The transactions are in EUR and are dated.

  The conversion factor (exchange rate) is in the system and
  is set up to cover date ranges.

  The popup on the Balance Sheet request form is asking which
  currency you would like to have the form displayed in.
  (This is the only possible use for this popup item)

  And then - the report is generated in EUR.

  And - there is no indication on the report (label) that
  the report had been requested in USD.

Why have the popup in the Balance Sheet request form
if not to generate the form in that currency?

Best regards

Bob G

On Tue, 2007-10-09 at 07:07 +0200, Paul Tammes wrote:
> I think you are waiting for a spontaneous conversion miracle?
> You tell the system to use EUR. You enter data, in EUR, and now want to know
> how much USD transactions are in the system? The primary currency is, as you
> said, EUR.
> 
> Here is the lowdown:
> 
> Open a new test firm. Enter some transactions in USD. Do not enter anything
> else.
> Check rate (iirc about70 eurocents per dollar at the moment).
> 
> Get report, and see if it shows about 0.70 of the USD amounts you just
> entered.
> 
> hth
> paul
> 
> 2007/10/8, Bob Gustafson <bo...@rc...>:
> >
> > I have EUR as my first defined currency.
> >
> > 99% of the transactions are in EUR and no exchange rate is given with
> > the transaction
> >
> > I have entered exchange rates to cover the period of the reports in the
> > Exchange Rates menu  (correctly?)
> >
> > When I display my Income Statement, I select USD and expect to see my
> > Income Statement displayed (and labeled) in USD. It is not. The numbers
> > are the same as when I select EUR and the same date periods.
> >
> > Am I expecting too much?
> >
> > Bob G
> >
> > -------------------------------------------------------------------------
> > This SF.net email is sponsored by: Splunk Inc.
> > Still grepping through log files to find problems?  Stop.
> > Now Search log events and configuration files using AJAX and a browser.
> > Download your FREE copy of Splunk now >> http://get.splunk.com/
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >
> >
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Displaying Balance Sheet report in different currencies?

[Paul T. <pt...@gm...>]

I think you are waiting for a spontaneous conversion miracle?
You tell the system to use EUR. You enter data, in EUR, and now want to know
how much USD transactions are in the system? The primary currency is, as you
said, EUR.

Here is the lowdown:

Open a new test firm. Enter some transactions in USD. Do not enter anything
else.
Check rate (iirc about70 eurocents per dollar at the moment).

Get report, and see if it shows about 0.70 of the USD amounts you just
entered.

hth
paul

2007/10/8, Bob Gustafson <bo...@rc...>:
>
> I have EUR as my first defined currency.
>
> 99% of the transactions are in EUR and no exchange rate is given with
> the transaction
>
> I have entered exchange rates to cover the period of the reports in the
> Exchange Rates menu  (correctly?)
>
> When I display my Income Statement, I select USD and expect to see my
> Income Statement displayed (and labeled) in USD. It is not. The numbers
> are the same as when I select EUR and the same date periods.
>
> Am I expecting too much?
>
> Bob G
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>

[SL] Displaying Balance Sheet report in different currencies?

[Bob G. <bo...@rc...>]

I have EUR as my first defined currency.

99% of the transactions are in EUR and no exchange rate is given with
the transaction

I have entered exchange rates to cover the period of the reports in the
Exchange Rates menu  (correctly?)

When I display my Income Statement, I select USD and expect to see my
Income Statement displayed (and labeled) in USD. It is not. The numbers
are the same as when I select EUR and the same date periods.

Am I expecting too much?

Bob G

Re: [SL] Upgrade went bad

[David J <ja...@in...>]

Try login to Admin, and simply unlock the database.
Hope it then works as intended.

> Hi,
> 
> I've been running 2.6.19 for a long time and I was very
> happy with it. I've just tried to upgrade to 2.8.8
> 
> I ran upgrade with setup.pl from the root of sql-ledger
> Upgrade seemed fine except that I got this warning during
> the process: chown: invalid option -- s
> 
> Then, I went to the web page and I had the following error
> message:
> 
> ---------------------------------------------------
> Upgrading to Version 2.8.8 ...
> Error!
> 
> drop trigger del_recurring ON oe
> ERROR: trigger "del_recurring" for table "oe" does not
> exist ---------------------------------------------------
> 
> I've refreshed the page and it says now:
> Login disabled!
> 
> 
> Has any one any idea of what I should do now ?
> 
> Thanks a lot !
> 
> -- 
> Adrien Laurent
> (514) 284-2020 x 202
> http://www.modulis-groupe.com
>

[SL] Upgrade went bad

[Adrien L. <ad...@mo...>]

Hi,

I've been running 2.6.19 for a long time and I was very happy with it.
I've just tried to upgrade to 2.8.8

I ran upgrade with setup.pl from the root of sql-ledger
Upgrade seemed fine except that I got this warning during the process:
chown: invalid option -- s

Then, I went to the web page and I had the following error message:

---------------------------------------------------
Upgrading to Version 2.8.8 ...
Error!

drop trigger del_recurring ON oe
ERROR: trigger "del_recurring" for table "oe" does not exist
---------------------------------------------------

I've refreshed the page and it says now:
Login disabled!


Has any one any idea of what I should do now ?

Thanks a lot !

-- 
Adrien Laurent
(514) 284-2020 x 202
http://www.modulis-groupe.com

[SL] Cups problem

[C. D. H. <du...@du...>]

Anyone ever gotten a "Print-Job client-error-not-authorized" error in 
CUPS before?  Everything was working fine on our Fedora 4 box, running 
SQL-Ledger 2.6.27, and cups 1.2.x and all of a sudden I started getting 
these messages.  If I do a File, Print from SQL-Ledger (or any app) I 
can print to cups just fine.  But when I use the print button (which 
calls lpr) I get the client-error-not-authorized message.  I'm now 
running cups 1.3.3, but that hasn't helped.  Any help is truly 
appreciated.  Thanks in advance,

Dunc

# Cups access_log w/ debug set when using the print button:
localhost - - [04/Oct/2007:08:33:27 -0400] "POST / HTTP/1.1" 200 418 
CUPS-Get-Printers successful-ok
localhost - - [04/Oct/2007:08:33:27 -0400] "POST / HTTP/1.1" 200 418 
CUPS-Get-Classes successful-ok
localhost - - [04/Oct/2007:08:33:27 -0400] "POST / HTTP/1.1" 200 75 
CUPS-Get-Default successful-ok
localhost - - [04/Oct/2007:08:33:27 -0400] "POST /printers/Checks 
HTTP/1.1" 200 90582 Print-Job client-error-not-authorized

# Cups access_log w/ debug set when using file, print to the same printer:
localhost - - [04/Oct/2007:08:31:44 -0400] "POST /printers/Checks 
HTTP/1.1" 200 72298 Print-Job successful-ok
localhost - - [04/Oct/2007:08:31:44 -0400] "POST /printers/Checks 
HTTP/1.1" 200 142 Get-Job-Attributes successful-ok
localhost - - [04/Oct/2007:08:31:44 -0400] "POST /printers/Checks 
HTTP/1.1" 200 142 Get-Job-Attributes successful-ok
localhost - - [04/Oct/2007:08:32:29 -0400] "POST / HTTP/1.1" 200 129 
CUPS-Get-Printers successful-ok
localhost - - [04/Oct/2007:08:32:29 -0400] "POST / HTTP/1.1" 200 129 
CUPS-Get-Classes successful-ok
localhost - - [04/Oct/2007:08:32:29 -0400] "POST /printers/Checks 
HTTP/1.1" 200 142 Get-Job-Attributes successful-ok

Re: [SL] Alternative setup of sql-ledger on multiple machines.

[Paul T. <pt...@gm...>]

As long as you do not need to be at two place at the same time, I would say
granting remote access to the machine with the SQL-Ledger and then log in
two or even X times would be no problem, as long as the web-server can
handle it. Apache is quite robust, so no sweat I guess.

Logging in from two different machines as two different users should also
not be a problem, although maybe some tables would be locked if the two
people are trying to enter the same type of transactions from 2 places at
once.

Or maybe I do not understand the problem / question correct..


2007/10/4, dasDasein <da...@da...>:
>
> Is it possible to run multiple installations of sql-ledger on different
> machines, each connecting to a single (the same) postgresql dataset on a
> server via ssh?  I would like to run sql-remotely on multiple machines
> connected to a database using ssh without requiring an https
> connection.  If
> so, how does once setup the same user account on the multiple sql-ledger
> installations?
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>

[SL] Alternative setup of sql-ledger on multiple machines.

[dasDasein <da...@da...>]

Is it possible to run multiple installations of sql-ledger on different
machines, each connecting to a single (the same) postgresql dataset on a
server via ssh?  I would like to run sql-remotely on multiple machines
connected to a database using ssh without requiring an https connection.  If
so, how does once setup the same user account on the multiple sql-ledger
installations?

[SL] Re-Occurring Invoices

[Munroe <so...@di...>]

We are a service based industry, and I would like to be able to setup 
automatic invoices every month that have a predetermined amount unless 
at some point in the month something was added or removed.  Is there a 
way to do this?

-- 
Munroe Sollog
Systems Engineer
Digirati Computer Consulting, LLC
so...@di...

[SL] Cash / Import / Payments

[Craig H. <cr...@ou...>]

Does the current version of the SQL-Ledger manual document the Import 
Payments function (as seen in 2.8.8 onwards). Our first year has 
expired, and as we'd like to use the Import function I'd like to obtain 
some documentation for it (ie what format does the CSV file have to be 
in? What is the map file and what should it look like?). If this is 
covered in the manual then we'll be more than happy to pay for another year.

						-- C.

Re: [SL] Saving Bank Balances for reconciliation?

[Bob G. <bo...@rc...>]

On Mon, 2007-10-01 at 11:48 -0700, Wallace Roberts Consulting wrote:
> On 10/1/07, Bob Gustafson <bo...@rc...> wrote:
> > To reconcile bank balances with the number given by the bank, the
> > function:
> >
> > Cash -> Reconciliation
> >
> > Is very useful.
> >
> > It could be made more useful if one could store the date and balance
> > numbers given by the banks, so this reconciliation could be easier to
> > do, and perhaps more automatic.
> >
> > I wonder if anyone has a good procedure for doing this?
> 
> Because my bank provides online access to my accounts (as do most
> banks, I imagine), I record and reconcile my accounts on a daily
> basis.  This makes reconciliation an easy task for me.
> 

Yes, I also have on-line access, but I have a 'catch-up' job that needs
all the help technology can provide.

Bob G

Re: [SL] Saving Bank Balances for reconciliation?

[Wallace R. C. <wrc...@gm...>]

On 10/1/07, Bob Gustafson <bo...@rc...> wrote:
> To reconcile bank balances with the number given by the bank, the
> function:
>
> Cash -> Reconciliation
>
> Is very useful.
>
> It could be made more useful if one could store the date and balance
> numbers given by the banks, so this reconciliation could be easier to
> do, and perhaps more automatic.
>
> I wonder if anyone has a good procedure for doing this?

Because my bank provides online access to my accounts (as do most
banks, I imagine), I record and reconcile my accounts on a daily
basis.  This makes reconciliation an easy task for me.

-- 
Best Regards,
Wallace

[SL] Saving Bank Balances for reconciliation?

[Bob G. <bo...@rc...>]

To reconcile bank balances with the number given by the bank, the
function:

Cash -> Reconciliation

Is very useful.

It could be made more useful if one could store the date and balance
numbers given by the banks, so this reconciliation could be easier to
do, and perhaps more automatic.

I wonder if anyone has a good procedure for doing this?

Bob G

Re: [SL] Help on SQL-Ledger needed ...

[Bob G. <bo...@rc...>]

My guess is that you have not yet created some of the tables. Have you
skipped a step in the new user list?

I had this same error a couple of days ago. The reason was that I had
dumped all my data and then did a

DROP DATABASE "sql-ledger";
CREATE DATABASE "sql-ledger";

on another machine in preparation to load the dumped data.

I was interrupted and forgot to do the load. When I next logged in, I
got the error you noted. The database sql-ledger was there, but it was
empty.

Have fun

Bob G

On Mon, 2007-04-09 at 00:55 -0400, Joshua Chan wrote:
> Hi all,
> 
> We are evaluating SQL-Ledger. Installation and configuration when well
> except when user attempt to log-in, the page returns with following
> error:
> 
> Error!
> SELECT version FROM defaults
> ERROR: relation "defaults" does not exist
> 
> The above did not occur for Admin (admin.pl) login but only on user
> (login.pl) login.
> 
> Our test system info as follow:
> OS: Kubuntu Dapper 6.06
> Kernel: 2.6.15-28-amd64-generic
> Apache: 2.0.55
> PostgreSQL: 8.1.8 (with schemas)
> Perl: 5.8.7
> 
> Any help is greatly appreciated. I am not aware of any community so I
> post here.
> 
> Do direct me to the correct channel.
> 
> Thanks.
> 
> Best regards,
> Joshua Frasir Chan
> IT Administrator
> * * * * *
> OAAG (S) PTE. LTD.
> 60 Kaki Bukit Place
> #09-10 Eunos Techpark II
> Singapore 415979
> Tel: (65)6744-1811
> DID: (65)6751-5679
> Fax: (65)6280-0090
> Email: jo...@oa...
> www.oaag.com
> 24hr regional PGA Assist: (65)6280-0808
> Company Registration No.: 200003073H
> Singapore . Hong Kong . Malaysia . Philippines . Taiwan . South Korea .
> Indonesia .
> Thailand . China . Sri Lanka . India . Japan . Australia . South Africa
> . Brazil .
> * * * * *
> Warning:
> This communication, including any attachments therein, may contain
> privileged/confidential information
> that is solely intended for the individual or entity named as
> recipientIf you are not the intended recipient, 
> please take notice that any disclosure, copying, distribution,
> review,retransmission or taking of any other 
> action in reliance upon, of any part of the content of this
> informationis strictly prohibited.
> 
> If you are not the intended recipient, please notify the sender by
> return email and delete this communication
> wholly from any storage media.
> 
> Thank you.
> 
> 
> -----Original Message-----
> From: sql...@li...
> [mailto:sql...@li...] On Behalf Of
> sql...@li...
> Sent: Saturday, April 07, 2007 6:27 AM
> To: sql...@li...
> Subject: sql-ledger-users Digest, Vol 12, Issue 1
> 
> Send sql-ledger-users mailing list submissions to
> 	sql...@li...
> 
> To subscribe or unsubscribe via the World Wide Web, visit
> 	https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> or, via email, send a message with subject or body 'help' to
> 	sql...@li...
> 
> You can reach the person managing the list at
> 	sql...@li...
> 
> When replying, please edit your Subject line so it is more specific than
> "Re: Contents of sql-ledger-users digest..."
> 
> 
> Today's Topics:
> 
>    1. Re: Best Linux OS for SL? (Oliver Heesakkers)
>    2. Re: Best Linux OS for SL? (Andrei Kolu)
>    3. Re: Best Linux OS for SL? (ATM Logic)
>    4. Re: SQL-Ledger from Windows Mobile 5.0 (Colin Manning)
>    5. Payroll (Jigme Datse)
>    6. Re: Project details for each timecard (Rune Bromer)
>    7. Re: Best Linux OS for SL? (Vladimir Botka)
>    8. Purchase Order field? (Danita Zanre)
>    9. Re: Payroll (David Boyle)
>   10. Re: Purchase Order field? (R Pennington)
>   11. Re: Payroll (Jeff Roberts)
>   12. Re: Best Linux OS for SL? (Wallace Roberts Consulting)
>   13. Re: Best Linux OS for SL? (Bob Crandell)
>   14. Re: Project details for each timecard (Victor H. Goff III)
>   15. HTML Invoice Template - broken image (Myk Robinson)
>   16. upgrading to 2.8 (Tage Danielsen)
>   17. Problems upgrading from 2.6.27 to 2.8.0 (Glen Morris)
>   18. Re: Problems upgrading from 2.6.27 to 2.8.0 (Dieter Simader)
>   19. Re: Problems upgrading from 2.6.27 to 2.8.0 (ATM Logic)
>   20. Re: Problems upgrading from 2.6.27 to 2.8.0 (Tage Danielsen)
>   21. Upgrade to 2.7 or 2.8? (ATM Logic)
>   22. Re: Problems upgrading from 2.6.27 to 2.8.0 (George Osvald)
>   23. Re: Upgrade to 2.7 or 2.8? (Mark Lubratt)
>   24. Restoring from a pg_dump (Glen Morris)
>   25. Can't process recurring transactions after upgrade to 2.8.0
>       (Glen Morris)
>   26. Re: Problems upgrading from 2.6.27 to 2.8.0 (Tage Danielsen)
>   27. Re: Restoring from a pg_dump (R Pennington)
>   28. Re: Restoring from a pg_dump (George Osvald)
>   29. Looking for a bookkeeper who knows how to use SQL-Ledger
>       (hh...@ch...)
>   30. SQL-Ledger on Apache Tomcat: it works (hh...@ch...)
>   31. AR balance sheet vs trial balance vs outstanding (Chris Johnson)
> 
> 
> ----------------------------------------------------------------------
> 
> Message: 1
> Date: Tue, 27 Mar 2007 00:51:02 +0200
> From: Oliver Heesakkers <sl...@he...>
> Subject: Re: [SL] Best Linux OS for SL?
> To: sql...@li...
> Message-ID: <200...@he...>
> Content-Type: text/plain;  charset="iso-8859-1"
> 
> Op Monday 26 March 2007 19:31:22 schreef ATM Logic:
> > Thanks, tried it on my VM Ware unit and it failed, will try on the 
> > server (re-installing the 6.2 now)
> >
> 
> I reccomend using Portsnap instead of cvsup.
> 
> http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/portsnap.html
> 
> 
> 
> ------------------------------
> 
> Message: 2
> Date: Tue, 27 Mar 2007 12:03:04 +0300
> From: Andrei Kolu <and...@ma...>
> Subject: Re: [SL] Best Linux OS for SL?
> To: sql...@li...
> Message-ID: <200...@ma...>
> Content-Type: text/plain;  charset="iso-8859-1"
> 
> On Monday 26 March 2007 8:31 pm, ATM Logic wrote:
> > Thanks, tried it on my VM Ware unit and it failed, will try on the 
> > server (re-installing the 6.2 now)
> >
> csup is already in FreeBSD 6.2 base system- I referred to 6.1 in case
> you have older installation.
> 
> 
> 
> ------------------------------
> 
> Message: 3
> Date: Tue, 27 Mar 2007 00:17:55 -0500
> From: "ATM Logic" <atm...@km...>
> Subject: Re: [SL] Best Linux OS for SL?
> To: <sql...@li...>
> Message-ID: <000001c7702f$4754c4a0$6800a8c0@ATMLogic.local>
> Content-Type: text/plain;	charset="us-ascii"
> 
> Thanks for taking the time for the help, however I have tried 2 flavors
> of
> FreeBSD, and as much as I would like it to work, I am getting little
> failures here here and there (pkg_add -r csup, fails, even when I get
> sql-ledger installed, I don't have pico to edit, so forced to use other
> apps, then I am a little confused... No Lynx, or links, not even mc...
> 
> So... Going with CentOS, I know it well enough, and will try FreeBSD as
> a
> project, not a production unit.
> 
> 
> > >
> > 
> > I reccomend using Portsnap instead of cvsup.
> > 
> > http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/port
> > snap.html
> > 
> > --------------------------------------------------------------
> > -----------
> > 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
> > 
> 
> 
> 
> 
> ------------------------------
> 
> Message: 4
> Date: Tue, 27 Mar 2007 18:17:15 +0800
> From: Colin Manning <co...@it...>
> Subject: Re: [SL] SQL-Ledger from Windows Mobile 5.0
> To: sql...@li...
> Message-ID: <460...@it...>
> Content-Type: text/plain; charset="us-ascii"
> 
> Awesome.
> 
> Lynx style menu works better with dopod anyway - Display is small.
> 
> Dieter Simader wrote:
> > pass terminal=lynx on the URL
> >
> > http://localhost/sql-ledger/login.pl?terminal=lynx
> >
> > Looks like the browser does not like the Javascript code.
> >
> > If you don't like the lynx style menu force Javascript off
> >
> >
> http://localhost/sql-ledger/login.pl?action=login&login=the_login&passwo
> rd=the_password
> >
> >   
> 
> -- 
> Regards,
> 
> *Colin Manning* B Sc.
> 
> /Computer service, sales and support./
> I.T. Navigate Pty Ltd
> Phone: (08) 9574 0200
> Mobile: 0412 384 242
> ABN:61 108 296 288
> 
> <http://www.itnavigate.com.au>
> www.itnavigate.com.au <http://www.itnavigate.com.au>
> 
> 
> ------------------------------
> 
> Message: 5
> Date: Mon, 26 Mar 2007 18:31:07 -0700
> From: "Jigme Datse" <jig...@gm...>
> Subject: [SL] Payroll
> To: sql...@li...
> Message-ID:
> 	<b3f...@ma...>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> 
> I'm looking at my setup for SL and right now I'm not seeing any
> payroll module.  That is while I see the HR module, and the Projects
> module, I don't see a way to print up cheques/cheque stubs for the
> hours that my employees have put in.  Am I missing something obvious?
> I think I've gone through a few times to figure this out, and put the
> payroll through, but the only way that I can see this right now, is to
> manually enter the cheques, and stubs through the general ledger.
> 
> Jigme Datse
> 
> 
> 
> ------------------------------
> 
> Message: 6
> Date: Tue, 27 Mar 2007 12:22:18 +0200
> From: Rune Bromer <run...@co...>
> Subject: Re: [SL] Project details for each timecard
> To: sql...@li...
> Message-ID: <460...@co...>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> 
> Tom Diehl wrote:
> > On Mon, 26 Mar 2007, Rune Bromer wrote:
> > 
> >> Tom Diehl wrote:
> >>> Yep, This is my exact situation. When you generate the sales order
> click
> >>> the details button and you will get entries on the sales order for
> each
> >>> timecard.
> >>>
> >>> Regards,
> >> When I click the generate button I get blank list. Should the sale
> order
> >> be visible somewhere? And how do you generate a invoice from it?
> > 
> > Look under sales orders and you should see the new sales orders. The
> timecards
> > will be gone from view because they are allocated.
> 
> Thanks for the reply, but I'm still lost. Where in the menu do I find 
> this? I can find "something" in the consolidate submenu, but there I can
> 
> see 3 entries (2, 2 and -2 hours). Where can I generate an invoice?
> 
> Rune
> 
> 
> 
> ------------------------------
> 
> Message: 7
> Date: Tue, 27 Mar 2007 10:17:23 +0200
> From: Vladimir Botka <vl...@bo...>
> Subject: Re: [SL] Best Linux OS for SL?
> To: sql...@li...
> Message-ID: <20070327101723.3e8cfa39@srv>
> Content-Type: text/plain; charset=US-ASCII
> 
> Hello,
> if you installed from CD then you can install the port collection much
> faster this way:
> 1. put your CD in
> 2. as a root type # sysinstal
> 3. go to CONFIGURE->DISTRIBUTIONS
> 4. check out the [x] ports
> 5. and press [OK]
> The port collection will be installed from your CD. Then you can find
> the SL in /usr/ports/finance directory. <gently flame=off> But in the
> long run with FreeBSD you can not avoid reading the handbook. It will
> pay you in time. I promisse.
> 
> Cheers, -vlado
> 
> > Any Idea what I am missing??
> > 
> > I have freeBSD installed, and I go to cd /usr/ports/ and ... There is
> > nothing there... I cannot go to finance  etc...  Tried and failed
> > with the VMWare, then on the full meal deal??
> > 
> > 
> > 
> > ??
> > > > 
> > > > If you're really insistent on having a GUI check out 
> > > www.pcbsd.org - 
> > > > FBSD + KDE
> > > > 
> > > 
> > > Looks like I cannot install SQL on the VMWare package of this  :(
> > > 
> > > At least not using:
> > > cd /usr/ports/finance/sql-ledger/ && make install clean
> > > 
> > > 
> > > --------------------------------------------------------------
> > > -----------
> > > 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
> > > 
> > 
> > 
> >
> ------------------------------------------------------------------------
> -
> > 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=DEVDE
> V
> > _______________________________________________ sql-ledger-users
> > mailing list sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> > 
> 
> 
> 
> ------------------------------
> 
> Message: 8
> Date: Tue, 27 Mar 2007 11:14:41 -0600
> From: "Danita Zanre" <da...@ca...>
> Subject: [SL] Purchase Order field?
> To: <sql...@li...>
> Message-ID: <460...@ca...>
> Content-Type: text/plain; charset=US-ASCII
> 
> Maybe I'm just blind, but I can't seem to find a variable to replace the
> "order" field in an invoice with "Purchase Order" - in our business, we
> really never have a need to pass our internal "Sales Order" information
> to the invoice, but we always need to pass the "purchase order" info.
> I've just taken to putting the purchase order number in the "order"
> field, but if there is a way to pass this info to the invoice I'd be
> happier.
> 
> Thanks.
> 
> Danita
> 
> 
> 
> 
> 
> 
> ------------------------------
> 
> Message: 9
> Date: Tue, 27 Mar 2007 10:04:11 -0500
> From: David Boyle <dav...@sb...>
> Subject: Re: [SL] Payroll
> To: sql...@li...
> Message-ID: <1175007851.5002.6.camel@Conall>
> Content-Type: text/plain
> 
> On Mon, 2007-03-26 at 18:31 -0700, Jigme Datse wrote:
> > I'm looking at my setup for SL and right now I'm not seeing any
> > payroll module.  That is while I see the HR module, and the Projects
> > module, I don't see a way to print up cheques/cheque stubs for the
> > hours that my employees have put in.  Am I missing something obvious?
> > I think I've gone through a few times to figure this out, and put the
> > payroll through, but the only way that I can see this right now, is to
> > manually enter the cheques, and stubs through the general ledger.
> 
> I have my associates/employees set up as vendors and pay out using Add
> AP Transaction.  Entering the transaction this way allows me to enter
> Gross Pay under whatever expense account I am paying them through and
> entering deductions in the same transaction for withheld payroll taxes,
> garnishments and other items.  Works for us, but your mileage may vary.
> 
> HTH,
> David Boyle
> NAPCO
> 
> 
> > 
> > Jigme Datse
> > 
> >
> ------------------------------------------------------------------------
> -
> > 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=DEVDE
> V
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> 
> 
> 
> 
> ------------------------------
> 
> Message: 10
> Date: Tue, 27 Mar 2007 15:24:45 -0500
> From: R Pennington <arc...@mt...>
> Subject: Re: [SL] Purchase Order field?
> To: sql...@li...
> Message-ID: <200...@mt...>
> Content-Type: text/plain;  charset="iso-8859-1"
> 
> On Tuesday 27 March 2007 12:14 pm, Danita Zanre wrote:
> > I've just taken to putting the purchase order number in the "order"
> field, but if there is a way to pass this info to the invoice I'd be
> happier.
> > 
> <%ponumber%>
> 
> Cheers,
> Roy
> 
> 
> 
> ------------------------------
> 
> Message: 11
> Date: Tue, 27 Mar 2007 12:53:20 -0700
> From: Jeff Roberts <je...@jr...>
> Subject: Re: [SL] Payroll
> To: sql...@li...
> Message-ID: <460...@jr...>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> 
> Hi Jigme
> 
> I do the same as David, if you set up your 'deduction' liability 
> accounts (tax owing, employment insurance owing, pension owing etc) they
> 
> will appear in the drop down menus of the AP module. You can put in the 
> gross pay and assign it to an expense and then use negative numbers to 
> 'deduct' from the gross and assign the 'deductions' to liability 
> accounts. When I'm all done printing the cheques I do a GL entry to 
> account for the matching expenses, I, for example, expense the amount I 
> have to match on their pension contributions (Pension expense) and add 
> it to a liability account called 'pension owing' (same account I used 
> when cutting their cheque). This way both my contribution and their 
> contribution end up in the same liability account. At the end of the 
> month when it's time for remittance I pay from a bank account and 
> decrease the liability account back to zero.
> 
> None of this does anything for the calculations that have to be made to 
> determine how much each employee has to pay each of the various 
> deductions. I have a spreadsheet with the Canadian formulas in it to do 
> that and it's printout is what I use to cut the cheques and do the GL
> entry.
> 
> Jeff Roberts
> 
> David Boyle wrote:
> > On Mon, 2007-03-26 at 18:31 -0700, Jigme Datse wrote:
> >   
> >> I'm looking at my setup for SL and right now I'm not seeing any
> >> payroll module.  That is while I see the HR module, and the Projects
> >> module, I don't see a way to print up cheques/cheque stubs for the
> >> hours that my employees have put in.  Am I missing something obvious?
> >> I think I've gone through a few times to figure this out, and put the
> >> payroll through, but the only way that I can see this right now, is
> to
> >> manually enter the cheques, and stubs through the general ledger.
> >>     
> >
> > I have my associates/employees set up as vendors and pay out using Add
> > AP Transaction.  Entering the transaction this way allows me to enter
> > Gross Pay under whatever expense account I am paying them through and
> > entering deductions in the same transaction for withheld payroll
> taxes,
> > garnishments and other items.  Works for us, but your mileage may
> vary.
> >
> > HTH,
> > David Boyle
> > NAPCO
> >
> >
> >   
> >> Jigme Datse
> >>
> >>
> ------------------------------------------------------------------------
> -
> >> 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=DEVDE
> V
> >> _______________________________________________
> >> sql-ledger-users mailing list
> >> sql...@li...
> >> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >>     
> >
> >
> >
> ------------------------------------------------------------------------
> -
> > 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=DEVDE
> V
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >
> >
> >   
> 
> 
> 
> ------------------------------
> 
> Message: 12
> Date: Tue, 27 Mar 2007 20:55:44 -0700
> From: "Wallace Roberts Consulting" <wrc...@gm...>
> Subject: Re: [SL] Best Linux OS for SL?
> To: sql...@li...
> Message-ID:
> 	<a7a...@ma...>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> 
> On 3/27/07, Vladimir Botka <vl...@bo...> wrote:
> > But in the
> > long run with FreeBSD you can not avoid reading the handbook. It will
> > pay you in time. I promisse.
> 
> ... OR ...
> 
> Simply use Fedora Core instead, & it will automagically work.
> 
> --
> Best Regards,
> Wallace
> 
> 
> 
> ------------------------------
> 
> Message: 13
> Date: Wed, 28 Mar 2007 11:29:49 -0700
> From: Bob Crandell <bo...@co...>
> Subject: Re: [SL] Best Linux OS for SL?
> To: sql...@li...
> Message-ID: <117...@bo...puterbaseusa.loc>
> Content-Type: text/plain
> 
> On Tue, 2007-03-27 at 20:55 -0700, Wallace Roberts Consulting wrote:
> > On 3/27/07, Vladimir Botka <vl...@bo...> wrote:
> > > But in the
> > > long run with FreeBSD you can not avoid reading the handbook. It
> will
> > > pay you in time. I promisse.
> > 
> > ... OR ...
> > 
> > Simply use Fedora Core instead, & it will automagically work.
> > 
> I've had the same results with SuSE.
> 
> Bob C.
> 
> 
> 
> 
> ------------------------------
> 
> Message: 14
> Date: Wed, 28 Mar 2007 16:17:24 -0500
> From: "Victor H. Goff III" <kee...@gm...>
> Subject: Re: [SL] Project details for each timecard
> To: sql...@li...
> Message-ID:
> 	<324...@ma...>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> 
> You would then generate an invoice from the sales order.  (At least
> this is the normal chain of events for us.... )
> 
> On 3/27/07, Rune Bromer <run...@co...> wrote:
> > Tom Diehl wrote:
> > > On Mon, 26 Mar 2007, Rune Bromer wrote:
> > >
> > >> Tom Diehl wrote:
> > >>> Yep, This is my exact situation. When you generate the sales order
> click
> > >>> the details button and you will get entries on the sales order for
> each
> > >>> timecard.
> > >>>
> > >>> Regards,
> > >> When I click the generate button I get blank list. Should the sale
> order
> > >> be visible somewhere? And how do you generate a invoice from it?
> > >
> > > Look under sales orders and you should see the new sales orders. The
> timecards
> > > will be gone from view because they are allocated.
> >
> > Thanks for the reply, but I'm still lost. Where in the menu do I find
> > this? I can find "something" in the consolidate submenu, but there I
> can
> > see 3 entries (2, 2 and -2 hours). Where can I generate an invoice?
> >
> > Rune
> >
> >
> ------------------------------------------------------------------------
> -
> > 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=DEVDE
> V
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >
> 
> 
> -- 
> Warmest Regards,
> 
> Victor H. Goff III
> Sr. Network Administrator
> Voice: (405) 213-0549
> Fax: (206)309-0765
> http://dgcc.custompcinc.net/
> 
> 
> 
> ------------------------------
> 
> Message: 15
> Date: Wed, 28 Mar 2007 16:03:06 -0500
> From: Myk Robinson <myk...@gm...>
> Subject: [SL] HTML Invoice Template - broken image
> To: sql...@li...
> Message-ID: <200...@gm...>
> Content-Type: text/plain;  charset="us-ascii"
> 
> Hey-
> 
> All of a sudden after an upgrade, my html invoice template is broken. My
> Latex 
> template is working fine..
> 
> the image I am trying to reference is called "new_logo.jpg"
> 
> Its location is
> /usr/local/sql-ledger/templates/myk.robinson/new_logo.jpg
> 
> 
> Please advise as to the proper way to refer to this image..
> 
> thanks,
> -myk
> 
> 
> 
> ------------------------------
> 
> Message: 16
> Date: Sun, 01 Apr 2007 21:24:53 +0200
> From: Tage Danielsen <ta...@ht...>
> Subject: [SL] upgrading to 2.8
> To: sql...@li...
> Message-ID: <461...@ht...>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> 
> Hello
> 
> Tage from Denmark
> 
> I am upgrading from 2.7.27 to 2.8 and get this error
> 
> **************************************
> Upgrading to Version 2.8.0 ...
> Error!
> 
> insert into defau (fldname, fldvalue) values ('inventory_accno_id', 
> (select inventory_accno_id from defaults))
> ERROR: more than one row returned by a subquery used as an expression
> 
> ****************************************
> 
> somebody able to help?
> 
> Thanks
> /tage
> 
> 
> 
> ------------------------------
> 
> Message: 17
> Date: Mon, 02 Apr 2007 09:48:45 +1000
> From: Glen Morris <gl...@au...>
> Subject: [SL] Problems upgrading from 2.6.27 to 2.8.0
> To: sql...@li...
> Message-ID: <461...@au...>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> 
> When I upgraded from 2.6.27 to 2.8.0 I couldn't login.
> 
> I unlocked the system from the admin interface but when I try to login I
> 
> get:
> 
>     Upgrading to Version 2.8.0 ...
> 
> 
>         Error!
> 
>     *create sequence assemblyid*
>     *ERROR: relation "assemblyid" already exists*
> 
> *
> *Also according to the upgrade docs there should be the following files 
> in the templates directory but they aren't there:
> 
>     3. copy the following templates from the templates directory to
>        your private directory
> 
>        Default-credit_invoice.html
>        Default-credit_invoice.tex
>        Default-debit_invoice.html
>        Default-debit_invoice.tex
> 
> Regards, Glen
> **
> 
> -- 
> Glen Morris: Arachnoid Australia
> 613 90175780 Melbourne | 612 90164032 Sydney
> 613 98961811 VoIP | Mbl 0419299140
> Skype=glenmo. PO Box 214, Healesville VIC 3777, Australia
> 
> 
> 
> ------------------------------
> 
> Message: 18
> Date: Mon, 02 Apr 2007 11:04:19 -0600 (MDT)
> From: Dieter Simader <dsi...@sq...>
> Subject: Re: [SL] Problems upgrading from 2.6.27 to 2.8.0
> To: sql...@li...
> Message-ID: <200...@gu...>
> Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed
> 
> The easiest is to restore from a backup, delete the second record in the
> 
> defaults table and upgrade again.
> 
> If you don't have a backup you have no choice but to do a manual upgrade
> 
> from the point on when the upgrade script failed. The upgrade failed in 
> Pg-upgrade-2.7.5-2.7.6.sql when it tried to rewrite the defaults table.
> 
> -- 
> Dieter Simader       http://www.sql-ledger.com   Tel: (780) 472-8161
> DWS Systems Inc.        Accounting Software      Fax: (780) 478-5281
> ============== On a clear disk you can seek forever ================
> 
> On Mon, 2 Apr 2007, Glen Morris wrote:
> 
> > When I upgraded from 2.6.27 to 2.8.0 I couldn't login.
> >
> > I unlocked the system from the admin interface but when I try to login
> I
> > get:
> >
> >    Upgrading to Version 2.8.0 ...
> >
> >
> >        Error!
> >
> >    *create sequence assemblyid*
> >    *ERROR: relation "assemblyid" already exists*
> >
> > *
> > *Also according to the upgrade docs there should be the following
> files
> > in the templates directory but they aren't there:
> >
> >    3. copy the following templates from the templates directory to
> >       your private directory
> >
> >       Default-credit_invoice.html
> >       Default-credit_invoice.tex
> >       Default-debit_invoice.html
> >       Default-debit_invoice.tex
> >
> > Regards, Glen
> > **
> >
> >
> 
> 
> 
> ------------------------------
> 
> Message: 19
> Date: Mon, 2 Apr 2007 12:41:15 -0500
> From: "ATM Logic" <atm...@km...>
> Subject: Re: [SL] Problems upgrading from 2.6.27 to 2.8.0
> To: <sql...@li...>
> Message-ID: <015001c7754e$1d9f8180$6800a8c0@ATMLogic.local>
> Content-Type: text/plain;	charset="US-ASCII"
> 
> I am back at 2.6.14 and was just about to go to the 2.7 (support)
> version...
> Should I jump to 2.8 instead?  After a backup, should I be worried about
> the
> update?  
>  
> > The easiest is to restore from a backup, delete the second 
> > record in the defaults table and upgrade again.
> > 
> 
> 
> 
> 
> ------------------------------
> 
> Message: 20
> Date: Mon, 02 Apr 2007 19:56:33 +0200
> From: Tage Danielsen <ta...@ht...>
> Subject: Re: [SL] Problems upgrading from 2.6.27 to 2.8.0
> To: sql...@li...
> Message-ID: <461...@ht...>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> 
> Dieter Simader wrote:
> > The easiest is to restore from a backup, delete the second record in
> the 
> > defaults table and upgrade again.
> >
> > If you don't have a backup you have no choice but to do a manual
> upgrade 
> > from the point on when the upgrade script failed. The upgrade failed
> in 
> > Pg-upgrade-2.7.5-2.7.6.sql when it tried to rewrite the defaults
> table.
> >
> >   
> Sorry it don't work, and come with this error
> 
> Upgrading to Version 2.8.0 ...
> Error!
> 
> create table cargo (id int not null, trans_id int not null, package 
> text, netweight float4, grossweight float4, volume float4)
> ERROR: could not create relation 1663/17233/111289: Filen eksisterer 
> {file exist}
> 
> hope it will be better
> 
> Tage from Denmark
> 
> 
> 
> ------------------------------
> 
> Message: 21
> Date: Mon, 2 Apr 2007 14:30:35 -0500
> From: "ATM Logic" <atm...@km...>
> Subject: [SL] Upgrade to 2.7 or 2.8?
> To: <sql...@li...>
> Message-ID: <017d01c7755d$63c7b830$6800a8c0@ATMLogic.local>
> Content-Type: text/plain;	charset="US-ASCII"
> 
> I am back at 2.6.14 and was just about to go to the 2.7 (support)
> version...
> 
> Should I jump to 2.8 instead? After a backup, should I be worried about
> the
> update? 
> 
> PS, sorry to hijack the "Problems upgrading from 2.6.27 to 2.8.0"
> earlier...
> 
>  
> 
> 
> 
> ------------------------------
> 
> Message: 22
> Date: Tue, 3 Apr 2007 09:28:21 +1000
> From: George Osvald <geo...@ya...>
> Subject: Re: [SL] Problems upgrading from 2.6.27 to 2.8.0
> To: sql...@li...
> Message-ID: <200...@ya...>
> Content-Type: text/plain;  charset="iso-8859-1"
> 
> On Tuesday 03 April 2007 03:56, Tage Danielsen wrote:
> > Dieter Simader wrote:
> > > The easiest is to restore from a backup, delete the second record in
> the
> > > defaults table and upgrade again.
> > >
> > > If you don't have a backup you have no choice but to do a manual
> upgrade
> > > from the point on when the upgrade script failed. The upgrade failed
> in
> > > Pg-upgrade-2.7.5-2.7.6.sql when it tried to rewrite the defaults
> table.
> >
> > Sorry it don't work, and come with this error
> 
> I have done this once before for earlier version. If you do not have
> backup or 
> at least system backup to get back to previous version you will have to
> go 
> manually and delete all existing files, tables and edit the sql file
> error by 
> error. Every time you do something run the setup it will give you
> another 
> error. Then you will have to back track and repeat all the steps you
> have 
> made to that point and so on. It is painfull but it will teach you one
> thing:
> Always have a backup before any upgrade.
> 
> 
> > Upgrading to Version 2.8.0 ...
> > Error!
> >
> > create table cargo (id int not null, trans_id int not null, package
> > text, netweight float4, grossweight float4, volume float4)
> > ERROR: could not create relation 1663/17233/111289: Filen eksisterer
> > {file exist}
> >
> > hope it will be better
> >
> > Tage from Denmark
> >
> >
> ------------------------------------------------------------------------
> -
> > 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=DEVDE
> V
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> 
> -- 
> George
> AUSTRALIA
> http://www.okstudio.com.au
> 
> 
> 
> ------------------------------
> 
> Message: 23
> Date: Mon, 2 Apr 2007 16:52:47 -0500
> From: Mark Lubratt <mar...@in...>
> Subject: Re: [SL] Upgrade to 2.7 or 2.8?
> To: sql...@li...
> Message-ID: <1D2...@in...>
> Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
> 
> After a couple of tries, my upgrade went smoothly when I made sure  
> that I had one and only one entry (tuple) in the defaults table.
> 
> 
> On Apr 2, 2007, at 2:30 PM, ATM Logic wrote:
> 
> > I am back at 2.6.14 and was just about to go to the 2.7 (support)  
> > version...
> >
> > Should I jump to 2.8 instead? After a backup, should I be worried  
> > about the
> > update?
> >
> > PS, sorry to hijack the "Problems upgrading from 2.6.27 to 2.8.0"  
> > earlier...
> >
> >
> >
> > ----------------------------------------------------------------------
> 
> > ---
> > 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
> >
> 
> 
> 
> 
> ------------------------------
> 
> Message: 24
> Date: Tue, 03 Apr 2007 09:01:52 +1000
> From: Glen Morris <gl...@au...>
> Subject: [SL] Restoring from a pg_dump
> To: sql...@li...
> Message-ID: <461...@au...>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> 
> I have a script that backs up my psql databases each night (SL 2.6.27). 
> For the first time I tried to restore (because of failed 2.8.0 upgrade) 
> from one but it failed. I used this command to create the backup:
> 
>     pg_dump -U sql-ledger dea > /spare/backup/postgresql/pgsql-dea_`date
>     +%G%m%d`.sql
> 
> And then tried to restore as per the manual with:
> 
>     psql -U sql-ledger dea < pgsql-dea_20070402.sql
> 
> 
> gives lots of:
> 
>     invalid command \N
>     invalid command \N
>     invalid command \N
>     invalid command \N
>     ERROR:  syntax error at or near "10078" at character 1
>     LINE 1: 10078 johne
> 
> Restoring from a SL backup works fine but I don't have one that's as 
> current as the pg_dump.
> 
> Regards Glen
> 
> 
> -- 
> Glen Morris: Arachnoid Australia
> 613 90175780 Melbourne | 612 90164032 Sydney
> 613 98961811 VoIP | Mbl 0419299140
> Skype=glenmo. PO Box 214, Healesville VIC 3777, Australia
> 
> 
> 
> ------------------------------
> 
> Message: 25
> Date: Tue, 03 Apr 2007 09:45:25 +1000
> From: Glen Morris <gl...@au...>
> Subject: [SL] Can't process recurring transactions after upgrade to
> 	2.8.0
> To: sql...@li...
> Message-ID: <461...@au...>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> 
> When I go to process recurring transactions I get the following error:
> 
> *Posting Sales Invoice 1 ... **DBD::Pg::db do failed: ERROR: syntax 
> error at or near "WHERE" at character 44
> *
> 
> 
>     Error!
> 
> *UPDATE exchangerate
> SET
> WHERE curr = 'AUD'
> AND transdate = '01-04-2007'
> ERROR: syntax error at or near "WHERE" at character 44*
> 
> 
> -- 
> Glen Morris: Arachnoid Australia
> 613 90175780 Melbourne | 612 90164032 Sydney
> 613 98961811 VoIP | Mbl 0419299140
> Skype=glenmo. PO Box 214, Healesville VIC 3777, Australia
> 
> 
> 
> ------------------------------
> 
> Message: 26
> Date: Tue, 03 Apr 2007 07:09:52 +0200
> From: Tage Danielsen <ta...@ht...>
> Subject: Re: [SL] Problems upgrading from 2.6.27 to 2.8.0
> To: sql...@li...
> Message-ID: <461...@ht...>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> 
> George Osvald wrote:
> > On Tuesday 03 April 2007 03:56, Tage Danielsen wrote:
> >   
> >> Dieter Simader wrote:
> >>     
> >>> The easiest is to restore from a backup, delete the second record in
> the
> >>> defaults table and upgrade again.
> >>>
> >>> If you don't have a backup you have no choice but to do a manual
> upgrade
> >>> from the point on when the upgrade script failed. The upgrade failed
> in
> >>> Pg-upgrade-2.7.5-2.7.6.sql when it tried to rewrite the defaults
> table.
> >>>       
> >> Sorry it don't work, and come with this error
> >>     
> >
> > I have done this once before for earlier version. If you do not have
> backup or 
> > at least system backup to get back to previous version you will have
> to go 
> > manually and delete all existing files, tables and edit the sql file
> error by 
> > error. Every time you do something run the setup it will give you
> another 
> > error. Then you will have to back track and repeat all the steps you
> have 
> > made to that point and so on. It is painfull but it will teach you one
> thing:
> > Always have a backup before any upgrade.
> >
> >
> >   
> >> Upgrading to Version 2.8.0 ...
> >> Error!
> >>
> >> create table cargo (id int not null, trans_id int not null, package
> >> text, netweight float4, grossweight float4, volume float4)
> >> ERROR: could not create relation 1663/17233/111289: Filen eksisterer
> >> {file exist}
> >>
> >> hope it will be better
> >>
> >> Tage from Denmark
> >>
> >>
> ------------------------------------------------------------------------
> -
> >> 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=DEVDE
> V
> >> _______________________________________________
> >> sql-ledger-users mailing list
> >> sql...@li...
> >> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >>     
> >
> >   
> The problem is not backup, I made at filebackup of database and 
> sql-ledger, and I am running 2.6.27 very OK, but I like to upgrade to 
> 2.8 due to new features, and this is not running.
> 
> Tage from Denmark
> 
> 
> ------------------------------
> 
> Message: 27
> Date: Thu, 5 Apr 2007 09:18:09 -0500
> From: R Pennington <arc...@mt...>
> Subject: Re: [SL] Restoring from a pg_dump
> To: sql...@li...
> Message-ID: <200...@mt...>
> Content-Type: text/plain;  charset="iso-8859-1"
> 
> On Monday 02 April 2007 6:01 pm, Glen Morris wrote:
> > I have a script that backs up my psql databases each night (SL
> 2.6.27). 
> > For the first time I tried to restore (because of failed 2.8.0
> upgrade) 
> > from one but it failed. I used this command to create the backup:
> > 
> >     pg_dump -U sql-ledger dea >
> /spare/backup/postgresql/pgsql-dea_`date
> >     +%G%m%d`.sql
> > 
> > And then tried to restore as per the manual with:
> > 
> >     psql -U sql-ledger dea < pgsql-dea_20070402.sql
> > 
> > 
> > gives lots of:
> > 
> >     invalid command \N
> >     invalid command \N
> >     invalid command \N
> >     invalid command \N
> >     ERROR:  syntax error at or near "10078" at character 1
> >     LINE 1: 10078 johne
> > 
> > Restoring from a SL backup works fine but I don't have one that's as 
> > current as the pg_dump.
> > 
> > Regards Glen
> > 
> > 
> Hi Glen
> 
> use pg_restore to restore the data.
> pg_dump and pg_restore are designed to be used together.
> 
> "psql -U sql-ledger dea < pgsql-dea_20070402.sql" works for restoring SL
> backups
> 
> Cheers,
> Roy
> 
> 
> 
> ------------------------------
> 
> Message: 28
> Date: Fri, 6 Apr 2007 10:06:08 +1000
> From: George Osvald <geo...@ya...>
> Subject: Re: [SL] Restoring from a pg_dump
> To: sql...@li...
> Message-ID: <200...@ya...>
> Content-Type: text/plain;  charset="iso-8859-1"
> 
> On Friday 06 April 2007 00:18, R Pennington wrote:
> > On Monday 02 April 2007 6:01 pm, Glen Morris wrote:
> > > I have a script that backs up my psql databases each night (SL
> 2.6.27).
> > > For the first time I tried to restore (because of failed 2.8.0
> upgrade)
> > > from one but it failed. I used this command to create the backup:
> > >
> > >     pg_dump -U sql-ledger dea >
> /spare/backup/postgresql/pgsql-dea_`date
> > >     +%G%m%d`.sql
> > >
> > > And then tried to restore as per the manual with:
> > >
> > >     psql -U sql-ledger dea < pgsql-dea_20070402.sql
> > >
> > >
> > > gives lots of:
> > >
> > >     invalid command \N
> > >     invalid command \N
> > >     invalid command \N
> > >     invalid command \N
> > >     ERROR:  syntax error at or near "10078" at character 1
> > >     LINE 1: 10078 johne
> > >
> > > Restoring from a SL backup works fine but I don't have one that's as
> > > current as the pg_dump.
> > >
> > > Regards Glen
> >
> 
> When I was using a backup file created from SL I would change for
> postgres 
> user and then go:
> 
> psql \i backup.sql mydatabase
> 
> If I was getting any error messages either from sql traceback or after
> login I 
> would copy those on clipboard resolve and run the command again. (for
> example 
> I had existing tables that I had to delete) I also found that I had to
> 
> delete my database before restoring otherwise I would get double
> entries.
> 
> Normally how ever I am running automatic backups from cron for the whole
> 
> system and also for databases. Something like this:
> 0 4 * * *	postgres pg_dump --format=t mydatabase > backup.tgz
> 20 4 * * *	postgres   pg_dumpall > alldata.sql
> 
> Typically I would restore from alldata.sql with:
> 
> psql template1 -f alldata.sql
> 
> that resores your whole database structure.
> 
> 
> -- 
> George
> AUSTRALIA
> http://www.okstudio.com.au
> 
> 
> 
> ------------------------------
> 
> Message: 29
> Date: Thu, 5 Apr 2007 23:33:08 -0700
> From: hh...@ch...
> Subject: [SL] Looking for a bookkeeper who knows how to use SQL-Ledger
> To: sql...@li...
> Message-ID: <200...@ch...>
> Content-Type: text/plain;  charset="us-ascii"
> 
> SQL-Ledger seems to be a very powerful accounting system.  We need help
> from a 
> bookkeeper who knows how to use this program.  Please contact me if you
> are 
> such a person or know such a person.  We need part-time help starting 
> immediately.  It would be great to find someone in the Los Angeles area.
> 
> Thank you
> 
> 
> 
> ------------------------------
> 
> Message: 30
> Date: Thu, 5 Apr 2007 23:44:25 -0700
> From: hh...@ch...
> Subject: [SL] SQL-Ledger on Apache Tomcat: it works
> To: sql...@li...
> Message-ID: <200...@ch...>
> Content-Type: text/plain;  charset="us-ascii"
> 
> If anyone is interested in information about running SQL-Ledger on
> Apache 
> Tomcat, let me know.  I had to make some modifications to the CGI
> servlet 
> that comes with Tomcat, but I did that and it's fine. I would be happy
> to 
> share my modified servlet with anyone who wants it.  If someone could
> post it 
> somewhere that would be great too.
> 
> SQL-Ledger was the last and only thing I was using Apache HTTPD for so
> it was 
> great to finally get it to Tomcat and get rid of Apache HTTPD.
> 
> 
> 
> ------------------------------
> 
> Message: 31
> Date: Fri, 6 Apr 2007 16:36:40 -0300 (ART)
> From: Chris Johnson <vac...@ya...>
> Subject: [SL] AR balance sheet vs trial balance vs outstanding
> To: sql...@li...
> Message-ID: <999...@we...>
> Content-Type: text/plain; charset=iso-8859-1
> 
> Hi all,
>  
>  I am working on closing out 2005 (still!). After a long time looking at
> the books and reports, talking with the accountant etc, I am suspecting
> the Accounts Receivable as having to do with my problem, so I wanted to
> see if anyone could shed some light on this issue. 
>  
>  My accounting is on a cash basis, and I am generating the balance sheet
> [1] and seeing a line for AR in assets. When I generate the trial
> balance, I see an amount for AR that is different (larger) than what
> showed on the balance sheet. I also tried to compare this to what I get
> if I do a report on open AR transactions - and I get yet another number
> for outstanding AR! Any idea why these would be different? 
>  
>  The other thing I am suspecting has to do with the current earnings vs
> net income. I performed a "year end" process at 12-31-2005. However, my
> current earnings (Balance Sheet) and net income (Income Statement) still
> do not match. I thought this process was supposed to bring these two
> into line. Any suggestions on bringing them into balance? 
>  
>  Thanks in advance for your help in setting this issue. 
>  
>  Regards,
>  Chris
>  
>  [1] Why is AR shown on the balance sheet for cash accounting? 
> 
>  		
> ---------------------------------
>  Pregunt?. Respond?. Descubr?.
>  Todo lo que quer?as saber, y lo que ni imaginabas,
>  est? en Yahoo! Respuestas (Beta).
>  Probalo ya! 
> 
> ------------------------------
> 
> ------------------------------------------------------------------------
> -
> 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=DEVDE
> V
> 
> ------------------------------
> 
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> 
> 
> End of sql-ledger-users Digest, Vol 12, Issue 1
> ***********************************************
> 
> 
> 
> -------------------------------------------------------------------------
> 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

[SL] Printing Credit Invoice Error

[Dirk E. S. <ds...@ca...>]

Hello,

I am using SL 2.8.4, openSUSE 10.1, trying to print a credit invoice
without sucess:


DBD::Pg::st execute failed: ERROR: invalid input syntax for integer:
"customer_id"
Error!

Assertion i == (((((SV *) (name_av))->sv_flags & 0x00008000)) ?
Perl_mg_size(((PerlInterpreter
*)pthread_getspecific((*Perl_Gthr_key_ptr(((void *)0))))), (SV *) name_av)
: ((XPVAV*) (name_av)->sv_any)->xav_fill)+1 failed: file "DBI.xs", line
1723 at SL/AA.pm line 1261.


I can register this transaction but on printing above error occures.
Invoices etc. print fine, including invoices for the same customer. Where
should I look at?

Thanks for any hint

Enrique

-- 
Dirk Enrique Seiffert - Lintec S.A.
Ed. Torre del Reloj - Of. 401
Plaza de los Coches, Centro
Cartagena - Colombia
http://www.lintecsa.com

Re: [SL] More migrating problems

[Paul T. <pt...@gm...>]

Depends, did you read the docs about upgrading and did you run al scripts
for the inbetween versions?

I mean, if Windows Vista is not going to run Windows own DirectX programs
from previous versions, it is a bit much to expect efrom Linux or SQL-Ledger
that everything JustWork (TM) out of the box..



2007/9/26, Stuart Luppescu <sl...@cc...>:
>
> On 日, 2007-09-23 at 10:01 -0500, Dirk Enrique Seiffert wrote:
> > > Hello again, Sorry for the last post. I had neglected to install DBI
> > and
> > > DBD-pg. Now those are installed, and I restored the data base using
> > > psgl. I also copied over all the files
> > in /usr/local/sql-ledger/users
> > > over to the new machine. I can get the admin page to come up and it
> >
> > Did you set the ownership of /usr/local/sql-ledger/users to your
> > webserver?
>
> Yes. The ownership is apache:apache. Could these problems be due to the
> fact that the old machine was running 2.6.22, and the new one is 2.8.8?
>
> --
> Stuart Luppescu -=- s-luppescu .at. uchicago.edu
> University of Chicago (^_^)/ CCSR
> 才文と智奈美の父 -=-=- Kernel 2.6.20-gentoo-r
> I can't understand why people are frightened of
> <new ideas.  I'm frightened of the old ones.   --
> John Cage
>
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2005.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] More migrating problems

[Stuart L. <s-l...@uc...>]

On 日, 2007-09-23 at 10:01 -0500, Dirk Enrique Seiffert wrote:
> > Hello again, Sorry for the last post. I had neglected to install DBI
> and
> > DBD-pg. Now those are installed, and I restored the data base using
> > psgl. I also copied over all the files
> in /usr/local/sql-ledger/users
> > over to the new machine. I can get the admin page to come up and it
> 
> Did you set the ownership of /usr/local/sql-ledger/users to your
> webserver?

Yes. The ownership is apache:apache. Could these problems be due to the
fact that the old machine was running 2.6.22, and the new one is 2.8.8?

-- 
Stuart Luppescu -=- s-luppescu .at. uchicago.edu        
University of Chicago (^_^)/ CCSR 
才文と智奈美の父 -=-=- Kernel 2.6.20-gentoo-r
"It was a virgin forest, a place where the Hand of
Man had never set foot." 

Re: [SL] More migrating problems

[Stuart L. <sl...@cc...>]

On 日, 2007-09-23 at 10:01 -0500, Dirk Enrique Seiffert wrote:
> > Hello again, Sorry for the last post. I had neglected to install DBI
> and
> > DBD-pg. Now those are installed, and I restored the data base using
> > psgl. I also copied over all the files
> in /usr/local/sql-ledger/users
> > over to the new machine. I can get the admin page to come up and it
> 
> Did you set the ownership of /usr/local/sql-ledger/users to your
> webserver?

Yes. The ownership is apache:apache. Could these problems be due to the
fact that the old machine was running 2.6.22, and the new one is 2.8.8?

-- 
Stuart Luppescu -=- s-luppescu .at. uchicago.edu        
University of Chicago (^_^)/ CCSR 
才文と智奈美の父 -=-=- Kernel 2.6.20-gentoo-r
I can't understand why people are frightened of
<new ideas.  I'm frightened of the old ones.   -- 
John Cage 

Re: [SL] Error upgrading... - SOLVED

[Stan W. <st...@ba...>]

Have been having similar problem.  What permission did you set?

Andrew @ ATM Logic wrote:
> Oops, sorry forgot to set permissions, did that, all is well.
>
>  
>
>   
>> -----Original Message-----
>> From: sql...@li... 
>> [mailto:sql...@li...] On 
>> Behalf Of Andrew @ ATM Logic
>> Sent: Friday, September 21, 2007 12:17 PM
>> To: sql...@li...
>> Subject: [SL] Error upgrading...
>>
>> Ok... so... could have sunk myself here, but its the 
>> weekend.. so... go time for this.  I tried an upgrade from 
>> 2.6.14 to 2.8.8 and got this logging in.
>>  
>> Upgrading to Version 2.8.8 ... 
>>
>> Error!
>>
>>
>> drop trigger del_recurring ON oe
>> ERROR: trigger "del_recurring" for table "oe" does not exist
>>
>> --------------------------------------------------------------
>> -----------
>> This SF.net email is sponsored by: Microsoft Defy all 
>> challenges. Microsoft(R) Visual Studio 2005.
>> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>     
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2005.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
>
>   

Re: [SL] Every Customer is customer #1

[Tony F. <to...@sy...>]

On Fri, 2007-09-21 at 11:48 -0500, Andrew @ ATM Logic wrote:
> Also... Speaking of customers... They have all of them in MYOB.... Any
> simple way to get them from MYOB to SL  (actually... Would even accept
> difficult way as long as its no worse than manual entry) 

If MYOB has an export function to export a customer list then there's a
way. You may need to hire a programmer to create you a migration script
though. I don't know of any pre-done scripts for MYOB.

-- 
Tony Fraser
to...@sy...
Sybaspace Internet Solutions                        System Administrator
phone: (250) 246-5368                                fax: (250) 246-5398