sql-ledger-users — SQL-Ledger users

Re: [SL] Service company; ad-hoc parts, parking/fuel expenses

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

On Thu, 2 Apr 2009, Alan Murrell wrote:

> I run an IT service company (well, just myself, really).  I don't keep an
> inventory, but do buy hardware and software for my clients on an as-needed
> basis.  I am wondering if the following workflow is correct?

Alan,

   I run an environmental consulting company that's primarily me. I set up
inventory items for various types of professional services and for each
travel item (e.g., air fare, vehicle rental, lodging, parking and fuel,
meals & entertainment). I have regular expense categories for work done by
colleages (Outside Services).

   While I'm neither an expert on accounting or using SL for Purchase Orders,
I encourage you to create a slew of hardware/software inventory items. They
could be generic (e.g., system board, video card, optical drive, memory,
keyboard; word processing, RDBMS, backup, etc.)

   I create sales invoices only for those clients who insist on detailed
time-and-expenses invoices (e.g., lawyers who hire me as an expert witness).

   Perhaps you should check with your accountant and ask her how she wants
you to keep records.

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] Service company; ad-hoc parts, parking/fuel expenses

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

Responses inline...

On Apr 2, 2009, at 4:08 PM, Alan Murrell wrote:

Hello.

I run an IT service company (well, just myself, really).  I don't  
keep an inventory, but do buy hardware and software for my clients on  
an as-needed basis.  I am wondering if the following workflow is  
correct?

First, I created two parts: "HARD001 - Hardware" and "SOFT001 -  
Software".  My idea is to use just those "parts" for hardware and  
software, rather than creating a seperate part for every piece of  
hardware and software I purchase.  I would then just change the  
descriptions as appropriate (e.g., change "Hardware" to "Dual-head  
video card" or change "Software" to "Microsoft Office 2007  
Profession", etc.)

Once I purchase a part, I would then create a purchase order.  From  
the purchase order I then create a vendor invoice, which I then issue  
a payment on after it has been posted.

This should, I believe, do the following:

   1.) Place the part into inventory
   2.) Balance out any amount owing to "0"

Once the part is in inventory, when I add it to a Sales Order, I am  
assuming that the inventory will be reduced accordingly?
==================================
Yes, and you can probably skip the PO and SO steps and just do  
invoices directly unless there is such a great length of time between  
events that you need the intermediary steps for your own tracking  
purposes.  (Inventory won't care either way).



Is this a good way to go about it, or is there a better way?  The  
only reason I am wanting to mess around with POs and vendor invoices  
is because I need to make sure I track the taxes that I pay on goods  
I am then reselling to my clients, and I don't know of another way to  
do that?

While on the topic, I also keep track of other expenses like parking  
and fuel.  What is the best way to do that?  Should I enter them in  
individually as a GL transaction, or do a PO/vendor invoice thing?  I  
wouldn't want to do a PO/vendor invoice for each individual fuel and  
parking expense, as I have quite a few of them in the course of a  
month.  Is this what "Vouchers" are for?  I am thinking a "cleaner"  
way to do this is to track my fuel and parking for each month  
seperately, but in a spreadsheet (one for each month) which keeps a  
total of each expense, plus any taxes paid on it.  I can then maybe  
create a "dummy" vendor for these sorts of expenses and do the PO/ 
vendor invoice thing; I wouldn't mind doing it once per month, or is  
a GL transaction best?  Can you input taxes paid and have them go  
into the appropriate tax account by doing a GL transaction?
==================================
GL entries are fine.  You'll probably need to create a couple of  
different expense accounts for fuel vs meals etc depending on the tax  
laws in your region.  A few minutes, (literally), with a bookkeeper  
will tell you what you need to know in that regard.






I hope that makes sense?

Thanks for your tips!

-Alan

------------------------------------------------------------------------ 
------
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

[SL] Service company; ad-hoc parts, parking/fuel expenses

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

Hello.

I run an IT service company (well, just myself, really).  I don't keep an inventory, but do buy hardware and software for my clients on an as-needed basis.  I am wondering if the following workflow is correct?

First, I created two parts: "HARD001 - Hardware" and "SOFT001 - Software".  My idea is to use just those "parts" for hardware and software, rather than creating a seperate part for every piece of hardware and software I purchase.  I would then just change the descriptions as appropriate (e.g., change "Hardware" to "Dual-head video card" or change "Software" to "Microsoft Office 2007 Profession", etc.)

Once I purchase a part, I would then create a purchase order.  From the purchase order I then create a vendor invoice, which I then issue a payment on after it has been posted.

This should, I believe, do the following:

  1.) Place the part into inventory
  2.) Balance out any amount owing to "0"

Once the part is in inventory, when I add it to a Sales Order, I am assuming that the inventory will be reduced accordingly?

Is this a good way to go about it, or is there a better way?  The only reason I am wanting to mess around with POs and vendor invoices is because I need to make sure I track the taxes that I pay on goods I am then reselling to my clients, and I don't know of another way to do that?

While on the topic, I also keep track of other expenses like parking and fuel.  What is the best way to do that?  Should I enter them in individually as a GL transaction, or do a PO/vendor invoice thing?  I wouldn't want to do a PO/vendor invoice for each individual fuel and parking expense, as I have quite a few of them in the course of a month.  Is this what "Vouchers" are for?  I am thinking a "cleaner" way to do this is to track my fuel and parking for each month seperately, but in a spreadsheet (one for each month) which keeps a total of each expense, plus any taxes paid on it.  I can then maybe create a "dummy" vendor for these sorts of expenses and do the PO/vendor invoice thing; I wouldn't mind doing it once per month, or is a GL transaction best?  Can you input taxes paid and have them go into the appropriate tax account by doing a GL transaction?

I hope that makes sense?

Thanks for your tips!

-Alan

Re: [SL] Multiple Entries for Same Transaction

[Jerome J. A. <jer...@bo...>]

No DST for our timezone and TZ is set to local time.

http://www.techsier.com - Blog
http://www.boholweb.com - Bohol tourism website
http://www.auza.net - enabling e-services in Bohol



Michael Hasse wrote:

>Are they near the new/old DST time change?  :)
>
>
>On Mar 31, 2009, at 11:02 PM, Jerome J. Auza wrote:
>
>Hi Rich,
>
>Did you manage to find the problem for this one?  I ran into a similar
>problem happening to a client running version 2.8.13.  This problem
>started to show in Dec 2008 where  a POS transaction is shown multiple
>times on different dates in GL.  They just noticed it recently that
>there are ghost entries.  The ghost entries just seem to be both a debit
>and a credit on the same account so overall, there is no effect but the
>question is why are they showing up on different dates when creating a
>GL report.  The correct data is the latest one.
>
>jerome
>
>http://www.techsier.com - Blog
>http://www.boholweb.com - Bohol tourism website
>http://www.auza.net - enabling e-services in Bohol
>
>
>
>Rich Shepard wrote:
>
>  
>
>>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
>>
>>
>>
>>    
>>
>
>------------------------------------------------------------------------ 
>------
>_______________________________________________
>sql-ledger-users mailing list
>sql...@li...
>https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
>------------------------------------------------------------------------------
>_______________________________________________
>sql-ledger-users mailing list
>sql...@li...
>https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>  
>

