sql-ledger-users — SQL-Ledger users

[SL] Tracking Down Printing Problem

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

   This is a new one on me: I set up a bunch of payables (using the
Cash->Payments menu), then try to print them directly to the printer.
Nothing happens.

   If I select each check individually and print it to the screen (as a .ps
file that's saved to disk), I can use lpr to print the check from the disk
file.

   Printing is working, but SL (2.8.18) has suddenly decided to not see the
printer. What should I do to trace the source of the problem so I can fix
it?

Rich

-- 
Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

[SL] Inventory issue: quantity on hand does not change

[<li...@mu...>]

Hello,

I do not keep inventory on hand, but purchase as I need it.  I saw a similar post in the archives, and tried to follow it, but while the part goes into my inventory, I cannot seem to make the "balance" I owe tot he vendor go to $0, nor reduce the iventory when i add it to an order/invoice.  Here is the workflow I did; maybe I missed something out?

  1.) Created a part# for the part that I purchased (filled in list price, description, etc.)
  2.) Created a Purchase Order
      a.) filled in the quantity I purchased, the quantity received (which is the same as purchased), the unit, and the price
      b.) I then save the PO
  3.) Create Vendor Invoice
      a.) Fill in part number, quantity, part number, and price
      b.) Down at the bottom, I fill in payment information (date, source, amount paid, account payment was from)
      c.) I then Post
  4.) Create Sales Order
      a.) Add part number, quantity sold, price charged
      b.) I then Save
  5.) Create Sales Invoice
      a.) Created from Sales Order
      b.) Post and send to client

After I create the invoice, if I look at "Goods & Services > Reports > Parts" and select the part I just added and sold from the list that comes up, it still shows that I have 1 item on hand.  Even after an invoice is paid, the quantity on hand still does not go down.

