sql-ledger-users — SQL-Ledger users

[SL] Handling prepayments

[Michael H. <mh...@it...>]

Hello everyone,

    Just a thought/question regarding prepayment of services.  At the  
moment when somebody prepays (or accidentally overpays) we make an AR  
entry for that client with the check number, date paid etc and then  
as the funds are applied to invoices we decrement the original AR  
entry accordingly until the overage is depleted and then delete the  
original entry all together.  This method does work but it is rather  
prone to human error.
    And then I had an epiphany - could we not simply create an actual  
separate AP account in the chart of accounts for each those clients?   
And then "pay" invoices out of the appropriate account?  Is anyone  
else doing this?  If so have there been any problems/pitfalls?  (Or  
is there some third method that would be better than either of these?)


Thanks!

Michael

Re: [SL] Upgrade time again - V2.7

[Dr E. L. <el...@li...>]

It's beta, and I also use it in production. But, stop whining.

el

on 2/12/07 4:46 AM Paolo Abadesco said the following:

> is an enhanced version with more features.  This version is in
> production use but requires more support because the features are
> not documented.  [ download v2.7
> <http://abacus.sql-ledger.com/source/sql-ledger> ]
>
> 2.7 is in production use...  With 2.8 being full of features (and
> will might also have a beta..)  how sure are we that 2.8 will be
> public or FREE for download?

Re: [SL] Upgrade time again - V2.7

[Paolo A. <pja...@gm...>]

is an enhanced version with more features. This version is in production use
but requires more support because the features are not documented. [ download
v2.7 <http://abacus.sql-ledger.com/source/sql-ledger> ]

2.7 is in production use...  With 2.8 being full of features (and will might
also have a beta..)     how sure are we that 2.8 will be public or FREE for
download?



On 2/12/07, Dr Eberhard Lisse <el...@li...> wrote:
>
> Well, if they don't want to pay for support, they get the support they
> pay for.
>
> My impression about 2.7.* is that it is beta and eventually it will
> become 2.8.* which will be public. But then this is Mr Simader's program.
>
> greetings, el
>
>
> on 2/11/07 10:35 PM Roy Nicholl said the following:
> > Oh ... where the marathon is a not-for-profit, I doubt they will be
> > inclined to pay for support/manual.
> >
> > Dieter,
> >
> > Does this mean that the 'public' version ends with 2.6.x?
> >
> > Roy
> >
> > On 11-Feb-2007, at 11:38, Dr Eberhard Lisse wrote:
> >
> >> You pay for the manual and get access to the download site.
> >>
> >> el
> >>
> >> on 2/11/07 4:43 PM Roy Nicholl said the following:
> >>> After far too long, I am upgrading the version of SQL-Ledger used by
> >>> the a local marathon from version 2.6.3.  When I run setup.pl, it
> >>> goes out and pulls down version 2.6.23, yet I have read of folks
> >>> running version 2.7.x on this list.   How do I get this latest
> >>> version?
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job
> easier.
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] Year End & Inventory Questions

[Roy N. <RNi...@NB...>]

Followup on my previous post.

This afternoon, I setup a new installation of SQL-Ledger with a new  
database.

I created two vendors and three customers.

I added a part and a service:

1) Part: Long Sleeve Technical 'T'  ... cost $25.00
2) Service: Screening of club logo ... cost $2.00

I then created an assembly comprised of the part and the service:

3) Club Crested long-sleeve technical 'T' ... sale price $35.00

I created a purchase order to vendor 1 for 20 units of 'part' (long  
sleeved technical 'T').
I then went into shipping and receiving and received the order (20  
units)
I then generated the corresponding vendor invoice.

Next I entered a vendor invoice from Vendor 2 for  
'service' (screening of club logo) for 20 units

