sql-ledger-users — SQL-Ledger users

Re: [SL] Je me souviens! Was:Re: Swedish SQL-ledger 2.6.20, To buy a computer: no right account number

[John H. <jo...@dh...>]

C. Duncan Hudson writes:
> The thread, though, got me thinking - why is it that there are both
> French and French Canadian keyboard layouts?

Because qu=E9b=E9cois and parisian are two different dialects of french.
Neither is "higher" or "lower", but they are different.
--=20
John Hasler=20
jo...@dh...
Elmwood, WI USA

Re: [SL] Refund Checks

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

Mark Bucciarelli wrote:
> On Sat, Nov 25, 2006 at 07:47:09PM -0800, Dave Snell wrote:
>   
>> --- Dr Eberhard Lisse <el...@li...> wrote:
>>
>>     
>>> End of year, actually.
>>>       
>> So just so I'm clear, good Doctor, I should create a
>> bogus vendor record and accompanying AP transaction so
>> that I can issue my refund check.  Then throughout the
>> year - as I continue to statement my customer - I
>> should just wink and say "just ignore this
>> transaction" we'll take care of it at the end of the
>> year.  And then come the end of the year I should do
>> what again?  Sorry if I'm being slow, I guess I just
>> expect an accounting package to handle some of the
>> basic accounting transactions for me.
>>
>>     
>
> Can't you create a holding account and enter a G/L transaction so
> the customer account is correct?  Then use A/P against this same
> holding account to generate the check?  Externally all is
> copacetic and you just need to reconcile that holding account at
> year end.
>
> Hopefully, you don't cut that many refund checks in a year.
>
> Yes, it is awkward.
>
> Yes, you have found an area that doesn't work well.
>   
I think doesn't work well is a bit of an understatement!  You'd still 
need to create a vendor to match the customer record, wouldn't you?  
It's not pretty, but here's what I do:  I print a customer receipt to a 
check template (that gets, unfortunately, listed on the stub as 
'prepayment'), then I negate the payment amount and post it to the 
customer's account. 

[SL] Je me souviens! Was:Re: Swedish SQL-ledger 2.6.20, To buy a computer: no right account number

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

Roy P wrote:
> On Sunday 26 November 2006 14:10, you wrote:
>   
>> On 11/26/06, Roy P <or...@sh...> wrote:
>>     
>>> Apology in advance to the list... I don't think this is a forum for this
>>> type of discussion, but since Chris sent his comment to the list.. i sent
>>> this reply in defence.
>>>
>>> All further replies will be offlist.
>>>       
>>  Which translates to: I want the last word on this to let my view prevail.
>>     
>
> No it does not. 
> This list is for discussion of SQL-ledger not a discussion about linguistics.
> Therefore our views on the topic is irrelevant to the group.
>
> I plan to discuss this off list and I'm more than willing to let your last 
> public post stand and "let you view prevail".
>   
I too attended French school in "La Belle Provence", and was never led 
to believe that the language I was being taught was a lower form of the 
language.  Nor, have I ever had any trouble communicating with any 
French speaking soul from any other nation.  The thread, though, got me 
thinking - why is it that there are both French and French Canadian 
keyboard layouts?

Dunc

Re: [SL] Refund Checks

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

As I said, some are slow. And cheap :-)-O

By the way, this Credit Note business of yours, how would it work if you
paid VAT? Ie, where you *have* to pay it *and* later claim it back? I
operate a domain Registrar and the Registry it exclusively works with.
So I could just do what you are doing, but would end up in jail for
violating the VAT act. Irritating, but I just pay the Receiver wait 2
months and get it back :-)-O.

Of course I hacked a little perl script which fills in the VAT forms,
and generates a list of transactions so if they come and inspect they
have it easier :-)-O. I'd *love* to email the form, and I probably could
(the taxation officers there are actually helpful), but since the
Receiver can not be paid by EFT, we have to drop a check anyway, so I
drop the form as well.

el