Re: [SL] Multiple Entries for Same Transaction

[Jerome J. A. <jer...@bo...>]

We can't duplicate how it appears.  It just happens on some transactions 
and only from POS transactions.

http://www.techsier.com - Blog
http://www.boholweb.com - Bohol tourism website
http://www.auza.net - enabling e-services in Bohol



Rich Shepard wrote:

>On Wed, 1 Apr 2009, Jerome J. Auza wrote:
>
>  
>
>>Did you manage to find the problem for this one?
>>    
>>
>
>Jerome,
>
>   No, I haven't found why it happened, and I'm still cleaning up the data.
>I'm not happy about the situation but am making the best of it that I can.
>
>Rich
>
>  
>

Re: [SL] Multiple Entries for Same Transaction

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

On Tue, 31 Mar 2009, Michael Hasse wrote:

> Are they near the new/old DST time change?  :)

   Not in my case. The duplicates (in almost every account) go back to 2004
and end in mid-2008. This does not mean the issue started then (I suspect it
was very recent), but those are the transactions affected. PITA.

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 Wed, 1 Apr 2009, Jerome J. Auza wrote:

> Did you manage to find the problem for this one?

Jerome,

   No, I haven't found why it happened, and I'm still cleaning up the data.
I'm not happy about the situation but am making the best of it that I can.

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...>]

Are they near the new/old DST time change?  :)


On Mar 31, 2009, at 11:02 PM, Jerome J. Auza wrote:

Hi Rich,

Did you manage to find the problem for this one?  I ran into a similar
problem happening to a client running version 2.8.13.  This problem
started to show in Dec 2008 where  a POS transaction is shown multiple
times on different dates in GL.  They just noticed it recently that
there are ghost entries.  The ghost entries just seem to be both a debit
and a credit on the same account so overall, there is no effect but the
question is why are they showing up on different dates when creating a
GL report.  The correct data is the latest one.

jerome

http://www.techsier.com - Blog
http://www.boholweb.com - Bohol tourism website
http://www.auza.net - enabling e-services in Bohol



Rich Shepard wrote:

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

------------------------------------------------------------------------ 
------
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Multiple Entries for Same Transaction

[Jerome J. A. <jer...@bo...>]

Hi Rich,

Did you manage to find the problem for this one?  I ran into a similar 
problem happening to a client running version 2.8.13.  This problem 
started to show in Dec 2008 where  a POS transaction is shown multiple 
times on different dates in GL.  They just noticed it recently that 
there are ghost entries.  The ghost entries just seem to be both a debit 
and a credit on the same account so overall, there is no effect but the 
question is why are they showing up on different dates when creating a 
GL report.  The correct data is the latest one.

jerome

http://www.techsier.com - Blog
http://www.boholweb.com - Bohol tourism website
http://www.auza.net - enabling e-services in Bohol



Rich Shepard wrote:

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

[SL] A few invoice issues

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

Hello-

Seems that something may have changed along the way with invoices.. 
My line items on my invoices, the first one always shows position 1, but
the next ones after seem to show a random number.
For example, I generated a false invoice to test, my first item showed
the correct position number one and the correct item number. My second
line item showed position 15064, followed by the correct item number.

how do I get the correct line number to show on my invoices? Seems this
should be automatic, and I don't remember having this problem before a
few updates ago..

Thanks,
-myk robinson

Re: [SL] Categories for taxes

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

The sales tax paid by you is NOT an expense account. It is a balance sheet
item (asset) that can be settled against the sales tax received by you that
you have to hand over to the tax man every month/quarter/year. To simlify
it, just think of TWO invoices. You buy a computer for 100$ including 20%
tax, then sell it for 200$ including 20% tax.

Sales tax on the buy (AP ledger, you will pay the factory normally) is 20$.
The sale goes either cash or on account, which will be AR (you want to
receive the money) .

The tax man will want to receive 40, but you can deduct the 20 you  paid
yourself.

Effectively, Tax has been taken over the VA part (Value added) of 200 minus
100 thta way.

2009/3/28 Stuart Luppescu <sl...@cc...>

> Hello, I've been muddling along with just one sales tax account for a
> long time, but I've decided I should do it right, with one account for
> sales tax paid, and one account for sales tax collected.
>
> I'm not sure that I'm classifying these accounts correctly. The sales
> tax collected account (for tax on retail sales) is AR_tax, AP_tax,
> IC_taxpart, and IC_taxservice. It's a liability account. Sale tax paid
> is AP_tax, IC_taxpart, and IC_taxservice, and it's an expense account.
>
> Does this seem correct? I'd appreciate some guidance. I'm worried that
> when we do purchases, both taxes will be calculated; or when we sell
> something, the sale tax paid will be calculated; or something else
> screwy will happen. How can I prevent this kind of mistakes?
>
> Thanks.
>
> --
> Stuart Luppescu -=- s-luppescu .at. uchicago.edu
> University of Chicago (^_^)/ CCSR
> 才文と智奈美の父 -=-=- Kernel 2.6.25-gentoo-r
> What an author likes to write most is his
>  signature on the back of a cheque.   -- Brendan
>  Francis
>
>
>
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

[SL] Categories for taxes

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

Hello, I've been muddling along with just one sales tax account for a
long time, but I've decided I should do it right, with one account for
sales tax paid, and one account for sales tax collected.

I'm not sure that I'm classifying these accounts correctly. The sales
tax collected account (for tax on retail sales) is AR_tax, AP_tax,
IC_taxpart, and IC_taxservice. It's a liability account. Sale tax paid
is AP_tax, IC_taxpart, and IC_taxservice, and it's an expense account. 

Does this seem correct? I'd appreciate some guidance. I'm worried that
when we do purchases, both taxes will be calculated; or when we sell
something, the sale tax paid will be calculated; or something else
screwy will happen. How can I prevent this kind of mistakes?

Thanks.

-- 
Stuart Luppescu -=- s-luppescu .at. uchicago.edu        
University of Chicago (^_^)/ CCSR 
才文と智奈美の父 -=-=- Kernel 2.6.25-gentoo-r
What an author likes to write most is his
 signature on the back of a cheque.   -- Brendan
 Francis 
 
 

Re: [SL] Sometimes can't print Sales Orders or Invoices

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

Hello List,

