sql-ledger-users — SQL-Ledger users

[SL] Re-generating Year End For Prior Years

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

   I have to manually clean up all the duplicate entries that go back 61
months. Can I re-run the year end closing for these years (2004-2007) on the
corrected data?

Thanks,

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] Multiple Entries for Same Transaction

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

On Tue, 10 Feb 2009, Rich Shepard wrote:

> around the tables using psql. Actually, what I want to do is set up scema

   Make that schema/schemae. My cold must be worse than it feels.

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] Multiple Entries for Same Transaction

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

On Tue, 10 Feb 2009, Michael Hasse wrote:

> Well, what I'm really wondering is if there's something funny on the back
> end, like maybe a duplicate entry for an actual account, where the
> bad/dupe/whatever record has always existed but previous versions of SL
> did a "select unique" and so you only ever saw single entries. Your
> reposting could be "cleaning" the entries but not necessarily curing the
> underlying problem.  If the cause can be tracked down then it could be
> fixed properly and not have the risk of it cropping back up.  Just my
> $1.50, (inflation, y'know :).

Michael,

   You raise valid concerns. After I get things looking correct I'll rummage
around the tables using psql. Actually, what I want to do is set up scema
(scemae?), one for each year. I have to read the Douglas^2 book to see if I
can do this retroactively. I've 5 full years of data in the system.

Thanks,

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] Multiple Entries for Same Transaction

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

Well, what I'm really wondering is if there's something funny on the  
back end, like maybe a duplicate entry for an actual account, where  
the bad/dupe/whatever record has always existed but previous versions  
of SL did a "select unique" and so you only ever saw single entries.   
Your reposting could be "cleaning" the entries but not necessarily  
curing the underlying problem.  If the cause can be tracked down then  
it could be fixed properly and not have the risk of it cropping back  
up.  Just my $1.50, (inflation, y'know :).


Thanks,

Michael


On Feb 10, 2009, at 1:20 PM, Rich Shepard wrote:

On Tue, 10 Feb 2009, Michael Hasse wrote:

> That's really odd.  I would be curious if the data on the back end was
> really duplicated or if it's a flakey query that's presenting them  
> that
> way.  Have you looked at the actual records in the tables yet?

Michael,

    No, I haven't. I need to get it straight so I can get corporate  
data to
our accountant quickly. Corporate taxes are due 15 March.

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

------------------------------------------------------------------------ 
------
Create and Deploy Rich Internet Apps outside the browser with Adobe(R) 
AIR(TM)
software. With Adobe AIR, Ajax developers can use existing skills and  
code to
build responsive, highly engaging applications that combine the power  
of local
resources and data with the reach of the web. Download the Adobe AIR  
SDK and
Ajax docs to start building applications today-http://p.sf.net/sfu/ 
adobe-com
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Multiple Entries for Same Transaction

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

On Tue, 10 Feb 2009, Michael Hasse wrote:

> That's really odd.  I would be curious if the data on the back end was
> really duplicated or if it's a flakey query that's presenting them that
> way.  Have you looked at the actual records in the tables yet?

Michael,

   No, I haven't. I need to get it straight so I can get corporate data to
our accountant quickly. Corporate taxes are due 15 March.

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] Multiple Entries for Same Transaction

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

That's really odd.  I would be curious if the data on the back end  
was really duplicated or if it's a flakey query that's presenting  
them that way.  Have you looked at the actual records in the tables yet?


Thanks,

Michael

On Feb 10, 2009, at 10:05 AM, Rich Shepard wrote:

On Tue, 10 Feb 2009, Michael Hasse wrote:

> Some benign causes we've seen:
> 	- they're not really duplicated.  (Problem was reported by somebody
> who didn't realize the GL shows a line item for every monetary
> element of the transaction.)
> 	- somebody got Back button happy in their browser and was just
> trying to correct an entry.

Michael,

    Since I'm the only one here and using the application, the latter  
is not
applicable.

    They actually are duplicated in two ways. I'm looking at my  