on 11/26/06 9:13 PM Tony Fraser said the following:
> On Sun, 2006-11-26 at 12:26 -0500, Mark Bucciarelli wrote:
>> On Sat, Nov 25, 2006 at 07:47:09PM -0800, Dave Snell wrote:
>>> So just so I'm clear, good Doctor, I should create a
>>> bogus vendor record and accompanying AP transaction so
>>> that I can issue my refund check.  Then throughout the
>>> year - as I continue to statement my customer - I
>>> should just wink and say "just ignore this
>>> transaction" we'll take care of it at the end of the
>>> year.  And then come the end of the year I should do
>>> what again?  Sorry if I'm being slow, I guess I just
>>> expect an accounting package to handle some of the
>>> basic accounting transactions for me.
>>>
>> Can't you create a holding account and enter a G/L transaction so
>> the customer account is correct?  Then use A/P against this same
>> holding account to generate the check?  Externally all is
>> copacetic and you just need to reconcile that holding account at
>> year end.
> 
> Um, just to fine tune this a bit. I actually do something similar, I
> have a Customer who uses my services quite a bit and I buy quite a lot
> of goods from them. A refund cheque is similar. Instead of sending each
> other large cheques that don't really mean anything, once a month or so
> we sit down and match up our invoices and issue each other credit notes
> and whoever still has a balance pays the balance.
> 
> What I have is a holding account I use for the task that has the links
> AR_paid,AR_amount,AP_paid,AP_amount. Mine is an Asset account, you could
> make yours a liability account. The refund cheque would be 2
> transactions:
> 
> A negative AR transaction (Credit Note) that debits the holding account.
> Which in your case would be used to "pay" the invoice that is being
> returned using the Cash->Reciept screen, just tick the 2 invoices to pay
> them in full and click update. Both invoices should get "paid" but the
> total payment amount should be $0.00
> 
> Now you can make a positive AP transaction (using as you say a bogus
> vendor record) that credits the holding account. now you can pay the AP
> transaction with a cheque from your chequing account.
> 
> By using a negative AR transaction the customer will see the credit on
> there next statement and the positive AP transaction will allow you to
> print the refund cheque properly.
> 

-- 
Dr. Eberhard W. Lisse  \        / Obstetrician & Gynaecologist (Saar)
el...@li... el108-ARIN / *     |   Telephone: +264 81 124 6733 (cell)
PO Box 8421             \     /   Please do NOT email to this address
Bachbrecht, Namibia     ;____/        if it is DNS related in ANY way

Re: [SL] Swedish SQL-ledger 2.6.20, To buy a computer: no right account number

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

On Sunday 26 November 2006 14:10, you wrote:
> On 11/26/06, Roy P <or...@sh...> wrote:
> > Apology in advance to the list... I don't think this is a forum for this
> > type of discussion, but since Chris sent his comment to the list.. i sent
> > this reply in defence.
> >
> > All further replies will be offlist.
>
>  Which translates to: I want the last word on this to let my view prevail.

No it does not. 
This list is for discussion of SQL-ledger not a discussion about linguistics.
Therefore our views on the topic is irrelevant to the group.

I plan to discuss this off list and I'm more than willing to let your last 
public post stand and "let you view prevail".

Re: [SL] Swedish SQL-ledger 2.6.20, To buy a computer: no right account number

[Christopher M. <chr...@gm...>]

On 11/26/06, Roy P <or...@sh...> wrote:
> Apology in advance to the list... I don't think this is a forum for this type
> of discussion, but since Chris sent his comment to the list.. i sent this
> reply in defence.
>
> All further replies will be offlist.

 Which translates to: I want the last word on this to let my view prevail.

> On 11/26/06, Roy P <or...@sh...> wrote:
> I guess it depends on when you went to school and which school you went to.
> I graduated from public high school in 1980 in Manitoba and the pronunciation
> we learned is the Quebecois dialect.

 Funny. I went to school in Quebec, and we learned international
French. I also speak French pretty much every day. I've got French
(from France) neighbours and obviously Quebecois neighbours. We all
understand each other perfectly when we speak international French and
when we speak using slang from either dialects (the core of the
dialects have very few differences).

 If you learned what you call 'Quebecois' French and you can't
understand people from France (and vice versa), then you likely
learned heavy slang.

> On the contrary...
> Quebecois French IS a lower form of French, just like Acadian French is.

That's snobbish BS. Are you saying that Canadian English is a lower
form of English too? Same for American English?

> The same as the English dialect as spoken in Liverpool, commonly reffered to
> as "scouse", is a lower form of English.

The Quebec French dialect that is spoken everywhere where electricity
is common does not differ from International or French French as much
as Liverpudlian does.

> "How Ya'll Doin' ?","Yo Yo wassup homie ?", and "Stay where yer at, I'll come
> where yer to" may be forms of english... but they are not common english,
> they are regional and cultural dialects.

 Somehow, I doubt you learned 'Oooouin? Ehhh tabarnak!' in your French classes.

> > It's divisive and insulting to all Canadians. It also makes
> > it much harder for English Quebecers like myself as we have to live
> > with these tensions on a regular basis. So, please don't refer to it
> > as 'non-real' or a lower form of French. Thanks.
>
> Quite simply...
> Quebecois French is a dialect of French.
> Dialects are not the preferred form to use when trying to communicate to a
> majority of people.
> I don't understand how stating that fact is divisive or insulting.

Maybe you don't understand what I'm saying because you only speak a
lower form of English. You should learn British or internaltional
English so that we can understand each other.

Cheers,