I have received a solution to this problem and I will share it with you. I was 
sent a patch by a fellow, Justin Wheeler, but I don't know how to apply the 
patch so I asked and this is the reply:

______________________________

Go into your sql ledger directory and go to the SL/Form.pm file.

Look for line 1007 which should be:

$str = $self->{$var}[$i];

Change it to say:

my $ary_ref = $self->{ $var };
$str = defined $ary_ref->[ $i ] ? $ary_ref->[ $i ] : q{};

That should fix it up.

Of course, back up the file before you modify it, and put it back if it breaks 
something.

_________________________________

Now, I do have the patch and I don't see why I shouldn't send it to anyone who 
asks for it by contacting me offline. This has worked for me and I'm grateful 
to Mr. Wheeler for the solution.


________________________

Nicholas Thirkettle, OSB

Saint Joseph's Monastery
Natchez, MS 39120

www.osbms.org
________________________





On Saturday 07 March 2009 01:43:55 Michael Hasse wrote:
> It's easy to sell things that aren't in inventory, we do it all the
> time when parts come in last minute for a project with a tight
> schedule.  The system handles it just fine as a negative inventory
> quantity.
>     Not to mention having had new employees do some truly bizarre and
> creative stuff when trying to create, correct and/or sell assemblies
> with wrong parts and/or new parts I strongly doubt this is the cause
> of the issue as we've never seen this kind of thing come up before.
>
>
> Thanks,
>
> Michael
>
>
> On Mar 6, 2009, at 10:18 PM, Paul Tammes wrote:
>
> Keep using articles, but do it right.
>
> I would strongly advise to not change existing articles, but copy
> them (save
> as new) and then do some changing.
> So "PC c2d version 1" could be saved as new, e.g. "PC c4d version 1".
> THEN change the CPU in the assembly to a quadcore. That way, you will
> not
> try to sell or assemble a PC with a quadcore IN THE PAST while
> quadcore was
> not available.
>
> No wonder you can not get the invice to print. The item (or part of the
> assembly) was not at hand, so how could u have sold it to begin with?
>
> Maybe you could even do the new article bit now, setting original
> article
> back.
> Re-try the sales and if that works, make a new article.
>
> Basic idea: The flow of goods trough the accounting depratment should
> match
> the real world. If you do that, this kind of problem woul dnot arise
> again I
> take it.
> (Other kinds of problems will take their place, not to worry)
>
> Hth
>
> 2009/3/6 Nicholas Thirkettle OSB <brn...@os...>
>
> > I have a feeling that it may be something to do with the inventory
> > in my
> > case.
> > This problem started about the time that we changed the formula for
> > one of
> > the
> > products that we make. I have tried to recreate invoices using both
> > old and
> > new formulas and it happens only on the invoices that have the new
> > formula.
> > I'm about to give it up because a few days ago I was asked for
> > Departmental
> > Income Statements for last year and I realized that they always
> > specify
> > Cash
> > Basis. I think I may just set up all products as services and just
> > do a
> > manual
> > inventory periodically. The problem is that we won't be aware when
> > items
> > are
> > taken out of the shop and not written down. We only report and pay
> > taxes we
> > collect in the State of Mississippi so it would probably be a much
> > simpler
> > solution. Anyone see any potential problems with this?
> >
> > Br. Nicholas
> > --
> > ________________________
> >
> > Nicholas Thirkettle, OSB
> >
> > Saint Joseph's Monastery
> > Natchez, MS 39120
> >
> > www.osbms.org
> >
> > On Friday 06 March 2009 01:54:08 Paul Tammes wrote:
> >> The 'sometimes' part is evil. A problem that only hick ups now and
> >> then
> >
> > is
> >
> >> extremely hard to find, let alone solve. One wild guess: do the
> >> names of
> >> customers with print errors have any strange letters or signs, like
> >> unmlauts, # or ë?
> >> I seem to remember people with problems that disappeared when
> >> renamed to
> >
> > e
> >
> >> instead of ë. Or something silly like a space too much at the
> >> beginning
> >
> > of
> >
> >> the name, so" Jansen" iso "Jansen" might be cooking things up.
> >>
> >> Hth
> >>
> >> 2009/3/5 C. Duncan Hudson <du...@du...>
> >>
> >>> I'm having the same problem.  Not on every invoice, but frequently
> >>> enough that it's a major issue.
> >>> We're running SQL-Ledger 2.8.23, Fedora 10, Perl 5.10.0, Postgres
> >>> 8.3.4.1, and Apache 2.2.10.
> >>> I've spoken to Dieter about this and he insists that it's a Perl
> >>> problem.  I don't really care if it's
> >>> a Perl problem, or a Perl coding problem, but I need a solution
> >>> because
> >>> right now I can't
> >>> invoice all my customers.
> >>>
> >>> Dunc
> >>>
> >>> Nicholas Thirkettle OSB wrote:
> >>>> Hello,
> >>>>
> >>>> Sometimes when I try to print Sales Orders or Invoices I get the
> >>>
> >>> following
> >>>
> >>>> error:
> >>>>
> >>>> panic: attempt to copy freed scalar c3a488 to 8e4178 at SL/Form.pm
> >
> > line
> >
> >>> 1007
> >>>
> >>>> I have tried searching for a solution in the forums and I have
> >>>> found
> >
> > a
> >
> >>> similar
> >>>
> >>>> problem a number of versions ago. I haven't actually found a
> >
> > solution.
> >
> >>>> I
> >>>
> >>> am
> >>>
> >>>> using SQL-Ledger Version 2.8.23 and I believe that is the most
> >
> > recent.
> >
> >>> Some
> >>>
> >>>> inovices print just fine. I read that it is when an invoice has
> >>>> more
> >>>> than
> >>>
> >>> 4
> >>>
> >>>> lines and the invoice I'm having trouble with right now has 8. I
> >
> > tried
> >
> >>>> deleting all the lines except for 3 but I still have the problem.
> >>>>
> >>>> openSuse 11.0
> >>>> perl 5.10.0-37.6
> >>>> SQL-Ledger 2.8.23
> >>>>
> >>>> Any help is appreciated.
> >>>>
> >>>> Br. Nicholas
> >
> > ----------------------------------------------------------------------
> > ---
> >
> >>> ----- Open Source Business Conference (OSBC), March 24-25, 2009, San
> >>> Francisco, CA
> >>> -OSBC tackles the biggest issue in open source: Open Sourcing the
> >>> Enterprise
> >>> -Strategies to boost innovation and cut costs with open source
> >>> participation
> >>> -Receive a $600 discount off the registration fee with the source
> >>> code:
> >>> SFAD
> >>> http://p.sf.net/sfu/XcvMzF8H
> >>> _______________________________________________
> >>> sql-ledger-users mailing list
> >>> sql...@li...
> >>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >
> > ----------------------------------------------------------------------
> > -----
> >
> >> --- Open Source Business Conference (OSBC), March 24-25, 2009, San
> >> Francisco, CA -OSBC tackles the biggest issue in open source: Open
> >
> > Sourcing
> >
> >> the Enterprise -Strategies to boost innovation and cut costs with
> >> open
> >> source participation -Receive a $600 discount off the registration
> >> fee
> >
> > with
> >
> >> the source code: SFAD http://p.sf.net/sfu/XcvMzF8H
> >> _______________________________________________
> >> sql-ledger-users mailing list
> >> sql...@li...
> >> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >
> > ________________________
> >
> >
> >
> > ----------------------------------------------------------------------
> > --------
> > Open Source Business Conference (OSBC), March 24-25, 2009, San
> > Francisco,
> > CA
> > -OSBC tackles the biggest issue in open source: Open Sourcing the
> > Enterprise
> > -Strategies to boost innovation and cut costs with open source
> > participation
> > -Receive a $600 discount off the registration fee with the source
> > code:
> > SFAD
> > http://p.sf.net/sfu/XcvMzF8H
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
> ------------------------------------------------------------------------
> ------
> Open Source Business Conference (OSBC), March 24-25, 2009, San
> Francisco, CA
> -OSBC tackles the biggest issue in open source: Open Sourcing the
> Enterprise
> -Strategies to boost innovation and cut costs with open source
> participation
> -Receive a $600 discount off the registration fee with the source
> code: SFAD
> http://p.sf.net/sfu/XcvMzF8H
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
> ---------------------------------------------------------------------------
>--- Open Source Business Conference (OSBC), March 24-25, 2009, San
> Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing
> the Enterprise -Strategies to boost innovation and cut costs with open
> source participation -Receive a $600 discount off the registration fee with
> the source code: SFAD http://p.sf.net/sfu/XcvMzF8H
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Bank Reconciliation

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

