sql-ledger-users

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

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

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

-- 
________________________

Nicholas Thirkettle, OSB

Saint Joseph's Monastery
Natchez, MS 39120

www.osbms.org
________________________

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

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

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

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

[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

[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] 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] Sometimes can't print Sales Orders or Invoices

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

Unless the patch is different then what you've posted here I see no 
change - still getting the freed scalar error.

Dunc

Nicholas Thirkettle OSB wrote:
> 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
>>     
>
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>   

[SL] How to account for pre-payments

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

Hi,

What is a good way to handle pre-payments?  I.e. we make payments to our 
accountant to pre-pay towards an invoice which is then raised at the end 
of the year.

Currently, I assign them to a suspense account - and then reallocate 
them.  But this is a bit of a pain as I have to delete these 
transactions later, add as a receipt and then reconsolidate the bank 
statements.


I suppose I could prepay to a debtors account - but how would I remember 
to pay this against the outstanding to stop our bookkeeper from paying 
the invoice twice!

Cheers,

Kevin

[SL] How to account for write-offs

[Yves L. ing. <yve...@gm...>]

Hi,

What is the prefered way to account for write-offs? I have customer 
dispute that ended up in a write-off of part of the amount due.
I figured I could move that amount into Allowance for doubtful accounts 
and enter GL entries to drop it to zero over a period.
Is that the way? Any suggestions?

Thanks,

Yves

Re: [SL] How to account for write-offs

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

Hi Yves

I have a "Bad debts expense" that I flagged for Receivables-Payment when 
I created it.

I simply "receive" the balance directly onto the expense account. ('Bad 
debts expense' will be in the drop down menu along with your bank 
accounts) This clears the AR and the customers account and takes care of 
it directly.

I also have a revenue account called "Bad debts collected" that I 
flagged for Receivables-Income. If I collect the amount later I do a AR 
transaction without having to go and edit the cleared invoice from 
before.('Bad debts collected" will be in the drop down menu of revenue 
accounts) I place a note of which invoice I've collected for in the 
notes section.

Jeff

Yves Lavoie ing. wrote:
> Hi,
>
> What is the prefered way to account for write-offs? I have customer 
> dispute that ended up in a write-off of part of the amount due.
> I figured I could move that amount into Allowance for doubtful accounts 
> and enter GL entries to drop it to zero over a period.
> Is that the way? Any suggestions?
>
> Thanks,
>
> Yves
> ------------------------------------------------------------------------------
> The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
> production scanning environment may not be a perfect world - but thanks to
> Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700
> Series Scanner you'll get full speed at 300 dpi even with all image 
> processing features enabled. http://p.sf.net/sfu/kodak-com
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
>   

Re: [SL] How to account for pre-payments

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

Good question!
    And if you search the archives you'll see that while there are  
several ways to handle it there are no "best" or "right" ways to do it.
    Or, to put it more plainly, SL does not really have a "credit"  
account per customer out of the box.  You can do it yourself, (a  
laborious process if you already have a lot of customers in the  
system).  Or you can do an equally laborious negative invoice and  
deletion as you've already described.
    There are some other possible ways but they all pretty much come  
down to the same thing - SL doesn't have a good credit tracking  
mechanism.  (Actually, I should say the tracking is fine, it's the  
application of the credit that's awkward).


Thanks,

Michael

On May 5, 2009, at 2:08 PM, Kevin Bailey wrote:

Hi,

What is a good way to handle pre-payments?  I.e. we make payments to our
accountant to pre-pay towards an invoice which is then raised at the end
of the year.

Currently, I assign them to a suspense account - and then reallocate
them.  But this is a bit of a pain as I have to delete these
transactions later, add as a receipt and then reconsolidate the bank
statements.


I suppose I could prepay to a debtors account - but how would I remember
to pay this against the outstanding to stop our bookkeeper from paying
the invoice twice!

Cheers,

Kevin

------------------------------------------------------------------------ 
------
The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
production scanning environment may not be a perfect world - but  
thanks to
Kodak, there's a perfect scanner to get the job done! With the NEW  
KODAK i700
Series Scanner you'll get full speed at 300 dpi even with all image
processing features enabled. http://p.sf.net/sfu/kodak-com
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] How to account for pre-payments

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

