sql-ledger-users — SQL-Ledger users

[SL] help with error after restoring backup please

[Mike <lak...@co...>]

Hello,

I recently installed (fresh installation - not distro upgrade) 
Ubuntu 8.04 LTS. I was previously using Ubuntu 7.10 which was 
distro upgraded from 7.04. I decided a clean fresh install was 
the way to go this time so I backed up my sql-ledger (and 
everything else I needed to keep) and did a clean install.

I installed sql-ledger 2.8.14 and tried to restore my backup 
but when launching sql-ledger I am receiving this error:
---------------------------------------------
Upgrading to Version 2.8.14 ...
Error!

create table curr (rn int, curr char(3) primary key, precision 
int2)
ERROR: relation "curr" already exists
---------------------------------------------
Could someone please explain this to me and what I need to do 
the get this up and running again?

Thanks very much!
Mike

Re: [SL] [SOLVED] sql-ledger printing A4 -paper size

[Joseph <sy...@in...>]

On 04/25/08 23:45, Rolf Stöckli wrote:

Solved, thank you for the hint.
Yes, I realized that it wasn't sql-ledger problem, what I was looking for is the confirmation what program 
sql-ledger was calling to print "ps" files; and that is "dvips"

When I upgraded to "texlive" dvips was upgraded as well and by default it sets the paper size to "A4" in:
/etc/texmf/dvips/config/config.ps
so the first setting are the default and that is:
@ a4 210mm 297mm
@+ ! %%DocumentPaperSizes: a4
@+ %%BeginPaperSize: a4
@+ /setpagedevice where
@+  { pop << /PageSize [595 842] >> setpagedevice }
@+  { /a4 where { pop a4 } if }
@+ ifelse
@+ %%EndPaperSize

to fix it all one has to do is to copy/move letter setting to be first:
@ letter 8.5in 11in
@+ ! %%DocumentPaperSizes: Letter
@+ %%BeginPaperSize: Letter
@+ /setpagedevice where
@+  { pop << /PageSize [612 792] >> setpagedevice }
@+  { /letter where { pop letter } if }
@+ ifelse
@+ %%EndPaperSize

--
#Joseph
GPG KeyID: ED0E1FB7