I then checked "All Items" under Good & Services/Reports and I had 20  
units of 'assembly' (Club Crested long-sleeve Technical T'

Now that I had an inventory it was time to sell.

Customer 1:
   I created a sales order for 2 shirts
   I then went under Shipping and 'ship'ed the order
   finally I generated the corresponding sales invoice.

Customer 2:
   I went under AR and created a 'sales invoice' for 1 shirt directly

Customer 3:
   I went under POS / Sale and sold 1 shirt

After each of the above transactions, I went under Goods & Services /  
Reports  / All Items and looked under Reports / "Chart of Accounts"  
and confirmed that the inventory was adjusted appropriately.

This reflects the same process I previously followed under the Club  
SQL Ledger setup, so I am really at a loss of how the inventory  
balance there is incorrect.

Roy

On 11-Feb-2007, at 16:52, Roy Nicholl wrote:

> All,
>
> I have setup a local running club to use SQL Ledger and, for the most
> part, it has worked well ... save two issues:
>
> 1) I have an issue with inventory which I have been unable to
> resolve.  We created two assemblies: one being a club technical shirt
> and the other a running shell (jacket).  In both instances the
> assembly was comprised of the clothing item + the cost of screening a
> logo on the item.  We have sold all of the shirts/jackets and when I
> go into "Goods & Services", "Reports" "All Items", the quantity for
> each assembly is correct (0).  Yet the balance sheet still shows
> inventory on hand ...  what have I done wrong?
>
> 2) In addition to the 'general operations' of the running club, it
> also presents two large road races each year: a marathon in the
> spring and a 10K in the autumn.   I have setup SQL Ledger such that
> the Marathon and 10K events are separate 'Departments' ... each
> department is its own profit/cost centre and has its own back
> account.  This worked just wonderfully until we tried to do a year
> end.   The "year end" function appear to work globally ... i.e. it
> sweeps all departments/divisions together and drops the retained
> earnings into a single account.   Is there a way I can perform the
> year end function on a per division/department basis?  ... or will I
> have to pull everything apart and re-implement them as separate
> 'companies' (highly inconvenient)?
>
> Roy
>
>
> ---------------------------------------------------------------------- 
> ---
> Using Tomcat but need to do more? Need to support web services,  
> security?
> Get stuff done quickly with pre-integrated technology to make your  
> job easier.
> Download IBM WebSphere Application Server v.1.0.1 based on Apache  
> Geronimo
> http://sel.as-us.falkag.net/sel? 
> cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Upgrade time again - V2.7

[Andi S. <as...@ac...>]

sorry, not being a native english speaker I consult my webster and read:

1. a) to utter a peevish, high-pitched, somewhat nasal sound, as in 
complaint, distress, fear, etc.
      b) to make a prolonged, high pitched sound like this

2. to complain or beg in a childishly undignified way.

I dont understand you - Which of theese do you mean? I do neither complain 
nor beg
I am just stating the download is password protected I am mentioning 
my private preferneces - which I consider as legitimate.

I respect Dieter Simaders wish for not revealing source code to everybody, 
but please explain how from the following text can be found out that that 
version 2.7 is not for free download:

"Version 2.7 is an enhanced version with more features. This version is in 
production use but requires more support because the features are not 
documented. [ download v2.7 ]

Additional features:
Debit/Credit notes and invoices
template variable calculations
voucher system for payable, general ledger, payment and payment reversals
early payment discounts, GAAP and European standards
default account links for customers/vendors
reconciliation procedure based on dates
warehouse links on invoices and orders
threshold for payment to exclude payments
import sales invoices
new batch print, queue and email functions

Installation instruction are in the README file."

regards

A.



On Sun, 11 Feb 2007, Dr Eberhard Lisse wrote:

> Stop whining.
>
> el
>
> on 2/11/07 11:07 PM Andi Stern said the following:
>> hi,
>>
>> just did not think about a missing password - a typical open source
>> product ;-))
>>
>> I personally suggest ledger-smb - I am just waiting for the first usable
>> debian Version - only a matter of time - but Documentation is included ...
>>
>> regards
>>
>> A.
>>
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier.
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] Upgrade time again - V2.7

[Roy N. <RNi...@NB...>]

Rich,

I believe the running club will also be fine with 2.6.23 (they are  
fine with 2.6.3) ... I'm upgrading them mostly for fixes (&  
security) ... I asked about 2.7 as I was interested in the new/ 
improved reconciliation procedure.

It's too bad that my company is using Adempiere, or I could probably  
swing the manual for the benefit of the running club.

Again thanks to all who responded.

Roy


On 11-Feb-2007, at 17:56, Rich Shepard wrote:

