sql-ledger-users — SQL-Ledger users

Re: [SL] Associate scanned images with invoice?

[Ed W <li...@wi...>]

Hi

> associate a button in SL with that script, 

Do you have an example of how to do this without simply hacking the 
code?  I wanted to do this via the various hooks provided, but couldn't 
quite figure out how to do it?

Cheers

Ed W

Re: [SL] Associate scanned images with invoice?

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

On Mon, Dec 04, 2006 at 02:42:39PM -0500, C. Duncan Hudson wrote:

> I never understand the argument about storing images / blobs in
> the database.  Yes, they are big.  Yes, they do take up alot of
> space.  But if you don't store them in the database, and you
> end up storing them on a share somewhere what are you saving?
> Just the overhead of the indices?  Maybe a little more.

I don't know how database caching works, but I would guess that
if the average bytes per row of query result went up from .5K to
30K (because each row has a blob), db performance would suffer,
as you could store 1/60th as much data in a cache.  

In any case, for db performance is not the lowest hanging fruit
for SL performance.

m

Re: [SL] Associate scanned images with invoice?

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

Mark Lubratt wrote:
> I just suggested almost the exact same thing on the feature request  
> part of the SL website.  I'd like to store PDFs of received POs from  
> our customers and have them linked to our sales order..
>
> Dieter didn't sound too interested. He said that would take up too  
> much space in the db. He also suggested that you can store the  
> scanned images on the server in the HTTP tree and put a hyperlink in  
> the notes section of your transaction.  Then, when you do a report,  
> include the notes and you'll have a link to the scanned image.
>
> I agree with you though.  I'd like it in the database with the  
> safeguards the db provides above and beyond what the file system  
> gives you (including backup).
>
> Mark
>
> On Dec 4, 2006, at 10:04 AM, Mark Bucciarelli wrote:
>
>   
>> Is anybody stored scanned images of receipts and associating them
>> with customer invoices?  I bill for expenses sometimes and would
>> like to have a complete record on file.
>>
>> If not, any clever ideas for a way to do this without much fuss?
>>
>> I'd like to put images in the db, so the built-in backup function
>> really get's me backup of all data.
>>
>> Thanks
>>     
I never understand the argument about storing images / blobs in the 
database.  Yes, they are big.  Yes, they do take up alot of space.  But 
if you don't store them in the database, and you end up storing them on 
a share somewhere what are you saving?  Just the overhead of the 
indices?  Maybe a little more.  And you're having to add more software 
into the mix to manage them.  I'd gladly trade a little extra space to 
make something easier or to manage.  While I don't want to store scanned 
images of receipts my vote would be to put them in the database.  While 
we're at it allow images of parts, and explosion diagrams / parts lists 
for assemblies!

Dunc

Re: [SL] Associate scanned images with invoice?

[Jason R. <jas...@gm...>]

On Monday 04 December 2006 11:27, Mark Lubratt wrote:
> On Dec 4, 2006, at 10:04 AM, Mark Bucciarelli wrote:
> > Is anybody stored scanned images of receipts and associating them
> > with customer invoices?  I bill for expenses sometimes and would
> > like to have a complete record on file.
> >
> > If not, any clever ideas for a way to do this without much fuss?

If your server is linux, and your scanner is supported by sane 
(http://www.sane-project.org/), and connected to a linux machine,  and you 
can get it all setup  then a script with:

scanimage | pnmtopng > /path/to/httpd-root/receipts/$sonum.png

Could do the trick for you. (without much fuss :) ) Simply put the document on 
the scanner bed, associate a button in SL with that script, and will put the 
image anywhere you need.  For most receipts, you'll probably want to 
add "--brightness=-25" to scanimage to darken it a bit. (depending on scanner 
model)

Jason

Re: [SL] Associate scanned images with invoice?

[Mark L. <mar...@in...>]

I just suggested almost the exact same thing on the feature request  
part of the SL website.  I'd like to store PDFs of received POs from  
our customers and have them linked to our sales order..

Dieter didn't sound too interested. He said that would take up too  
much space in the db. He also suggested that you can store the  
scanned images on the server in the HTTP tree and put a hyperlink in  
the notes section of your transaction.  Then, when you do a report,  
include the notes and you'll have a link to the scanned image.