>Joseph schrieb:
>> This one saves pdf files as "Letter" size but postscripts prints as "A4"
>> So I'm trying to ind out what commend is sql-ledger using to send "ps" output to a printer.
>> This way I can double check my postscript setting if I know what postscript program is sql-ledger using.
>
>SQL-Ledger calls latex + dvips to create the PS and pdflatex to create 
>the PDF files:
>
>Form.pm line 825...:
>     if ($self->{format} eq 'postscript') {
>
>       system("latex --interaction=nonstopmode $self->{tmpfile} > 
>$self->{errfile}");
>...
>       system("dvips $self->{tmpfile} -o -q");
>...
>
>Form.pm line 839...:
>     if ($self->{format} eq 'pdf') {
>       system("pdflatex --interaction=nonstopmode $self->{tmpfile} > 
>$self->{errfile}");
>...
>
>If they behave differently, I would look for the cause in the LaTeX 
>installation and not in SQL-Ledger. I suggest to create simple tex file, 
>run latex and check the logfile for warnings and errors.
>
>Rolf
>

Re: [SL] sql-ledger printing A4 -paper size

[Rolf S. <in...@to...>]

Joseph schrieb:
> This one saves pdf files as "Letter" size but postscripts prints as "A4"
> So I'm trying to ind out what commend is sql-ledger using to send "ps" output to a printer.
> This way I can double check my postscript setting if I know what postscript program is sql-ledger using.

SQL-Ledger calls latex + dvips to create the PS and pdflatex to create 
the PDF files:

Form.pm line 825...:
     if ($self->{format} eq 'postscript') {

       system("latex --interaction=nonstopmode $self->{tmpfile} > 
$self->{errfile}");
...
       system("dvips $self->{tmpfile} -o -q");
...

Form.pm line 839...:
     if ($self->{format} eq 'pdf') {
       system("pdflatex --interaction=nonstopmode $self->{tmpfile} > 
$self->{errfile}");
...

If they behave differently, I would look for the cause in the LaTeX 
installation and not in SQL-Ledger. I suggest to create simple tex file, 
run latex and check the logfile for warnings and errors.

Rolf

Re: [SL] sql-ledger printing A4 -paper size

[Joseph <sy...@in...>]

This was the original preamble from invoice.tex:
--------original invoice.tex-----------

\documentclass[twoside]{scrartcl}
\usepackage[frame]{xy}
\usepackage{tabularx}
\usepackage[latin1]{inputenc}
\setlength{\voffset}{0.4cm}
\setlength{\hoffset}{-2.0cm}
\setlength{\topmargin}{0cm}
\setlength{\headheight}{0.5cm}
\setlength{\headsep}{1cm}
\setlength{\topskip}{0pt}
\setlength{\oddsidemargin}{1.4cm}
\setlength{\evensidemargin}{1.4cm}
\setlength{\textwidth}{18.2cm}
\setlength{\textheight}{24.5cm}
\setlength{\footskip}{1cm}
\setlength{\parindent}{0pt}
\renewcommand{\baselinestretch}{1}
\begin{document}

-----end original invoice.tex----------------

This generated A4 pdf files but ps (postscript) printed as "Letter"; it didn't bother me much.
Now after upgrade to "texlive" I had to adjust the invoice.tex:

-------modified invoice.tex-----------

\documentclass[nopagenumber]{scrartcl}
\usepackage[latin1]{inputenc}
\usepackage{tabularx}
\usepackage[letterpaper,top=2.4cm,bottom=0.8cm,left=1.4cm,right=1.5cm]{geometry}
\usepackage{graphicx}
\begin{document}

-------end modified invoice.tex----------

This one saves pdf files as "Letter" size but postscripts prints as "A4"
So I'm trying to ind out what commend is sql-ledger using to send "ps" output to a printer.
This way I can double check my postscript setting if I know what postscript program is sql-ledger using.

--
#Joseph
GPG KeyID: ED0E1FB

On 04/25/08 16:25, Dr Eberhard W Lisse wrote:
>Put an option into the invoice.tex file.
>
>I use A4 and these options (for my *HEAVILY* modified invoice template):
>
>\usepackage{geometry}
>\geometry
>{portrait,a4paper,tmargin=2cm,bmargin=2cm,lmargin=2cm,rmargin=2cm}
>
>So I assume letterpaper would be the one to use.
>
>
>By the way, current version is 2.8.14...
>
>greetings, el
>
>
>On Apr 25, 2008, at 15:54, Joseph wrote:
>
>> Does anybody know what command is sql-ledger using to print an  
>> invoice (ps file) to a printer?
>> I have upgraded to "texlive" and when I print an invoice (Postscript  
>> - Printer) it sending job in "A4" paper size
>> instead of US "Letter" size.
>> When I print to PDF-file the file is "Letter" size.
>>
>> I'm using sql-leger-2.2.7
>>
>> -- 
>> #Joseph
>>
>> -------------------------------------------------------------------------
>> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
>> Don't miss this year's exciting event. There's still time to save  
>> $100.
>> Use priority code J8TL2D2.
>> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
>
>
>-------------------------------------------------------------------------
>This SF.net email is sponsored by the 2008 JavaOne(SM) Conference 
>Don't miss this year's exciting event. There's still time to save $100. 
>Use priority code J8TL2D2. 
>http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
>_______________________________________________
>sql-ledger-users mailing list
>sql...@li...
>https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] sql-ledger printing A4 -paper size

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

Put an option into the invoice.tex file.

I use A4 and these options (for my *HEAVILY* modified invoice template):

\usepackage{geometry}
\geometry
{portrait,a4paper,tmargin=2cm,bmargin=2cm,lmargin=2cm,rmargin=2cm}

So I assume letterpaper would be the one to use.


By the way, current version is 2.8.14...

greetings, el


On Apr 25, 2008, at 15:54, Joseph wrote:

> Does anybody know what command is sql-ledger using to print an  
> invoice (ps file) to a printer?
> I have upgraded to "texlive" and when I print an invoice (Postscript  
> - Printer) it sending job in "A4" paper size
> instead of US "Letter" size.
> When I print to PDF-file the file is "Letter" size.
>
> I'm using sql-leger-2.2.7
>
> -- 
> #Joseph
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
> Don't miss this year's exciting event. There's still time to save  
> $100.
> Use priority code J8TL2D2.
> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

[SL] sql-ledger printing A4 -paper size

[Joseph <sy...@in...>]

Does anybody know what command is sql-ledger using to print an invoice (ps file) to a printer?
I have upgraded to "texlive" and when I print an invoice (Postscript - Printer) it sending job in "A4" paper size 
instead of US "Letter" size.
When I print to PDF-file the file is "Letter" size.

I'm using sql-leger-2.2.7

-- 
#Joseph

Re: [SL] Multiple Invoices, one payment - howto?

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

Thanks!
-myk

On Thursday 24 April 2008 04:32:52 am sl...@li... wrote:
> I would use cash -> receipt for this, since it's only a single customer.
>
> Go in, select the customer, select update.
> Then check the box on the invoices that the check in question pays;
> adjust the date ifnecessary; fill in your memo; set the proper account;
> fill in anything else that needs to be; and hit update.
> Check that all of the right amounts were filled in by the program in the
> right places, and then post away.
>
> Regards,
>
> Luke
>
> On Wed, 23 Apr 2008, Myk Robinson wrote:
> > Got a simple one..
> >
> > If I have a customer with several invoices, and he writes one check to
> > cover them all, what is the proper way to put this into the ledger? Is it
> > under Cash-->Receipt?
> >
> > Thanks,
> > -myk
> >
> > -------------------------------------------------------------------------
> > This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
> > Don't miss this year's exciting event. There's still time to save $100.
> > Use priority code J8TL2D2.
> > http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/ja
> >vaone _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Multiple Invoices, one payment - howto?

[<sl...@li...>]

I would use cash -> receipt for this, since it's only a single customer.

Go in, select the customer, select update.
Then check the box on the invoices that the check in question pays; 
adjust the date ifnecessary; fill in your memo; set the proper account; 
fill in anything else that needs to be; and hit update.
Check that all of the right amounts were filled in by the program in the 
right places, and then post away.

Regards,

Luke


On Wed, 23 Apr 2008, Myk Robinson wrote:

> Got a simple one..
> 
> If I have a customer with several invoices, and he writes one check to cover 
> them all, what is the proper way to put this into the ledger? Is it under 
> Cash-->Receipt?
> 
> Thanks,
> -myk
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference 
> Don't miss this year's exciting event. There's still time to save $100. 
> Use priority code J8TL2D2. 
> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> 

-- 
Luke

"From the dawn of the Republic, America's quest for freedom has been
guided by the conviction that the principles governing political and
social life are intimately linked to a moral order based on the dominion
of God the Creator." - Benedict XVI

Re: [SL] Multiple Invoices, one payment - howto?

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

Works in the singular as well if it's just one customer.  (The other  
lets you do the same for multiple customers...)


Thanks,

Michael


On Apr 23, 2008, at 12:54 PM, Stuart Luppescu wrote:

> On 水, 2008-04-23 at 14:44 -0500, Myk Robinson wrote:
>> Got a simple one..
>>
>> If I have a customer with several invoices, and he writes one  
>> check to cover
>> them all, what is the proper way to put this into the ledger? Is  
>> it under
>> Cash-->Receipt?
>
> I use Cash -> Receipts (note the plural).
> -- 
> Stuart Luppescu -=- slu .at. ccsr.uchicago.edu
> University of Chicago -=- CCSR
> 才文と智奈美の父 -=-    Kernel 2.6.23-gentoo-r8
> When a lot of remedies are suggested for a disease,
>  that means it can't be cured.   -- Anton Chekhov,
>  "The Cherry Orchard"
>
>
>
> ---------------------------------------------------------------------- 
> ---
> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
> Don't miss this year's exciting event. There's still time to save  
> $100.
> Use priority code J8TL2D2.
> http://ad.doubleclick.net/clk;198757673;13503038;p?http:// 
> java.sun.com/javaone
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Multiple Invoices, one payment - howto?

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

On 水, 2008-04-23 at 14:44 -0500, Myk Robinson wrote:
> Got a simple one..
> 
> If I have a customer with several invoices, and he writes one check to cover 
> them all, what is the proper way to put this into the ledger? Is it under 
> Cash-->Receipt?

I use Cash -> Receipts (note the plural).
-- 
Stuart Luppescu -=- slu .at. ccsr.uchicago.edu        
University of Chicago -=- CCSR 
才文と智奈美の父 -=-    Kernel 2.6.23-gentoo-r8                
When a lot of remedies are suggested for a disease,
 that means it can't be cured.   -- Anton Chekhov, 
 "The Cherry Orchard" 
 
 

[SL] Multiple Invoices, one payment - howto?

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

Got a simple one..

If I have a customer with several invoices, and he writes one check to cover 
them all, what is the proper way to put this into the ledger? Is it under 
Cash-->Receipt?

Thanks,
-myk

Re: [SL] Credit Card Payment Question

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

> when you pay the card with the GL
> entry, do you use any intermediate accounts for recording
> the transactions, 
No.

> or do you directly credit the checking account, 
> into a debit to the credit card's liability account?
Yes.

> 
> Thanks.
You're welcome.

[SL] Credit Card Payment Question

[Luke <sl...@li...>]

Hello

For people who are using the "real vendor" plus "transfer payment" method 
for business credit card accounts, I have a question.
What I mean by that, is you use a credit card by setting it up as a 
liability account, and create each vendor who bills you via the card as an 
actual vendor, which you pay by posting a payment against the credit card 
liability account.
To pay the credit card, you use a GL entry.  This has been discussed here 
before.

My question is this: when you pay the card with the GL entry, do you use 
any intermediate accounts for recording the transactions, or do you 
directly credit the checking account, into a debit to the credit card's 
liability account?

Thanks.

-- 
Luke

"If Ben starts running those printing presses faster than he's already
doing, we're going to have a serious recession. The dollar's going to
collapse... there's going to be problems." - Jim Rogers, Telegraph
9/12/07

Re: [SL] Bizarre copy of ARRAY and.... Attempt to free unreferenced scalar etc

[Roy W P. <arc...@mt...>]

On Friday 18 April 2008, Wallace Roberts Consulting wrote:
> On Fri, Apr 18, 2008 at 7:41 AM, Roy W Pennington <arc...@mt...> wrote:
> > On Friday 18 April 2008, Wallace Roberts Consulting wrote:
> >  > On Fri, Apr 18, 2008 at 7:11 AM, Roy W Pennington <arc...@mt...> wrote:
> >  > ...
> >  > >     $query = qq|INSERT INTO acc_trans (trans_id, chart_id, amount,
> >  > >                 transdate, project_id, invoice_id)
> >  > >                 VALUES ($form->{id}, $ref->{chart_id}, $amount,
> >  > >               '$form->{transdate}', $ref->{project_id}, $ref->{invoice_id})|;
> >  > >     $dbh->do($query) || $form->dberror($query);
> >  >
> >  > >From the generated error, it appears that the following variables
> >  > might be undefined:
> >  >
> >  > $ref->{project_id}, $ref->{invoice_id}
> >  >
> >  > You could place a conditional in the perl code to check those
> >  > variables & use some kind of default value if they don't exist.
> >
> >  So you're saying that SQL-ledger's official code is broken  ?
> 
> No.  I'm saying that a pathological interaction has cropped up among
> the new pieces of code, & making a very simple change to the above
> SQL-Ledger code will ameliorate said pathology.

I'm gonna get 1.49 dbd-pg via cpan and see if that helps.
Gonna take the easiest route if possible. I'm not a real coder.. just a geek/user.

"pathological interaction" brought a smile to my face...
Hehe I had the same issue with a girlfriend many many years ago.
I had just 'migrated' to a new GF  and a "pathological interaction" developed.
I found that the legacy version was more compatible and switching would have had an ameliorative effect. unfortunately there was no way to roll back the changes.

Cheers !
Roy

Re: [SL] Bizarre copy of ARRAY and.... Attempt to free unreferenced scalar etc

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

On Fri, Apr 18, 2008 at 7:41 AM, Roy W Pennington <arc...@mt...> wrote:
> On Friday 18 April 2008, Wallace Roberts Consulting wrote:
>  > On Fri, Apr 18, 2008 at 7:11 AM, Roy W Pennington <arc...@mt...> wrote:
>  > ...
>  > >     $query = qq|INSERT INTO acc_trans (trans_id, chart_id, amount,
>  > >                 transdate, project_id, invoice_id)
>  > >                 VALUES ($form->{id}, $ref->{chart_id}, $amount,
>  > >               '$form->{transdate}', $ref->{project_id}, $ref->{invoice_id})|;
>  > >     $dbh->do($query) || $form->dberror($query);
>  >
>  > >From the generated error, it appears that the following variables
>  > might be undefined:
>  >
>  > $ref->{project_id}, $ref->{invoice_id}
>  >
>  > You could place a conditional in the perl code to check those
>  > variables & use some kind of default value if they don't exist.
>
>  So you're saying that SQL-ledger's official code is broken  ?

No.  I'm saying that a pathological interaction has cropped up among
the new pieces of code, & making a very simple change to the above
SQL-Ledger code will ameliorate said pathology.
-- 
Best Regards,
Wallace

Re: [SL] Bizarre copy of ARRAY and.... Attempt to free unreferenced scalar etc

[Roy W P. <arc...@mt...>]

On Friday 18 April 2008, Wallace Roberts Consulting wrote:
> On Fri, Apr 18, 2008 at 7:11 AM, Roy W Pennington <arc...@mt...> wrote:
> ...
> >     $query = qq|INSERT INTO acc_trans (trans_id, chart_id, amount,
> >                 transdate, project_id, invoice_id)
> >                 VALUES ($form->{id}, $ref->{chart_id}, $amount,
> >               '$form->{transdate}', $ref->{project_id}, $ref->{invoice_id})|;
> >     $dbh->do($query) || $form->dberror($query);
> 
> >From the generated error, it appears that the following variables
> might be undefined:
> 
> $ref->{project_id}, $ref->{invoice_id}
> 
> You could place a conditional in the perl code to check those
> variables & use some kind of default value if they don't exist.

So you're saying that SQL-ledger's official code is broken  ?

Roy

Re: [SL] Bizarre copy of ARRAY and.... Attempt to free unreferenced scalar etc

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

On Fri, Apr 18, 2008 at 7:11 AM, Roy W Pennington <arc...@mt...> wrote:
...
>     $query = qq|INSERT INTO acc_trans (trans_id, chart_id, amount,
>                 transdate, project_id, invoice_id)
>                 VALUES ($form->{id}, $ref->{chart_id}, $amount,
>               '$form->{transdate}', $ref->{project_id}, $ref->{invoice_id})|;
>     $dbh->do($query) || $form->dberror($query);

>From the generated error, it appears that the following variables
might be undefined:

$ref->{project_id}, $ref->{invoice_id}

You could place a conditional in the perl code to check those
variables & use some kind of default value if they don't exist.
-- 
Best Regards,
Wallace

Re: [SL] Bizarre copy of ARRAY and.... Attempt to free unreferenced scalar etc

[Roy W P. <arc...@mt...>]

> On Thu, Apr 17, 2008 at 11:45 AM, Roy W Pennington <arc...@mt...> wrote:
> ...
> >  I get this error when "posting as new" invoices...
> >
> >  DBD::Pg::db do failed: ERROR: syntax error at or near ")"
> >  LINE 4: '04-03-2008', NULL, )
> >  ^ at SL/IS.pm line 854.
> 
> The above line is obviously in error -- the last parameter (before the
> closing parenthesis) is missing.  Can you post the code snippet around
> SL/IS.pm, line 854?  That would certainly help.
> 

Yup that last parameter is missing.

Here's the code.

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

# add lineitems + tax
  $amount = 0;
  $grossamount = 0;
  $fxgrossamount = 0;
  for (@{ $form->{acc_trans}{lineitems} }) {
    $amount += $_->{amount};
    $grossamount += $_->{grossamount};
    $fxgrossamount += $_->{fxgrossamount};
  }
  $invnetamount = $amount;
  
  $amount = 0;
  for (split / /, $form->{taxaccounts}) { $amount += $form->{acc_trans}{$form->{id}}{$_}{amount} = $form->round_amount($form->{acc_trans}{$form->{id}}{$_}{amount}, 2) }
  $invamount = $invnetamount + $amount;

  $diff = 0;
  if ($form->{taxincluded}) {
    $diff = $form->round_amount($grossamount - $invamount, 2);
    $invamount += $diff;
  }
  $fxdiff = $form->round_amount($fxdiff,2);
  $invnetamount += $fxdiff;
  $invamount += $fxdiff;

  if ($form->round_amount($form->{paid} - $fxgrossamount,2) == 0) {
    $form->{paid} = $invamount;
  } else {
    $form->{paid} = $form->round_amount($form->{paid} * $form->{exchangerate}, 2);
  }

  foreach $ref (sort { $b->{amount} <=> $a->{amount} } @ { $form->{acc_trans}{lineitems} }) {
    $amount = $ref->{amount} + $diff + $fxdiff;
    $query = qq|INSERT INTO acc_trans (trans_id, chart_id, amount,
		transdate, project_id, invoice_id)
		VALUES ($form->{id}, $ref->{chart_id}, $amount,
	      '$form->{transdate}', $ref->{project_id}, $ref->{invoice_id})|;
    $dbh->do($query) || $form->dberror($query);
    $diff = 0;
    $fxdiff = 0;
  }
  
  $form->{receivables} = $invamount * -1;
 
  delete $form->{acc_trans}{lineitems};
------------------------
  
But the fact is the code hasn't been changed....
it worked fine until i upgraded my distro and newer versions of DBI, DBD-pg, and perl were installed.
Either:
1) the newer perl/dbi/dbd-pg packages (or code) is broken
2) something has changed in rgeards to the DBI/DBD implementation has changed and the old SL code is not compatible.
3) ??

If I roll back the version of perl, perl-DBI, and DBD-pg to the version packaged with Mandriva 2008, the SQL-ledger works fine.. but then most of the perl based gui in mandriva 2008.1 is broken.


judging from the previous threads... this is a issue that others have had:
http://abacus.sql-ledger.com/userforum/forum_entry.php?id=941
http://abacus.sql-ledger.com/userforum/forum_entry.php?id=910
http://abacus.sql-ledger.com/userforum/forum_entry.php?id=888


Due to the fact that "arblake" had the problem with a different version of perl (from what i have running) and I get the same problem with multiple versions of Postgresql.... 
I suspect it's DBD-pg or DBI.


Regards,
Roy

Re: [SL] Bizarre copy of ARRAY and.... Attempt to free unreferenced scalar etc

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

On Thu, Apr 17, 2008 at 11:45 AM, Roy W Pennington <arc...@mt...> wrote:
...
>  I get this error when "posting as new" invoices...
>
>  DBD::Pg::db do failed: ERROR: syntax error at or near ")"
>  LINE 4: '04-03-2008', NULL, )
>  ^ at SL/IS.pm line 854.

The above line is obviously in error -- the last parameter (before the
closing parenthesis) is missing.  Can you post the code snippet around
SL/IS.pm, line 854?  That would certainly help.

-- 
Best Regards,
Wallace

Re: [SL] Bizarre copy of ARRAY and.... Attempt to free unreferenced scalar etc

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

On April 17, 2008 01:45:33 pm Roy W Pennington wrote:
> These problems that have recently been posted in the list seem to be due to
> a new version of either DBI     DBD-PG    perl or postgresql
>
> I'm running Version 2.6.27 and everything worked fine on mandriva 2008.
>
> I just upgraded to mandriva 2008.1 spring to try solve a DVD burner
> problem.
>
> Now I get the "....Attempt to free unreferenced scalar....." error when
> printing.
>
> I get this error when "posting as new" invoices...
>
> DBD::Pg::db do failed: ERROR: syntax error at or near ")"
> LINE 4: '04-03-2008', NULL, )
> ^ at SL/IS.pm line 854.
>
>
> a bit of testing with 2.8 and even with dieter's fix...
> http://abacus.sql-ledger.com/userforum/forum_entry.php?id=911
>
> i get the bizarre copy of array error as noted in this thread.
> http://abacus.sql-ledger.com/userforum/forum_entry.php?id=941
>
> previously running
> postgresql 8.2.6
> perl-DBD-pg-1.49
> perl-DBI 1.59
>
> now running
> postgresql 8.2.7
> perl-DBD-pg 2.2.2
> perl-DBI 1.601
>
> I suspect it's an DBD/DBI issue
> anyone narrow this down ?
>