Chris

Re: [SL] Refund Checks

[Tony F. <to...@sy...>]

On Sun, 2006-11-26 at 12:26 -0500, Mark Bucciarelli wrote:
> On Sat, Nov 25, 2006 at 07:47:09PM -0800, Dave Snell wrote:
> > 
> > So just so I'm clear, good Doctor, I should create a
> > bogus vendor record and accompanying AP transaction so
> > that I can issue my refund check.  Then throughout the
> > year - as I continue to statement my customer - I
> > should just wink and say "just ignore this
> > transaction" we'll take care of it at the end of the
> > year.  And then come the end of the year I should do
> > what again?  Sorry if I'm being slow, I guess I just
> > expect an accounting package to handle some of the
> > basic accounting transactions for me.
> > 
> 
> Can't you create a holding account and enter a G/L transaction so
> the customer account is correct?  Then use A/P against this same
> holding account to generate the check?  Externally all is
> copacetic and you just need to reconcile that holding account at
> year end.

Um, just to fine tune this a bit. I actually do something similar, I
have a Customer who uses my services quite a bit and I buy quite a lot
of goods from them. A refund cheque is similar. Instead of sending each
other large cheques that don't really mean anything, once a month or so
we sit down and match up our invoices and issue each other credit notes
and whoever still has a balance pays the balance.

What I have is a holding account I use for the task that has the links
AR_paid,AR_amount,AP_paid,AP_amount. Mine is an Asset account, you could
make yours a liability account. The refund cheque would be 2
transactions:

A negative AR transaction (Credit Note) that debits the holding account.
Which in your case would be used to "pay" the invoice that is being
returned using the Cash->Reciept screen, just tick the 2 invoices to pay
them in full and click update. Both invoices should get "paid" but the
total payment amount should be $0.00

Now you can make a positive AP transaction (using as you say a bogus
vendor record) that credits the holding account. now you can pay the AP
transaction with a cheque from your chequing account.

By using a negative AR transaction the customer will see the credit on
there next statement and the positive AP transaction will allow you to
print the refund cheque properly.

-- 
Tony Fraser
to...@sy...
Sybaspace Internet Solutions                        System Administrator
phone: (250) 246-5368                                fax: (250) 246-5398

Re: [SL] Swedish SQL-ledger 2.6.20, To buy a computer: no right account number

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

Apology in advance to the list... I don't think this is a forum for this ty=
pe=20
of discussion, but since Chris sent his comment to the list.. i sent this=20
reply in defence.

All further replies will be offlist.

