sql-ledger-users — 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 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
>
>
>   

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

[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

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

Re: [SL] Error encountered when attempting to create .pdf invoices

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

It means that you're running one of the more recent versions of 
SQL-Ledger, and you have Perl 5.10 installed.  Currently there isn't a 
fix for the problem, but Dieter is working on solving it.

Dunc

Myk Robinson wrote:
> I got this error message today:
>
> panic: attempt to copy freed scalar 987aeb8 to 929a788 at SL/Form.pm
> line 1007.
>
>
> Not sure what this means, or what I could have done to cause it.
>
> Please advise.
>
> ------------------------------------------------------------------------------
> Stay on top of everything new and different, both inside and 
> around Java (TM) technology - register by April 22, and save
> $200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco.
> 300 plus technical and hands-on sessions. Register today. 
> Use priority code J9JMT32. http://p.sf.net/sfu/p
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>   

Re: [SL] Process recurring transac shows Failed

[Dirk E. S. <ds...@ca...>]

Same observation here: SL 2.8.16. Recurring transactions were working fine
- until we upgraded the base system to openSuSE 11 with perl-5.8.8-34.
Since then recurring transactions are broken, same error as you described.

Enrique


> Doing to testing in the sandbox on version 2.8.23 and noticed something
> after creating a recurring transaction.
>
> Afterwards going to 'Recurring Transactions' select the one We want and
> click 'Process Transactions' we recieve(Set to e-mail invoice  Html):
>
> Posting Sales Invoice 33 ... ok
> Sending Invoice 33 ... ... failed
>
> However, the e-mail does go out and is received by the recipient. Just
> want to know why it shows as faild.
>
> $sendmail = "| /usr/sbin/sendmail -t";
>
> in the conf file.
>
> Sendmail and Perl version:
> perl-5.8.8-15.el5_2.1
> sendmail-8.13.8-2.el5
>
> www.sislink.net A+, N+, CCNA
>
>
>
>
> --
> This message has been scanned for viruses and
> dangerous content by SISLINK.NET. Come join us!
>
>
> ------------------------------------------------------------------------------
> Stay on top of everything new and different, both inside and
> around Java (TM) technology - register by April 22, and save
> $200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco.
> 300 plus technical and hands-on sessions. Register today.
> Use priority code J9JMT32. http://p.sf.net/sfu/p
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>


Cartagena - Colombia
http://www.sipcolombia.com

[SL] Error encountered when attempting to create .pdf invoices

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

I got this error message today:

panic: attempt to copy freed scalar 987aeb8 to 929a788 at SL/Form.pm
line 1007.


Not sure what this means, or what I could have done to cause it.

Please advise.

[SL] Process recurring transac shows Failed

[James S. <jst...@si...>]

Doing to testing in the sandbox on version 2.8.23 and noticed something
after creating a recurring transaction.

Afterwards going to 'Recurring Transactions' select the one We want and
click 'Process Transactions' we recieve(Set to e-mail invoice  Html):

Posting Sales Invoice 33 ... ok
Sending Invoice 33 ... ... failed

However, the e-mail does go out and is received by the recipient. Just
want to know why it shows as faild.

$sendmail = "| /usr/sbin/sendmail -t";

in the conf file.

Sendmail and Perl version:
perl-5.8.8-15.el5_2.1
sendmail-8.13.8-2.el5

www.sislink.net A+, N+, CCNA




-- 
This message has been scanned for viruses and 
dangerous content by SISLINK.NET. Come join us!

[SL] Process recurring transac shows Failed

[James S. <jst...@si...>]

Doing to testing in the sandbox on version 2.8.23 and noticed something
after creating a recurring transaction.

Afterwards going to 'Recurring Transactions' select the one We want and
click 'Process Transactions' we recieve(Set to e-mail invoice  Html):

Posting Sales Invoice 33 ... ok
Sending Invoice 33 ... ... failed

However, the e-mail does go out and is received by the recipient. Just
want to know why it shows as faild.

$sendmail = "| /usr/sbin/sendmail -t";

in the conf file.

Sendmail and Perl version:
perl-5.8.8-15.el5_2.1
sendmail-8.13.8-2.el5

www.sislink.net A+, N+, CCNA




-- 
This message has been scanned for viruses and 
dangerous content by SISLINK.NET. Come join us!

[SL] ERROR - SL 2.6.27 - Not a HASH reference at SL/IS.pm

[William H. <wil...@gm...>]

Hi I have a client who has been running SL for a few years at with the end
of year etc happening now he is printing invoices and the like.

Error is as follows
*Not a HASH reference at SL/IS.pm line 385.
**Attempt to free unreferenced scalar: SV 0x87087c0, Perl interpreter:
0x817b008 at SL/IS.pm line 385.*

This occurs whenever trying to print an invoice either as PDF or HTML.

Environment is:
Debian
Perl 5.10.0-19
SQL Ledger 2.6.27
Latex installed.

All had been working in the past but assume some Perl upgrade caused probs?
Any solution suggestions appreciated.  Found a couple f references to this
last year but no solution.

tia

W

Re: [SL] Upgrade to current SL in big jump

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

Do you use the provided update scripts? I did several installs, updates and
what not and found the procedure with these scripts pretty straight forward.


1) Did you remember to change the security settings for local use (in
/var/lib/pgsql/data/pg_hba.conf i believe)? That might cause the permission
denied errors. If that does not fix it, consider option