I know I must be missing something, but I do not know what.  If someone can let me know what the correct workflow should be, that would be appreciated.  Alternatively, if there is a better way to do this, that would be appreciated too (maybe I don't have to do a PO since I do one-off purchases?)

Thanks, in advance, for your help.

-Alan

Re: [SL] Printing error

[Nicholas T. O. <brn...@os...>]

Thank you so much for the help. I think the entire system has problems
and I should have known not to update one OS with another, although SLED
and openSuse are both Novell. I have done a complete installation and it
is running the updates now. I will next need to install a fresh copy of
SQL. I hope this will work and I don't think there will be problems
because I have data backups. 

Nicholas Thirkettle
Saint Joseph Monastery
Natchez, Mississippi


On Tue, 2008-12-16 at 13:45 -0800, Rich Shepard wrote:
> On Tue, 16 Dec 2008, Nicholas Thirkettle OSB wrote:
> 
> > panic: attempt to copy freed scalar 1435040 to 8e16e8 at SL/Form.pm line
> > 984
> 
>    That line follows a function. However, since I find perl quite opaque I
> cannot tell you what's being done here.
> 
> > I have no idea about how to resolve this.
> 
>    Form.pm is a perl module. The installed version may be outdated relative
> to the perl version installed in your upgrade. If you can use CPAN, try
> installing the latest version:
> 
> (as root)# perl -CPAN -e shell
> <cpan> install Form
> 
> then follow instructions.
> 
>    You might also consider upgrading to SQL-Ledger 2.8.18 if you're not
> already there.
> 
>    As a last resort, wait for someone with more expertise and insight to
> guide you to a solution.
> 
> Good luck,
> 
> Rich
> 

Re: [SL] Printing error

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

On Tue, 16 Dec 2008, Nicholas Thirkettle OSB wrote:

> panic: attempt to copy freed scalar 1435040 to 8e16e8 at SL/Form.pm line
> 984

   That line follows a function. However, since I find perl quite opaque I
cannot tell you what's being done here.

> I have no idea about how to resolve this.

   Form.pm is a perl module. The installed version may be outdated relative
to the perl version installed in your upgrade. If you can use CPAN, try
installing the latest version:

(as root)# perl -CPAN -e shell
<cpan> install Form

then follow instructions.

   You might also consider upgrading to SQL-Ledger 2.8.18 if you're not
already there.

   As a last resort, wait for someone with more expertise and insight to
guide you to a solution.

Good luck,

Rich

-- 
Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

[SL] Printing error

[Nicholas T. O. <brn...@os...>]

I am having a problem printing. When I try to print an invoice I get the
following error:

panic: attempt to copy freed scalar 1435040 to 8e16e8 at SL/Form.pm line
984

I have no idea about how to resolve this.

I had been using Suse Linux Enterprise Desktop 10, SP 2. Yesterday my
entire file system went to read only so I updated to openSuse 11.0,
which fixed the read-only problem. Now I have this problem and I'm
afraid I will not be able to print checks tomorrow. Any help is greatly
appreciated. Thank you.

Nicholas Thirkettle, OSB
Saint Joseph Monastery
Natchez, Mississippi

Re: [SL] one check, multiple invoices

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

We'll take another look, thanks for the heads up!


On Dec 9, 2008, at 10:29 AM, Jeff Roberts wrote:

Hi Michael

One total balance for each customer? That's not what I get.

When I click Cash, receipts, update I get a listing that includes  
every invoice owing to me. If customer ABC owes on five invoices they  
are all listed there

ABC Canada Ltd.      5202      10-10-2008      730.03      730.03

                                    5197     10-10-2008       931.21
931.21
                                    5201     10-10-2008      2,799.37
2,799.37
                                     5196     10-10-2008     1,751.05
1,751.05
                                     5198     10-10-2008     301.21
301.21
                                     5199     10-10-2008     790.09
790.09

If they sent a cheque that pays the first three and the last two I just
click on the radio boxes for those five invoices put the cheque number
into the source box and then hit enter, it leaves the middle one out and
applies that cheque number to the other five. No Problem, all done in
one step.

If your customer sends individual cheques then you need to use receipt
instead of receipts but that's not SQLs fault that's your customers  
fault.

Jeff

Michael Hasse wrote:
> Got all that, (I think), the problem is that it's just one total
> balance given for each customer.  So if the customer has 5
> outstanding invoices and either sends individual checks for each one,
> or sends a single check for just four of them, (with the odd one
> invariably in the middle of course), then this doesn't work.  If it
> simply had a check box to enable a more detailed, (per outstanding
> invoice), listing then it would be fine.
>     Similarly it would be nice if the plain Receipt screen had check
> info per line item as well instead of just a single entry at the
> top.  Some of our customers run their AP with a separate check for
> every invoice.  Kinds sucks when they're paying for a dozen items -
> we have to wait for every single one to post individually because
> even though they're all on from the same check-run on the customer
> end and deposited the same day on our end, they're still different
> check numbers so have to be entered and applied separately.
>     (CC'ing Dieter here on the off-chance nobody's ever thought to
> ask about this before.)
>
>
> Thanks,
>
> Michael
>
>


------------------------------------------------------------------------ 
------
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas,  
Nevada.
The future of the web can't happen without you.  Join us at MIX09 to  
help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http:// 
2009.visitmix.com/
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Cannot Access SL -- UPDATE

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

On Tue, 9 Dec 2008, Rich Shepard wrote:

>   Upgraded the distribution (to Slackware-12.1) and now I can no longer load
> SL in the browser.

   Getting closer! The /etc/apache/ directory (and the apache package) has
been replaced by /etc/httpd/ and the httpd package. I needed to move the
sql-ledger specific files there and include them in httpd.conf.

   This done, I can now access the login.pl page, but after entering my
username and password I see:

Error!
users/rshepard.conf : Permission denied

   Permissions on this file are 644, and it's owned by nobody.nobody.

   If I try to access the admin.pl page I get:

Error!
No Database Drivers available!

   Not sure what to do now that I've gotten this far.

Rich

-- 
Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

Re: [SL] one check, multiple invoices

[Jeff R. <je...@jr...>]

Hi Michael

One total balance for each customer? That's not what I get.

When I click Cash, receipts, update I get a listing that includes every invoice owing to me. If customer ABC owes on five invoices they are all listed there 

ABC Canada Ltd.      5202      10-10-2008      730.03      730.03      
           
                                   5197     10-10-2008       931.21     
931.21                    
                                   5201     10-10-2008      2,799.37     
2,799.37                    
                                    5196     10-10-2008     1,751.05     
1,751.05                    
                                    5198     10-10-2008     301.21     
301.21                    
                                    5199     10-10-2008     790.09     
790.09                    
    
If they sent a cheque that pays the first three and the last two I just 
click on the radio boxes for those five invoices put the cheque number 
into the source box and then hit enter, it leaves the middle one out and 
applies that cheque number to the other five. No Problem, all done in 
one step.

If your customer sends individual cheques then you need to use receipt 
instead of receipts but that's not SQLs fault that's your customers fault.

Jeff

Michael Hasse wrote:
> Got all that, (I think), the problem is that it's just one total  
> balance given for each customer.  So if the customer has 5  
> outstanding invoices and either sends individual checks for each one,  
> or sends a single check for just four of them, (with the odd one  
> invariably in the middle of course), then this doesn't work.  If it  
> simply had a check box to enable a more detailed, (per outstanding  
> invoice), listing then it would be fine.
>     Similarly it would be nice if the plain Receipt screen had check  
> info per line item as well instead of just a single entry at the  
> top.  Some of our customers run their AP with a separate check for  
> every invoice.  Kinds sucks when they're paying for a dozen items -  
> we have to wait for every single one to post individually because  
> even though they're all on from the same check-run on the customer  
> end and deposited the same day on our end, they're still different  
> check numbers so have to be entered and applied separately.
>     (CC'ing Dieter here on the off-chance nobody's ever thought to  
> ask about this before.)
>
>
> Thanks,
>
> Michael
>
>   

[SL] Cannot Access SL

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

   Upgraded the distribution (to Slackware-12.1) and now I can no longer load
SL in the browser.

   httpd is running. The postgresql postmaster is running. When I enter the
URL 'http://localhost/sql-ledger/login.pl' I see:

Not Found

The requested URL /sql-ledger/admin.pl was not found on this server.

   I know this has come up before, but I don't have a saved message with the
solution, and I need to access SL right away.

TIA,

Rich

-- 
Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

Re: [SL] one check, multiple invoices

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

Got all that, (I think), the problem is that it's just one total  
balance given for each customer.  So if the customer has 5  
outstanding invoices and either sends individual checks for each one,  
or sends a single check for just four of them, (with the odd one  
invariably in the middle of course), then this doesn't work.  If it  
simply had a check box to enable a more detailed, (per outstanding  
invoice), listing then it would be fine.
    Similarly it would be nice if the plain Receipt screen had check  
info per line item as well instead of just a single entry at the  
top.  Some of our customers run their AP with a separate check for  
every invoice.  Kinds sucks when they're paying for a dozen items -  
we have to wait for every single one to post individually because  
even though they're all on from the same check-run on the customer  
end and deposited the same day on our end, they're still different  
check numbers so have to be entered and applied separately.
    (CC'ing Dieter here on the off-chance nobody's ever thought to  
ask about this before.)


Thanks,

Michael

On Dec 9, 2008, at 5:55 AM, David Boyle wrote:

On Mon, 2008-12-08 at 17:17 -0800, Michael Hasse wrote:
> The only problem with Receipts, (vs Receipt), is that it doesn't
> break out the detail.  In an ongoing client relationship how often
> does one get a single check which actually covers all outstanding
> balances?  We never use it just because of that, it's actually easier
> to enter them one at a time via Receipt.
>     Now if there was something like a combined version of the two
> screens, which showed all outstanding balances for all clients AND
> allowed multiple check entries, (one per balance), that would be
> GREAT!  But it's probably pretty far down on Dieter's priority
> list...  :
Using Cash--> Receipts and hit update.  For me this brings up all
customer with a balance due with a field for Amount (rarely need to
enter anything here), Memo & Source as well as radio check boxes for
which items you are applying.  In my operation I'll often process 20 -
30 checks in a batch and this method allows me to knock them out quick.
The radio boxes are the trick...maybe something missing in one of your
templates?  I am still using 2.6.22.

David Boyle


> Thanks,
>
> Michael
>
>
>
> On Dec 1, 2008, at 10:58 AM, David Boyle wrote:
>
> On Mon, 2008-12-01 at 10:18 -0600, Myk Robinson wrote:
>> What is the proper way to enter one check that covers several
>> invoices? I
>> think that the "Receipt" option is right, but need clarification on
>> how to
>> enter this.
>
> RECEIPT is indeed correct.  Select the customer and hit update.   
> Source
> would be the check number or whatever then use the check boxes to  
> select
> which invoices you are applying to.  Once you have them selected, hit
> update again and SL should calculate for you.  Make sure your amounts
> match before hitting post.  If you are doing a large batch for more  
> than
> one customer, RECEIPTS is a great feature.
>
> HTH,
> David Boyle
>
>
>
>> Thanks,
>> -myk
>>
>> --------------------------------------------------------------------- 
>> -
>> ---
>> This SF.Net email is sponsored by the Moblin Your Move Developer's
>> challenge
>> Build the coolest Linux based applications with Moblin SDK & win
>> great prizes
>> Grand prize is a trip for two to an Open Source event anywhere in
>> the world
>> http://moblin-contest.org/redirect.php?banner_id=100&url=/
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
> ---------------------------------------------------------------------- 
> --
> -
> This SF.Net email is sponsored by the Moblin Your Move Developer's
> challenge
> Build the coolest Linux based applications with Moblin SDK & win
> great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the
> world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
> ---------------------------------------------------------------------- 
> --------
> SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas,  
> Nevada.
> The future of the web can't happen without you.  Join us at MIX09  
> to help
> pave the way to the Next Web now. Learn more and register at
> http://ad.doubleclick.net/clk;208669438;13503038;i?http:// 
> 2009.visitmix.com/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users


------------------------------------------------------------------------ 
------
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas,  
Nevada.
The future of the web can't happen without you.  Join us at MIX09 to  
help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http:// 
2009.visitmix.com/
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] one check, multiple invoices

