sql-ledger-users — SQL-Ledger users

Re: [SL] Cross currency invoice entry

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

Ed,

on 1/25/07 1:10 PM Ed W said the following:
> Dr Eberhard Lisse wrote:
>> The solution is to take the rate you get for buying the USD and to stick
>> the slip to the invoice which you file.
>>
>> I have this occasionally when I pay by credit card. I take the amount
>> that the credit card debits from my account andit is only one simple entry.
>>   
> 
> You said exactly this already - either I don't understand what you are 
> saying or you missed my reply?
> 
> The basics here are that:
> 
> a) The invoice has to get entered today in foreign currency

No, it does *NOT*. Neither today, nor in a foreign currency, nor via AP.


> b) I might not pay the bill for 1-6 months time, hence I won't have an 
> actual rate for it until after a year end of tax quarter.  Therefore I 
> need to account for it on an accrual basis

No, you don't.

> I already entered my first invoice in using the foreign currency, but I 
> am unsure how to pay it... There is a rate option in the payment page 
> when paying a foreign currency invoice, but again it pulls out the 
> generic rate for today (entered using a CRON job) and so again we will 
> have a small FX deviation - I'm just not quite sure how to enter this
> 
> Additionally I am not sure what is going to happen to the cost of goods 
> once I enter the payment - will these be affected or is the rate used 
> only to enter an FX accrual for me automatically?


Since it does not involve local taxes you can do it with a GL entry when
you (eventually) pay.

el

Re: [SL] Cross currency invoice entry

[Ed W <li...@wi...>]

Dr Eberhard Lisse wrote:
> The solution is to take the rate you get for buying the USD and to stick
> the slip to the invoice which you file.
>
> I have this occasionally when I pay by credit card. I take the amount
> that the credit card debits from my account andit is only one simple entry.
>   

You said exactly this already - either I don't understand what you are 
saying or you missed my reply?

The basics here are that:

a) The invoice has to get entered today in foreign currency
b) I might not pay the bill for 1-6 months time, hence I won't have an 
actual rate for it until after a year end of tax quarter.  Therefore I 
need to account for it on an accrual basis

I already entered my first invoice in using the foreign currency, but I 
am unsure how to pay it... There is a rate option in the payment page 
when paying a foreign currency invoice, but again it pulls out the 
generic rate for today (entered using a CRON job) and so again we will 
have a small FX deviation - I'm just not quite sure how to enter this

Additionally I am not sure what is going to happen to the cost of goods 
once I enter the payment - will these be affected or is the rate used 
only to enter an FX accrual for me automatically?

Ed W

Re: [SL] latex and pdf export on debian sarge

[Ashley J G. <sql...@pu...>]

On Thursday 25 January 2007 13:57, Mark Clarke wrote:
> Hi there,
>
>
> I cant get the pdf functionality working on debian. I have done apt-get
> install teext;apt-get instal tetex-extra;  but when re-install
> sql-ledger I still only have the export to html option available.

Sorry if it sounds like a dumb question but one must dot all the i's as they 
say...

have you set

$latex = 1;

in sql-ledger.conf?

Following that, is there anything interesting is the apache error logs? If you 
run "latex -version" what does it give you?

I know little about latex itself, but these steps will be the first to take in 
working out why it's not working for you, and might help others come up with 
some suggestions.

-- 
Regards,
	Ashley J Gittins
	web: 	http://www.purple.dropbear.id.au
	jabber: agi...@pu...

Re: [SL] Cross currency invoice entry

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

The solution is to take the rate you get for buying the USD and to stick
the slip to the invoice which you file.

I have this occasionally when I pay by credit card. I take the amount
that the credit card debits from my account andit is only one simple entry.

el

on 1/24/07 8:48 PM Ed W said the following:
> Dr Eberhard W Lisse wrote:
>> Simple,
>>
>> paste the slip from your USD purchase onto it and account the amount in
>> Sterling. That way even the bank charges get accounted.
>>   
> 
> Well, that's what I used to do, but its getting to be too time consuming 
> to have to recalculate the whole invoice with the new rate.  Also we 
> have 30 days to pay, so the point the rate comes back is usually much, 
> much too late.
> 
> The solution is to pick a rate, then post in an accrual entry to an FX 
> control account, but I just can't quite get my head around the required 
> entries...
> 
> Regards
> 
> Ed W