interest and
bank charge account and for each journal entry written there are two  
lines
for the interest and two for the principal (same amounts of interest and
pricipal in each), but only one (correct) total. Then, when I look at  
the
trial balance and select that account, each transaction is displayed  
four
times, with the balance increasing each time.

    Deleting one transaction deletes them all.

    So, I am slowly working my way through them, deleting and re- 
entering each
one. PITA, and something I've not seen before in the 6 years I've been
running SL.

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

------------------------------------------------------------------------ 
------
Create and Deploy Rich Internet Apps outside the browser with Adobe(R) 
AIR(TM)
software. With Adobe AIR, Ajax developers can use existing skills and  
code to
build responsive, highly engaging applications that combine the power  
of local
resources and data with the reach of the web. Download the Adobe AIR  
SDK and
Ajax docs to start building applications today-http://p.sf.net/sfu/ 
adobe-com
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Multiple Entries for Same Transaction

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

On Tue, 10 Feb 2009, Michael Hasse wrote:

> Some benign causes we've seen:
> 	- they're not really duplicated.  (Problem was reported by somebody
> who didn't realize the GL shows a line item for every monetary
> element of the transaction.)
> 	- somebody got Back button happy in their browser and was just
> trying to correct an entry.

Michael,

   Since I'm the only one here and using the application, the latter is not
applicable.

   They actually are duplicated in two ways. I'm looking at my interest and
bank charge account and for each journal entry written there are two lines
for the interest and two for the principal (same amounts of interest and
pricipal in each), but only one (correct) total. Then, when I look at the
trial balance and select that account, each transaction is displayed four
times, with the balance increasing each time.

   Deleting one transaction deletes them all.

   So, I am slowly working my way through them, deleting and re-entering each
one. PITA, and something I've not seen before in the 6 years I've been
running SL.

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] Multiple Entries for Same Transaction

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

Some benign causes we've seen:
	- they're not really duplicated.  (Problem was reported by somebody  
who didn't realize the GL shows a line item for every monetary  
element of the transaction.)
	- somebody got Back button happy in their browser and was just  
trying to correct an entry.


Thanks,

Michael



On Feb 10, 2009, at 6:15 AM, Rich Shepard wrote:

On Tue, 10 Feb 2009, Paul Tammes wrote:

> It sounds like a recurring transaction to me. Is it possible a  
> transaction
> gets flagged as recurring somehow? Business logic (and a perl  
> script for
> that matter) could be easily fooled by a trransaction occurring  
> every year
> or quarter, so even if we do NOT flag it manual strange things  
> happen due
> to the script?

Paul,

    I don't know how it could be so flagged, but I'll take a look.  
Regardless,
I should not see the bank's monthly service charge show up 4 times on  
the
same date, nor have a list of purchases on a credit card repeated,  
with 4
payments of the same amount on the same day. I have a meeting this  
evening,
so it looks like tomorrow night will be a long session cleaning up  
theese
duplicates. And, I suppose I'll need to go through each account, too.

> Unsettling idea in an acconting package however..

    That's what bothers me, too.

Thanks,

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

------------------------------------------------------------------------ 
------
Create and Deploy Rich Internet Apps outside the browser with Adobe(R) 
AIR(TM)
software. With Adobe AIR, Ajax developers can use existing skills and  
code to
build responsive, highly engaging applications that combine the power  
of local
resources and data with the reach of the web. Download the Adobe AIR  
SDK and
Ajax docs to start building applications today-http://p.sf.net/sfu/ 
adobe-com
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Multiple Entries for Same Transaction

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

On Tue, 10 Feb 2009, Paul Tammes wrote:

> It sounds like a recurring transaction to me. Is it possible a transaction
> gets flagged as recurring somehow? Business logic (and a perl script for
> that matter) could be easily fooled by a trransaction occurring every year
> or quarter, so even if we do NOT flag it manual strange things happen due
> to the script?

Paul,

   I don't know how it could be so flagged, but I'll take a look. Regardless,