On more investigation...
I tested postgresql 8.2.6 and 8.3 with a clean install and still no luck.
So it appears this is due to Perl 5.10, DBI 1.601, or DBD-pg 2.2.2.

I'll try getting the latest DBI and DBD-pg from cpan to see if that fixes it.

Any ideas ?
Roy

[SL] Bizarre copy of ARRAY and.... Attempt to free unreferenced scalar etc

[Roy W P. <arc...@mt...>]

These problems that have recently been posted in the list seem to be due to a new version of either
DBI     DBD-PG    perl or postgresql

I'm running Version 2.6.27 and everything worked fine on mandriva 2008.

I just upgraded to mandriva 2008.1 spring to try solve a DVD burner problem.

Now I get the "....Attempt to free unreferenced scalar....." error when printing.

I get this error when "posting as new" invoices...

DBD::Pg::db do failed: ERROR: syntax error at or near ")"
LINE 4: '04-03-2008', NULL, )
^ at SL/IS.pm line 854.


a bit of testing with 2.8 and even with dieter's fix...
http://abacus.sql-ledger.com/userforum/forum_entry.php?id=911

i get the bizarre copy of array error as noted in this thread.
http://abacus.sql-ledger.com/userforum/forum_entry.php?id=941

previously running
postgresql 8.2.6
perl-DBD-pg-1.49
perl-DBI 1.59