[SL] latex and pdf export on debian sarge

[Mark C. <ma...@cy...>]

Hi there,


I cant get the pdf functionality working on debian. I have done apt-get
install teext;apt-get instal tetex-extra;  but when re-install
sql-ledger I still only have the export to html option available.

Please help.

regards

Mark

[SL] Upgraded Version Displays Former Number

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

   I upgraded from 2.6.22 to 2.6.23. But the login screen displays the 2.6.22
version number, but with a changed background. /usr/local/sql-ledger/VERSION
contains 2.6.23.

   This just a typo in /usr/local/sql-ledger/SL/Form.pl. I changed the
version string there and the display is now correct.

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] Permissions Error -- SOLVED!!

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

On Tue, 23 Jan 2007, Jason Rodrigues wrote:

> Check the permissions of the apache process:

   Found and fixed the problem.

   To summarize where we left off at the last reel, during my distribution
upgrade a bunch of perl modules went AWOL. Today I grabbed the source for
DBD::Pg-1.49, built, and installed it.

   Then I started looking at the libpq.so libraries and discovered the old
stuff in /usr/local/lib/ I removed them. But, this was after I built
DBD::Pg. That's why when 'ldd Pg.pm' reported using libpq.so.3 I thought
nothing of it. There's a more recent /usr/lib/libpq.so.3.1. That's not the
one to which the perl module pointed.

   So, a repeat performance of 'perl Makefile.PL, make, make test, and make
install' recreated DBD::Pg with the proper library.

   Now, SQL-Ledger lets me log in. Whew!

   Two down, two to go.

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] Permissions Error

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

On Wed, 24 Jan 2007, Rich Shepard wrote:

>    I now have the latest release (1.49) of DBD::Pg installed. Postgres is
> idling away in the background. But, when I try to log into SL I get a
> server error.

> lrwxrwxrwx 1 root root     12 2006-07-06 17:19 /usr/lib/libpq.so ->
> libpq.so.4.1*
> lrwxrwxrwx 1 root root     12 2006-01-27 10:22 /usr/lib/libpq.so.3 ->
> libpq.so.3.1*
> -rwxr-xr-x 1 root root 110586 2006-01-26 09:49 /usr/lib/libpq.so.3.1*
> lrwxrwxrwx 1 root root     12 2006-07-06 17:19 /usr/lib/libpq.so.4 ->
> libpq.so.4.1*
> -rwxr-xr-x 1 root root 111532 2006-05-24 15:06 /usr/lib/libpq.so.4.1*

   More information that I hope helps someone to point me toward a fix for
this problem:

> Method 1: Find the .so module that perl uses (try locate Pg.so and ldd
> that).

 	/lib/libsafe.so.2 (0xb7f76000)
         linux-gate.so.1 =>  (0xffffe000)
         libpq.so.3 => /usr/lib/libpq.so.3 (0xb7f5f000)
         libc.so.6 => /lib/tls/libc.so.6 (0xb7e1a000)
         libdl.so.2 => /lib/tls/libdl.so.2 (0xb7e16000)
         libcrypt.so.1 => /lib/tls/libcrypt.so.1 (0xb7de8000)
         libresolv.so.2 => /lib/tls/libresolv.so.2 (0xb7dd4000)
         libnsl.so.1 => /lib/tls/libnsl.so.1 (0xb7dbd000)
         /lib/ld-linux.so.2 (0x80000000)

So it's finding all the libraries it wants, and it's using the older
libpq.so. Interesting.

   I open a new firefox tab and open http://localhost/sql-ledger/login.pl.
After entering my username and password and pressing [Enter] I get an
internal server error:

"The server encountered an internal error or misconfiguration and was unable
to complete your request.

"Please contact the server administrator, rsh...@ap... and inform
them of the time the error occurred, and anything you might have done that
may have caused the error.