I should not see the bank's monthly service charge show up 4 times on the
same date, nor have a list of purchases on a credit card repeated, with 4
payments of the same amount on the same day. I have a meeting this evening,
so it looks like tomorrow night will be a long session cleaning up theese
duplicates. And, I suppose I'll need to go through each account, too.

> Unsettling idea in an acconting package however..

   That's what bothers me, too.

Thanks,

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] Multiple Entries for Same Transaction

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

It sounds like a recurring transaction to me.
Is it possible a transaction gets flagged as recurring somehow? Business
logic (and a perl script for that matter) could be easily fooled by a
trransaction occurring every year or quarter, so even if we do NOT flag it
manual strange things happen due to the script?

Unsettling idea in an acconting package however..

2009/2/10 Rich Shepard <rsh...@ap...>

>   I'm working toward giving my accountant all the information she needs to
> prepare our business tax returns. However, when I look at the trial
> balance's account for interest and bank charges I find 4 entries of the
> same
> amount from way back in 2003 until June of last year. I'm running version
> 2.8.20
> if that matters.
>
>   Also when I look at the details for one of these (haven't looked yet at
> others), I find the four expenses are repeated and the check paying them
> repeated 4 times.
>
>   Any ideas what happened? I'll go back and fix them for 2008, but there's
> no need to do anything earlier.
>
>   Never saw this before.
>
> 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
>
>
> ------------------------------------------------------------------------------
> Create and Deploy Rich Internet Apps outside the browser with
> Adobe(R)AIR(TM)
> software. With Adobe AIR, Ajax developers can use existing skills and code
> to
> build responsive, highly engaging applications that combine the power of
> local
> resources and data with the reach of the web. Download the Adobe AIR SDK
> and
> Ajax docs to start building applications today-
> http://p.sf.net/sfu/adobe-com
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

[SL] Multiple Entries for Same Transaction

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

   I'm working toward giving my accountant all the information she needs to
prepare our business tax returns. However, when I look at the trial
balance's account for interest and bank charges I find 4 entries of the same
amount from way back in 2003 until June of last year. I'm running version 2.8.20
if that matters.

   Also when I look at the details for one of these (haven't looked yet at
others), I find the four expenses are repeated and the check paying them
repeated 4 times.

   Any ideas what happened? I'll go back and fix them for 2008, but there's
no need to do anything earlier.

   Never saw this before.

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] Tracking Down Printing Problem -- Fixed! Yes!

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

On Thu, 8 Jan 2009, Rich Shepard wrote:

>   I'll need to get a perl monger to work on this. For various reasons I've
> avoided perl; C and Python meet all of my needs.

   Actually, it turned out to be a CUPS problem. Not before now have I needed
to define CUPS_SERVER, but now I need to export that from ~/.bash_profile
and also put it in /etc/cups/client.conf. Most importantly, the hostname
must be the same in both places. I had 'localhost' in one and the full
host.domain.tld name in the other. As soon as I changed both to localhost
the printing worked once again.

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] After upgrade to 2.8.20 payments are automatically posted to recurring invoices

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

On 2/6/09, Craig Isdahl <cr...@da...> wrote:
> We upgraded from 2.8.17 to 2.8.20 last night, everything seemed fine.  Today
> we processed recurring invoices and discovered shortly thereafter that all
> (see below for exceptions) of the recurring invoices automatically posted a
> payment to each one!  The system went back in time (2005, 2006, 2007 and 2008)
> and grabbed a previous client payment then posted it to this new invoice.

Hi Craig,

Thanks for your information. I was about to send invoices to my
customers and this has saved me a lot of hassle and confusion to my
clients.

I was able to reproduce this bug and a quick fix in the form of a
patch is below. This should correct the bug. If you (or any one else)
wants a patched file, let me know off-list and I shall send it.

Regards

===================== Patch starts ==========================
freebsd# git diff
diff --git a/bin/mozilla/am.pl b/bin/mozilla/am.pl
index ea2ec73..f52eb56 100755
--- a/bin/mozilla/am.pl
+++ b/bin/mozilla/am.pl
@@ -3448,6 +3448,15 @@ sub process_transactions {
              ($form->{"$form->{ARAP}_paid_$j"}) = split /--/,
$form->{"$form->{ARAP}_paid_$j"};
              delete $form->{"cleared_$j"};
            }