Why prepay at all? Especially an accountant should see the logic that one
has to send an invoice in order to get paid.

Just my two cents..

2009/5/5 Michael Hasse <mh...@it...>

> Good question!
>    And if you search the archives you'll see that while there are
> several ways to handle it there are no "best" or "right" ways to do it.
>    Or, to put it more plainly, SL does not really have a "credit"
> account per customer out of the box.  You can do it yourself, (a
> laborious process if you already have a lot of customers in the
> system).  Or you can do an equally laborious negative invoice and
> deletion as you've already described.
>    There are some other possible ways but they all pretty much come
> down to the same thing - SL doesn't have a good credit tracking
> mechanism.  (Actually, I should say the tracking is fine, it's the
> application of the credit that's awkward).
>
>
> Thanks,
>
> Michael
>
> On May 5, 2009, at 2:08 PM, Kevin Bailey wrote:
>
> Hi,
>
> What is a good way to handle pre-payments?  I.e. we make payments to our
> accountant to pre-pay towards an invoice which is then raised at the end
> of the year.
>
> Currently, I assign them to a suspense account - and then reallocate
> them.  But this is a bit of a pain as I have to delete these
> transactions later, add as a receipt and then reconsolidate the bank
> statements.
>
>
> I suppose I could prepay to a debtors account - but how would I remember
> to pay this against the outstanding to stop our bookkeeper from paying
> the invoice twice!
>
> Cheers,
>
> Kevin
>
> ------------------------------------------------------------------------
> ------
> The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
> production scanning environment may not be a perfect world - but
> thanks to
> Kodak, there's a perfect scanner to get the job done! With the NEW
> KODAK i700
> Series Scanner you'll get full speed at 300 dpi even with all image
> processing features enabled. http://p.sf.net/sfu/kodak-com
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
>
> ------------------------------------------------------------------------------
> The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
> production scanning environment may not be a perfect world - but thanks to
> Kodak, there's a perfect scanner to get the job done! With the NEW KODAK
> i700
> Series Scanner you'll get full speed at 300 dpi even with all image
> processing features enabled. http://p.sf.net/sfu/kodak-com
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] How to account for pre-payments

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

On Wed, 2009-05-06 at 19:31 +0200, Paul Tammes wrote:
> 
> Why prepay at all? Especially an accountant should see the logic that
>  one has to send an invoice in order to get paid.

For service delivery, pre-payment is a great way not to get left holding
the bill after delivering the work. 