"More information about this error may be available in the server error
log."

   The log file (/var/log/apache/error_log) shows:

[Wed Jan 24 15:01:20 2007] [error] [client 127.0.0.1] Premature end of
script headers: /usr/local/sql-ledger/login.pl

   Also, I installed 2.6.23 over 2.6.22; VERSION reports 2.6.23. But, when I
load login.pl it's the old version number that displays.

   I seem to be going in circles here.

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] Permissions Error

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

On Wed, 24 Jan 2007, Rich Shepard wrote:

>   I tried forcing the installation, but still saw server errors when I
> tried to log in. Since the .cpan directory is root's I'll grab the module
> tarball and install it manually.

>   Stay tuned for further reports. :-)

    I now have the latest release (1.49) of DBD::Pg installed. Postgres is
idling away in the background. But, when I try to log into SL I get a server
error.

[Wed Jan 24 11:46:58 2007] [error] [client 127.0.0.1] Premature end of
script headers: /usr/local/sql-ledger/login.pl
/usr/local/sql-ledger/login.pl: symbol lookup error:
/usr/lib/perl5/site_perl/5.8.8/i486-linux/auto/DBD/Pg/Pg.so: undefined symbol: PQserverVersion

[Wed Jan 24 13:14:12 2007] [error] [client 127.0.0.1] Premature end of
script headers: /usr/local/sql-ledger/login.pl

    The library symbol error is not reported for the latest attempt.

    A Google search for 'PQserverVersion' yields 1,830 hits for postgres bug
#2701. But, further checking reveals that the installed libpq.so* are
sufficiently new:

lrwxrwxrwx 1 root root     12 2006-07-06 17:19 /usr/lib/libpq.so ->
libpq.so.4.1*
lrwxrwxrwx 1 root root     12 2006-01-27 10:22 /usr/lib/libpq.so.3 ->
libpq.so.3.1*
-rwxr-xr-x 1 root root 110586 2006-01-26 09:49 /usr/lib/libpq.so.3.1*
lrwxrwxrwx 1 root root     12 2006-07-06 17:19 /usr/lib/libpq.so.4 ->
libpq.so.4.1*
-rwxr-xr-x 1 root root 111532 2006-05-24 15:06 /usr/lib/libpq.so.4.1*

    My perl installation and modules appear to be current, appropriate, and
correct. Postgres-8.1.4 has been working with SL before. I'm being pointed
in circles, and I don't know just where the problem really is. But, getting
SL working again is critical for me.

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] Cross currency invoice entry

[Ed W <li...@wi...>]

Dr Eberhard W Lisse wrote:
> Simple,
>
> paste the slip from your USD purchase onto it and account the amount in
> Sterling. That way even the bank charges get accounted.
>   

Well, that's what I used to do, but its getting to be too time consuming 
to have to recalculate the whole invoice with the new rate.  Also we 
have 30 days to pay, so the point the rate comes back is usually much, 
much too late.

The solution is to pick a rate, then post in an accrual entry to an FX 
control account, but I just can't quite get my head around the required 
entries...

Regards

Ed W

Re: [SL] Permissions Error

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

On Tue, 23 Jan 2007, Jason Rodrigues wrote:

> Check the permissions of the apache process:
> ps auxww |grep httpd
> or
> ps auxww |grep apache
> The files in that directory should be writable by that user.

Hi, Jason!

   After a lot of hard work, I've turned this into a postgres problem. I had
some crufty old libpq.so in /usr/local/lib/ from 2003 and 2004. So I got rid
of those, ran 'ldconfig,' retarted httpd and postgresql. Oops! The latter
didn't start. That's what /var/log/apache/error_log says, too.

   I broke something in postgres. While '/etc/rc.d/rc.postgesql start'
reports 'OK,' '/etc/rc.d/rc.postgresql status' reports 'pg_ctl: neither
postmaster nor postgres running.'

   I made sym links from /usr/lib/libpq.so* to /usr/local/lib/, but that
hasn't helped. Now it's time to ask the fine folks on the postgres mail list
for help.