+         } else {
+           delete $form->{datepaid};
+           delete $form->{paid};
+           delete $form->{oldtotalpaid};
+           for ($j = 1; $j <= $form->{paidaccounts}; $j++) {
+             delete $form->{"datepaid_$j"};
+             delete $form->{"paid_$j"};
+             delete $form->{"$form->{ARAP}_paid_$j"};
+           }
          }

          for (qw(id recurring printed emailed queued)) { delete $form->{$_} }
========================= Patch Ends =============================

-- 
http://www.ledger123.com/

- Free SQL-Ledger Hosting
- Documentation wiki
- Virtual appliances
--

[SL] After upgrade to 2.8.20 payments are automatically posted to recurring invoices

[Craig I. <cr...@da...>]

Hi Everyone,

We upgraded from 2.8.17 to 2.8.20 last night, everything seemed fine.  Today
we processed recurring invoices and discovered shortly thereafter that all
(see below for exceptions) of the recurring invoices automatically posted a
payment to each one!  The system went back in time (2005, 2006, 2007 and 2008)
and grabbed a previous client payment then posted it to this new invoice.

The only exceptions we have noticed so far are:
  - Recurring transactions that were new (i.e. recently created)
  - Invoices posted by hand (i.e. they were not a recurring invoice)

The system has been solid and stable until this upgrade.  Any thoughts on how
we can prevent this from happing again in the future are welcome.

---
CentOS release 4.7 (Final)
Sql-Ledger 2.8.20
---

Thanks!
Craig

[SL] Cannot print after update

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

I have updated to 2.8.20 and now I seem to be having trouble printing. When 
printing an invoice I get the error:

panic: attempt to copy freed scalar 1454250 to 86ec00 at SL/Form.pm line 1008

I'm afraid I am having a panic attack. Any help would be appreciated.

Br. Nicholas
-- 
________________________

Nicholas Thirkettle, OSB

Saint Joseph's Monastery
Natchez, MS 39120

www.osbms.org
________________________

Re: [SL] Upgrade dataset error

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

Open it with a text editor like Kate ,notepad or whatrever, it will say
something in or just below line one iirc

2009/2/1 Reverso <re...@o2...>

> Paul Tammes pisze:
> > The version of the backup data is mostly in the name of the backup file.
> > Like companyname-2.8.14-2008-12-31.sql.gz
> >
> > Now look in the SL dir en look for PG-Upgrade-2.xxx-2,xx+1 sort of tools,
> > and run those on the database before opening admin.pl
>
> Unfortunately my backup name in not self explained. Just "data.sql"
> Maybe is there a version information in tables?
>
>
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by:
> SourcForge Community
> SourceForge wants to tell your story.
> http://p.sf.net/sfu/sf-spreadtheword
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] Upgrade dataset error - SOLVED

[Reverso <re...@o2...>]

Wallace Roberts Consulting pisze:

> 
> Check the comments at the very beginning of your data.sql file.
> 

Not so easy :-)
My backup was done out of sql-ledger mechanizm.

But ... the dataset version number was in table: defaults (field: version)
Then, as Paul wrote, I applied apropriate sql scripts and that's all.

Thanks guys

Re: [SL] Upgrade dataset error

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

On Sun, Feb 1, 2009 at 2:40 AM, Reverso <re...@o2...> wrote:
> Paul Tammes pisze:
>> The version of the backup data is mostly in the name of the backup file.
>> Like companyname-2.8.14-2008-12-31.sql.gz
>>
>> Now look in the SL dir en look for PG-Upgrade-2.xxx-2,xx+1 sort of tools,
>> and run those on the database before opening admin.pl
>
> Unfortunately my backup name in not self explained. Just "data.sql"
> Maybe is there a version information in tables?

Check the comments at the very beginning of your data.sql file.

-- 
Best Regards,
Wallace