On Tue, Mar 17, 2009 at 6:35 AM, P.V.Anthony <an...@so...> wrote:
> On 17-Mar-09 7:22 AM, Armaghan Saqib wrote:
>
>> If you are interested in the patch, contact me off-list and I shall
>> send you the patched rc.pl file.
>
> Please share the patch with Dieter. Maybe he may include the patches in
> the next update of SQL-Ledger.

I have sent the patched files to list members who requested. I shall
soon be putting it on the ledger123 git repository and dropping a note
to Dieter too.

Regards

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

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

[SL] Inventory Bin Locations Disappearing

[Nathan L. <nl...@to...>]

Has anyone experienced and/or found a solution for the disappearance
of inventory bin locations in SQL-Ledger? We consistently see bins
that disappear from the parts data. It doesn't seem to happen
immediately, but after some period of time...usually 1 or more days.
All other data seems unaffected...and bin data entered in the notes
field (as a workaround) remains in place.

I have spent quite a bit of time trying to research this problem, but
with no definitive result. I have also done application upgrades as
available, but with no affect on the problem. Any insight would be
appreciated.

Thanks,
Nathan

Re: [SL] Sometimes can't print Sales Orders or Invoices

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

On Saturday 07 March 2009 01:43:55 Michael Hasse wrote:
> It's easy to sell things that aren't in inventory, we do it all the
> time when parts come in last minute for a project with a tight
> schedule.  The system handles it just fine as a negative inventory
> quantity.
>     Not to mention having had new employees do some truly bizarre and
> creative stuff when trying to create, correct and/or sell assemblies
> with wrong parts and/or new parts I strongly doubt this is the cause
> of the issue as we've never seen this kind of thing come up before.
>
>
> Thanks,
>
> Michael
>
>
> On Mar 6, 2009, at 10:18 PM, Paul Tammes wrote:
>
> Keep using articles, but do it right.
>
> I would strongly advise to not change existing articles, but copy
> them (save
> as new) and then do some changing.
> So "PC c2d version 1" could be saved as new, e.g. "PC c4d version 1".
> THEN change the CPU in the assembly to a quadcore. That way, you will
> not
> try to sell or assemble a PC with a quadcore IN THE PAST while
> quadcore was
> not available.
>
> No wonder you can not get the invice to print. The item (or part of the
> assembly) was not at hand, so how could u have sold it to begin with?
>
> Maybe you could even do the new article bit now, setting original
> article
> back.
> Re-try the sales and if that works, make a new article.
>
> Basic idea: The flow of goods trough the accounting depratment should
> match
> the real world. If you do that, this kind of problem woul dnot arise
> again I
> take it.
> (Other kinds of problems will take their place, not to worry)
>
> Hth
>
> 2009/3/6 Nicholas Thirkettle OSB <brn...@os...>
>
> > I have a feeling that it may be something to do with the inventory
> > in my
> > case.
> > This problem started about the time that we changed the formula for
> > one of
> > the
> > products that we make. I have tried to recreate invoices using both
> > old and
> > new formulas and it happens only on the invoices that have the new
> > formula.
> > I'm about to give it up because a few days ago I was asked for
> > Departmental
> > Income Statements for last year and I realized that they always
> > specify
> > Cash
> > Basis. I think I may just set up all products as services and just
> > do a
> > manual
> > inventory periodically. The problem is that we won't be aware when
> > items
> > are
> > taken out of the shop and not written down. We only report and pay
> > taxes we
> > collect in the State of Mississippi so it would probably be a much
> > simpler
> > solution. Anyone see any potential problems with this?
> >
> > Br. Nicholas
> > --
> > ________________________
> >
> > Nicholas Thirkettle, OSB
> >
> > Saint Joseph's Monastery
> > Natchez, MS 39120
> >
> > www.osbms.org
> >
> > On Friday 06 March 2009 01:54:08 Paul Tammes wrote:
> >> The 'sometimes' part is evil. A problem that only hick ups now and
> >> then
> >
> > is
> >
> >> extremely hard to find, let alone solve. One wild guess: do the
> >> names of
> >> customers with print errors have any strange letters or signs, like
> >> unmlauts, # or ë?
> >> I seem to remember people with problems that disappeared when
> >> renamed to
> >
> > e
> >
> >> instead of ë. Or something silly like a space too much at the
> >> beginning
> >
> > of
> >
> >> the name, so" Jansen" iso "Jansen" might be cooking things up.
> >>
> >> Hth
> >>
> >> 2009/3/5 C. Duncan Hudson <du...@du...>
> >>
> >>> I'm having the same problem.  Not on every invoice, but frequently
> >>> enough that it's a major issue.
> >>> We're running SQL-Ledger 2.8.23, Fedora 10, Perl 5.10.0, Postgres
> >>> 8.3.4.1, and Apache 2.2.10.
> >>> I've spoken to Dieter about this and he insists that it's a Perl
> >>> problem.  I don't really care if it's
> >>> a Perl problem, or a Perl coding problem, but I need a solution
> >>> because
> >>> right now I can't
> >>> invoice all my customers.
> >>>
> >>> Dunc
> >>>
> >>> Nicholas Thirkettle OSB wrote:
> >>>> Hello,
> >>>>
> >>>> Sometimes when I try to print Sales Orders or Invoices I get the
> >>>
> >>> following
> >>>
> >>>> error:
> >>>>
> >>>> panic: attempt to copy freed scalar c3a488 to 8e4178 at SL/Form.pm
> >
> > line
> >
> >>> 1007
> >>>
> >>>> I have tried searching for a solution in the forums and I have
> >>>> found
> >
> > a
> >
> >>> similar
> >>>
> >>>> problem a number of versions ago. I haven't actually found a
> >
> > solution.
> >
> >>>> I
> >>>
> >>> am
> >>>
> >>>> using SQL-Ledger Version 2.8.23 and I believe that is the most
> >
> > recent.
> >
> >>> Some
> >>>
> >>>> inovices print just fine. I read that it is when an invoice has
> >>>> more
> >>>> than
> >>>
> >>> 4
> >>>
> >>>> lines and the invoice I'm having trouble with right now has 8. I
> >
> > tried
> >
> >>>> deleting all the lines except for 3 but I still have the problem.
> >>>>
> >>>> openSuse 11.0
> >>>> perl 5.10.0-37.6
> >>>> SQL-Ledger 2.8.23
> >>>>
> >>>> Any help is appreciated.
> >>>>
> >>>> Br. Nicholas
> >
> > ----------------------------------------------------------------------
> > ---
> >
> >>> ----- Open Source Business Conference (OSBC), March 24-25, 2009, San
> >>> Francisco, CA
> >>> -OSBC tackles the biggest issue in open source: Open Sourcing the
> >>> Enterprise
> >>> -Strategies to boost innovation and cut costs with open source
> >>> participation
> >>> -Receive a $600 discount off the registration fee with the source
> >>> code:
> >>> SFAD
> >>> http://p.sf.net/sfu/XcvMzF8H
> >>> _______________________________________________
> >>> sql-ledger-users mailing list
> >>> sql...@li...
> >>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >
> > ----------------------------------------------------------------------
> > -----
> >
> >> --- Open Source Business Conference (OSBC), March 24-25, 2009, San
> >> Francisco, CA -OSBC tackles the biggest issue in open source: Open
> >
> > Sourcing
> >
> >> the Enterprise -Strategies to boost innovation and cut costs with
> >> open
> >> source participation -Receive a $600 discount off the registration
> >> fee
> >
> > with
> >
> >> the source code: SFAD http://p.sf.net/sfu/XcvMzF8H
> >> _______________________________________________
> >> sql-ledger-users mailing list
> >> sql...@li...
> >> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >
> > ________________________
> >
> >
> >
> > ----------------------------------------------------------------------
> > --------
> > Open Source Business Conference (OSBC), March 24-25, 2009, San
> > Francisco,
> > CA
> > -OSBC tackles the biggest issue in open source: Open Sourcing the
> > Enterprise
> > -Strategies to boost innovation and cut costs with open source
> > participation
> > -Receive a $600 discount off the registration fee with the source
> > code:
> > SFAD
> > http://p.sf.net/sfu/XcvMzF8H
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
> ------------------------------------------------------------------------
> ------
> Open Source Business Conference (OSBC), March 24-25, 2009, San
> Francisco, CA
> -OSBC tackles the biggest issue in open source: Open Sourcing the
> Enterprise
> -Strategies to boost innovation and cut costs with open source
> participation
> -Receive a $600 discount off the registration fee with the source
> code: SFAD
> http://p.sf.net/sfu/XcvMzF8H
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
> ---------------------------------------------------------------------------
>--- Open Source Business Conference (OSBC), March 24-25, 2009, San
> Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing
> the Enterprise -Strategies to boost innovation and cut costs with open
> source participation -Receive a $600 discount off the registration fee with
> the source code: SFAD http://p.sf.net/sfu/XcvMzF8H
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Now I don't think that the problem is in the inventory because I have set up 
each of our products as a service and I still get the same error. Therefore I 
have gone back to tracking the inventory.