> On Sun, 11 Feb 2007, Dr Eberhard Lisse wrote:
>
>> My impression about 2.7.* is that it is beta and eventually it  
>> will become
>> 2.8.* which will be public. But then this is Mr Simader's program.
>
>    I have not looked at the added features in 2.7.x, because 2.6.23
> accommodates all my needs -- and a whole lot more. If I was just  
> now coming
> to upgrade from an earlier version of SL, I'd use the current stable
> version.
>
> Rich
>
> -- 
> Richard B. Shepard, Ph.D.               |    The Environmental  
> Permitting
> Applied Ecosystem Services, Inc.        |          Accelerator(TM)
> <http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax:  
> 503-667-8863
>
> ---------------------------------------------------------------------- 
> ---
> Using Tomcat but need to do more? Need to support web services,  
> security?
> Get stuff done quickly with pre-integrated technology to make your  
> job easier.
> Download IBM WebSphere Application Server v.1.0.1 based on Apache  
> Geronimo
> http://sel.as-us.falkag.net/sel? 
> cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Upgrade time again - V2.7

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

On Sun, 11 Feb 2007, Dr Eberhard Lisse wrote:

> My impression about 2.7.* is that it is beta and eventually it will become
> 2.8.* which will be public. But then this is Mr Simader's program.

   I have not looked at the added features in 2.7.x, because 2.6.23
accommodates all my needs -- and a whole lot more. If I was just now coming
to upgrade from an earlier version of SL, I'd use the current stable
version.

Rich

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

Re: [SL] Upgrade time again - V2.7

[Dr E. L. <el...@li...>]

Stop whining.

el

on 2/11/07 11:07 PM Andi Stern said the following:
> hi,
>
> just did not think about a missing password - a typical open source
> product ;-))
>
> I personally suggest ledger-smb - I am just waiting for the first usable
> debian Version - only a matter of time - but Documentation is included ...
>
> regards
>
> A.
>

Re: [SL] Upgrade time again - V2.7

[Dr E. L. <el...@li...>]

Well, if they don't want to pay for support, they get the support they
pay for.

My impression about 2.7.* is that it is beta and eventually it will
become 2.8.* which will be public. But then this is Mr Simader's program.

greetings, el


on 2/11/07 10:35 PM Roy Nicholl said the following:
> Oh ... where the marathon is a not-for-profit, I doubt they will be  
> inclined to pay for support/manual.
> 
> Dieter,
> 
> Does this mean that the 'public' version ends with 2.6.x?
> 
> Roy
> 
> On 11-Feb-2007, at 11:38, Dr Eberhard Lisse wrote:
> 
>> You pay for the manual and get access to the download site.
>>
>> el
>>
>> on 2/11/07 4:43 PM Roy Nicholl said the following:
>>> After far too long, I am upgrading the version of SQL-Ledger used by
>>> the a local marathon from version 2.6.3.  When I run setup.pl, it
>>> goes out and pulls down version 2.6.23, yet I have read of folks
>>> running version 2.7.x on this list.   How do I get this latest  
>>> version?

Re: [SL] Upgrade time again - V2.7

[Andi S. <as...@ac...>]

hi,

just did not think about a missing password - a typical open source 
product ;-))

I personally suggest ledger-smb - I am just waiting for the first usable 
debian Version - only a matter of time - but Documentation is included ...

regards

A.

On Sun, 11 Feb 2007, Andi Stern wrote:

> hi,
>
> hint: just got to the download page
>
> http://sql-ledger.org/cgi-bin/nav.pl?page=source/index.html&title=Download
>
> search for 2.7
>
> regards
>
> A.
>
> On Sun, 11 Feb 2007, Roy Nicholl wrote:
>
>> 
>> Oh ... where the marathon is a not-for-profit, I doubt they will be
>> inclined to pay for support/manual.
>> 
>> Dieter,
>> 
>> Does this mean that the 'public' version ends with 2.6.x?
>> 
>> Roy
>> 
>> On 11-Feb-2007, at 11:38, Dr Eberhard Lisse wrote:
>> 
>>> You pay for the manual and get access to the download site.
>>> 
>>> el
>>> 
>>> on 2/11/07 4:43 PM Roy Nicholl said the following:
>>>> After far too long, I am upgrading the version of SQL-Ledger used by
>>>> the a local marathon from version 2.6.3.  When I run setup.pl, it
>>>> goes out and pulls down version 2.6.23, yet I have read of folks
>>>> running version 2.7.x on this list.   How do I get this latest
>>>> version?
>>>> 
>>>> Roy
>>> 
>> 
>> 
>> -------------------------------------------------------------------------
>> Using Tomcat but need to do more? Need to support web services, security?
>> Get stuff done quickly with pre-integrated technology to make your job 
>> easier.
>> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
>> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>> 
>