Thanks,

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

[SL] Error: Could not decompress sql-ledger-2.6.23.tar.gz

[Mark C. <Ma...@Ju...>]

Hi all,

No matter which mirror I use I get this error. Is anyone else having
upgrade problems?


regards

Mark

Re: [SL] Cross currency invoice entry

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

Simple,

paste the slip from your USD purchase onto it and account the amount in
Sterling. That way even the bank charges get accounted.

el

Ed W wrote:
> Bump...
> 
> ...Anyone...?  How to enter foreign currency invoices..?
> 
> Ed W
> 
> 
> Ed W wrote:
>> OK, so I have only sterling bank accounts, but I have an invoice from a 
>> supplier in USD.  I go to the bank and buy dollars using sterling and 
>> then wire the money to the beneficiary
>>
>> ....Now how to best enter this into the accounts system..?
>>
>> I had previously been taking the rate that I got on my USD transaction 
>> and converting the invoice into stering at this rate, but it's awkward 
>> and error prone.  I now want to use the accrual type system and an FX 
>> account.
>>
>> So I enter in the invoices in USD.  I then use the "payment" function to 
>> pay the invoice in USD, which I believe will leave me with a calculated 
>> GBP amount against my cash account.  Now the remaining bit is how to 
>> post the balancing item into an FX reserve account so that the correct 
>> amount of GBP is shown...?
>>
>> Can anyone talk me through the best way to do this last step please?
>>
>> Cheers
>>
>> Ed W
>>
>>
>> -------------------------------------------------------------------------
>> 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=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Permissions Error

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

On Tue, 23 Jan 2007, Dieter Simader wrote:

> if you compile as root you run into a problem during the test phase
> because root cannot connect to the postgres server. ignore the error and
> proceed with 'make install'. It works even though the tests failed.

Dieter,

   I tried forcing the installation, but still saw server errors when I tried
to log in. Since the .cpan directory is root's I'll grab the module tarball
and install it manually.

   Stay tuned for further reports. :-)

Thanks,

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] Cross currency invoice entry

[Ed W <li...@wi...>]

Bump...

...Anyone...?  How to enter foreign currency invoices..?

Ed W


Ed W wrote:
> OK, so I have only sterling bank accounts, but I have an invoice from a 
> supplier in USD.  I go to the bank and buy dollars using sterling and 
> then wire the money to the beneficiary
>
> ....Now how to best enter this into the accounts system..?
>
> I had previously been taking the rate that I got on my USD transaction 
> and converting the invoice into stering at this rate, but it's awkward 
> and error prone.  I now want to use the accrual type system and an FX 
> account.
>
> So I enter in the invoices in USD.  I then use the "payment" function to 
> pay the invoice in USD, which I believe will leave me with a calculated 
> GBP amount against my cash account.  Now the remaining bit is how to 
> post the balancing item into an FX reserve account so that the correct 
> amount of GBP is shown...?
>
> Can anyone talk me through the best way to do this last step please?
>
> Cheers
>
> Ed W
>
>
> -------------------------------------------------------------------------
> 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
>   

Re: [SL] Permissions Error

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

On Tue, 23 Jan 2007 20:32:42 -0800 (PST), Rich Shepard wrote
> On Wed, 24 Jan 2007, Ashley J Gittins wrote:
>
>    Unfortunately, trying to re-install DBD::Pg fails because one or more
> tests fail. I need to contact a perl expert to learn how to overcome 
> that.

if you compile as root you run into a problem during the test phase because 
root cannot connect to the postgres server. ignore the error and proceed with 
'make install'. It works even though the tests failed.

Dieter Simader

Re: [SL] Permissions Error

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

On Wed, 24 Jan 2007, Ashley J Gittins wrote:

> 	In the doc subdirectory you will find instructions for each version's
> upgrade. Essentially the bit you need to do is (do this from the root of your
> sl install, eg /usr/local/sql-ledger/):
>
> 2. fix permissions
>   # chown -hR nobody:nogroup *
>   # chmod 711 templates users css spool