[David B. <dav...@sb...>]

On Mon, 2008-12-08 at 17:17 -0800, Michael Hasse wrote:
> The only problem with Receipts, (vs Receipt), is that it doesn't  
> break out the detail.  In an ongoing client relationship how often  
> does one get a single check which actually covers all outstanding  
> balances?  We never use it just because of that, it's actually easier  
> to enter them one at a time via Receipt.
>     Now if there was something like a combined version of the two  
> screens, which showed all outstanding balances for all clients AND  
> allowed multiple check entries, (one per balance), that would be  
> GREAT!  But it's probably pretty far down on Dieter's priority  
> list...  :
Using Cash--> Receipts and hit update.  For me this brings up all
customer with a balance due with a field for Amount (rarely need to
enter anything here), Memo & Source as well as radio check boxes for
which items you are applying.  In my operation I'll often process 20 -
30 checks in a batch and this method allows me to knock them out quick.
The radio boxes are the trick...maybe something missing in one of your
templates?  I am still using 2.6.22.

David Boyle


> Thanks,
> 
> Michael
> 
> 
> 
> On Dec 1, 2008, at 10:58 AM, David Boyle wrote:
> 
> On Mon, 2008-12-01 at 10:18 -0600, Myk Robinson wrote:
> > What is the proper way to enter one check that covers several  
> > invoices? I
> > think that the "Receipt" option is right, but need clarification on  
> > how to
> > enter this.
> 
> RECEIPT is indeed correct.  Select the customer and hit update.  Source
> would be the check number or whatever then use the check boxes to select
> which invoices you are applying to.  Once you have them selected, hit
> update again and SL should calculate for you.  Make sure your amounts
> match before hitting post.  If you are doing a large batch for more than
> one customer, RECEIPTS is a great feature.
> 
> HTH,
> David Boyle
> 
> 
> 
> > Thanks,
> > -myk
> >
> > ---------------------------------------------------------------------- 
> > ---
> > This SF.Net email is sponsored by the Moblin Your Move Developer's  
> > challenge
> > Build the coolest Linux based applications with Moblin SDK & win  
> > great prizes
> > Grand prize is a trip for two to an Open Source event anywhere in  
> > the world
> > http://moblin-contest.org/redirect.php?banner_id=100&url=/
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> 
> 
> ------------------------------------------------------------------------ 
> -
> This SF.Net email is sponsored by the Moblin Your Move Developer's  
> challenge
> Build the coolest Linux based applications with Moblin SDK & win  
> great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the  
> world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> 
> 
> ------------------------------------------------------------------------------
> SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
> The future of the web can't happen without you.  Join us at MIX09 to help
> pave the way to the Next Web now. Learn more and register at
> http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Cannot Access SL

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