Re: [SL] Upgrade time again - V2.7

[Roy N. <RNi...@NB...>]

The link on the page wants a user name and password (htaccess?) ...  
which appears to fit in with Eberhard's explanation.

Thanks anyway,

Roy

On 11-Feb-2007, at 17:01, Andi Stern wrote:

> hi,
>
> hint: just got to the download page
>
> http://sql-ledger.org/cgi-bin/nav.pl?page=source/ 
> index.html&title=Download
>
> search for 2.7
>
> regards
>
> A.
>
> On Sun, 11 Feb 2007, Roy Nicholl wrote:
>
>>
>> Oh ... where the marathon is a not-for-profit, I doubt they will be
>> inclined to pay for support/manual.
>>
>> Dieter,
>>
>> Does this mean that the 'public' version ends with 2.6.x?
>>
>> Roy
>>
>> On 11-Feb-2007, at 11:38, Dr Eberhard Lisse wrote:
>>
>>> You pay for the manual and get access to the download site.
>>>
>>> el
>>>
>>> on 2/11/07 4:43 PM Roy Nicholl said the following:
>>>> After far too long, I am upgrading the version of SQL-Ledger  
>>>> used by
>>>> the a local marathon from version 2.6.3.  When I run setup.pl, it
>>>> goes out and pulls down version 2.6.23, yet I have read of folks
>>>> running version 2.7.x on this list.   How do I get this latest
>>>> version?
>>>>
>>>> Roy
>>>
>>
>>
>> --------------------------------------------------------------------- 
>> ----
>> Using Tomcat but need to do more? Need to support web services,  
>> security?
>> Get stuff done quickly with pre-integrated technology to make your  
>> job easier.
>> Download IBM WebSphere Application Server v.1.0.1 based on Apache  
>> Geronimo
>> http://sel.as-us.falkag.net/sel? 
>> cmd=lnk&kid=120709&bid=263057&dat=121642
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
>
> ---------------------------------------------------------------------- 
> ---
> Using Tomcat but need to do more? Need to support web services,  
> security?
> Get stuff done quickly with pre-integrated technology to make your  
> job easier.
> Download IBM WebSphere Application Server v.1.0.1 based on Apache  
> Geronimo
> http://sel.as-us.falkag.net/sel? 
> cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Upgrade time again - V2.7

[Andi S. <as...@ac...>]

hi,

hint: just got to the download page

http://sql-ledger.org/cgi-bin/nav.pl?page=source/index.html&title=Download

search for 2.7

regards

A.

On Sun, 11 Feb 2007, Roy Nicholl wrote:

>
> Oh ... where the marathon is a not-for-profit, I doubt they will be
> inclined to pay for support/manual.
>
> Dieter,
>
> Does this mean that the 'public' version ends with 2.6.x?
>
> Roy
>
> On 11-Feb-2007, at 11:38, Dr Eberhard Lisse wrote:
>
>> You pay for the manual and get access to the download site.
>>
>> el
>>
>> on 2/11/07 4:43 PM Roy Nicholl said the following:
>>> After far too long, I am upgrading the version of SQL-Ledger used by
>>> the a local marathon from version 2.6.3.  When I run setup.pl, it
>>> goes out and pulls down version 2.6.23, yet I have read of folks
>>> running version 2.7.x on this list.   How do I get this latest
>>> version?
>>>
>>> Roy
>>
>
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier.
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

[SL] Year End & Inventory Questions

[Roy N. <RNi...@NB...>]

All,

I have setup a local running club to use SQL Ledger and, for the most  
part, it has worked well ... save two issues:

1) I have an issue with inventory which I have been unable to  
resolve.  We created two assemblies: one being a club technical shirt  
and the other a running shell (jacket).  In both instances the  
assembly was comprised of the clothing item + the cost of screening a  
logo on the item.  We have sold all of the shirts/jackets and when I  
go into "Goods & Services", "Reports" "All Items", the quantity for  
each assembly is correct (0).  Yet the balance sheet still shows  
inventory on hand ...  what have I done wrong?

2) In addition to the 'general operations' of the running club, it  
also presents two large road races each year: a marathon in the  
spring and a 10K in the autumn.   I have setup SQL Ledger such that  
the Marathon and 10K events are separate 'Departments' ... each  
department is its own profit/cost centre and has its own back  
account.  This worked just wonderfully until we tried to do a year  
end.   The "year end" function appear to work globally ... i.e. it  
sweeps all departments/divisions together and drops the retained  
earnings into a single account.   Is there a way I can perform the  
year end function on a per division/department basis?  ... or will I  
have to pull everything apart and re-implement them as separate  
'companies' (highly inconvenient)?

Roy

Re: [SL] Upgrade time again - V2.7

[Roy N. <RNi...@NB...>]

Oh ... where the marathon is a not-for-profit, I doubt they will be  
inclined to pay for support/manual.

Dieter,

Does this mean that the 'public' version ends with 2.6.x?

Roy

On 11-Feb-2007, at 11:38, Dr Eberhard Lisse wrote:

> You pay for the manual and get access to the download site.
>
> el
>
> on 2/11/07 4:43 PM Roy Nicholl said the following:
>> After far too long, I am upgrading the version of SQL-Ledger used by
>> the a local marathon from version 2.6.3.  When I run setup.pl, it
>> goes out and pulls down version 2.6.23, yet I have read of folks
>> running version 2.7.x on this list.   How do I get this latest  
>> version?
>>
>> Roy
>

Re: [SL] Upgrade time again - V2.7

[Dr E. L. <el...@li...>]

You pay for the manual and get access to the download site.

el

on 2/11/07 4:43 PM Roy Nicholl said the following:
> After far too long, I am upgrading the version of SQL-Ledger used by  
> the a local marathon from version 2.6.3.  When I run setup.pl, it  
> goes out and pulls down version 2.6.23, yet I have read of folks  
> running version 2.7.x on this list.   How do I get this latest version?
> 
> Roy

-- 
Dr. Eberhard W. Lisse  \        / Obstetrician & Gynaecologist (Saar)
el...@li... el108-ARIN / *     |   Telephone: +264 81 124 6733 (cell)
PO Box 8421             \     /   Please do NOT email to this address
Bachbrecht, Namibia     ;____/        if it is DNS related in ANY way

[SL] Upgrade time again - V2.7

[Roy N. <RNi...@NB...>]

After far too long, I am upgrading the version of SQL-Ledger used by  
the a local marathon from version 2.6.3.  When I run setup.pl, it  
goes out and pulls down version 2.6.23, yet I have read of folks  
running version 2.7.x on this list.   How do I get this latest version?

Roy

[SL] UTF8, chinese and the pound sign

[Bernd P. <bp...@ch...>]

Hi Wan,

I had the same problem some time ago.
Please contact me directly for a patch.

Regards,

Bernd Plagge

-- 
プラゲ ベェアント - Bernd Plagge
ファースト・チョイス・インターネット(有)
First Choice Internet Ltd., Tokyo
Tel. 03-4500-7799
Fax. 03-4400-3723
mail: bp...@ch...
url: http://www.choicenet.ne.jp


On Sat, 10 Feb 2007 17:33:47 -0800
sql...@li... wrote:

> Message: 3
> Date: Sat, 3 Feb 2007 22:55:02 -0800 (PST)
> From: Wan Ling <big...@ya...>
> Subject: [SL] UTF8, chinese and the pound sign
> To: sql...@li...
> Message-ID: <920...@we...>
> Content-Type: text/plain; charset=iso-8859-1
> 
> i have problems printing postscript invoices with chinese customer names
> where the UTF code contains a pound sign. for example,
> ????????????
> 
> which became
> 
> ???????????\pound
> 
> how can i solve this problem?
> 
> using 2.6.22 on windows XP running apache and postgresql.
> 
> wan ling