Ashley,

   Well, I missed that because permissions were not changed in prior
upgrades.

> Note: replace nobody:nogroup with your web server user and group

   According to /etc/apache/httpd.conf, it's nobody.nobody. But, that gave me
an internal server error when I tried to log in. So, I changed the group to
to nogroup and now I get other access denied errors.

> Ultimately I think your problem is that the config file is owned by
> yourself, not apache, but you'll have other issues if you don't fix the
> whole lot by doing to two steps above (note that the first step sets
> ownership recursively, so will include your conf file etc).

   No, it's more insiduous. When I upgraded my system from Slackware-10.2 to
-11.0 a bunch of perl modules went missing for some reason. So, I took a
look at /var/log/apache/error_log and saw this:

[root@salmo ~]# tail -f /var/log/apache/error_log
  at SL/User.pm line 117
Compilation failed in require at /usr/local/sql-ledger/login.pl line 99.
[Tue Jan 23 20:17:59 2007] [error] [client 127.0.0.1] Premature end of
script headers: /usr/local/sql-ledger/login.pl
install_driver(Pg) failed: Can't locate DBD/Pg.pm in @INC (@INC contains:
/usr/lib/perl5/5.8.8/i486-linux /usr/lib/perl5/5.8.8
/usr/lib/perl5/site_perl/5.8.8/i486-linux /usr/lib/perl5/site_perl/5.8.8
/usr/lib/perl5/site_perl .) at (eval 10) line 3.
Perhaps the DBD::Pg perl module hasn't been fully installed,
or perhaps the capitalisation of 'Pg' isn't right.
Available drivers: DBM, ExampleP, File, Proxy, Sponge, mysql.
  at SL/User.pm line 117
Compilation failed in require at /usr/local/sql-ledger/login.pl line 99.
[Tue Jan 23 20:20:42 2007] [error] [client 127.0.0.1] Premature end of
script headers: /usr/local/sql-ledger/login.pl

   Unfortunately, trying to re-install DBD::Pg fails because one or more
tests fail. I need to contact a perl expert to learn how to overcome that.
>From the log, it appears that when I get the module re-installed I'll be
able to log in. If not, I'll be back. :-)

Many thanks,

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] Permissions Error

[Ashley J G. <sql...@pu...>]

Hi Rich,
	In the doc subdirectory you will find instructions for each version's 
upgrade. Essentially the bit you need to do is (do this from the root of your 
sl install, eg /usr/local/sql-ledger/):

2. fix permissions
   # chown -hR nobody:nogroup *
   # chmod 711 templates users css spool

Note: replace nobody:nogroup with your web server user and group


So if apache runs as "apache" then you do chown -hR apache:apache *

Ultimately I think your problem is that the config file is owned by yourself, 
not apache, but you'll have other issues if you don't fix the whole lot by 
doing to two steps above (note that the first step sets ownership 
recursively, so will include your conf file etc).

-- 
Regards,
	Ashley J Gittins
	web: 	http://www.purple.dropbear.id.au
	jabber: agi...@pu...


On Wednesday 24 January 2007 08:43, Rich Shepard wrote:
> On Tue, 23 Jan 2007, Rich Shepard wrote:
> >   That's what I tried. /usr/local/sql-ledger/users has permissions 777
> > (rwxrwxrwx). The files in that directory -- specifically rshepard.conf --
> > is owned by me and has 755 permissions (rwxr-xr-x). /usr/local/sql-ledger
> > is owned by root.root with 755 permissions.
>
>    I also forgot to write that immediately after upgrading sql-ledger from
> -2.6.21 to -2.6.22 I logged in to ensure that the application upgrade
> caused no problems.
>
> Rich

Re: [SL] Permissions Error

[Jason R. <jas...@gm...>]

On Tuesday 23 January 2007 17:41, Rich Shepard wrote:
>    That's what I tried. /usr/local/sql-ledger/users has permissions 777
> (rwxrwxrwx). The files in that directory -- specifically rshepard.conf --
> is owned by me and has 755 permissions (rwxr-xr-x). /usr/local/sql-ledger
> is owned by root.root with 755 permissions.