On 月, 2008-12-08 at 19:38 -0800, Rich Shepard wrote:
> Upgraded the distribution (to Slackware-12.1) and now I can no longer load
> SL in the browser.
> 
>    httpd is running. The postgresql postmaster is running. When I enter the
> URL 'http://localhost/sql-ledger/login.pl' I see:
> 
> Not Found
> 
> The requested URL /sql-ledger/admin.pl was not found on this server.
> 
>    I know this has come up before, but I don't have a saved message with the
> solution, and I need to access SL right away.

Hmm. I'm no expert, but I would guess that you don't have 
Include /etc/apache2/sql-ledger-httpd.conf
in your /etc/apache2/httpd.conf

either that or you don't have sql-ledger-httpd.conf (less likely)
-- 
Stuart Luppescu -=- s-luppescu .at. uchicago.edu        
University of Chicago (^_^)/ CCSR 
才文と智奈美の父 -=-=- Kernel 2.6.25-gentoo-r
But what can you do with it?  -- ubiquitous cry
 from Linux-user partner. (Submitted by Andy
 Pearce, aj...@hp...) 
 
 

[SL] Cannot Access SL

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

   Upgraded the distribution (to Slackware-12.1) and now I can no longer load
SL in the browser.

   httpd is running. The postgresql postmaster is running. When I enter the
URL 'http://localhost/sql-ledger/login.pl' I see:

Not Found

The requested URL /sql-ledger/admin.pl was not found on this server.

   I know this has come up before, but I don't have a saved message with the
solution, and I need to access SL right away.

TIA,

Rich

-- 
Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

Re: [SL] one check, multiple invoices

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

The only problem with Receipts, (vs Receipt), is that it doesn't  
break out the detail.  In an ongoing client relationship how often  
does one get a single check which actually covers all outstanding  
balances?  We never use it just because of that, it's actually easier  
to enter them one at a time via Receipt.
    Now if there was something like a combined version of the two  
screens, which showed all outstanding balances for all clients AND  
allowed multiple check entries, (one per balance), that would be  
GREAT!  But it's probably pretty far down on Dieter's priority  
list...  :/


Thanks,

Michael



On Dec 1, 2008, at 10:58 AM, David Boyle wrote:

On Mon, 2008-12-01 at 10:18 -0600, Myk Robinson wrote:
> What is the proper way to enter one check that covers several  
> invoices? I
> think that the "Receipt" option is right, but need clarification on  
> how to
> enter this.

RECEIPT is indeed correct.  Select the customer and hit update.  Source
would be the check number or whatever then use the check boxes to select
which invoices you are applying to.  Once you have them selected, hit
update again and SL should calculate for you.  Make sure your amounts
match before hitting post.  If you are doing a large batch for more than
one customer, RECEIPTS is a great feature.

HTH,
David Boyle



> Thanks,
> -myk
>
> ---------------------------------------------------------------------- 
> ---
> This SF.Net email is sponsored by the Moblin Your Move Developer's  
> challenge
> Build the coolest Linux based applications with Moblin SDK & win  
> great prizes
> Grand prize is a trip for two to an Open Source event anywhere in  
> the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users


------------------------------------------------------------------------ 
-
This SF.Net email is sponsored by the Moblin Your Move Developer's  
challenge
Build the coolest Linux based applications with Moblin SDK & win  
great prizes
Grand prize is a trip for two to an Open Source event anywhere in the  
world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

[SL] perl crash when posting transactions

[Andreas J. <in...@be...>]

Hi,

I have SQL-Ledger up and running on my Mac, however, when I submit a 
form (post a transaction) I get the 500 Inernal Server Error. The 
transaction will be posted into the database, but it is annoying.