[SL] Install Notes for Lighttpd

[Mark B. <ma...@hu...>]

Dieter,

Attached are notes for configuring Lighttpd to run Sql-Ledger.

Potential README material.

m
-------------- next part --------------
Sat Feb 10 20:34:48 EST 2007
Mark Bucciarelli


    1. Make sure mod_cgi and mod_alias are in server.modules list.


    2. Add Sql-Ledger directory as an alias, ie:

            alias_url = (
                "/sql-ledger/" => "/usr/local/sql-ledger/"
            )


    3. Setup Perl as hander for *.pl files.

            cgi.assign = (
                ".pl" => "/usr/bin/perl"
            )

        Note: server.follow-symlink is on by default in lighttpd.


    4. Deny access to users directory.

            $HTTP["url"] =~ "/sql-ledger/users" {
                url.access-deny = ("")
            }

Re: [SL] Will SQL-Ledger run ok on SuSE 10.2, or, is there any version of PostgreSQL that's too new?

[Joseph A. M. <ja...@jo...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I had some problems with postgres yast online updates running on suse
10.1 - that required some minor tweaking - had to call in my computer
guy - but he quickly fixed it.


www.joemaffia.com



Dirk Enrique Seiffert wrote:
>> Hello,
>>
>> I saw someone mention the other day that they are running SuSE 10.1 and
>> they
>> were having problems after installing SuSE updates because the data was
>> too
>> old for that version of Postgres - or something like that.
>>
>> I have been running an old 1.x version of SQL ledger on SuSE 9.0 for a f=
ew
>> years now, and I am about to make a fresh install and wanted to ask, is
>> there
>> a problem running the latest SQL-Ledger on SuSE 10.2?
>>
>
> We run installations of SQL-Ledger on SUSE 10.1 and OpenSUSE 10.2, no
> problem at all. Migrating an existing installation between different
> postgres versions might cause some haedaches, but this is not related to
> the Linux flavour  you use.
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org

iD8DBQFFznKC1Zo2InkR90QRAnoyAJ4oMNcR6lgUhJcrLE546kPaWOodQACdF7sK
RHn4D0XZfrCHtoZ/AmlqDTg=3D
=3DUfTR
-----END PGP SIGNATURE-----

Re: [SL] Will SQL-Ledger run ok on SuSE 10.2, or, is there any version of PostgreSQL that's too new?

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

> Hello,
>
> I saw someone mention the other day that they are running SuSE 10.1 and
> they
> were having problems after installing SuSE updates because the data was
> too
> old for that version of Postgres - or something like that.
>
> I have been running an old 1.x version of SQL ledger on SuSE 9.0 for a few
> years now, and I am about to make a fresh install and wanted to ask, is
> there
> a problem running the latest SQL-Ledger on SuSE 10.2?
>

We run installations of SQL-Ledger on SUSE 10.1 and OpenSUSE 10.2, no
problem at all. Migrating an existing installation between different
postgres versions might cause some haedaches, but this is not related to
the Linux flavour  you use.

-- 
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] Will SQL-Ledger run ok on SuSE 10.2, or, is there any version of PostgreSQL that's too new?

[R P. <arc...@mt...>]

On Friday 09 February 2007 2:25 pm, Jonathan Wilson wrote:
> Hello,
> 
> I saw someone mention the other day that they are running SuSE 10.1 and they 
> were having problems after installing SuSE updates because the data was too 
> old for that version of Postgres - or something like that.
> 
> I have been running an old 1.x version of SQL ledger on SuSE 9.0 for a few 
> years now, and I am about to make a fresh install and wanted to ask, is there 
> a problem running the latest SQL-Ledger on SuSE 10.2?
> 
> Is there any version of PostgreSQL that is too new?
> 
> Thanks,
> 
> 	JW
> 

The issue of newer versions of Postgresql....
Major version changes of Postgresql require you to backup you data.. do the upgrade.. then restore that data.
this is because the Postgresql developers have been known to change how Postgresql stores the data.
In other words... If you upgrade Postgresql.. the newer version can't read the older version's files.
Do search on the Postgresql site for info on upgrading between versions and it will explain all.