Check the permissions of the apache process:

ps auxww |grep httpd

or 

ps auxww |grep apache

The files in that directory should be writable by that user.

Re: [SL] Permissions Error

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

On Tue, 23 Jan 2007, Rich Shepard wrote:

>   That's what I tried. /usr/local/sql-ledger/users has permissions 777
> (rwxrwxrwx). The files in that directory -- specifically rshepard.conf --
> is owned by me and has 755 permissions (rwxr-xr-x). /usr/local/sql-ledger
> is owned by root.root with 755 permissions.

   I also forgot to write that immediately after upgrading sql-ledger from
-2.6.21 to -2.6.22 I logged in to ensure that the application upgrade caused
no problems.

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] Permissions Error

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

On Tue, 23 Jan 2007, Lenny Leblanc wrote:

> Check the permissions on the users directory and make sure the apache
> user/group has access (rwx).

Lenny,

   That's what I tried. /usr/local/sql-ledger/users has permissions 777
(rwxrwxrwx). The files in that directory -- specifically rshepard.conf -- is
owned by me and has 755 permissions (rwxr-xr-x). /usr/local/sql-ledger is
owned by root.root with 755 permissions.

   This is a new one on me.

Thanks,

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] Permissions Error

[Lenny L. <lle...@ma...>]

Check the permissions on the users directory and make sure the apache
user/group has access (rwx).

--
Lenny Leblanc
=20
628 Leila Avenue
Winnipeg, Manitoba  R2V 3N7
P: 204.338.0233
=20
-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of
Rich Shepard
Sent: Tuesday, January 23, 2007 4:20 PM
To: sql...@li...
Subject: [SL] Permissions Error

   I recently upgraded my system and now get this error when I try to
log in:

Error!
users/rshepard.conf : Permission denied

   What should be the ownership and permissions on
/usr/local/sql-ledger/users? It's owned by nobody.nogroup and had perms
of
755. I changed those to 777 but to no avail.

Thanks,

Rich

--=20
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

------------------------------------------------------------------------
-
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=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDE
V
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

[SL] Permissions Error

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

   I recently upgraded my system and now get this error when I try to log in:

Error!
users/rshepard.conf : Permission denied

   What should be the ownership and permissions on
/usr/local/sql-ledger/users? It's owned by nobody.nogroup and had perms of
755. I changed those to 777 but to no avail.

Thanks,

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

[SL] R: error message

[Gianluca C. <gc...@pe...>]

Did you do any automatic/manual updates on your system involving
postgresql?
What kind of linux ditro/version?

Re: [SL] accounting question

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

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

glad to help - and I figured out my problem.

I use suse 10.1 and whenever I do an online upgrade it screws up
sql-ledger. The data was in an older postgres format then expected by
the program. My computer guy fixed it.


www.joemaffia.com



Michael Hasse wrote:
> Thank you Joseph!
>     We went through the chart of accounts with our CPA and that's =

> what he said as well.
>     I'll add some more detail here in case anyone else is ever =

> searching.  We created an account under Current Assets and just =

> called it "Distributions" with the Account Type set to "Equity".  We =

> then reposted the distribution GL entries using it instead of the =

> wage expense account.
>
>
> On Jan 22, 2007, at 4:24 PM, Joseph A. Maffia wrote:
>
>> Someone posted an accounting question last week about distributions =

>> for an us s corp.
>>
>> Distributions should be shown as a seperate equity account. =

>> Therefore it won't affect the profit and loss and you can close it =

>> out the previous year against retained earnings.
>>
>>
>>
>> ----------------------------------------------------------------------
>> ---
>> 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=3Djoin.php&p=3Dsourceforge&CID=3DDEVDEV
>> _______________________________________________
>> 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=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org

iD8DBQFFtaH71Zo2InkR90QRAphbAJ91UUBl3RTpG5lRMQezWyGDjx0ZXgCfRPwN
+rtU/QBZndiv8K2QIAU4CXQ=3D
=3Dzxsv
-----END PGP SIGNATURE-----