I agree with you though.  I'd like it in the database with the  
safeguards the db provides above and beyond what the file system  
gives you (including backup).

Mark

On Dec 4, 2006, at 10:04 AM, Mark Bucciarelli wrote:

> Is anybody stored scanned images of receipts and associating them
> with customer invoices?  I bill for expenses sometimes and would
> like to have a complete record on file.
>
> If not, any clever ideas for a way to do this without much fuss?
>
> I'd like to put images in the db, so the built-in backup function
> really get's me backup of all data.
>
> Thanks,
>
> m
>
> ---------------------------------------------------------------------- 
> ---
> 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] Associate scanned images with invoice?

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

Is anybody stored scanned images of receipts and associating them
with customer invoices?  I bill for expenses sometimes and would
like to have a complete record on file.

If not, any clever ideas for a way to do this without much fuss?

I'd like to put images in the db, so the built-in backup function
really get's me backup of all data.

Thanks,

m

Re: [SL] shipping address v2.6.5

[Antony G. <an...@wa...>]

C. Duncan Hudson wrote:
> This has been discussed many times before.  It would be wonderful if 
> things were changed so that you could search by shipto from both the 
> invoice and the PO screens.  Heck for that matter why not add searching 
> by Employee too - I think someone, earlier this week, was looking for 
> commission.  If you could search and subtotal by employee it would sure 
> help in figuring out commissions!
> 

Indeed - that was me.  Good to know that somebody made sense of my post. 
    :)

Antony

Re: [SL] shipping address v2.6.5

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

davidc wrote:
> Thanks Roy
> from you info, i  been able to get it via phpPgadmin, it is in the 
> shipto table.
> but this is not  satisfactory to past to the  office to do as a daily  
> procedure, just can not give root access to every one to use.
> mush be from inside Ledger sql for that.
> This will be my wish list for  **** Dieter **** to add  for the future
>
> cheers
> Allan
>
> R Pennington wrote:
>
>   
>> On Thursday 30 November 2006 9:06 pm, davidc wrote:
>>  
>>
>>     
>>> HI
>>> I am running version 2.6.5, are there any ways to list the shipping 
>>> address of customers ??
>>>
>>> thanks for any help in advance
>>> Allan
>>>    
>>>
>>>       
>> Hello Allan.
>>
>> The only way is to query the database directly via psql.
>>
>> If I remember correctly it's a query against the "customer",  "shipto" and one other ? table
>> Unfortunately I don't have a system in from of me to tell you specifically which tables to query.
>>
>> Maybe someone else has a system close by and be more specific.
>>
>> Cheers,
>> Roy
This has been discussed many times before.  It would be wonderful if 
things were changed so that you could search by shipto from both the 
invoice and the PO screens.  Heck for that matter why not add searching 
by Employee too - I think someone, earlier this week, was looking for 
commission.  If you could search and subtotal by employee it would sure 
help in figuring out commissions!

Dunc

Re: [SL] shipping address v2.6.5

[davidc <da...@mo...>]

Thanks Roy
from you info, i  been able to get it via phpPgadmin, it is in the 
shipto table.
but this is not  satisfactory to past to the  office to do as a daily  
procedure, just can not give root access to every one to use.
mush be from inside Ledger sql for that.
This will be my wish list for  **** Dieter **** to add  for the future

cheers
Allan

R Pennington wrote:

>On Thursday 30 November 2006 9:06 pm, davidc wrote:
>  
>
>>HI
>>I am running version 2.6.5, are there any ways to list the shipping 
>>address of customers ??
>>
>>thanks for any help in advance
>>Allan
>>    
>>
>
>Hello Allan.
>
>The only way is to query the database directly via psql.
>
>If I remember correctly it's a query against the "customer",  "shipto" and one other ? table
>Unfortunately I don't have a system in from of me to tell you specifically which tables to query.
>
>Maybe someone else has a system close by and be more specific.
>
>Cheers,
>Roy
>
>-------------------------------------------------------------------------
>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
>  
>

Re: [SL] shipping address v2.6.5

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

On Thursday 30 November 2006 9:06 pm, davidc wrote:
> HI
> I am running version 2.6.5, are there any ways to list the shipping 
> address of customers ??
> 
> thanks for any help in advance
> Allan