now running
postgresql 8.2.7
perl-DBD-pg 2.2.2
perl-DBI 1.601

I suspect it's an DBD/DBI issue
anyone narrow this down ?


------------------
Roy W Pennington

Re: [SL] Handling PayPal Money Market & Trading Accounts

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

Is there any reason why the interest can't be a separate/additional  
line item in the same GL entry...?  We've also seen reference to  
scripts for importing electronic account statements but haven't  
actually looked at any of them.


Thanks,

Michael

On Apr 16, 2008, at 10:15 PM, Luke wrote:
> This is an accounting question...
>
> How are people handling interest payments (incoming), such as from the
> PayPal money market fund?
>
> I have a PayPal account (configured much like a checking account)  
> in the
> COA, and my plan to date is to just use an AR transaction for each
> interest payment I encounter while back entering, just as I plan to  
> use
> an AP Transaction to vendor "PayPal" for credit card charging fees  
> they
> assess.
>
> So, once I know how much PayPal has paid for that period, I can  
> post an AR
> transaction for that amount, including a payment.
>
> However, if there is a more reasonable way, which does not involve  
> so many
> AR transactions, I'd be interested in hearing about it.
>
> I say "so many", because PayPal is not the only such account we  
> have which
> does this--some checking accounts do it, as do stock trading accounts.
>
> Speaking of stock trading accounts: is anyone here tracking a trading
> account in SL, and if so, what are some of the practices you use for
> recording transactions in it?
>
> Thanks
>
> Luke
>
> ---------------------------------------------------------------------- 
> ---
> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
> Don't miss this year's exciting event. There's still time to save  
> $100.
> Use priority code J8TL2D2.
> http://ad.doubleclick.net/clk;198757673;13503038;p?http:// 
> java.sun.com/javaone
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