2) Updating both SQL and postgres a the same time might be a problem,
especially with exisiting 7.x database. I did a clean install, including
Postgres 8.
That leaves you to copy over /users /templates and /images by hand if you
changed anything there. The rest of the data is in the saved sql-file iirc.
Update that with the updatre scripts and follow the install howto if needed.

Plus: this works on new machine too, nice in case of update (or in my case
install to netbook)
Minus: manual copy fo some dirs and files and re-creation of users.

Create user(s) with database db_new_2.8.24, remeber to give the user a Pg
driver (via admin login). Then check if you can su postgres and do the psql
db_new_2.8.24 < db_old_2.6_1.sql

Hth
Paul

2009/4/16 <wj...@pa...>

> Further to below mail I managed to get a bit further but am now getting
> following error as soon as I try to login to the now updated (I think!)
> dataset:
> Error!  SELECT * FROM defaults
> ERROR: permission denied for relation defaults.
>
> Quite puzzled as to what is going on.
>
>
>
> I am attempting to upgrade 2.6.1 database(PG 7.3) to version 2.8.24(with
> PG 8.3).
>
> Created new empty dataset "db_new_2.8.24",
> Fixed SETVAL etc as per FAQ in old database "db_old_2.6_1"
> then restore with psql db_new_2.8.24 < db_old_2.6_1.sql
>
> BUT getting scores of errors "relation xyz etc does not exist".
>
> I also tried fixing all the tables by putting "WITH OIDS" in
> db_old_2.6_1.sql but that does not work either (the inserts now appeared
> to work but getting same errors at the end - maybe INDEXES may be an
> issue)
>
> Any suggestions anyone?
> Thanks and regards
>
>
>
>
> ------------------------------------------------------------------------------
> Stay on top of everything new and different, both inside and
> around Java (TM) technology - register by April 22, and save
> $200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco.
> 300 plus technical and hands-on sessions. Register today.
> Use priority code J9JMT32. http://p.sf.net/sfu/p
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

[SL] Upgrade to current SL in big jump

[<wj...@pa...>]

Further to below mail I managed to get a bit further but am now getting
following error as soon as I try to login to the now updated (I think!)
dataset:
Error!  SELECT * FROM defaults
ERROR: permission denied for relation defaults.

Quite puzzled as to what is going on.



I am attempting to upgrade 2.6.1 database(PG 7.3) to version 2.8.24(with
PG 8.3).