Hello Allan.

The only way is to query the database directly via psql.

If I remember correctly it's a query against the "customer",  "shipto" and one other ? table
Unfortunately I don't have a system in from of me to tell you specifically which tables to query.

Maybe someone else has a system close by and be more specific.

Cheers,
Roy

Re: [SL] shipping address v2.6.5

[davidc <da...@mo...>]

HI
I am running version 2.6.5, are there any ways to list the shipping 
address of customers ??

thanks for any help in advance
Allan

Re: [SL] Refund Checks

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

On Wed, 2006-11-29 at 10:25 +0200, Dr Eberhard Lisse wrote:
> as you write at the end, the question is not not to pay the net tax,
> but
> some jurisdictions require that you pay first, claim second and
> reconcile the net tax last.
> 
> How would you address this?

The same way you would normally... You have two invoices, one customer
invoice that registers revenue and tax collected and one vendor invoice
that incurs some expense and pays some tax. In this case I pay the tax
man his $20 and later claim back the $16 leaving a net collected tax of
$4. The "Credit Note" is just transferring money around... In my
jurisdiction there is no tax on that maybe there is where you are?

In my tax jurisdiction we have to periodically file a Sales tax report
that includes the net tax calculation and remit a payment for the net
tax.

> > I never said I didn't pay the taxes due...
> > 
> > Say I do some work. Invoice to customer:
> >   Labour   $100
> >      Tax   $ 20
> >    Total   $120
> > 
> > And I buy some goods: Invoice from Vendor:
> >   Parts $ 80
> >     Tax $ 16
> >   Total $ 96

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

[SL] Discount varying according to salesperson

[Antony G. <an...@wa...>]

Hi all,

I have an interesting requirement from a customer.

They want to be able to print commission reports for salespeople.  I 
note that the AR transaction report doesn't allow selection by 
salesperson.  Would this need to be coded as a new report or have I 
missed it somewhere?

It gets more complicated.  They pay commission such that the percentage 
is different depending on the product types that they have sold.  For 
example, 20% on hamburgers, 10% on baked beans.  I've looked at the Add 
Part screen, but I don't see anywhere to assign categories (that could 
be leveraged in the report above).  Does this type of functionality 
exist out of the box?  Am I looking at the wrong screen?

The piece de resistance is that the commission rate itself may be 
discounted for certain customers, typically where the salesperson wants 
to offer a large discount, he takes a hit on commission as well.

I expect that this could be built into the report in the first 
paragraph, if everything else was in place, but again, I just want to 
know if I'm reinventing the wheel and there is a way of doing this out 
of the box.

Antony

Re: [SL] Add a new currency

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

On Thursday 30 November 2006 4:29 am, Luc van Stappershoef wrote:

> For my buisness I do not really see a problem in this. But I can imagine 
> others would want to be able to use diffrent exchange rates per day.
> 
> But more important in principal one should be able to correct mistakes 
> directly and thus alter the exchangerate in the same day, hour, or 
> minute. After  all most of us are humans.

Agreed.
The lack of support for multiple exchange rates is the only frustration I have with SL.
We do credit card and bank draft purchases and they have different exchanges.

We are forced to make sure we don't do bank drafts on the same day as credit card purchases so that the exchange rate is right.
The additional problem is that, the credit card companies don't know the rate until they post the transaction at the end of the day.
This causes problems with foreign currency  purchase orders, because when the order is created, we have no idea what the exchange at the end of the
day will be.
We have be creating the purchase orders with no item value, then going back the next day and entering the prices when we know the exchange rate.

it would be nice if it was possible to just enter an exchange rate when you actually pay for something (not on the orders)
Of course this would remove the ability for the foreign exchange gain/loss calculation.

Cheers,
Roy

Re: [SL] Add a new currency

[Luc v. S. <lu...@co...>]

I have have solved the problem by indeed waiting 1 day.

I normally do everything in firefox, so today I made a new purchaseorder 
in explorer and I was able to put in a new (correct) exchange rate.
Then I went back to firefox to check strollers comment beneath:

And indeed the new exchangerate comes up which is not "editable", in 
other words the exchange rate is fixed for the day.

For my buisness I do not really see a problem in this. But I can imagine 
others would want to be able to use diffrent exchange rates per day.