We create an invoice with just the payment which is used for tracking
the credit. Then as work is invoiced, we use apply a negative amount to
this tracking invoice (I think this is handled via the Cash Payments
screen but I don't have to do the book-keeping anymore these days :).


HTH,
William

-- 
Knowmad Technologies - Open Source Web Solutions
W: http://www.knowmad.com | E: wi...@kn... | P: 704.343.9330

Re: [SL] How to account for pre-payments

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

Some places give discounts for prepayment, (e.g. prepaid blocks of  
time for service).  If regular customer has a return they may just  
ask for credit rather than cash back.  It could be a year-end rebate  
based on volume of business, a coupon, even just a discount after the  
sale.  Probably many more, this is just off the top of my head...


Thanks,

Michael


On May 6, 2009, at 10:31 AM, Paul Tammes wrote:

Why prepay at all? Especially an accountant should see the logic that  
one
has to send an invoice in order to get paid.

Just my two cents..

2009/5/5 Michael Hasse <mh...@it...>

> Good question!
>    And if you search the archives you'll see that while there are
> several ways to handle it there are no "best" or "right" ways to do  
> it.
>    Or, to put it more plainly, SL does not really have a "credit"
> account per customer out of the box.  You can do it yourself, (a
> laborious process if you already have a lot of customers in the
> system).  Or you can do an equally laborious negative invoice and
> deletion as you've already described.
>    There are some other possible ways but they all pretty much come
> down to the same thing - SL doesn't have a good credit tracking
> mechanism.  (Actually, I should say the tracking is fine, it's the
> application of the credit that's awkward).
>
>
> Thanks,
>
> Michael
>
> On May 5, 2009, at 2:08 PM, Kevin Bailey wrote:
>
> Hi,
>
> What is a good way to handle pre-payments?  I.e. we make payments  
> to our
> accountant to pre-pay towards an invoice which is then raised at  
> the end
> of the year.
>
> Currently, I assign them to a suspense account - and then reallocate
> them.  But this is a bit of a pain as I have to delete these
> transactions later, add as a receipt and then reconsolidate the bank
> statements.
>
>
> I suppose I could prepay to a debtors account - but how would I  
> remember
> to pay this against the outstanding to stop our bookkeeper from paying
> the invoice twice!
>
> Cheers,
>
> Kevin
>
> ---------------------------------------------------------------------- 
> --
> ------
> The NEW KODAK i700 Series Scanners deliver under ANY circumstances!  
> Your
> production scanning environment may not be a perfect world - but
> thanks to
> Kodak, there's a perfect scanner to get the job done! With the NEW
> KODAK i700
> Series Scanner you'll get full speed at 300 dpi even with all image
> processing features enabled. http://p.sf.net/sfu/kodak-com
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
>
> ---------------------------------------------------------------------- 
> --------
> The NEW KODAK i700 Series Scanners deliver under ANY circumstances!  
> Your
> production scanning environment may not be a perfect world - but  
> thanks to
> Kodak, there's a perfect scanner to get the job done! With the NEW  
> KODAK
> i700
> Series Scanner you'll get full speed at 300 dpi even with all image
> processing features enabled. http://p.sf.net/sfu/kodak-com
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
------------------------------------------------------------------------ 
------
The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
production scanning environment may not be a perfect world - but  
thanks to
Kodak, there's a perfect scanner to get the job done! With the NEW  
KODAK i700
Series Scanner you'll get full speed at 300 dpi even with all image
processing features enabled. http://p.sf.net/sfu/kodak-com
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] How to account for pre-payments

[Mark P. <mar...@mo...>]

On May 6, 2009, at 10:31 AM, Paul Tammes wrote:
> Why prepay at all? Especially an accountant should see the logic  
> that one
> has to send an invoice in order to get paid.

I respectfully disagree. It is quite common for many businesses to  
require a retainer or "advance billing deposit". Some will not begin a  
project until funds sufficient to cover the anticipated work are  
deposited, even as much as 100% of the anticipated billing. Some of  
these will produce an invoice based on an estimate or contract, then  
amend if required.

Others do not invoice until the end of a project. In the meantime, the  
estimate serves as the controlling document, with funds advanced and  
charges tracked against the estimate. At the time of invoice, the  
charges and payments are tallied and posted so they appear on the  
invoice and are "booked" in accordance with the accounting policies of  
the client.

FWIW, I have no idea how this fits into SL, so my comments are more  
general in nature. That said, I have created such processes in the  
software applications we maintain and develop for clients. As another  
poster wrote, the point is to make sure the value of the service or  
product is compensated, or more plainly, to make sure you get paid.


Mark Phillips

-------------- next part --------------


On the web at www.mophilly.com
On the phone at (619) 444-9210

Re: [SL] How to account for pre-payments

[Jersey <je...@ib...>]

Hi there,

I am not an accountant... but I have sometimes 50% of invoice value
prepayments long before the final delivery is due. I treat them like a loan
(At the end of the day actually it is :)). I created a "service" item with
income pointing to liability account called "deposit received". I invoice
the client with this item before finilising the contract. And on final
invoice I credit that item. This way I do not have a false, artificial
profit/loss in case I receive the order (and payment) one financial year and
I deliver the goods next financial year.
Reverse applies when I do prepayment.

Am I correct? Any comments.

Regards

-----Original Message-----
From: Mark Phillips [mailto:mar...@mo...] 
Sent: 07 May 2009 01:59 AM
To: sql...@li...
Subject: Re: [SL] How to account for pre-payments


On May 6, 2009, at 10:31 AM, Paul Tammes wrote:
> Why prepay at all? Especially an accountant should see the logic  
> that one
> has to send an invoice in order to get paid.

I respectfully disagree. It is quite common for many businesses to  
require a retainer or "advance billing deposit". Some will not begin a  
project until funds sufficient to cover the anticipated work are  
deposited, even as much as 100% of the anticipated billing. Some of  
these will produce an invoice based on an estimate or contract, then  
amend if required.