This has nothing to do with SQL-Ledger.

Cheers,
Roy

[SL] Will SQL-Ledger run ok on SuSE 10.2, or, is there any version of PostgreSQL that's too new?

[Jonathan W. <jw...@ma...>]

Hello,

I saw someone mention the other day that they are running SuSE 10.1 and they 
were having problems after installing SuSE updates because the data was too 
old for that version of Postgres - or something like that.

I have been running an old 1.x version of SQL ledger on SuSE 9.0 for a few 
years now, and I am about to make a fresh install and wanted to ask, is there 
a problem running the latest SQL-Ledger on SuSE 10.2?

Is there any version of PostgreSQL that is too new?

Thanks,

	JW

-- 

----------------------
jw...@ma... - System Administrator - Cedar Creek Software

[SL] Manual

[Keith H. <kei...@ba...>]

G'day Dieter,

I've lost the manual I purchased for an older version of SQL-Ledger.
Would you be able to send me the documentation for the last version of 
SQL-Ledger I was registered for?

Thanks

Keith

Re: [SL] unique ID's

[Roy P <or...@sh...>]

On Wednesday 07 February 2007 14:11, C. Duncan Hudson wrote:

> > I wish that:
> >
> > 1) Administrator users could override the tax on vendor invoices
> > 2) That SL allowed you to force unique invoice numbers. A toggle like
> > that of enforce transaction reversal would be good.
>
> I have no logic to prevent duplicate vendor invoices - with hundreds of
> vendors I have to allow for the fact that there will be dups on that
> side of the house. 

Agreed I should have been more specific by saying i wish AR invoice numbers 
were forced to be unique.

FWIW many of the frustrations I've run into with SL could be prevented if 
there was more built in prevention of user errors.

Cheers,
Roy

Re: [SL] unique ID's

[Dieter S. <dsi...@sq...>]

You have the sourcecode, change it, submit a patch and I'll incorporate it 
in the code.

-- 
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 Wed, 7 Feb 2007, C. Duncan Hudson wrote:

> arc...@mt... wrote:
>>> From: "C. Duncan Hudson" <Du...@Du...>
>>> Date: 2007/02/07 Wed AM 11:23:06 CST
>>> To: sql...@li...
>>> Subject: Re: [SL] unique ID's
>>>
>>> Our accountants just about stroked out when they discovered duplicate
>>> invoice numbers in SQL-Ledger.  The official response on this list was
>>> "don't let your users make duplicaes".  Which, I think was a little
>>> poor.  Our users weren't doing it on purpose, but the Post As New
>>> buttons duplicate invoices, quotes, POs, etc verbatim - including the
>>> ID.  I can't imagine why anyone who wasn't cooking their books would
>>> want duplicate invoice numbers, so I added logic to force a new invoice,
>>> quote and PO number assignment if a duplicate existed.
>>>
>>> Dunc
>>>
>>
>> The only reason I've had to use duplicate invoice numbers, was in cases where a vendor's software would not match SL Ledger due to differences on if the tax was calculated on the subtotal or each line item.
>>
>> I would:
>> 1) create an AP transaction (with just the tax difference) using the same number as the vendor invoice in SL.
>> 2) Put a comment in the notes field, about why the transaction existed.
>>
>> By using the same invoice number, a report would group them together.
>>
>>
>> Since then, a kind list member, George Osvald gave me a alternative.
>> http://sourceforge.net/mailarchive/message.php?msg_id=9106581
>> (ignore my misguided reply in the archive.. i misunderstood what he meant)
>>
>>
>> I wish that:
>>
>> 1) Administrator users could override the tax on vendor invoices
>> 2) That SL allowed you to force unique invoice numbers. A toggle like that of enforce transaction reversal would be good.
>>
> I have no logic to prevent duplicate vendor invoices - with hundreds of
> vendors I have to allow for the fact that there will be dups on that
> side of the house. But with my company's documents there can be no
> duplicates - I believe that is basic GAAP. As for tax... Ugh - I wish
> you could override tax throughout the entire application. SQL-Ledger's
> tax logic is the biggest thorn in my side.
>
> Dunc
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier.
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>