But more important in principal one should be able to correct mistakes 
directly and thus alter the exchangerate in the same day, hour, or 
minute. After  all most of us are humans.

Nevertheless I am endlessly happy with SQL-ledger's capabilities

Luc

Stroller wrote:
> No - I'm sure this is a feature. It was mentioned on here a while back.
>
> When no exchange rate is existing for a day then a text-entry box is  
> given so that the user can enter one. If you add a second foreign- 
> currency transaction with the same date then the rate is no longer  
> shown in a text-entry box, but as a fixed part of the HTML (like the  
> xxx in "Credit Limit: xxx" on the Sales Invoice Page). I believe this  
> is because it is anticipated that the exchange rate should not  
> fluctuate during a day's transactions.
>
> Stroller.
>
>
>
> On 28 Nov 2006, at 15:39, Graeme Bruton wrote:
>   
>> Hmmmm. Got me there. It may be cached in the browser. Close SL, re- 
>> open it
>> and try again, maybe clearing cache as well.
>>
>>     
>>> This thread came right in time because I just had to make my first
>>> "other currency" purchasing order and it worked. The only thing is  
>>> I put
>>> in the exchange rate wrong ( 1/x). So no worries I thought just  
>>> delete
>>> the just made purchasing order and make a new one.
>>>
>>> But that doesn't work. Somehow it keeps coming back with the same
>>> exhange rate which I can not alter. Looking through the archives I  
>>> saw
>>> somebody wanting to have diffrent exchage rate in one day ( wich  
>>> did not
>>> work either).
>>>       
>
>
> -------------------------------------------------------------------------
> 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
>
>
>
>   

Re: [SL] Upgrade problem

[Adrian B. <adr...@ie...>]

Problem was solved by installing postgres 7.3 and pointing to the old data files. Upgrade sql-ledger to latest. backup sql-ledger 
& pg_dumpall. Stopping old postgres. start postgres 8.1. edit data, i.e. output file pg_dumpall. restore database data.

Now it all works.

Thanks for assistance.

Adrian

Paul Tammes wrote:
> Adrian Blake schreef:
>> Progress:
>>
>> the error is now:
>>
>> DBD::Pg::st execute failed: ERROR: column t.validto does not exist
>> .
>> .
>> .
>>
>> ERROR: column t.validto does not exist
>>
>> I should add, I had a hard disk crash but I could do a pg_dumpall & SQL-Ledger is the only database. I have had to upgrade from 
>> postgres 7.? to 8.1.?
>>
>> Adrian
>>
>> Dieter Simader wrote:
>>   
>>> edit the backup you made with SQL-Ledger,
>>> change the tables orderitems, inventory and assembly and add 'WITH OIDS'
>>> (see the FAQ)
>>> restore the backup with psql
>>>
>>> psql -U sql-ledger dbname < backup.sql
>>>
>>>     
>>   
> Had the same here some time ago, the SQL-Ledger internal backup (you did 
> make one I hope) was my rescue.
> Clean install of System on a new computer, including latest of 
> everything, then unzip the sql-ledger backed up file.
> Look at version, install latest SQL-Ledger and carefully read any 
> remarks about uodating from older versions.
> Sounds like you not only uograded PostgreSQL from 7 to 8 to me.
> Rather then hacking in files I suggest using some of the update scripts 
> in the tar-balls.
> You should be up and running that way in half a day..
> 
> BTW, this is also a good way to transfer complete set of accounts from 
> say customer to bookkeeper.
> If customer uses SQL-Ledger and bookkeeper is at least able to do the 
> same that is.
> Add any needed year end corrections, like salary journal entries and 
> some amortisation.
> Do yearend report and return to customer.
> 
> 
> 
> -------------------------------------------------------------------------
> 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
> 
> 

-- 
Adrian Blake
Molonglo Radio Observatory
University of Sydney
1152 Hoskinstown Rd
Bungendore 2621
ph. 02 80042212  mobile 0407 232 978

http://150.101.125.30

Re: [SL] Add a new currency

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

No - I'm sure this is a feature. It was mentioned on here a while back.