Details:
MacOS X 10.4.11
Apache/1.3.41 (Darwin)
Perl v5.8.8 built for darwin-thread-multi-2level

httpd error_log:
----------------------
Processing config directory: /private/etc/httpd/users/*.conf
  Processing config file: /private/etc/httpd/users/beeandy.conf
  Processing config file: /private/etc/httpd/users/postgres.conf
  Processing config file: /private/etc/httpd/users/postgresql.conf
  Processing config file: /private/etc/httpd/users/sql-ledger.conf
[Sun Dec  7 23:07:57 2008] [alert] httpd: Could not determine the 
server's fully qualified domain name, using 127.0.0.1 for ServerName
[Sun Dec  7 23:07:57 2008] [notice] Apache/1.3.41 (Darwin) configured 
-- resuming normal operations
[Sun Dec  7 23:07:57 2008] [notice] Accept mutex: flock (Default: flock)
[Sun Dec  7 23:08:38 2008] [error] [client 127.0.0.1] Premature end 
of script headers: /Library/WebServer/Documents/sql-ledger/gl.pl

console.log:
----------------
Processing config directory: /private/etc/httpd/users/*.conf
  Processing config file: /private/etc/httpd/users/beeandy.conf
  Processing config file: /private/etc/httpd/users/postgres.conf
  Processing config file: /private/etc/httpd/users/postgresql.conf
  Processing config file: /private/etc/httpd/users/sql-ledger.conf
[Sun Dec  7 23:07:56 2008] [alert] httpd: Could not determine the 
server's fully qualified domain name, using 127.0.0.1 for ServerName
/usr/sbin/apachectl start: httpd started
Dec  7 23:08:38 PowerBookG4 crashdump[21402]: perl crashed
Dec  7 23:08:39 PowerBookG4 crashdump[21402]: crash report written 
to: /Library/Logs/CrashReporter/perl.crash.log

perl.crash.log:
-------------------
Host Name:      PowerBookG4
Date/Time:      2008-12-07 23:08:37.336 +0100
OS Version:     10.4.11 (Build 8S165)
Report Version: 4

Command: perl
Path:    /usr/bin/perl
Parent:  httpd [21343]

Version: ??? (???)

PID:    21399
Thread: 0

Exception:  EXC_BAD_ACCESS (0x0001)
Codes:      KERN_PROTECTION_FAILURE (0x0002) at 0x00000000

Thread 0 Crashed:
0   libSystem.B.dylib        	0x90131280 bcmp + 224
1   com.apple.CoreFoundation 	0x907f4640 __CFInitialize + 420
2   dyld                     	0x8fe155e0 
ImageLoaderMachO::doInitialization(ImageLoader::LinkContext const&) + 
672
3   dyld                     	0x8fe0babc 
ImageLoader::recursiveInitialization(ImageLoader::LinkContext const&) 
+ 212
4   dyld                     	0x8fe0ba4c 
ImageLoader::recursiveInitialization(ImageLoader::LinkContext const&) 
+ 100
5   dyld                     	0x8fe0ba4c 
ImageLoader::recursiveInitialization(ImageLoader::LinkContext const&) 
+ 100
6   dyld                     	0x8fe0ba4c 
ImageLoader::recursiveInitialization(ImageLoader::LinkContext const&) 
+ 100
7   dyld                     	0x8fe0dcdc 
ImageLoader::link(ImageLoader::LinkContext const&, 
ImageLoader::BindingLaziness, ImageLoader::InitializerRunning, 
unsigned) + 468
8   dyld                     	0x8fe04070 dyld::link(ImageLoader*, 
ImageLoader::BindingLaziness, ImageLoader::InitializerRunning) + 380
9   dyld                     	0x8fe09b00 dlopen + 316
10  libSystem.B.dylib        	0x900310f4 dlopen + 96
11  perl                     	0x00002cfc 0x1000 + 7420
12  libperl.dylib            	0x97a2c8a8 Perl_pp_entersub + 1292
13  libperl.dylib            	0x97a251d0 Perl_runops_standard + 64
14  libperl.dylib            	0x979d15fc S_run_body + 308
15  libperl.dylib            	0x979d1258 perl_run + 164
16  perl                     	0x000029b8 0x1000 + 6584
17  perl                     	0x00002120 0x1000 + 4384
18  perl                     	0x00001fc0 0x1000 + 4032

Thread 0 crashed with PPC Thread State 64:
   srr0: 0x0000000090131280 srr1: 0x000000000200f030 
vrsave: 0x0000000000000000
     cr: 0x44000248          xer: 0x0000000000000004   lr: 
0x00000000907f4640  ctr: 0x0000000000000004
     r0: 0x0000000000000bf4   r1: 0x00000000bfffe4a0   r2: 
0x0000000000000003   r3: 0x0000000000000000
     r4: 0x000000009087140c   r5: 0x0000000000000000   r6: 
0x0000000000000001   r7: 0x00000000fffff41c
     r8: 0x0000000000000004   r9: 0x0000000000000010  r10: 
0x00000000900014f0  r11: 0x00000000a07bc2f4
    r12: 0x00000000901311a0  r13: 0x0000000000000143  r14: 
0x0000000067dec8f6  r15: 0x0000000000000143
    r16: 0x0000000067dee91d  r17: 0x0000000000000000  r18: 
0x0000000000000000  r19: 0x0000000000000000
    r20: 0x0000000000000000  r21: 0x0000000000000001  r22: 
0x0000000000000000  r23: 0x0000000000000001
    r24: 0x0000000000000000  r25: 0x0000000000101fe0  r26: 
0x00000000a07b44a4  r27: 0x00000000bffff400
    r28: 0x00000000bffff404  r29: 0x0000000000000001  r30: 
0x0000000000000002  r31: 0x00000000907f44a4

Binary Images Description:
     0x1000 -     0x3fff perl 	/usr/bin/perl
     0x6000 -     0x7fff Cwd.bundle 
	/System/Library/Perl/5.8.6/darwin-thread-multi-2level/auto/Cwd/Cwd.bundle
     0xa000 -     0xdfff Glob.bundle 
	/System/Library/Perl/5.8.6/darwin-thread-multi-2level/auto/File/Glob/Glob.bundle
    0x1a000 -    0x1ffff Util.bundle 
	/System/Library/Perl/5.8.6/darwin-thread-multi-2level/auto/List/Util/Util.bundle
    0x28000 -    0x40fff DBI.bundle 
	/Library/Perl/5.8.6/darwin-thread-multi-2level/auto/DBI/DBI.bundle
    0x68000 -    0x82fff Pg.bundle 
	/Library/Perl/5.8.6/darwin-thread-multi-2level/auto/DBD/Pg/Pg.bundle
   0x205000 -   0x21cfff libpq.5.dylib 	/usr/local/pgsql/lib/libpq.5.dylib
0x8fe00000 - 0x8fe52fff dyld 46.16	/usr/lib/dyld
0x90000000 - 0x901bcfff libSystem.B.dylib 	/usr/lib/libSystem.B.dylib
0x90214000 - 0x90219fff libmathCommon.A.dylib 
	/usr/lib/system/libmathCommon.A.dylib
0x907bb000 - 0x90895fff com.apple.CoreFoundation 6.4.11 (368.35) 
	/System/Library/Frameworks/CoreFoundation.framework/Versions/A/CoreFoundation
0x908de000 - 0x908defff com.apple.CoreServices 10.4 (???) 
	/System/Library/Frameworks/CoreServices.framework/Versions/A/CoreServices
0x908e0000 - 0x909e2fff libicucore.A.dylib 	/usr/lib/libicucore.A.dylib
0x90a3c000 - 0x90ac0fff libobjc.A.dylib 	/usr/lib/libobjc.A.dylib
0x90aea000 - 0x90b5cfff com.apple.framework.IOKit 1.4 (???) 
	/System/Library/Frameworks/IOKit.framework/Versions/A/IOKit
0x90b72000 - 0x90b84fff libauto.dylib 	/usr/lib/libauto.dylib
0x90b8b000 - 0x90e62fff com.apple.CoreServices.CarbonCore 681.18 
	/System/Library/Frameworks/CoreServices.framework/Versions/A/Frameworks/CarbonCore.framework/Versions/A/CarbonCore
0x90ec8000 - 0x90f48fff com.apple.CoreServices.OSServices 4.1 
	/System/Library/Frameworks/CoreServices.framework/Versions/A/Frameworks/OSServices.framework/Versions/A/OSServices
0x90f92000 - 0x90fd4fff com.apple.CFNetwork 4.0 (129.23) 
	/System/Library/Frameworks/CoreServices.framework/Versions/A/Frameworks/CFNetwork.framework/Versions/A/CFNetwork
0x90fe9000 - 0x91001fff com.apple.WebServices 1.1.2 (1.1.0) 
	/System/Library/Frameworks/CoreServices.framework/Versions/A/Frameworks/WebServicesCore.framework/Versions/A/WebServicesCore
0x91011000 - 0x91092fff com.apple.SearchKit 1.0.8 
	/System/Library/Frameworks/CoreServices.framework/Versions/A/Frameworks/SearchKit.framework/Versions/A/SearchKit
0x910d8000 - 0x91101fff com.apple.Metadata 10.4.4 (121.36) 
	/System/Library/Frameworks/CoreServices.framework/Versions/A/Frameworks/Metadata.framework/Versions/A/Metadata
0x91112000 - 0x91120fff libz.1.dylib 	/usr/lib/libz.1.dylib
0x91123000 - 0x912defff com.apple.security 4.6 (29770) 
	/System/Library/Frameworks/Security.framework/Versions/A/Security
0x913dd000 - 0x913e6fff com.apple.DiskArbitration 2.1.2 
	/System/Library/Frameworks/DiskArbitration.framework/Versions/A/DiskArbitration
0x913ed000 - 0x913f5fff libbsm.dylib 	/usr/lib/libbsm.dylib
0x913f9000 - 0x91421fff com.apple.SystemConfiguration 1.8.3 
	/System/Library/Frameworks/SystemConfiguration.framework/Versions/A/SystemConfiguration
0x91434000 - 0x9143ffff libgcc_s.1.dylib 	/usr/lib/libgcc_s.1.dylib
0x91a19000 - 0x91ae0fff libcrypto.0.9.7.dylib 	/usr/lib/libcrypto.0.9.7.dylib
0x937a8000 - 0x937c8fff libmx.A.dylib 	/usr/lib/libmx.A.dylib
0x95078000 - 0x950a7fff libssl.0.9.7.dylib 	/usr/lib/libssl.0.9.7.dylib
0x950b7000 - 0x950d4fff libresolv.9.dylib 	/usr/lib/libresolv.9.dylib
0x955d2000 - 0x95700fff edu.mit.Kerberos 5.5.26 
	/System/Library/Frameworks/Kerberos.framework/Versions/A/Kerberos
0x979ce000 - 0x97aa9fff libperl.dylib 
	/System/Library/Perl/5.8.6/darwin-thread-multi-2level/CORE/libperl.dylib

How could this problem be solved? It happens also on my other mac.

Andreas

Re: [SL] one check, multiple invoices

[Myk R. <myk...@gm...>]

Thank you.

On Monday 01 December 2008 12:58:45 pm David Boyle wrote:
> On Mon, 2008-12-01 at 10:18 -0600, Myk Robinson wrote:
> > What is the proper way to enter one check that covers several invoices? I
> > think that the "Receipt" option is right, but need clarification on how
> > to enter this.
>
> RECEIPT is indeed correct.  Select the customer and hit update.  Source
> would be the check number or whatever then use the check boxes to select
> which invoices you are applying to.  Once you have them selected, hit
> update again and SL should calculate for you.  Make sure your amounts
> match before hitting post.  If you are doing a large batch for more than
> one customer, RECEIPTS is a great feature.
>
> HTH,
> David Boyle
>
> > Thanks,
> > -myk
> >
> > -------------------------------------------------------------------------
> > This SF.Net email is sponsored by the Moblin Your Move Developer's
> > challenge Build the coolest Linux based applications with Moblin SDK &
> > win great prizes Grand prize is a trip for two to an Open Source event
> > anywhere in the world
> > http://moblin-contest.org/redirect.php?banner_id=100&url=/
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's
> challenge Build the coolest Linux based applications with Moblin SDK & win
> great prizes Grand prize is a trip for two to an Open Source event anywhere
> in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] OK - Here we go - the VAT question

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

There is a valid from - to field for VAT rates iirc

2008/12/1 Kevin Bailey <kb...@fr...>

> So I add another account for 15% VAT.
>
> Go to the customer page and tick the box to enable 15% VAT and leave the
> 17.5% box ticked.
>
> Go to the service/item page and tick the 15% box and leave the 17.5% box
> ticked.
>
> Now how do I create an invoice and use the 15% rate?
>
> I can't untick either of the 17.5% boxes as looking at old invoices
> means they are wrong.
>
> So - how do we set the 'default' VAT rate to use when creating invoices?
>
> And another question - how does this work with scheduled transactions?
>
> Thanks,
>
> --
> *Kevin Bailey*
> Director/Programmer - Freeway Projects Limited
> Web: www.freewayprojects.com <http://www.freewayprojects.com/>
> Email: kb...@fr... <mailto:kb...@fr...>
> Phone: +44 (0)1752 267090
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's
> challenge
> Build the coolest Linux based applications with Moblin SDK & win great
> prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>

Re: [SL] one check, multiple invoices

[David B. <dav...@sb...>]

On Mon, 2008-12-01 at 10:18 -0600, Myk Robinson wrote:
> What is the proper way to enter one check that covers several invoices? I 
> think that the "Receipt" option is right, but need clarification on how to 
> enter this.

RECEIPT is indeed correct.  Select the customer and hit update.  Source
would be the check number or whatever then use the check boxes to select
which invoices you are applying to.  Once you have them selected, hit
update again and SL should calculate for you.  Make sure your amounts
match before hitting post.  If you are doing a large batch for more than
one customer, RECEIPTS is a great feature.

HTH,
David Boyle



> Thanks,
> -myk
> 
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

[SL] Remove from list

[Jeff E. <jef...@sb...>]

please.
email might also be jef...@al...

[SL] one check, multiple invoices

[Myk R. <myk...@gm...>]

What is the proper way to enter one check that covers several invoices? I 
think that the "Receipt" option is right, but need clarification on how to 
enter this.

Thanks,
-myk

Re: [SL] OK - Here we go - the VAT question

[Kevin B. <kb...@fr...>]

Kevin Bailey wrote:
> So I add another account for 15% VAT.
>
> Go to the customer page and tick the box to enable 15% VAT and leave the 
> 17.5% box ticked.
>
> Go to the service/item page and tick the 15% box and leave the 17.5% box 
> ticked.
>
> Now how do I create an invoice and use the 15% rate?
>
> I can't untick either of the 17.5% boxes as looking at old invoices 
> means they are wrong.
>
> So - how do we set the 'default' VAT rate to use when creating invoices?
>
> And another question - how does this work with scheduled transactions?
>
> Thanks,
>
>   

To answer my own post...

After adding the VAT account it is necessary to go to system - taxes to 
set the rate. Here it is possible to set an end date for the rate.

Next all customers, suppliers, parts and services need to have the VAT 
rate box ticked - this is a bit of a bind - is there anyway of 
automating this easily?

But the Brucie bonus is that it looks like the VAT rates will be set 
correctly for future invoices produced by the scheduled transactions.

Cheers,

Kevin


-- 
*Kevin Bailey*
Director/Programmer - Freeway Projects Limited
Web: www.freewayprojects.com <http://www.freewayprojects.com/>
Email: kb...@fr... <mailto:kb...@fr...>
Phone: +44 (0)1752 267090

[SL] OK - Here we go - the VAT question

[Kevin B. <kb...@fr...>]

So I add another account for 15% VAT.

Go to the customer page and tick the box to enable 15% VAT and leave the 
17.5% box ticked.

Go to the service/item page and tick the 15% box and leave the 17.5% box 
ticked.

Now how do I create an invoice and use the 15% rate?

I can't untick either of the 17.5% boxes as looking at old invoices 
means they are wrong.

So - how do we set the 'default' VAT rate to use when creating invoices?

And another question - how does this work with scheduled transactions?

Thanks,

-- 
*Kevin Bailey*
Director/Programmer - Freeway Projects Limited
Web: www.freewayprojects.com <http://www.freewayprojects.com/>
Email: kb...@fr... <mailto:kb...@fr...>
Phone: +44 (0)1752 267090

Re: [SL] Possible problem with broken transactions

[Kevin B. <kb...@fr...>]

Thanks Michael,

After re enabling the drop down list for the account it shows up again.

The error must have occurred because I change an invoice (yes I know I 
shouldn't) and then reposted it without noticing the missing part.

Cheers,

Kevin


Michael Hasse wrote:
> Should all still be there, what happens if you re-enable that account?
>
>
> Thanks,
>
> Michael
>
>
> On Nov 4, 2008, at 3:19 AM, Kevin Bailey wrote:
>
> Hi,
>
> Been using SL for a while and very happy.
>
> One thing has happened due to a tidy up.
>
> We needed to tidy up the accounts shown to the book keeper when adding
> accounts payable transactions.
>
> So I unticked the 'Expense/Asset' check box under the Payables column -
> this is the section which says 'Payables'.
>
> Now what's happened is that the main part of the invoice has disapeared
> - and the only parts of the transaction I can find in the general ledger
> are the VAT.
>
> This is really worrying because it probably means the totals are going
> to be out - also, the section says 'Include in drop-down menus' - so it
> doesn't imply that part of the transactions are going to get deleted.
>
> Is there anyway I can check the overall totals? - or find the missing
> transaction part?  Maybe it's still in the DB but not being shown in
> some screens?
>
> Maybe this hasn't been thought of - what happens when you remove an
> account from the drop-down list when you then view the invoice - maybe
> the main part should still be shown with the original account linked to
> greyed out.
>
> Thanks,
>
> Kevin Bailey
>
> ------------------------------------------------------------------------ 
> -
> This SF.Net email is sponsored by the Moblin Your Move Developer's  
> challenge
> Build the coolest Linux based applications with Moblin SDK & win  
> great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the  
> world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>   


-- 
*Kevin Bailey*
Director/Programmer - Freeway Projects Limited
Web: www.freewayprojects.com <http://www.freewayprojects.com/>
Email: kb...@fr... <mailto:kb...@fr...>
Phone: +44 (0)1752 267090

Re: [SL] Statement Question

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

The aged page is to analyse A/R and send out reminders or run phone lists.
"I see there are overdue invoices,would that have anything to do with the
credit crunch crisis maybe, and if so, when do you expect to pay?"

Use sales reports per customer for analyses of sales might be easier.
Or tack the box with closed transactions when running the A/R report.

Fact is, A/R type of people are normally only interested in outstanding
invoices, not in sales. Whereas sales people tend to overlook the fact a
customer might be non paying. From a sales point of view that is irrelevant,
as long as they hit the turnover targets and get the christmas bonus. Credit
controllers tend to have a different opinion there ;-)

2008/11/25 Rich Shepard <rsh...@ap...>

>   My understanding of an accounts receivable statement is that it is a
> history of what's been invoiced, paid, and remains outstanding. However,
> when I print an invoice for a client who's late in paying, but who paid
> part
> of one outstanding invoice, I see only what is still due to be paid. This
> is
> from the Accounts Receivable -> Aged page.
>
>   Is there another report that can be used to produce a statement with the
> full amounts of invoices plus the partial payments, too?
>
> Rich
>
> --
> Richard B. Shepard, Ph.D.               |  Integrity            Credibility
> Applied Ecosystem Services, Inc.        |            Innovation
> <http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax:
> 503-667-8863
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's
> challenge
> Build the coolest Linux based applications with Moblin SDK & win great
> prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>

[SL] Statement Question

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

   My understanding of an accounts receivable statement is that it is a
history of what's been invoiced, paid, and remains outstanding. However,
when I print an invoice for a client who's late in paying, but who paid part
of one outstanding invoice, I see only what is still due to be paid. This is
from the Accounts Receivable -> Aged page.

   Is there another report that can be used to produce a statement with the
full amounts of invoices plus the partial payments, too?

Rich

-- 
Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863