Others do not invoice until the end of a project. In the meantime, the  
estimate serves as the controlling document, with funds advanced and  
charges tracked against the estimate. At the time of invoice, the  
charges and payments are tallied and posted so they appear on the  
invoice and are "booked" in accordance with the accounting policies of  
the client.

FWIW, I have no idea how this fits into SL, so my comments are more  
general in nature. That said, I have created such processes in the  
software applications we maintain and develop for clients. As another  
poster wrote, the point is to make sure the value of the service or  
product is compensated, or more plainly, to make sure you get paid.


Mark Phillips

-------------- next part --------------


On the web at www.mophilly.com
On the phone at (619) 444-9210




----------------------------------------------------------------------------
--
The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
production scanning environment may not be a perfect world - but thanks to
Kodak, there's a perfect scanner to get the job done! With the NEW KODAK
i700
Series Scanner you'll get full speed at 300 dpi even with all image 
processing features enabled. http://p.sf.net/sfu/kodak-com
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] How to account for pre-payments

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

I think you do it correctly.
However, there are *some *countries where tax-authorities have a very
narrow-minded view on 'work in progress' like this, combined with rules on
what part of work should be taken as profit when.

In case of doubt, check with them (tax authorities)  also.

2009/5/15 Jersey <je...@ib...>

> Hi there,
>
> I am not an accountant... but I have sometimes 50% of invoice value
> prepayments long before the final delivery is due. I treat them like a loan
> (At the end of the day actually it is :)). I created a "service" item with
> income pointing to liability account called "deposit received". I invoice
> the client with this item before finilising the contract. And on final
> invoice I credit that item. This way I do not have a false, artificial
> profit/loss in case I receive the order (and payment) one financial year
> and
> I deliver the goods next financial year.
> Reverse applies when I do prepayment.
>
> Am I correct? Any comments.
>
> Regards
>
> -----Original Message-----
> From: Mark Phillips [mailto:mar...@mo...]
> Sent: 07 May 2009 01:59 AM
> To: sql...@li...
> Subject: Re: [SL] How to account for pre-payments
>
>
> On May 6, 2009, at 10:31 AM, Paul Tammes wrote:
> > Why prepay at all? Especially an accountant should see the logic
> > that one
> > has to send an invoice in order to get paid.
>
> I respectfully disagree. It is quite common for many businesses to
> require a retainer or "advance billing deposit". Some will not begin a
> project until funds sufficient to cover the anticipated work are
> deposited, even as much as 100% of the anticipated billing. Some of
> these will produce an invoice based on an estimate or contract, then
> amend if required.
>
> Others do not invoice until the end of a project. In the meantime, the
> estimate serves as the controlling document, with funds advanced and
> charges tracked against the estimate. At the time of invoice, the
> charges and payments are tallied and posted so they appear on the
> invoice and are "booked" in accordance with the accounting policies of
> the client.
>
> FWIW, I have no idea how this fits into SL, so my comments are more
> general in nature. That said, I have created such processes in the
> software applications we maintain and develop for clients. As another
> poster wrote, the point is to make sure the value of the service or
> product is compensated, or more plainly, to make sure you get paid.
>
>
> Mark Phillips
>
> -------------- next part --------------
>
>
> On the web at www.mophilly.com
> On the phone at (619) 444-9210
>
>
>
>
>
> ----------------------------------------------------------------------------
> --
> The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
> production scanning environment may not be a perfect world - but thanks to
> Kodak, there's a perfect scanner to get the job done! With the NEW KODAK
> i700
> Series Scanner you'll get full speed at 300 dpi even with all image
> processing features enabled. http://p.sf.net/sfu/kodak-com
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
>
> ------------------------------------------------------------------------------
> Crystal Reports - New Free Runtime and 30 Day Trial
> Check out the new simplified licensing option that enables
> unlimited royalty-free distribution of the report engine
> for externally facing server and web deployment.
> http://p.sf.net/sfu/businessobjects
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] How to account for pre-payments

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

I am not against payment of services.
I just suggest the service provider could (and should in my opinion) send an
invoice.