On Sunday 26 November 2006 10:33, you wrote:
> On 11/26/06, Roy P <or...@sh...> wrote:
> > Here in Canada I was  taught Quebec French in school. The problem is,
> > it's not real French so it's not as useful. Due to lack of use... I can
> > barely remember the basics. Now I usually just say.. Je ne comprend pas=
=20
> > :(
>
>   First of all, if your school was worth attending at all, you were
> likely taught 'Fran=C3=A7ais International' (international French), which
> is more or less the French spoken by diplomats and business folks when
> they are talking to people from many nationalities. I grew up and
> still live in Quebec and this was the French I was taught (public
> school K-11).

I guess it depends on when you went to school and which school you went to.
I graduated from public high school in 1980 in Manitoba and the pronunciati=
on=20
we learned is the Quebecois dialect.

>   Secondly, Quebec French is just as 'real' as Canadian English, or
> American English or UK English. To say otherwise is really an insult
> to Quebecois. While I don't think you intended this as an insult, the
> notion in Canada that Quebecois speak some lower form of their
> language is a sign of some of the prejudices in certain parts of the
> country.

On the contrary...
Quebecois French IS a lower form of French, just like Acadian French is.
The same as the English dialect as spoken in Liverpool, commonly reffered t=
o=20
as "scouse", is a lower form of English.

"How Ya'll Doin' ?","Yo Yo wassup homie ?", and "Stay where yer at, I'll co=
me=20
where yer to" may be forms of english... but they are not common english,=20
they are regional and cultural dialects.

If you ever take a German language course, you will hear the terms "Low=20
German" and "High German".  In today's definition of the term, "High German=
"=20
is the official language of Germany as taught in german schools, used in=20
german media and shown in the official dictionary.
Low German encompasses the regional dialects that are not High German.
=46or example, in southern Manitoba communities with a Mennonnite history, =
you=20
will hear a German dialect referred to as "Plautdietsch"

Every language has a lower form (dialect).=20
That's not to say it's any less valid LOCALLY as a language.=20
The issue comes down to widespread usability.

Learning the Liverpool English "Scouse" dialect is great if you want to spe=
ak=20
to someone from Liverpool, but you would have a horrible time being=20
understood in any other English speaking region.

Learning "Plautdietsch" would be pointless if you want to listen to German=
=20
radio or speak to the majority of Germans.

It would also be pointless to learn Quebecois French (Which I in fact learn=
t=20
in school, here in 2nd largest French speaking community in Canada), if I=20
wanted to be easily understood in France or other parts of the world.

Learning the high level version of any language will assist in communicatin=
g=20
with the vast majority of others, including those who use lower dialects,=20
because the lower dialect  is derived from the higher language.

> It's divisive and insulting to all Canadians. It also makes
> it much harder for English Quebecers like myself as we have to live
> with these tensions on a regular basis. So, please don't refer to it
> as 'non-real' or a lower form of French. Thanks.

Quite simply...
Quebecois French is a dialect of French.
Dialects are not the preferred form to use when trying to communicate to a=
=20
majority of people.
I don't understand how stating that fact is divisive or insulting.

Regards,
Roy0

Re: [SL] Refund Checks

[Mark B. <ma...@ga...>]

On Sat, Nov 25, 2006 at 07:47:09PM -0800, Dave Snell wrote:
> --- Dr Eberhard Lisse <el...@li...> wrote:
> 
> > End of year, actually.
> 
> So just so I'm clear, good Doctor, I should create a
> bogus vendor record and accompanying AP transaction so
> that I can issue my refund check.  Then throughout the
> year - as I continue to statement my customer - I
> should just wink and say "just ignore this
> transaction" we'll take care of it at the end of the
> year.  And then come the end of the year I should do
> what again?  Sorry if I'm being slow, I guess I just
> expect an accounting package to handle some of the
> basic accounting transactions for me.
> 

Can't you create a holding account and enter a G/L transaction so
the customer account is correct?  Then use A/P against this same
holding account to generate the check?  Externally all is
copacetic and you just need to reconcile that holding account at
year end.

Hopefully, you don't cut that many refund checks in a year.

Yes, it is awkward.

Yes, you have found an area that doesn't work well.

In Free Software there is the idea that people scratch their own
itch--and you have a nasty case of poison oak on this one.  I've
never seen this request come up in years of being subscribed so
it is not that common of a need.

So, submit a wish on the sql-ledger website.  Or write the code
yourself.  Or hire someone to write it for you.  In any case,
submit it to the project for all to benefit, as others have done
before you.  How do you think Dieter can offer Sql-Ledger in so
many languages?  Where do you think the idea for recurring
transactions came from?  Etc, etc.  If it pains you so much, then
you have the opportunity to help make it better.

m

Re: [SL] Swedish SQL-ledger 2.6.20, To buy a computer: no right account number

[Christopher M. <chr...@gm...>]

T24gMTEvMjYvMDYsIFJveSBQIDxvcmFuZW9Ac2hhdy5jYT4gd3JvdGU6Cj4gSGVyZSBpbiBDYW5h
ZGEgSSB3YXMgIHRhdWdodCBRdWViZWMgRnJlbmNoIGluIHNjaG9vbC4gVGhlIHByb2JsZW0gaXMs
Cj4gaXQncyBub3QgcmVhbCBGcmVuY2ggc28gaXQncyBub3QgYXMgdXNlZnVsLiBEdWUgdG8gbGFj
ayBvZiB1c2UuLi4gSSBjYW4gYmFyZWx5Cj4gcmVtZW1iZXIgdGhlIGJhc2ljcy4gTm93IEkgdXN1
YWxseSBqdXN0IHNheS4uIEplIG5lIGNvbXByZW5kIHBhcyAgOigKCiAgRmlyc3Qgb2YgYWxsLCBp
ZiB5b3VyIHNjaG9vbCB3YXMgd29ydGggYXR0ZW5kaW5nIGF0IGFsbCwgeW91IHdlcmUKbGlrZWx5
IHRhdWdodCAnRnJhbsOnYWlzIEludGVybmF0aW9uYWwnIChpbnRlcm5hdGlvbmFsIEZyZW5jaCks
IHdoaWNoCmlzIG1vcmUgb3IgbGVzcyB0aGUgRnJlbmNoIHNwb2tlbiBieSBkaXBsb21hdHMgYW5k
IGJ1c2luZXNzIGZvbGtzIHdoZW4KdGhleSBhcmUgdGFsa2luZyB0byBwZW9wbGUgZnJvbSBtYW55
IG5hdGlvbmFsaXRpZXMuIEkgZ3JldyB1cCBhbmQKc3RpbGwgbGl2ZSBpbiBRdWViZWMgYW5kIHRo
aXMgd2FzIHRoZSBGcmVuY2ggSSB3YXMgdGF1Z2h0IChwdWJsaWMKc2Nob29sIEstMTEpLgoKICBT
ZWNvbmRseSwgUXVlYmVjIEZyZW5jaCBpcyBqdXN0IGFzICdyZWFsJyBhcyBDYW5hZGlhbiBFbmds
aXNoLCBvcgpBbWVyaWNhbiBFbmdsaXNoIG9yIFVLIEVuZ2xpc2guIFRvIHNheSBvdGhlcndpc2Ug
aXMgcmVhbGx5IGFuIGluc3VsdAp0byBRdWViZWNvaXMuIFdoaWxlIEkgZG9uJ3QgdGhpbmsgeW91
IGludGVuZGVkIHRoaXMgYXMgYW4gaW5zdWx0LCB0aGUKbm90aW9uIGluIENhbmFkYSB0aGF0IFF1
ZWJlY29pcyBzcGVhayBzb21lIGxvd2VyIGZvcm0gb2YgdGhlaXIKbGFuZ3VhZ2UgaXMgYSBzaWdu
IG9mIHNvbWUgb2YgdGhlIHByZWp1ZGljZXMgaW4gY2VydGFpbiBwYXJ0cyBvZiB0aGUKY291bnRy
eS4gSXQncyBkaXZpc2l2ZSBhbmQgaW5zdWx0aW5nIHRvIGFsbCBDYW5hZGlhbnMuIEl0IGFsc28g
bWFrZXMKaXQgbXVjaCBoYXJkZXIgZm9yIEVuZ2xpc2ggUXVlYmVjZXJzIGxpa2UgbXlzZWxmIGFz
IHdlIGhhdmUgdG8gbGl2ZQp3aXRoIHRoZXNlIHRlbnNpb25zIG9uIGEgcmVndWxhciBiYXNpcy4g
U28sIHBsZWFzZSBkb24ndCByZWZlciB0byBpdAphcyAnbm9uLXJlYWwnIG9yIGEgbG93ZXIgZm9y
bSBvZiBGcmVuY2guIFRoYW5rcy4KCkNoZWVycywKCkNocmlzCg==

Re: [SL] Swedish SQL-ledger 2.6.20, To buy a computer: no right account number

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

Bonjour M. Tourde !

If I understand correctly, you are buying a computer for use by the company ?
It is an expense ? Not as inventory for selling later ?

You have to customize your COA (chart of accounts) to include account 1250 
(and any other accounts you need). 

The basic chart of accounts that is supplied with SQL-Ledger is only a 
starting point. Different types of businesses need a different chart of 
accounts. Before you use the system, you should customize the basic accounts 
so they match the ones your accountant/business needs.

Bon Nuit,
Roy Pennington

PS: I disagree Daniel. You have no need to apologize for your language skills. 
If anything.. we English speaking North Americans should hang our heads 
because many people do not learn a second language.  Here in Canada I was 
taught Quebec French in school. The problem is, it's not real French so it's 
not as useful. Due to lack of use... I can barely remember the basics. Now I 
usually just say.. Je ne comprend pas  :(

 

On Saturday 25 November 2006 13:27, Daniel Tourde wrote:
> Hello,
>
> According to the swedish rules, when one buys a computer, the 1250 account
> (Computers, Dator) must be used. However, when I register an acquisition, I
> can only choose between accounts: 4010, 5010, 5410 and a few others.
>
> Is it a missing feature, a bug or did I miss something?
>
>                 Daniel
>
> PS: Sorry for being so imprecise in my description of the probleme. I am a
> frenchman, working with SQL-ledger in Swedish and sending a question /
> request in english... It ain't easy... ;)

Re: [SL] Refund Checks

[Dave S. <bou...@ya...>]

--- Dr Eberhard Lisse <el...@li...> wrote:

> End of year, actually.

So just so I'm clear, good Doctor, I should create a
bogus vendor record and accompanying AP transaction so
that I can issue my refund check.  Then throughout the
year - as I continue to statement my customer - I
should just wink and say "just ignore this
transaction" we'll take care of it at the end of the
year.  And then come the end of the year I should do
what again?  Sorry if I'm being slow, I guess I just
expect an accounting package to handle some of the
basic accounting transactions for me.


 
____________________________________________________________________________________
Want to start your own business?
Learn how on Yahoo! Small Business.
http://smallbusiness.yahoo.com/r-index

[SL] Swedish SQL-ledger 2.6.20, To buy a computer: no right account number

[Daniel T. <dan...@ca...>]

Hello,

According to the swedish rules, when one buys a computer, the 1250 account 
(Computers, Dator) must be used. However, when I register an acquisition, I 
can only choose between accounts: 4010, 5010, 5410 and a few others.

Is it a missing feature, a bug or did I miss something?

                Daniel

PS: Sorry for being so imprecise in my description of the probleme. I am a 
frenchman, working with SQL-ledger in Swedish and sending a question / 
request in english... It ain't easy... ;)

[SL] [OT] advise on price list making tool?

[Gianluca C. <gc...@pe...>]

Off-topic question. Perhaps anyone on the list used something similar...

Basically I would like to be able to:

- define customers
- define products
- define currency depending on customer
- define base prices
- define sell types (kg or piece basically)
- define categories such as fot, ddp to include freight prices
- define expected margin to apply, minimum margin and possibility to
manually set an in-between price

Target is
- one guy sets prices at the beginning of the week=20
- another guy have possibility to extract a printout layout for every
customer with weekly price list based on base prices defined and margins
so that to automatically send this file (pdf or html) to the customer.
I probably could define in sql-ledger in some way customizing, but it
seems to me to "shoot a fly with a gun"
Any experience with open source price list composing sw, better if via
web interface?
Thanks in advance for any suggestions.

Gianluca=20

Re: [SL] [sl] inventory donated to charity____

[Nefnifi, K. <Kas...@at...>]

aSB0aGluayBhbiBpbnZvaWNlIHdpdGggMTAwJSBkaXNjb3VudCBpcyB0aGUgc29sdXRpb24gZm9y
IHRoYXQuIGFsc28gaWYgdSB1c2Ugc29tZXRoaW5nIGludGVybmFsbHkgZm9yIHlvdXJzZWwuDQpy
ZWdhcmRzDQprYXNlbSwNCg0KCS0tLS0tT29yc3Byb25rZWxpamsgYmVyaWNodC0tLS0tIA0KCVZh
bjogUiBQZW5uaW5ndG9uIFttYWlsdG86YXJjaGRpc3RAbXRzLm5ldF0gDQoJVmVyem9uZGVuOiB2
ciAyNC8xMS8yMDA2IDE2OjI4IA0KCUFhbjogc3FsLWxlZGdlci11c2Vyc0BsaXN0cy5zb3VyY2Vm
b3JnZS5uZXQgDQoJQ0M6IA0KCU9uZGVyd2VycDogW3NsXSBpbnZlbnRvcnkgZG9uYXRlZCB0byBj
aGFyaXR5X19fXw0KCQ0KCQ0KCU9yaWdpbmFsIHN1YmplY3Q6IFtTTF0gSW52ZW50b3J5IERvbmF0
ZWQgdG8gQ2hhcml0eS4uLi4NCgkNCg0KCUkgZG9uYXRlZCBzb21lIHByb2R1Y3RzIHRvIGEgbG9j
YWwgY2hhcml0eS4NCglPYnZpb3VzbHkgSSBoYXZlIHRvIGNyZWF0ZSBhbiBpbnZvaWNlIHdoaWNo
IGFkanVzdHMgdGhlIENPR1MgYW5kIGludmVudG9yeSBjb3VudC4NCgkNCglJIGFzc3VtZSBJIHdv
dWxkIGludm9pY2UgIHRoZSBpdGVtIHRvIHRoZSBjaGFyaXR5IGZvciBteSBjb3N0IGFuZCB0aGVu
IHBheSB0aGF0IGludm9pY2UgZnJvbSB0aGUgIkRvbmF0aW9ucy1DaGFyaXRhYmxlIiBleHBlbnNl
IGFjY291bnQgPw0KCQ0KCUlzIHRoZXJlIGEgYmV0dGVyIHdheSB0byBoYW5kbGUgdGhpcyA/DQoJ
LS0NCglDaGVlcnMsDQoJUm95IFANCgkNCgktLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQoJVGFrZSBTdXJ2ZXlz
LiBFYXJuIENhc2guIEluZmx1ZW5jZSB0aGUgRnV0dXJlIG9mIElUDQoJSm9pbiBTb3VyY2VGb3Jn
ZS5uZXQncyBUZWNoc2F5IHBhbmVsIGFuZCB5b3UnbGwgZ2V0IHRoZSBjaGFuY2UgdG8gc2hhcmUg
eW91cg0KCW9waW5pb25zIG9uIElUICYgYnVzaW5lc3MgdG9waWNzIHRocm91Z2ggYnJpZWYgc3Vy
dmV5cyAtIGFuZCBlYXJuIGNhc2gNCglodHRwOi8vd3d3LnRlY2hzYXkuY29tL2RlZmF1bHQucGhw
P3BhZ2U9am9pbi5waHAmcD1zb3VyY2Vmb3JnZSZDSUQ9REVWREVWDQoJX19fX19fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18NCglzcWwtbGVkZ2VyLXVzZXJzIG1haWxp
bmcgbGlzdA0KCXNxbC1sZWRnZXItdXNlcnNAbGlzdHMuc291cmNlZm9yZ2UubmV0DQoJaHR0cHM6
Ly9saXN0cy5zb3VyY2Vmb3JnZS5uZXQvbGlzdHMvbGlzdGluZm8vc3FsLWxlZGdlci11c2Vycw0K
CQ0KCQ0KDQo=

[SL] Inventory Donated to Charity....

[R P. <arc...@mt...>]

I donated some products to a local charity.
Obviously I have to create an invoice which adjusts the COGS and inventory count.

I assume I would invoice  the item to the charity for my cost and then pay that invoice from the "Donations-Charitable" expense account ?

Is there a better way to handle this ?
-- 
Cheers,
Roy P

Re: [SL] Refund Checks

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

End of year, actually.



on 11/24/06 5:07 AM Dave Snell said the following:
> --- Dr Eberhard Lisse <el...@li...> wrote:
> 
>> But then one can sort out these issues at the end of
>> an accounting
>> period. Which I am quite sure the slow people
>> already realized too.
> 
> The reason most of use accounting packages is so that
> we don't have to 'sort things out' at the end of the
> month.  Unfortunately, with the way SQL-Ledger is
> designed there is no solution but 'sorting things out'
> if one is to attempt to refund a customer's payment.

Re: [SL] Refund Checks

[Dave S. <bou...@ya...>]

--- Dr Eberhard Lisse <el...@li...> wrote:

> But then one can sort out these issues at the end of
> an accounting
> period. Which I am quite sure the slow people
> already realized too.

The reason most of use accounting packages is so that
we don't have to 'sort things out' at the end of the
month.  Unfortunately, with the way SQL-Ledger is
designed there is no solution but 'sorting things out'
if one is to attempt to refund a customer's payment.

 



 
____________________________________________________________________________________
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail beta.
http://new.mail.yahoo.com

Re: [SL] SQL Version 2.6.19 has been acting up since the last upgrade. We have to keep inputting our password all the time.

[Chuck A. S. A. <ch...@sm...>]

Hi List

I note that a lot of SQL Admins and their users had session expiry
issues.
I did get to the bottom of mine which was due to ntp daemon dieing on me
somehow nevertheless I just had to restart ntpd and the server and
clients where in harmony.

I have since upgraded to version 2.6.20 after updating our test site and
all is well nice to see how many suggestions and possible fixes were
sent and thanks Dieter for your quick response.

Cheers

Chuck

On Wed, 2006-11-15 at 12:28 +0000, Chuck Amadi Systems Administrator
wrote:
> Hi List Sorry but I forgot to mention their using IE6
> SL is installed on a Linux SLES 9 Server But the user access
> SL and Postgresql via IE Browser web interface.
> 
> SQL Version 2.6.19 has been acting up since the last upgrade.  We have
> to keep inputting our password all the time.
> 
> PS Thus I gather it's a possible cache issue Please email suggestions or
> good links
> 
> Cheers List
> 
> 
> On Wed, 2006-11-15 at 12:21 +0000, Chuck Amadi Systems Administrator
> wrote:
> > Hi List 
> > 
> > SQL Version 2.6.19 has been acting up since the last upgrade.  We have
> > to keep inputting our password all the time.
> > 
> > Cheers List
> > 
> > 
-- 
Unix/ Linux Systems Administrator
Chuck Amadi
The Surgical Material Testing Laboratory (SMTL), 
Princess of Wales Hospital 
Coity Road 
Bridgend, 
United Kingdom, CF31 1RQ.
Email chuck.smtl.co.uk
Tel: +44 1656 752820 
Fax: +44 1656 752830

Re: [SL] Refund Checks

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

But then one can sort out these issues at the end of an accounting
period. Which I am quite sure the slow people already realized too.

el

on 11/23/06 1:50 AM Rich Cloutier said the following:
> But then one *WOULD* have two separate account balances, wouldn't one?
> 
> I think the slow people already realized this.
> 
> 
> Dr Eberhard W Lisse wrote:
>> Well, one *COULD* add the customer on the AP side of things, now could
>> one? If one wasn't slow, that is.
>>
>> el
>>
>> Dave Snell wrote:
>>   
>>>> add an AP transaction and print the check
>>>>
>>>> or you could subscribe to support and download v2.7
>>>>       
>>> Would that work Dieter?  Wait, customers don't exist
>>> on the AP side of the application so by adding the AP
>>> transaction I still wouldn't be able to refund their
>>> money...  Dang, glad I didn't pay for that support!
>>>     
>> -------------------------------------------------------------------------
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to share your
>> opinions on IT & business topics through brief surveys - and earn cash
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
>>
>>
>>   
> 
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

-- 
Dr. Eberhard W. Lisse  \        / Obstetrician & Gynaecologist (Saar)
el...@li... el108-ARIN / *     |   Telephone: +264 81 124 6733 (cell)
PO Box 8421             \     /   Please do NOT email to this address
Bachbrecht, Namibia     ;____/        if it is DNS related in ANY way

Re: [SL] Refund Checks

[Rich C. <ri...@sy...>]

But then one *WOULD* have two separate account balances, wouldn't one?

I think the slow people already realized this.


Dr Eberhard W Lisse wrote:
> Well, one *COULD* add the customer on the AP side of things, now could
> one? If one wasn't slow, that is.
>
> el
>
> Dave Snell wrote:
>   
>>> add an AP transaction and print the check
>>>
>>> or you could subscribe to support and download v2.7
>>>       
>> Would that work Dieter?  Wait, customers don't exist
>> on the AP side of the application so by adding the AP
>> transaction I still wouldn't be able to refund their
>> money...  Dang, glad I didn't pay for that support!
>>     
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
>
>   

[SL] New users in 2.6.19

[Patrick R. <pa...@pa...>]

I am experiencing something very odd inside of 2.6.19. I have created a new 
install. All went as normal. I then created my test dataset ( I always do a 
test dataset to make sure the system is functional and so that I have a 
traing ground for my customers). After creating the test dataset, I tried to 
create some users. I set my first user as just a user. I wanted this user to 
be able to do most things so I only unchecked a few items such as all of the 
HR items. I then tried to login as that user, I discovered that even though I 
had specifically enabled certain access, it would not let me in. Things like 
adding a new customer. I logged out and from the admin panel, I tried to 
re-enable the same items, saved and exited, logged in again and got the same 
thing. I deleted the dataset thinking that I needed to create an Admin user 
first, went through the same process (with an admin user) and ended up in the 
same place.

Anyone have any ideas?

Server specs as follows.
IBM x330 800MHz P3, 1GB Ram, Dual 18GB SCSI drives
Mandriva 2007 Powerpack
SQL-Ledger 2.6.19
Perl 5.8.8
Apache 2.2.3
Postgres 8.1.4 (with schemas)
-- 
Patrick Rea
http://www.reasystems.com
Toronto, Canada

-- 
Patrick Rea
Toronto, ON, CA
http://www.patrickrea.org

Ask me how to end your virus problems. Today!

Re: [SL] Refund Checks

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

Well, one *COULD* add the customer on the AP side of things, now could
one? If one wasn't slow, that is.

el

Dave Snell wrote:
>> add an AP transaction and print the check
>>
>> or you could subscribe to support and download v2.7
> 
> Would that work Dieter?  Wait, customers don't exist
> on the AP side of the application so by adding the AP
> transaction I still wouldn't be able to refund their
> money...  Dang, glad I didn't pay for that support!

Re: [SL] Refund Checks

[Dave S. <bou...@ya...>]

--- Dieter Simader <dsi...@sq...> wrote:

> On Mon, 20 Nov 2006, Dave Snell wrote:
> 
> >
> > --- Wallace Roberts Consulting
> <wrc...@gm...>
> > wrote:
> >
> > > On 11/20/06, Dave Snell <bou...@ya...>
> > > wrote:
> > > ...
> > > > "How are you supposed to issue refund checks
> with
> > > SQL-Ledger?"
> > >
> > > Can you not write one out by hand?
> > >
> > > Obviously, I'm missing something here.
> >
> > Nope, I can't.  We use blank check laser stock for
> all
> > of our checks.  Our bank will not clear any hand
> > written checks.  Nor will they clear any check
> that
> > prints with a negative dollar amount.  I guess I'm
> in
> > the minority here - nobody else ever gives money
> back,
> > or expects their accounting system to be able to
> do it
> > for them.
> >
> > Dave
> 
> add an AP transaction and print the check
> 
> or you could subscribe to support and download v2.7

Would that work Dieter?  Wait, customers don't exist
on the AP side of the application so by adding the AP
transaction I still wouldn't be able to refund their
money...  Dang, glad I didn't pay for that support!




 
____________________________________________________________________________________
Sponsored Link

Rates near 39yr lows. $510,000 Loan for $1698/mo. 
Calcuate new payment. www.LowerMyBills.com/lre

Re: [SL] Printing Issues

[Stroller <lin...@my...>]

On 21 Nov 2006, at 20:07, Jon Scottorn wrote:
> ... I am trying to
> print the AR Aging report and I am running into issues.
> When I print that report this is what happens.  We are printing
> thousands of records which when you print it seperates each client  
> into
> a seperate print job so what happens is we get an error saying too  
> many
> jobs for the printer.

What printing system are you using, please?

I wouldn't have thought that a few thousand print jobs would be too  
much for CUPS; I appreciate that this isn't an answer to your  
question, but perhpas migrating to CUPS would resolve your issue?

Stroller.