Re: [SL] Upgrade dataset error

[Reverso <re...@o2...>]

Paul Tammes pisze:
> The version of the backup data is mostly in the name of the backup file.
> Like companyname-2.8.14-2008-12-31.sql.gz
> 
> Now look in the SL dir en look for PG-Upgrade-2.xxx-2,xx+1 sort of tools,
> and run those on the database before opening admin.pl

Unfortunately my backup name in not self explained. Just "data.sql"
Maybe is there a version information in tables?

Re: [SL] Upgrade dataset error

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

The version of the backup data is mostly in the name of the backup file.
Like companyname-2.8.14-2008-12-31.sql.gz

Now look in the SL dir en look for PG-Upgrade-2.xxx-2,xx+1 sort of tools,
and run those on the database before opening admin.pl

Should do the trick.

2009/1/31 Reverso <re...@o2...>

> I'm trying upgrade backup of my accounting data (I don't remember SL
> version) to the latest version (2.8.20)
>
> Routine:
> 1. run admin.pl and log in
> 2. select my Pg Database Administration
> 3. insert database data and click Update Dataset
> 4. select my dataset and click Continue
> 5. got Internal Server Error
>
> There is relevant apache error.log below:
>
> Undefined subroutine &main:: called at bin/mozilla/admin.pl line 1257.,
> referer: http://omnibook/sql-ledger/admin.pl
> Compilation failed in require at /usr/share/sql-ledger/admin.pl line
> 85., referer: http://omnibook/sql-ledger/admin.pl
> Premature end of script headers: admin.pl, referer:
> http://omnibook/sql-ledger/admin.pl
>
> I try on another system (mac). The result is the same.
>
> Undefined subroutine &main:: called at bin/mozilla/admin.pl line 1256.,
> referer: http://localhost/sql-ledger/admin.pl
> Compilation failed in require at
> /Library/WebServer/Documents/sql-ledger/admin.pl line 84., referer:
> http://localhost/sql-ledger
> /admin.pl <http://localhost/sql-ledger%0A/admin.pl>
> Premature end of script headers: admin.pl, referer:
> http://localhost/sql-ledger/admin.pl
>
> Any ideas how to cope with that?
>
>
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by:
> SourcForge Community
> SourceForge wants to tell your story.
> http://p.sf.net/sfu/sf-spreadtheword
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

[SL] Upgrade dataset error

[Reverso <re...@o2...>]

I'm trying upgrade backup of my accounting data (I don't remember SL
version) to the latest version (2.8.20)

Routine:
1. run admin.pl and log in
2. select my Pg Database Administration
3. insert database data and click Update Dataset
4. select my dataset and click Continue
5. got Internal Server Error

There is relevant apache error.log below:

Undefined subroutine &main:: called at bin/mozilla/admin.pl line 1257., 
referer: http://omnibook/sql-ledger/admin.pl
Compilation failed in require at /usr/share/sql-ledger/admin.pl line 
85., referer: http://omnibook/sql-ledger/admin.pl
Premature end of script headers: admin.pl, referer: 
http://omnibook/sql-ledger/admin.pl

I try on another system (mac). The result is the same.

Undefined subroutine &main:: called at bin/mozilla/admin.pl line 1256., 
referer: http://localhost/sql-ledger/admin.pl
Compilation failed in require at 
/Library/WebServer/Documents/sql-ledger/admin.pl line 84., referer: 
http://localhost/sql-ledger
/admin.pl
Premature end of script headers: admin.pl, referer: 
http://localhost/sql-ledger/admin.pl

Any ideas how to cope with that?

Re: [SL] assistance with LaTeX template - items cut off page

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

This is a common problem.  Even though the page may be defined as  
8.5x11 in the template, what actually gets printed out is the total  
length of "stuff" defined within the template.
    I.e. you need to go through it line by line and add up the total  
length of the content and then start fiddling with it and seeing  
where you can maybe combine or eliminate lines of text & carriage- 
returns, shrink margins, reduce font & image sizes etc to get the  
aggregate back down to 11in.