Last week a set aside a day and upgraded my operating system to opensuse 11.1, 
the latest version, hoping that may help. I also did a fresh install of SQL-
Ledger 2.8.23. I have the latest stable version of perl. It still won't print 
properly. I created a Sales Order with various quantities of five different 
items and when I try to print I get the following error message:

Error!

Bizarre copy of ARRAY in sassign at SL/Form.pm line 1007.

This is not exactly the same error message as before but it is still the same 
line number. Does anyone have a clue about this?

Br. Nicholas
Saint Joseph's Monastery
Natchez, Mississippi

Re: [SL] Bank Reconciliation

[P.V.Anthony <an...@so...>]

On 17-Mar-09 7:22 AM, Armaghan Saqib wrote:

> If you are interested in the patch, contact me off-list and I shall
> send you the patched rc.pl file.

Please share the patch with Dieter. Maybe he may include the patches in 
the next update of SQL-Ledger.

P.V.Anthony

Re: [SL] Bank Reconciliation

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

On Tue, Mar 17, 2009 at 12:53 AM, John Saunders <jo...@sc...> wrote:
>
> I am running SL 2.8.23 on Linux with PostgreSQL.
>
> I have a strange phenomenon in that once a bankaccount is reconciled, updated and
> "Done" it seems that the changesare not posted and each time I go into Bank
> Reconciliation  I get all the previous entries which were already reconciled,

Starting from version 2.8.0 there are at least 3 bank reconciliation
issues (which I have corrected in my hosted version. see
http://www.ledger123.com/our-enhancements/)

1. When there are multiple receipts for a single invoice/date or same
amount/date, only one is shown. This happens when

* When source column is blank for both payments
* When source column contains same value for both payments.

2) Marking one receipt of *same* invoice as reconciled will
incorrectly mark the other receipt as reconciled as well.

3) Reconciled transactions are displayed on reconciliation screen
forever making it inconvenient and error prone to do the
reconciliation.

If you are interested in the patch, contact me off-list and I shall
send you the patched rc.pl file.

Regards

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

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

Re: [SL] Bank Reconciliation

[William M. <wi...@kn...>]

On Mon, 2009-03-16 at 21:53 +0200, John Saunders wrote:
> I am running SL 2.8.23 on Linux with PostgreSQL.
> 
> I have a strange phenomenon in that once a bankaccount is reconciled,
>  updated and "Done" it seems that the changesare not posted and each
>  time I go into Bank Reconciliation  I get all the previous entries
>  which were already reconciled,
> 
> Can anyone help with this ?