For example, contracters here in Holland start building the house after
receiving payment for the invoiced 20% 'up front' part of the building
contract. Then, after the foundation or some defined part of work is
finished, they invoice the next 10 % and so on, till the house is finished,
all work done is invoiced and off to the next project.

Same for accountants; when they take on a job (say control of anual
accounts), they send an invoice for 20 or 50% at start, rest after the job.

The only reason I can come up with for NOT sending invoices and yet to ask
for payment (advance, whatever) is to postpone taxation: once he invoice is
sent, tax is due. So let us wait as long as possible to send tjhe invoice.

At this point in time, with people and businesses going bankrupt every so
often, I would be very hesitant to pay with or without an invoice, but not
having an invoice (or reminder if cash is low) would not prompt me to pay
anything whatsoever.

2009/5/7 Mark Phillips <mar...@mo...>

>
> On May 6, 2009, at 10:31 AM, Paul Tammes wrote:
> > Why prepay at all? Especially an accountant should see the logic
> > that one
> > has to send an invoice in order to get paid.
>
> I respectfully disagree. It is quite common for many businesses to
> require a retainer or "advance billing deposit". Some will not begin a
> project until funds sufficient to cover the anticipated work are
> deposited, even as much as 100% of the anticipated billing. Some of
> these will produce an invoice based on an estimate or contract, then
> amend if required.
>
> Others do not invoice until the end of a project. In the meantime, the
> estimate serves as the controlling document, with funds advanced and
> charges tracked against the estimate. At the time of invoice, the
> charges and payments are tallied and posted so they appear on the
> invoice and are "booked" in accordance with the accounting policies of
> the client.
>
> FWIW, I have no idea how this fits into SL, so my comments are more
> general in nature. That said, I have created such processes in the
> software applications we maintain and develop for clients. As another
> poster wrote, the point is to make sure the value of the service or
> product is compensated, or more plainly, to make sure you get paid.
>
>
> Mark Phillips
>
> -------------- next part --------------
>
>
> On the web at www.mophilly.com
> On the phone at (619) 444-9210
>
>
>
>
>
> ------------------------------------------------------------------------------
> The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
> production scanning environment may not be a perfect world - but thanks to
> Kodak, there's a perfect scanner to get the job done! With the NEW KODAK
> i700
> Series Scanner you'll get full speed at 300 dpi even with all image
> processing features enabled. http://p.sf.net/sfu/kodak-com
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] How to account for pre-payments

[Mark P. <mar...@mo...>]

On May 6, 2009, at 8:34 PM, Paul Tammes wrote:

> The only reason I can come up with for NOT sending invoices and yet  
> to ask
> for payment (advance, whatever) is to postpone taxation: once he  
> invoice is
> sent, tax is due. So let us wait as long as possible to send tjhe  
> invoice.
>
> At this point in time, with people and businesses going bankrupt  
> every so
> often, I would be very hesitant to pay with or without an invoice,  
> but not
> having an invoice (or reminder if cash is low) would not prompt me  
> to pay
> anything whatsoever.

Well, that certainly makes sense. In our locale, invoices are not  
taxed when they are created. At least for the moment, we are allowed  
to tally the sum at the end of each quarter or year, then send a tax  
contribution.

I have an associate in Mexico who was very hesitant to send me an  
invoice. Like you, I am hesitant to send money without an invoice or  
similar. His problem was the tax was due at the moment the invoice was  
created. So, my associate would be out of pocket for taxes paid  
whether or not he ever collected on the invoice. It will come as no  
surprise that we made other arrangements so that payment of tax  
demanded coincided with real income.

  -- Mark


Mark Phillips

On the web at www.mophilly.com
On the phone at (619) 444-9210

[SL] Sales tax paid on purchases

[KevinC at AutoDFW.c. <ke...@au...>]

I'm probably not the only one to have this issue, so I'll ask for some  
ideas.

There are times when I have to make purchases that should be tax- 
exempt, but end up paying tax due to not having my tax certificate  
with me or encountering a cashier who has no clue how to do a tax  
exempt transaction, or whatever reason.

Has anyone figured out a way to flag transactions like this, or at  
least a way to make them easier to separate from legitimately taxed  
transactions in SQLledger? It would sure make it easier to sort  
through everything come quarterly Sales and Use Tax filing time.

Thanks,
Kevin