Created new empty dataset "db_new_2.8.24",
Fixed SETVAL etc as per FAQ in old database "db_old_2.6_1"
then restore with psql db_new_2.8.24 < db_old_2.6_1.sql

BUT getting scores of errors "relation xyz etc does not exist".

I also tried fixing all the tables by putting "WITH OIDS" in
db_old_2.6_1.sql but that does not work either (the inserts now appeared
to work but getting same errors at the end - maybe INDEXES may be an
issue)

Any suggestions anyone?
Thanks and regards

[SL] Upgrade to current SL in big jump

[<wj...@pa...>]

I am attempting to upgrade 2.6.1 database(PG 7.3) to version 2.8.24(with
PG 8.3).

Created new empty dataset "db_new_2.8.24",
Fixed SETVAL etc as per FAQ in old database "db_old_2.6_1"
then restore with psql db_new_2.8.24.sql < db_old_2.6_1.sql

BUT getting scores of errors "relation xyz etc does not exist".

I also tried fixing all the tables by putting "WITH OIDS" in
db_old_2.6_1.sql but that does not work either (the inserts now appeared
to work but getting same errors at the end - maybe INDEXES may be an
issue)

Any suggestions anyone?
Thanks and regards

[SL] Two Language Invoice

[Omar <ob...@ab...>]

Hi All,
I want to make invoices in two languages,
One arabic and one English,
The Arabic is for the customs reasons in Egypt and the English is for the 
customer,

I can either enter one or the other , because when the description of the 
invoice is done then it is fixed to the language needed ,
Can I make printing the invoice take the description from the language file 
directly so I make one template for printing Arabic invoices and another for 
printing English ones,

best rgeards
Omar

[SL] Sales, Inventory, & Purchasing Numbers Seem Wrong

[<la...@cl...>]

Hello,

For those who sell parts and perform reverse invoice, have you seen this
before?

We upgraded from 2.4 to 2.8 last May, and this is what we discover
recently while try to close our last year's book. The sales, inventory,
and purchasing numbers were wrong. We had created two test cases with
2.8.11 and 2.8.24 and the results were the same.

1. create test part A cost $10 each and sell price $20 each, shipping
service B, and restock fee service C in goods and services.

2. create vendor invoice of 100 pieces test part A.

3. create sales invoide of 1 each part A for $20 and shipping for $10,
total sales $30.

4. Reverse the about invoice, non-refundable shipping, and $4 restock fee.
Total credit $16.

The income statement now say...

INCOME

Apr 08 2009

SALES REVENUE
   4010 - Sales 24.00  *** Should be $4 (restock fee). Part A was returned.
   SALES REVENUE 24.00

OTHER REVENUE
   4430 - Shipping & Handling 10.00
   OTHER REVENUE 10.00

 TOTAL INCOME 34.00 ***Should be $14

EXPENSES

COST OF GOODS SOLD
   5010 - Purchases 10.00
   COST OF GOODS SOLD 10.00

 TOTAL EXPENSES 10.00  *** Should be $0 since part A was returned.

INCOME / (LOSS) 24.00  ***Should be $14

And the balance sheet say...

ASSETS

 Apr 08 2009
 CURRENT ASSETS
   1060 - Checking Account 14.00
   CURRENT ASSETS 14.00
 INVENTORY ASSETS
   1510 - Inventory 1,010.00
   INVENTORY ASSETS 1,010.00  *** should be $1000. Part A was returned.

TOTAL ASSETS 1,024.00  *** should be $1014.

LIABILITIES

 CURRENT LIABILITIES
   2100 - Accounts Payable 1,000.00
   CURRENT LIABILITIES 1,000.00

 TOTAL LIABILITIES 1,000.00

SHAREHOLDER'S EQUITY

   Current Earnings 24.00

 TOTAL EQUITY 24.00  *** should be $14 from earning

TOTAL LIABILITIES & EQUITY 1,024.00  *** should be $1014.

Is this just me and can anyone give me some input? I really appreciate
your help! Thanks!

Regards,