[SL] Handling PayPal Money Market & Trading Accounts

[Luke <sl...@li...>]

This is an accounting question...

How are people handling interest payments (incoming), such as from the 
PayPal money market fund?

I have a PayPal account (configured much like a checking account) in the 
COA, and my plan to date is to just use an AR transaction for each 
interest payment I encounter while back entering, just as I plan to use 
an AP Transaction to vendor "PayPal" for credit card charging fees they 
assess.

So, once I know how much PayPal has paid for that period, I can post an AR 
transaction for that amount, including a payment.

However, if there is a more reasonable way, which does not involve so many 
AR transactions, I'd be interested in hearing about it.

I say "so many", because PayPal is not the only such account we have which 
does this--some checking accounts do it, as do stock trading accounts.

Speaking of stock trading accounts: is anyone here tracking a trading 
account in SL, and if so, what are some of the practices you use for 
recording transactions in it?

Thanks

Luke

Re: [SL] Letterhead on every page

[J.M. \Jersey\ M. <je...@ib...>]

Hello Rolf,

Thnx,
I'll try this route too... I just wander why I can not print the "header"
within the split table. I can put it everywhere further on the page.

"Jersey"

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of Rolf
Stöckli
Sent: 16 April 2008 02:01 PM
To: sql...@li...
Subject: Re: [SL] Letterhead on every page