Sorry, I can only confirm that we have on-going issues with
reconcilation. Generally, we're able to figure out where something got
unmarked. Usually, it's due to making edits to a reconciled item;
SQL-Ledger allows this with no warning that it will be marked as
unreconciled.


William
-- 
Knowmad Technologies - Open Source Software Solutions
W: http://www.knowmad.com | E: wi...@kn...
P: 704.343.9330 | http://www.LinkedIn.com/in/williammckee

[SL] Bank Reconciliation

[John S. <jo...@sc...>]

I am running SL 2.8.23 on Linux with PostgreSQL.

I have a strange phenomenon in that once a bankaccount is reconciled, updated and "Done" it seems that the changesare not posted and each time I go into Bank Reconciliation  I get all the previous entries which were already reconciled,

Can anyone help with this ?

Thanks,

John

Re: [SL] Sometimes can't print Sales Orders or Invoices

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

It's easy to sell things that aren't in inventory, we do it all the  
time when parts come in last minute for a project with a tight  
schedule.  The system handles it just fine as a negative inventory  
quantity.
    Not to mention having had new employees do some truly bizarre and  
creative stuff when trying to create, correct and/or sell assemblies  
with wrong parts and/or new parts I strongly doubt this is the cause  
of the issue as we've never seen this kind of thing come up before.


Thanks,

Michael


On Mar 6, 2009, at 10:18 PM, Paul Tammes wrote:

Keep using articles, but do it right.

I would strongly advise to not change existing articles, but copy  
them (save
as new) and then do some changing.
So "PC c2d version 1" could be saved as new, e.g. "PC c4d version 1".
THEN change the CPU in the assembly to a quadcore. That way, you will  
not
try to sell or assemble a PC with a quadcore IN THE PAST while  
quadcore was
not available.

No wonder you can not get the invice to print. The item (or part of the
assembly) was not at hand, so how could u have sold it to begin with?

Maybe you could even do the new article bit now, setting original  
article
back.
Re-try the sales and if that works, make a new article.

Basic idea: The flow of goods trough the accounting depratment should  
match
the real world. If you do that, this kind of problem woul dnot arise  
again I
take it.
(Other kinds of problems will take their place, not to worry)

Hth

2009/3/6 Nicholas Thirkettle OSB <brn...@os...>

> I have a feeling that it may be something to do with the inventory  
> in my
> case.
> This problem started about the time that we changed the formula for  
> one of
> the
> products that we make. I have tried to recreate invoices using both  
> old and
> new formulas and it happens only on the invoices that have the new  
> formula.
> I'm about to give it up because a few days ago I was asked for  
> Departmental
> Income Statements for last year and I realized that they always  
> specify
> Cash
> Basis. I think I may just set up all products as services and just  
> do a
> manual
> inventory periodically. The problem is that we won't be aware when  
> items
> are
> taken out of the shop and not written down. We only report and pay  
> taxes we
> collect in the State of Mississippi so it would probably be a much  
> simpler
> solution. Anyone see any potential problems with this?
>
> Br. Nicholas
> --
> ________________________
>
> Nicholas Thirkettle, OSB
>
> Saint Joseph's Monastery
> Natchez, MS 39120
>
> www.osbms.org
>
>
> On Friday 06 March 2009 01:54:08 Paul Tammes wrote:
>> The 'sometimes' part is evil. A problem that only hick ups now and  
>> then
> is
>> extremely hard to find, let alone solve. One wild guess: do the  
>> names of
>> customers with print errors have any strange letters or signs, like
>> unmlauts, # or ë?
>> I seem to remember people with problems that disappeared when  
>> renamed to
> e
>> instead of ë. Or something silly like a space too much at the  
>> beginning
> of
>> the name, so" Jansen" iso "Jansen" might be cooking things up.
>>
>> Hth
>>
>> 2009/3/5 C. Duncan Hudson <du...@du...>
>>
>>> I'm having the same problem.  Not on every invoice, but frequently
>>> enough that it's a major issue.
>>> We're running SQL-Ledger 2.8.23, Fedora 10, Perl 5.10.0, Postgres
>>> 8.3.4.1, and Apache 2.2.10.
>>> I've spoken to Dieter about this and he insists that it's a Perl
>>> problem.  I don't really care if it's
>>> a Perl problem, or a Perl coding problem, but I need a solution  
>>> because
>>> right now I can't
>>> invoice all my customers.
>>>
>>> Dunc
>>>
>>> Nicholas Thirkettle OSB wrote:
>>>> Hello,
>>>>
>>>> Sometimes when I try to print Sales Orders or Invoices I get the
>>>
>>> following
>>>
>>>> error:
>>>>
>>>> panic: attempt to copy freed scalar c3a488 to 8e4178 at SL/Form.pm
> line
>>>
>>> 1007
>>>
>>>> I have tried searching for a solution in the forums and I have  
>>>> found
> a
>>>
>>> similar
>>>
>>>> problem a number of versions ago. I haven't actually found a
> solution.
>>>> I
>>>
>>> am
>>>
>>>> using SQL-Ledger Version 2.8.23 and I believe that is the most
> recent.
>>>
>>> Some
>>>
>>>> inovices print just fine. I read that it is when an invoice has  
>>>> more
>>>> than
>>>
>>> 4
>>>
>>>> lines and the invoice I'm having trouble with right now has 8. I
> tried
>>>> deleting all the lines except for 3 but I still have the problem.
>>>>
>>>> openSuse 11.0
>>>> perl 5.10.0-37.6
>>>> SQL-Ledger 2.8.23
>>>>
>>>> Any help is appreciated.
>>>>
>>>> Br. Nicholas
>>>
>>>
> ---------------------------------------------------------------------- 
> ---
>>> ----- Open Source Business Conference (OSBC), March 24-25, 2009, San
>>> Francisco, CA
>>> -OSBC tackles the biggest issue in open source: Open Sourcing the
>>> Enterprise
>>> -Strategies to boost innovation and cut costs with open source
>>> participation
>>> -Receive a $600 discount off the registration fee with the source  
>>> code:
>>> SFAD
>>> http://p.sf.net/sfu/XcvMzF8H
>>> _______________________________________________
>>> sql-ledger-users mailing list
>>> sql...@li...
>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
>>
> ---------------------------------------------------------------------- 
> -----
>> --- Open Source Business Conference (OSBC), March 24-25, 2009, San
>> Francisco, CA -OSBC tackles the biggest issue in open source: Open
> Sourcing
>> the Enterprise -Strategies to boost innovation and cut costs with  
>> open
>> source participation -Receive a $600 discount off the registration  
>> fee
> with
>> the source code: SFAD http://p.sf.net/sfu/XcvMzF8H
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
> ________________________
>
>
>
> ---------------------------------------------------------------------- 
> --------
> Open Source Business Conference (OSBC), March 24-25, 2009, San  
> Francisco,
> CA
> -OSBC tackles the biggest issue in open source: Open Sourcing the
> Enterprise
> -Strategies to boost innovation and cut costs with open source
> participation
> -Receive a $600 discount off the registration fee with the source  
> code:
> SFAD
> http://p.sf.net/sfu/XcvMzF8H
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
------------------------------------------------------------------------ 
------
Open Source Business Conference (OSBC), March 24-25, 2009, San  
Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the  
Enterprise
-Strategies to boost innovation and cut costs with open source  
participation
-Receive a $600 discount off the registration fee with the source  
code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Sometimes can't print Sales Orders or Invoices

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