When no exchange rate is existing for a day then a text-entry box is  
given so that the user can enter one. If you add a second foreign- 
currency transaction with the same date then the rate is no longer  
shown in a text-entry box, but as a fixed part of the HTML (like the  
xxx in "Credit Limit: xxx" on the Sales Invoice Page). I believe this  
is because it is anticipated that the exchange rate should not  
fluctuate during a day's transactions.

Stroller.



On 28 Nov 2006, at 15:39, Graeme Bruton wrote:
>
> Hmmmm. Got me there. It may be cached in the browser. Close SL, re- 
> open it
> and try again, maybe clearing cache as well.
>
>> This thread came right in time because I just had to make my first
>> "other currency" purchasing order and it worked. The only thing is  
>> I put
>> in the exchange rate wrong ( 1/x). So no worries I thought just  
>> delete
>> the just made purchasing order and make a new one.
>>
>> But that doesn't work. Somehow it keeps coming back with the same
>> exhange rate which I can not alter. Looking through the archives I  
>> saw
>> somebody wanting to have diffrent exchage rate in one day ( wich  
>> did not
>> work either).

Re: [SL] Upgrade problem

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

Adrian Blake schreef:
> Progress:
>
> the error is now:
>
> DBD::Pg::st execute failed: ERROR: column t.validto does not exist
> .
> .
> .
>
> ERROR: column t.validto does not exist
>
> I should add, I had a hard disk crash but I could do a pg_dumpall & SQL-Ledger is the only database. I have had to upgrade from 
> postgres 7.? to 8.1.?
>
> Adrian
>
> Dieter Simader wrote:
>   
>> edit the backup you made with SQL-Ledger,
>> change the tables orderitems, inventory and assembly and add 'WITH OIDS'
>> (see the FAQ)
>> restore the backup with psql
>>
>> psql -U sql-ledger dbname < backup.sql
>>
>>     
>
>   
Had the same here some time ago, the SQL-Ledger internal backup (you did 
make one I hope) was my rescue.
Clean install of System on a new computer, including latest of 
everything, then unzip the sql-ledger backed up file.
Look at version, install latest SQL-Ledger and carefully read any 
remarks about uodating from older versions.
Sounds like you not only uograded PostgreSQL from 7 to 8 to me.
Rather then hacking in files I suggest using some of the update scripts 
in the tar-balls.
You should be up and running that way in half a day..

BTW, this is also a good way to transfer complete set of accounts from 
say customer to bookkeeper.
If customer uses SQL-Ledger and bookkeeper is at least able to do the 
same that is.
Add any needed year end corrections, like salary journal entries and 
some amortisation.
Do yearend report and return to customer.

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

[David J <ja...@in...>]

Daniel
Its clearly set out on page 22 of the SQL-L Manual.


> Hello,
> 
> It seems that I have been misunderstood in my previous
> email (let aside the  debate about languages).
> 
> Here is my problem with SQL-ledger:
> - I use it in Swedish with what's called the 'BAS-plan',
> basically the account  numbers. I suppose every country
> has its own system with its own account  numbers and their
> significance. I suppose this is what is called COA in 
> english. - I bought several computers and I need to get
> the purchases registered in the  1250 account (Computers).
> 
> The problem is that this account is not available to me
> when I use  the 'purchase' option (sorry, using the
> program in Swedish I am not used to  the english
> terminology). I can buy things as 'varor' ("wares",
> "material")  which has the account number 4010, plus other
> accounts but not the 1250.
> 
> In this forum, it has been recommended to me to add the
> 1250 account number to  the COA, but it already exists.
> The problem is not in the non existence of  the account,
> the problem lies in the fact that I do not have access to
> this  account number when I buy something.
> 
> Can someone help me?
> 
> Thanks in advance
> 
>         Daniel
>

Re: [SL] Add a new currency

[Graeme B. <gb...@te...>]

Hmmmm. Got me there. It may be cached in the browser. Close SL, re-open it
and try again, maybe clearing cache as well.
Graeme

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...]On Behalf Of Luc
van Stappershoef
Sent: Tuesday, November 28, 2006 1:01 PM
To: sql...@li...
Subject: Re: [SL] Add a new currency


This thread came right in time because I just had to make my first
"other currency" purchasing order and it worked. The only thing is I put
in the exchange rate wrong ( 1/x). So no worries I thought just delete
the just made purchasing order and make a new one.