J.M. "Jersey" Miszczyk schrieb:
> I am trying to print my letterhead on every page of the invoice.

The default letterhead is not a real header, but a text printed at the 
beginning of the document. Use the "fancyhdr" package if you want to 
have more control over headers and footers.
You find informations here:
http://en.wikibooks.org/wiki/LaTeX/Page_Layout
(section "Page Styles")
Or in the complete documentation:
http://www.ctan.org/tex-archive/macros/latex/contrib/fancyhdr/fancyhdr.pdf

Rolf

-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference 
Don't miss this year's exciting event. There's still time to save $100. 
Use priority code J8TL2D2. 
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javao
ne
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users


-- 
No virus found in this incoming message.
Checked by AVG. 
Version: 7.5.524 / Virus Database: 269.23.0/1379 - Release Date: 4/15/2008
6:10 PM

Re: [SL] Letterhead on every page

[Rolf S. <in...@to...>]

J.M. "Jersey" Miszczyk schrieb:
> I am trying to print my letterhead on every page of the invoice.

The default letterhead is not a real header, but a text printed at the 
beginning of the document. Use the "fancyhdr" package if you want to 
have more control over headers and footers.
You find informations here:
http://en.wikibooks.org/wiki/LaTeX/Page_Layout
(section "Page Styles")
Or in the complete documentation:
http://www.ctan.org/tex-archive/macros/latex/contrib/fancyhdr/fancyhdr.pdf

Rolf