Tim

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

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

On Mon, 6 Apr 2009, Alan Murrell wrote:

> Based on the feedback, I have created a new "Expenses" category that I
> have entries for "Fuel", "Parking", and "Meals". I will add to it as
> necessary if I come across any other expenses I may need (such as paying a
> deposit for a client to drop a hard drive off for recovery, etc.).

   I get the impression that you do not have a Chart of Accounts set up. If
that's correct, I encourage you to do so.

> I will just use GL transactions (which I think is the same as "AP/add
> transaction"?  I am not in front of PC I can check that form at the
> moment)

   Not really. Accounts Payable is a journal. Transactions in journals are
also posted to the General Ledger. You use Accounts Payable to enter
invoices you receive from vendors, and you pay them using the Cash module.

   Your local library probably has a basic accounting book that could be
useful to  you.

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

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

Thanks to everyone for their replies and own experiences :-)

Based on the feedback, I have created a new "Expenses" category that I have entries for "Fuel", "Parking", and "Meals".  I will add to it as necessary if I come across any other expenses I may need (such as paying a deposit for a client to drop a hard drive off for recovery, etc.).  I will just use GL transactions (which I think is the same as "AP/add transaction"?  I am not in front of PC I can check that form at the moment)

I am going to keep my "Aftermarket hardware" and "Software" parts items, and just not worry about whether it shows a negative inventory balance or not since I don't really sell hardware; I only pick up hardware I need to complete a job, and just overtype the description with whatever the part is on the invoice.

This looks like it will be easier than I anticipated.

-Alan

Re: [SL] size and color

[<la...@cl...>]

code it in the partnumber...it works for us for 4 years now. we also added
an unique index to the partnumber column of the parts table...

for ex. 9999/Black/S

tim

> Hi All,
> Does anybody know how to make size and color in the items numbers,
>
> ------------------------------------------------------------------------------
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] stock

[<la...@cl...>]

don't think that you can...you can always check the onhand before
invoicing...tim

> How Can I prevent Sql-ledger from making invoice if the stock in the
> warhouse
> is less than the invoice quantity
> best regards
> Omar
>
> ------------------------------------------------------------------------------
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] size and color

[Omar B. <o...@ab...>]

Hi All,
Does anybody know how to make size and color in the items numbers,

Re: [SL] stock

[Omar <ob...@ab...>]

How Can I prevent Sql-ledger from making invoice if the stock in the warhouse 
is less than the invoice quantity
best regards
Omar

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

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

Ooops forgot the second half of your question.

I put all of my gas and parking in using AP/Add transaction. I have an 
account in the GL for gasoline expense and another for parking expense. 
I just put the purchase in under Chevron and separate out the taxes. I 
also set up a bank account named "Amex" and I enter it as paid the same 
day from that account. that way it's closed and done with. Then at the 
end of the month when I pay the Amex card I do a single transfer from 
the business chequeing account to the Amex bank account and it zeros it 
out. This has the added benefit of allowing me to easily see how much 
business expenses I've charged onto the amex at any time during the 
month. Again, the taxes all go where they are supposed to and show up on 
the taxes paid report.

Jeff

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

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

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

Hello Alan

There is no need to go through all the trouble of keeping inventory just 
to track taxes. I do the same thing as you as far as buying stuff for 
clients but I just enter the purchase under "AP/Add transaction". I 
chose my expense account for "parts expense" and write a little memo if 
I need to. When I sell it I have a part called "misc part sale". It's 
got a price of "$0.00" and is linked to "Part sales revenue". Once I've 
got it in the invoice on a line, I type over it with a correct 
description and fill in the price I'm selling it for.

The purchase becomes a direct expense and the sale becomes a direct form 
of income, nothing is ever in stock more than a few days here so I'm not 
worried about the balance sheet showing any inventory.

The taxes will be recorded properly and you can run a taxes paid and 
taxes collected report from the AP and Ar sections to reconcile them at 
remittance time.

Jeff


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