But that doesn't work. Somehow it keeps coming back with the same
exhange rate which I can not alter. Looking through the archives I saw
somebody wanting to have diffrent exchage rate in one day ( wich did not
work either).

Is the solution to wait one day and can I have a new exchange rate
tomorrow ? Or is their another way I should handle this problem?

Thanks in advance for your quick reply

Luc

Neil Johnson wrote:
> Many thanks.
>
> Neil
>
>
>
> Graeme Bruton wrote:
>
>> There is a place on the invoice screen to manually change the currency
and
>> exchange rate. I use it if I purchase software in USD, and sell it in the
>> local currency. If you put your currency first in the list under the
>> "System" settings, it is the default. When you change the invoice screen
to
>> a different currency, the exchange rate field becomes available.
>>
>>
>>
>> -----Original Message-----
>> From: sql...@li...
>> [mailto:sql...@li...]On Behalf Of Neil
>> Johnson
>> Sent: Tuesday, November 28, 2006 1:50 AM
>> To: sql...@li...
>> Subject: Re: [SL] Add a new currency
>>
>>
>> and the exchange rate.......?
>>
>>
>> Graeme Bruton wrote:
>>
>>
>>> Hi Srimal
>>>
>>> Quite simple - go to "System" on the left menu, add your currency in the
>>> right hand frame, separated by a colon.
>>>
>>> Graeme
>>>
>>> -----Original Message-----
>>> From: sql...@li...
>>> [mailto:sql...@li...]On Behalf Of
>>> Srimal Jayawardena
>>> Sent: Monday, November 27, 2006 7:54 PM
>>> To: sql...@li...
>>> Subject: [SL] Add a new currency
>>>
>>>
>>> Hi
>>>
>>> Im rather new to sql-ledger..but am impressed by its versatality.
>>>
>>> Could anyone tell me how to add a new currency ?
>>>
>>> Thanks in advance
>>>
>>> Srimal.
>>> ------------------------------------------------------------------------
-
>>> 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
>>>
>>>
>>>
>>>
>> -------------------------------------------------------------------------
>> 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
>>
>>
>>
>
> -------------------------------------------------------------------------
> 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

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

[Mark L. <mar...@in...>]

Hello, Daniel,

You need to change a flag on the 1250 (Computers) account to tell SL  
to allow that account to be used for payments.  Or, you could use  
some other account and then use a GL transaction to transfer the  
money to the 1250 account.

If you want to change the flag, go to the Systems menu, select "Chart  
of Accounts" and list all the accounts.  Click on the "1250".  SL  
should bring up the detail for account 1250.  Be sure the checkbox  
next to Payments under the Payables column is checked.  Now hit  
"Save".  Account 1250 will now appear every time you go to pay for  
something.

HTH!
Mark

On Nov 29, 2006, at 3:23 PM, Daniel Tourde wrote:

> Hello,
>
> It seems that I have been misunderstood in my previous email (let  
> aside the
> debate about languages).
>
> Here is my problem with SQL-ledger:
> - I use it in Swedish with what's called the 'BAS-plan', basically  
> the account
> numbers. I suppose every country has its own system with its own  
> account
> numbers and their significance. I suppose this is what is called  
> COA in
> english.
> - I bought several computers and I need to get the purchases  
> registered in the
> 1250 account (Computers).
>
> The problem is that this account is not available to me when I use
> the 'purchase' option (sorry, using the program in Swedish I am not  
> used to
> the english terminology). I can buy things as 'varor' ("wares",  
> "material")
> which has the account number 4010, plus other accounts but not the  
> 1250.
>
> In this forum, it has been recommended to me to add the 1250  
> account number to
> the COA, but it already exists. The problem is not in the non  
> existence of
> the account, the problem lies in the fact that I do not have access  
> to this
> account number when I buy something.
>
> Can someone help me?
>
> Thanks in advance
>
> 		Daniel
>
> ---------------------------------------------------------------------- 
> ---
> 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] Swedish SQL-ledger 2.6.20, To buy a computer: no access to the right account number.

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

Hello,

It seems that I have been misunderstood in my previous email (let aside the 
debate about languages).