Keep using articles, but do it right.

I would strongly advise to not change existing articles, but copy them (save
as new) and then do some changing.
So "PC c2d version 1" could be saved as new, e.g. "PC c4d version 1".
THEN change the CPU in the assembly to a quadcore. That way, you will not
try to sell or assemble a PC with a quadcore IN THE PAST while quadcore was
not available.

No wonder you can not get the invice to print. The item (or part of the
assembly) was not at hand, so how could u have sold it to begin with?

Maybe you could even do the new article bit now, setting original article
back.
Re-try the sales and if that works, make a new article.

Basic idea: The flow of goods trough the accounting depratment should match
the real world. If you do that, this kind of problem woul dnot arise again I
take it.
(Other kinds of problems will take their place, not to worry)

Hth

2009/3/6 Nicholas Thirkettle OSB <brn...@os...>

> I have a feeling that it may be something to do with the inventory in my
> case.
> This problem started about the time that we changed the formula for one of
> the
> products that we make. I have tried to recreate invoices using both old and
> new formulas and it happens only on the invoices that have the new formula.
> I'm about to give it up because a few days ago I was asked for Departmental
> Income Statements for last year and I realized that they always specify
> Cash
> Basis. I think I may just set up all products as services and just do a
> manual
> inventory periodically. The problem is that we won't be aware when items
> are
> taken out of the shop and not written down. We only report and pay taxes we
> collect in the State of Mississippi so it would probably be a much simpler
> solution. Anyone see any potential problems with this?
>
> Br. Nicholas
> --
> ________________________
>
> Nicholas Thirkettle, OSB
>
> Saint Joseph's Monastery
> Natchez, MS 39120
>
> www.osbms.org
>
>
> On Friday 06 March 2009 01:54:08 Paul Tammes wrote:
> > The 'sometimes' part is evil. A problem that only hick ups now and then
> is
> > extremely hard to find, let alone solve. One wild guess: do the names of
> > customers with print errors have any strange letters or signs, like
> > unmlauts, # or ë?
> > I seem to remember people with problems that disappeared when renamed to
> e
> > instead of ë. Or something silly like a space too much at the beginning
> of
> > the name, so" Jansen" iso "Jansen" might be cooking things up.
> >
> > Hth
> >
> > 2009/3/5 C. Duncan Hudson <du...@du...>
> >
> > > I'm having the same problem.  Not on every invoice, but frequently
> > > enough that it's a major issue.
> > > We're running SQL-Ledger 2.8.23, Fedora 10, Perl 5.10.0, Postgres
> > > 8.3.4.1, and Apache 2.2.10.
> > > I've spoken to Dieter about this and he insists that it's a Perl
> > > problem.  I don't really care if it's
> > > a Perl problem, or a Perl coding problem, but I need a solution because
> > > right now I can't
> > > invoice all my customers.
> > >
> > > Dunc
> > >
> > > Nicholas Thirkettle OSB wrote:
> > > > Hello,
> > > >
> > > > Sometimes when I try to print Sales Orders or Invoices I get the
> > >
> > > following
> > >
> > > > error:
> > > >
> > > > panic: attempt to copy freed scalar c3a488 to 8e4178 at SL/Form.pm
> line
> > >
> > > 1007
> > >
> > > > I have tried searching for a solution in the forums and I have found
> a
> > >
> > > similar
> > >
> > > > problem a number of versions ago. I haven't actually found a
> solution.
> > > > I
> > >
> > > am
> > >
> > > > using SQL-Ledger Version 2.8.23 and I believe that is the most
> recent.
> > >
> > > Some
> > >
> > > > inovices print just fine. I read that it is when an invoice has more
> > > > than
> > >
> > > 4
> > >
> > > > lines and the invoice I'm having trouble with right now has 8. I
> tried
> > > > deleting all the lines except for 3 but I still have the problem.
> > > >
> > > > openSuse 11.0
> > > > perl 5.10.0-37.6
> > > > SQL-Ledger 2.8.23
> > > >
> > > > Any help is appreciated.
> > > >
> > > > Br. Nicholas
> > >
> > >
> -------------------------------------------------------------------------
> > >----- Open Source Business Conference (OSBC), March 24-25, 2009, San
> > > Francisco, CA
> > > -OSBC tackles the biggest issue in open source: Open Sourcing the
> > > Enterprise
> > > -Strategies to boost innovation and cut costs with open source
> > > participation
> > > -Receive a $600 discount off the registration fee with the source code:
> > > SFAD
> > > http://p.sf.net/sfu/XcvMzF8H
> > > _______________________________________________
> > > sql-ledger-users mailing list
> > > sql...@li...
> > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >
> >
> ---------------------------------------------------------------------------
> >--- Open Source Business Conference (OSBC), March 24-25, 2009, San
> > Francisco, CA -OSBC tackles the biggest issue in open source: Open
> Sourcing
> > the Enterprise -Strategies to boost innovation and cut costs with open
> > source participation -Receive a $600 discount off the registration fee
> with
> > the source code: SFAD http://p.sf.net/sfu/XcvMzF8H
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
> ________________________
>
>
>
> ------------------------------------------------------------------------------
> Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco,
> CA
> -OSBC tackles the biggest issue in open source: Open Sourcing the
> Enterprise
> -Strategies to boost innovation and cut costs with open source
> participation
> -Receive a $600 discount off the registration fee with the source code:
> SFAD
> http://p.sf.net/sfu/XcvMzF8H
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] Sometimes can't print Sales Orders or Invoices

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

I have a feeling that it may be something to do with the inventory in my case. 
This problem started about the time that we changed the formula for one of the 
products that we make. I have tried to recreate invoices using both old and 
new formulas and it happens only on the invoices that have the new formula. 
I'm about to give it up because a few days ago I was asked for Departmental 
Income Statements for last year and I realized that they always specify Cash 
Basis. I think I may just set up all products as services and just do a manual 
inventory periodically. The problem is that we won't be aware when items are 
taken out of the shop and not written down. We only report and pay taxes we 
collect in the State of Mississippi so it would probably be a much simpler 
solution. Anyone see any potential problems with this?