Thanks,

Michael


On Jan 31, 2009, at 9:48 AM, Myk Robinson wrote:

I have my TeX template set up for invoices by modifying slightly the US
Letter Size default template. I have changed only the letterhead to
include my company logo and moved the address information around a bit.

When I print an invoice, if the client has made payments, the
information is cut off at the bottom of the page. Seems as though
something is out of whack with the template, but again, I have only
adjusted the letterhead.

I need some help formatting this so that the document properly fits a US
letter sized document, 8.5 inches by 11 inches.

Here is my TeX template:

http://pastebin.ca/1323694

And a sample invoice:

http://www.sendspace.com/file/4ovnd4


Thanks in advance to anyone who can help.

--
Myk Robinson
Computer Support Specialist
Kingdom Computer Solutions
http://www.kingdomcomputer.info
myk...@ki...
(731) 616.5030
------------------------------------------------------------------------ 
------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

[SL] assistance with LaTeX template - items cut off page

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

I have my TeX template set up for invoices by modifying slightly the US
Letter Size default template. I have changed only the letterhead to
include my company logo and moved the address information around a bit.

When I print an invoice, if the client has made payments, the
information is cut off at the bottom of the page. Seems as though
something is out of whack with the template, but again, I have only
adjusted the letterhead.

I need some help formatting this so that the document properly fits a US
letter sized document, 8.5 inches by 11 inches.

Here is my TeX template:

http://pastebin.ca/1323694

And a sample invoice:

http://www.sendspace.com/file/4ovnd4


Thanks in advance to anyone who can help.

--
Myk Robinson
Computer Support Specialist
Kingdom Computer Solutions
http://www.kingdomcomputer.info
myk...@ki...
(731) 616.5030

Re: [SL] Perl on Mac OS X Leopard - SOLVED

[Reverso <re...@o2...>]

The problem source were two perl interpreters installed in the system.
I've installed pg drivers in first instance and start the second.
After dezactivating one it's work fine.

Re: [SL] Perl on Mac OS X Leopard

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

You get to the /admin.pl login ok?
There make and edit database and user, remembering to give them the Pg
driver there.
Is in the faq iirc

2009/1/29 Reverso <re...@o2...>

> Hi,
>
> I am trying to get working SL on my mac.
> I've sttopped on error "No Database Drivers available!" (admin.pl)
>
> I've installed perl modules via command:
>
> # perl -MCPAN -e 'install DBI'
> # perl -MCPAN -e 'install DBD::Pg'
>
> Below is listing of directory
> /opt/local/lib/perl5/site_perl/5.8.8/darwin-2level/
>
> drwxr-xr-x   4 root  admin     136 Jan 27 18:58 Bundle
> drwxr-xr-x  11 root  admin     374 Jan 27 18:58 DBD
> drwxr-xr-x  19 root  admin     646 Jan 27 18:55 DBI
> -r--r--r--   1 root  admin  290848 Jul 22  2008 DBI.pm
> -r--r--r--   1 root  admin   15161 Mar 25  2005 Roadmap.pod
> -r--r--r--   1 root  admin    1048 Sep  4  2006 TASKS.pod
> drwxr-xr-x   3 root  admin     102 Jan 27 18:55 Win32
> drwxr-xr-x   5 root  admin     170 Jan 27 18:58 auto
> -r--r--r--   1 root  admin    1533 Jul 16  2007 dbixs_rev.pl
> drwxr-xr-x   3 root  admin     102 Jan 27 18:58 version
> -r--r--r--   1 root  admin    1080 Jul 19  2008 version.pm
> -r--r--r--   1 root  admin   25988 Jul 19  2008 version.pod
>
>
> I've changed line in sql-ledger.conf
>
> $ENV{PERL5LIB} .= ":/opt/local/lib/perl5/site_perl/5.8.8/darwin-2level";
>
> But ... It's still not working
>
> Help needed :-)
>
>
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by:
> SourcForge Community
> SourceForge wants to tell your story.
> http://p.sf.net/sfu/sf-spreadtheword
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>