Here is my problem with SQL-ledger:
- I use it in Swedish with what's called the 'BAS-plan', basically the account 
numbers. I suppose every country has its own system with its own account 
numbers and their significance. I suppose this is what is called COA in 
english.
- I bought several computers and I need to get the purchases registered in the 
1250 account (Computers).

The problem is that this account is not available to me when I use 
the 'purchase' option (sorry, using the program in Swedish I am not used to 
the english terminology). I can buy things as 'varor' ("wares", "material") 
which has the account number 4010, plus other accounts but not the 1250.

In this forum, it has been recommended to me to add the 1250 account number to 
the COA, but it already exists. The problem is not in the non existence of 
the account, the problem lies in the fact that I do not have access to this 
account number when I buy something.

Can someone help me?

Thanks in advance

		Daniel

Re: [SL] Refund Checks

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

Tony

as you write at the end, the question is not not to pay the net tax, but
some jurisdictions require that you pay first, claim second and
reconcile the net tax last.

How would you address this?

el

on 11/29/06 3:18 AM Tony Fraser said the following:
> On Sun, 2006-11-26 at 23:59 +0200, Dr Eberhard Lisse wrote:
>> 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.
> 
> I never said I didn't pay the taxes due...
> 
> Say I do some work. Invoice to customer:
>   Labour   $100
>      Tax   $ 20
>    Total   $120
> 
> And I buy some goods: Invoice from Vendor:
>   Parts $ 80
>     Tax $ 16
>   Total $ 96
> 
> The Customer and Vendor happen to be the same legal entity so at the end
> of the month I "pay" the Vendor invoice by debiting the holding account.
> I then issue the customer a "Credit Note" (Negative AR Transation
> crediting the holding account) for $96 and apply it as a payment on the
> invoice they owe to me. Then the Customer issues me a Cheque for $24
> which I use to pay the remaining balance of the invoice.
> 
> When I report to the tax man I report $20 collected and $16 paid and
> send a cheque for $4. AFAIK all perfectly legal under our tax laws...
> Yours may be different.
> 

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

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

On Sun, 2006-11-26 at 23:59 +0200, Dr Eberhard Lisse wrote:
> 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.

I never said I didn't pay the taxes due...

Say I do some work. Invoice to customer:
  Labour   $100
     Tax   $ 20
   Total   $120

And I buy some goods: Invoice from Vendor:
  Parts $ 80
    Tax $ 16
  Total $ 96

The Customer and Vendor happen to be the same legal entity so at the end
of the month I "pay" the Vendor invoice by debiting the holding account.
I then issue the customer a "Credit Note" (Negative AR Transation
crediting the holding account) for $96 and apply it as a payment on the
invoice they owe to me. Then the Customer issues me a Cheque for $24
which I use to pay the remaining balance of the invoice.

When I report to the tax man I report $20 collected and $16 paid and
send a cheque for $4. AFAIK all perfectly legal under our tax laws...
Yours may be different.

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

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

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

On Monday 27 November 2006 6:32 pm, Ashley J Gittins wrote:
> On Tuesday 28 November 2006 01:38, R Pennington wrote:
> > On Friday 24 November 2006 9:34 am, Nefnifi, Kasem wrote:
> > > i think an invoice with 100% discount is the solution for that. also if u
> > > use something internally for yoursel. regards
> > > kasem,
> >
> > Thank you for your advice Kasem !
> > I'll have to to re-read the manual section about discounts
> 
> Hi Roy, I suspect you were on the right path with the invoice then pay from 
> donations account. If you discount the item 100% then you will not be able to 
> pay the invoice from the donations account and you will lose the ability to 
> show your charitable donations in your balance sheet / income statement etc.
> 
> Your accountant might be the best one to start answering the question - find 
> out what the end result needs to be (eg: a GL account showing donations to 
> charity as an expense account), and then find a way to do that in SL while 
> keeping stock etc correct. I suspect your first idea was probably the best 
> approach but others might have better ideas.
> 

Thanks Ashley !

You are correct, after looking at Kasem's idea, I think my original one is the simplest way
to handle COGS, inventory and the donations expense and it works without having to do GL entries.

We have a charity donations account already but have never donated product.
Got a call in to the accountant.

IIt would be nice to have the ability to restrict the payment accounts available based on login ID.
Time to send feature request.

Best Regards,
Roy