Br. Nicholas
-- 
________________________

Nicholas Thirkettle, OSB

Saint Joseph's Monastery
Natchez, MS 39120

www.osbms.org


On Friday 06 March 2009 01:54:08 Paul Tammes wrote:
> The 'sometimes' part is evil. A problem that only hick ups now and then is
> extremely hard to find, let alone solve. One wild guess: do the names of
> customers with print errors have any strange letters or signs, like
> unmlauts, # or ë?
> I seem to remember people with problems that disappeared when renamed to e
> instead of ë. Or something silly like a space too much at the beginning of
> the name, so" Jansen" iso "Jansen" might be cooking things up.
>
> Hth
>
> 2009/3/5 C. Duncan Hudson <du...@du...>
>
> > I'm having the same problem.  Not on every invoice, but frequently
> > enough that it's a major issue.
> > We're running SQL-Ledger 2.8.23, Fedora 10, Perl 5.10.0, Postgres
> > 8.3.4.1, and Apache 2.2.10.
> > I've spoken to Dieter about this and he insists that it's a Perl
> > problem.  I don't really care if it's
> > a Perl problem, or a Perl coding problem, but I need a solution because
> > right now I can't
> > invoice all my customers.
> >
> > Dunc
> >
> > Nicholas Thirkettle OSB wrote:
> > > Hello,
> > >
> > > Sometimes when I try to print Sales Orders or Invoices I get the
> >
> > following
> >
> > > error:
> > >
> > > panic: attempt to copy freed scalar c3a488 to 8e4178 at SL/Form.pm line
> >
> > 1007
> >
> > > I have tried searching for a solution in the forums and I have found a
> >
> > similar
> >
> > > problem a number of versions ago. I haven't actually found a solution.
> > > I
> >
> > am
> >
> > > using SQL-Ledger Version 2.8.23 and I believe that is the most recent.
> >
> > Some
> >
> > > inovices print just fine. I read that it is when an invoice has more
> > > than
> >
> > 4
> >
> > > lines and the invoice I'm having trouble with right now has 8. I tried
> > > deleting all the lines except for 3 but I still have the problem.
> > >
> > > openSuse 11.0
> > > perl 5.10.0-37.6
> > > SQL-Ledger 2.8.23
> > >
> > > Any help is appreciated.
> > >
> > > Br. Nicholas
> >
> > -------------------------------------------------------------------------
> >----- Open Source Business Conference (OSBC), March 24-25, 2009, San
> > Francisco, CA
> > -OSBC tackles the biggest issue in open source: Open Sourcing the
> > Enterprise
> > -Strategies to boost innovation and cut costs with open source
> > participation
> > -Receive a $600 discount off the registration fee with the source code:
> > SFAD
> > http://p.sf.net/sfu/XcvMzF8H
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
> ---------------------------------------------------------------------------
>--- Open Source Business Conference (OSBC), March 24-25, 2009, San
> Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing
> the Enterprise -Strategies to boost innovation and cut costs with open
> source participation -Receive a $600 discount off the registration fee with
> the source code: SFAD http://p.sf.net/sfu/XcvMzF8H
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users


________________________

Re: [SL] Sometimes can't print Sales Orders or Invoices

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

The 'sometimes' part is evil. A problem that only hick ups now and then is
extremely hard to find, let alone solve. One wild guess: do the names of
customers with print errors have any strange letters or signs, like
unmlauts, # or ë?
I seem to remember people with problems that disappeared when renamed to e
instead of ë. Or something silly like a space too much at the beginning of
the name, so" Jansen" iso "Jansen" might be cooking things up.

Hth

2009/3/5 C. Duncan Hudson <du...@du...>

> I'm having the same problem.  Not on every invoice, but frequently
> enough that it's a major issue.
> We're running SQL-Ledger 2.8.23, Fedora 10, Perl 5.10.0, Postgres
> 8.3.4.1, and Apache 2.2.10.
> I've spoken to Dieter about this and he insists that it's a Perl
> problem.  I don't really care if it's
> a Perl problem, or a Perl coding problem, but I need a solution because
> right now I can't
> invoice all my customers.
>
> Dunc
>
> Nicholas Thirkettle OSB wrote:
> > Hello,
> >
> > Sometimes when I try to print Sales Orders or Invoices I get the
> following
> > error:
> >
> > panic: attempt to copy freed scalar c3a488 to 8e4178 at SL/Form.pm line
> 1007
> >
> > I have tried searching for a solution in the forums and I have found a
> similar
> > problem a number of versions ago. I haven't actually found a solution. I
> am
> > using SQL-Ledger Version 2.8.23 and I believe that is the most recent.
> Some
> > inovices print just fine. I read that it is when an invoice has more than
> 4
> > lines and the invoice I'm having trouble with right now has 8. I tried
> > deleting all the lines except for 3 but I still have the problem.
> >
> > openSuse 11.0
> > perl 5.10.0-37.6
> > SQL-Ledger 2.8.23
> >
> > Any help is appreciated.
> >
> > Br. Nicholas
> >
> >
>
>
>
> ------------------------------------------------------------------------------
> Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco,
> CA
> -OSBC tackles the biggest issue in open source: Open Sourcing the
> Enterprise
> -Strategies to boost innovation and cut costs with open source
> participation
> -Receive a $600 discount off the registration fee with the source code:
> SFAD
> http://p.sf.net/sfu/XcvMzF8H
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] Sometimes can't print Sales Orders or Invoices

[C. D. H. <du...@du...>]

I'm having the same problem.  Not on every invoice, but frequently 
enough that it's a major issue. 
We're running SQL-Ledger 2.8.23, Fedora 10, Perl 5.10.0, Postgres 
8.3.4.1, and Apache 2.2.10.
I've spoken to Dieter about this and he insists that it's a Perl 
problem.  I don't really care if it's
a Perl problem, or a Perl coding problem, but I need a solution because 
right now I can't
invoice all my customers.

Dunc

Nicholas Thirkettle OSB wrote:
> Hello,
>
> Sometimes when I try to print Sales Orders or Invoices I get the following 
> error:
>
> panic: attempt to copy freed scalar c3a488 to 8e4178 at SL/Form.pm line 1007
>
> I have tried searching for a solution in the forums and I have found a similar 
> problem a number of versions ago. I haven't actually found a solution. I am 
> using SQL-Ledger Version 2.8.23 and I believe that is the most recent. Some 
> inovices print just fine. I read that it is when an invoice has more than 4 
> lines and the invoice I'm having trouble with right now has 8. I tried 
> deleting all the lines except for 3 but I still have the problem.
>
> openSuse 11.0
> perl 5.10.0-37.6
> SQL-Ledger 2.8.23
>
> Any help is appreciated.
>
> Br. Nicholas
>
>