sql-ledger-users — SQL-Ledger users

[SL] searching for customers

[Andrew M. <atm...@km...>]

I have a business looking to move to SL, everything is looking good, and
sorry I know this must have been asked once before...  However...
=20
In just about every accounting app in the customer feild once you start
typing the customer name it creates a short list of the client...  Can
SL be setup to do this?
=20
e.g.   A client comes in to purchace bottled water, clerk asks clients
name, client replies Johnston, clerk types in Joh and notices on the
short list that two names are female, and client is male, so client must
be Berry or Dave, clerk asks for the first name, and all is well.
Interesting enough in other apps it would also list all users with first
name John.
=20
=20

Re: [SL] installation issues

[Arthur D. <ar...@av...>]

I've just install Edgy so I'll give it another try.

On Sunday 18 March 2007 12:27, Hall Family wrote:
> arthur, why use dapper?  I can tell you with edgy it works.
> you might have to follow the manual config instructions for http if your
> using dapper.
> troy
>
> Arthur Dyck wrote:
> > I have installed sql-ledger using Adept on Kubuntu Dapper.  Going to
> > http://localhost/sql-ledger/admin.pl I have been able to create a user.
> > However, when I go to the SQL-Ledger/Database Administration page and
> > attempt to do anything I get the following error: FATAL: role
> > "sql-ledger" does not exist.  sql-ledger comes up automatically as the
> > user.  Can anyone tell me what I am doing wrong?  Thanks for the help.
> >
> > Arthur
> >
> > -------------------------------------------------------------------------
> > 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

[SL] newbie question regarding laptop POS

[Kirti <ki...@UN...>]

<There is a solution upcoming here in the Netherlands where there will be 
<a syncronisation script between joomla/virtuemart and sql-ledger as well 
<as sugar-crm.
<In a bout a month time they will show me a demo.
<I am not sure if this company will keep this code opensource. However 
<they said they intended to.

<If things look promising I will reply again

<Luc

This would be very welcome. For some time I have been searching for a Postgresql backend for Virtuemart instead of the MySQL one that comes with the package. Any solutions anyone?
At least it would be easier to synchronize VMart and SL that way.

The advantage with Joomla/VMart is that it has a very Customer Friendly Web Frontend with Product and Price display etc. I find the Product Group and Subgroup and CSV-upload features very handy . However this app lacks the transaction solidity that SL provides.

However if SL could incorporate features similar to Joomla, this might be best - that way DB integrity would be assured.

Ken

Re: [SL] Multiple Location Customers

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

Thanks
-i found a semi-solution, which is to simply change the heading on my invoice 
templates to reverse the bill to and ship to address.. This way, I can make a 
new location and put the billing info in the shipping field on the "Add 
Customer" page.. Since I'm the only one using it, it works for me... ANd when 
I look through the customer list, it shows them the way I need it..

Hopefully, someone has a proper fix for this..

Thanks again,
-myk
On Monday 19 March 2007 08:46:01 pm Michael Hasse wrote:
> Unfortunately SL only supports a single "Ship To" so you're
> functionally limited to two locations per customer.  It wouldn't
> surprise me if someone has written a patch to remedy that though -
> anyone?
>
> On Mar 19, 2007, at 5:35 PM, Myk Robinson wrote:
> > This may be a simple one, but want to make sure it is done
> > correctly. I have a
> > customer with multiple locations, but a single billing address..
> > What is the
> > proper way to enter these? I ask because I tried a few ways, and I
> > ended up
> > having the same customer listed multiple times in my "customer"
> > list, because
> > the customer list only shows the billing information..
> >
> > help?
> >
> > thanks,
> > -myk
> >
> > ----------------------------------------------------------------------
> > ---
> > 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] Multiple Location Customers

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

Unfortunately SL only supports a single "Ship To" so you're  
functionally limited to two locations per customer.  It wouldn't  
surprise me if someone has written a patch to remedy that though -  
anyone?



On Mar 19, 2007, at 5:35 PM, Myk Robinson wrote:

> This may be a simple one, but want to make sure it is done  
> correctly. I have a
> customer with multiple locations, but a single billing address..  
> What is the
> proper way to enter these? I ask because I tried a few ways, and I  
> ended up
> having the same customer listed multiple times in my "customer"  
> list, because
> the customer list only shows the billing information..
>
> help?
>
> thanks,
> -myk
>
> ---------------------------------------------------------------------- 
> ---
> 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] Multiple Location Customers

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

This may be a simple one, but want to make sure it is done correctly. I have a 
customer with multiple locations, but a single billing address.. What is the 
proper way to enter these? I ask because I tried a few ways, and I ended up 
having the same customer listed multiple times in my "customer" list, because 
the customer list only shows the billing information..

help?

thanks,
-myk

Re: [SL] Early Payment Discount....

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

On Friday 16 March 2007 10:16, ma...@hu... wrote:
> > On Thu, 2007-03-15 at 16:05 -0500, arc...@mt... wrote:
> >> I have a supplier who gave me an early payment discount of 1%
> >> The discount is on the items, not the freight charges or GST.
> >>
> >> Any idea on how best to handle this with SL 2.6.23 ?
> >
> > My solution...your mileage may vary.
> >
> > I've created a G/L account (mine is under COGS) called Discounts Earned.
> > After you key the vendor invoice for the full amount, key an AP
> > Transaction selecting the Discounts Earned account using a negative
> > dollar amount.  Yes, you'll have two items on your check run referring
> > to the same invoice number, but it works well for me.
>
> I had the reverse issue (tracking pre-pay disounts for customers) and
> solved it this way:
>
> (1) create COA income account (in 4000 range) for discounts
> (2) define a part CREDIT as service and give it that income account
> (3) use that part # on invoice line item, but with negative amount.
>
> A nice side effect is that when you run an income statement, the discounts
> show up in parentheses in the income statement, which (for my case) was a
> more accurate statement.
>
> You could just as easily have it show up as an expense.  Just use a 5000
> serices account in step (1) above and mark the expense account as an
> inventory tracking item.
>
> m
>
Thanks for the input !

I've been doing it the same way that David suggests. Good to know I'm on the 
right page.

Cheers !
Roy Pennington

Re: [SL] installation issues

[Hall F. <hei...@io...>]

arthur, why use dapper?  I can tell you with edgy it works.
you might have to follow the manual config instructions for http if your 
using dapper.
troy

Arthur Dyck wrote:
> I have installed sql-ledger using Adept on Kubuntu Dapper.  Going to 
> http://localhost/sql-ledger/admin.pl I have been able to create a user.  
> However, when I go to the SQL-Ledger/Database Administration page and attempt 
> to do anything I get the following error: FATAL: role "sql-ledger" does not 
> exist.  sql-ledger comes up automatically as the user.  Can anyone tell me 
> what I am doing wrong?  Thanks for the help.
>
> Arthur
>
> -------------------------------------------------------------------------
> 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] installation issues

[Arthur D. <ar...@av...>]

I have installed sql-ledger using Adept on Kubuntu Dapper.  Going to 
http://localhost/sql-ledger/admin.pl I have been able to create a user.  
However, when I go to the SQL-Ledger/Database Administration page and attempt 
to do anything I get the following error: FATAL: role "sql-ledger" does not 
exist.  sql-ledger comes up automatically as the user.  Can anyone tell me 
what I am doing wrong?  Thanks for the help.

Arthur

[SL] gnc20.perl Recipe

[<rlo...@fo...>]

All,

I kept at it and finally got some of what I wanted from gnc20.perl. I've 
pasted below a recipe for what I did; perhaps it can save some time and 
frustration for others.

In gnucash select File, then Export, then Export Accounts.Name the file
gnucash.xml and select a folder to save it in. I saved it in /tmp, where I
had already placed gnc20.perl. This will simplify things. Click on the 
Export button.

Go to where you've saved the export and gnc20.perl. I made gnc20.perl 
executable (chmod 755...) but perl is an interpreted language so I don't think
this is necessary. Then do:

perl ./gnc20.perl

and the output should stream by on the screen. Next, repeat the command but
redirect that output to a new COA:

perl ./gnc20.perl > foobar-chart.sql

This should work fine. If it doesn't check permissions and ownerships; but 
if you're using a UNIX or variant you should already know all about that 
stuff, it's usually the first thing to bite a newbie user. Move 
foobar-chart.sql to your sql-ledger directory and place it in the sql
directory. Adjust the permissions and ownership to match the other 
*-chart.sql files in there.

Log in to sql-ledger as admin and create a new dataset using 
foobar-chart.sql (it should appear in the list) and edit your usual user 
to use that dataset. foobar-chart.sql is just a list of sql insert 
statements that will be used by the database to create the various tables 
in the new dataset. That's it, alas. I was hoping it would magically 
import the actual data as well but it doesn't look like that is the case. 
You'll likely have lots of account re-numbering to do too if you didn't 
give your gnucash accounts numbers; like I didn't. The script looks for 
gnucash.xml for its input file but you can edit that easily to look for 
any file, it's right up by the top of gnc20.perl. Look for "gnucash.xml". 
I'm not going to clean up my COA until I can import all my data. That way 
everything will be the same numbering scheme (if gnc20.perl and any future 
data import script think alike.) Until then I'll stick with gnucash and 
see what happens. In the meantime, sql-ledger looks pretty nice and I can 
always psql right into the tables themselves, something I understand much 
better than XML, or perl.

HTH somebody.

r

Re: [SL] Early Payment Discount....

[<ma...@hu...>]

> On Thu, 2007-03-15 at 16:05 -0500, arc...@mt... wrote:
>> I have a supplier who gave me an early payment discount of 1%
>> The discount is on the items, not the freight charges or GST.
>>
>> Any idea on how best to handle this with SL 2.6.23 ?
>
> My solution...your mileage may vary.
>
> I've created a G/L account (mine is under COGS) called Discounts Earned.
> After you key the vendor invoice for the full amount, key an AP
> Transaction selecting the Discounts Earned account using a negative
> dollar amount.  Yes, you'll have two items on your check run referring
> to the same invoice number, but it works well for me.

I had the reverse issue (tracking pre-pay disounts for customers) and
solved it this way:

(1) create COA income account (in 4000 range) for discounts
(2) define a part CREDIT as service and give it that income account
(3) use that part # on invoice line item, but with negative amount.

A nice side effect is that when you run an income statement, the discounts
show up in parentheses in the income statement, which (for my case) was a
more accurate statement.

You could just as easily have it show up as an expense.  Just use a 5000
serices account in step (1) above and mark the expense account as an
inventory tracking item.

m

Re: [SL] newbie question regarding laptop POS

[Hall F. <hei...@io...>]

oh that would be soooo nice.  There is a guy who wrote an inventory 
program that unfortunately is on his site only, but it allows us to do 
all kinds of inventory stuff ( peninventory.com) and he's going to be 
working on a vm integration module for it.
So with that and sql-ledger and this syncro we'd be in great shape here 
as long as the stuff from the netherlands knows how to handle US style 
taxation properly.
Troy


Luc van Stappershoef wrote:
> There is a solution upcoming here in the Netherlands where there will be 
> a syncronisation script between joomla/virtuemart and sql-ledger as well 
> as sugar-crm.
> In a bout a month time they will show me a demo.
> I am not sure if this company will keep this code opensource. However 
> they said they intended to.
>
> If things look promising I will reply again
>
> Luc
>
>
>
> Matt Jackson wrote:
>   
>
> -------------------------------------------------------------------------
> 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] newbie question regarding laptop POS

[Hall F. <hei...@io...>]

Thanks Mat.  I know an excellent perl programmer and a sql programmer so 
perhaps your right.
Thanks for the encouragement.
Troy

Matt Jackson wrote:
> PARTIALLY OFF TOPIC
>
> Hey man!
>
> No comfort here, except to say that you have asked what I've been putting
> off wondering, since I run Joomla! with VirtueMart as well for my site-based
> sales.
>
> I have actually been looking around for alternatives, because I am tired of
> fooling with odd SEO, flaky checkout and such on VirtueMart, wondering if
> there is a simpler, clearer alternative out there.
>
> For example, I have been very interested in Volusion, especially if it can
> offer me just turnkey, guaranteed rock-solid checkout (that doesn't fail or
> give errors at random times to my customers) and guaranteed best-in-class
> SEO and marketing help. Sucks that it isn't FREE FREE FREE, but hey, I am
> learning you can't trip over a dollar to save a dime.
>
> I am tired of fooling around...I have lost so many sales due to flaky, too
> long, error-prone checkout. SEO has actually not been too too terrible, but
> it is still inconsistent and gives me the "grass is greener on the other
> side of the fence" feeling that there is something that is a better VALUE
> out there, see?
>
> Anyhow, back on track, I would be very interested in what you are interested
> in. Even a pan-solution solution, a generic import that could be reworked
> from csv exports and such, would be sweet. I tried the generic SQL-Ledger
> import thing and it didn't work for me. Kept failing out.
>
> I wonder if we could pool some monetary resources and get this added to the
> project on a faster-track basis.
>
> Anyhow, just putting my vote in and saying HI to a fellow Joomla/VirtueMart
> user!
>
> Best,
> Matt
>
>
>
>
> On 3/15/07, Hall Family <hei...@io...> wrote:
>   
>> Hello, this has probably come up before but I can't find the answer I'm
>> looking for.
>> I have a mixed OS environment consisting of the following computers
>> (Linux server - Kubuntu server edition  - household lan )
>> Mac G3 - 10.3.9
>> Windows XP Home
>> Compaq Presario 1685 Laptop ( non-wireless but does have ethernet ) this
>> will be the GPS and POS machine
>> and finally another linux server that my websites are hosted on in
>> another city where I do NOT have root access nor postgresql capability.
>>
>> My thoughts are this.
>> I would like to be able to have a central place where my accounting
>> takes place that is accessible from any of the other machines.
>> I'm thinking the laptop would be a good candidate for this as it will
>> need to be used when we go to craft shows and such to sell our
>> products.  I doubt we will have wireless capability because most are in
>> farm country.
>> I need it to store the credit card processing information and sale
>> history, print a receipt/invoice for the customer.
>> I use joomla as my CMS and Virtuemart as my ecommerce software.
>> My ideal scenario is that sql-ledger would be able to import via csv or
>> some other method my days activities ( virtuemart uses mysql ) and
>> updates its accounting accordingly.  Lacking that we don't do so much
>> business via the net that we couldn't enter them by hand for now.
>> but when we come home from shows, we need to be able to synchronize the
>> data thats on the laptop with the server. ( if its not the main machine
>> already ).  Similarly when we are in the office at home I want to be
>> able to access the sql-ledger program from any of the desktop machines
>> or laptop be it xp or mac or even the linux clients.
>>
>> I don't know the best way to install/build sql-ledger to fit my needs,
>> or if it really will.  I'm not very good at accounting and really am
>> tired of looking.  I would really appreciate any and all help.
>> Thanks
>> Troy
>>
>>
>>
>> -------------------------------------------------------------------------
>> 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] newbie question regarding laptop POS

[Hall F. <hei...@io...>]

Thanks for responding David,

> First: All you have to worry about is your server.. .any machine can act
> as client. I have a similar mixed bag.
>
> If your server doesn't need to be online 24/7, the lapdog will do fine. 
>
> As far as importing data, you need info from someone else.. I've never
> needed to do it ;-)  It seems to me that the laptop being POS and server
> makes things relatively easy. Then when you plug your laptop into your
> lan you have access to everything you need.
>
> I'm assuming that your joomla/ecommerce is off line when you are at
> shows anyway, and that it's all installed on the laptop?? Or did i miss
> something?
>
>   

No, thats incorrect.  My websites are all run offsite in Cedar Falls at 
a Major Data Center.  The laptops only original purporse was GPS 
navigation and email while traveling.
It has since come up that it would be great to use it also as a POS 
system while at the shows.  Thats why I was thinking of having some part 
of SQL-Ledger on the laptop.  I can see your point about having it be 
the server completely.
Do you know if "Damn Small Linux" will handle sql-ledger?  I ask because 
the drive space on the laptop is very limited.
Its a lowly ADM-K6 381mhz system with 192mb of ram. and a 4G HD.  It 
Does have a dvd drive so I could I believe run a "live" variant of linux 
and store the data ONLY on the hd.  Another alternative I suppose would 
be to purchase a USB drive for it but I think that would be fairly 
expensive.
I don't know what the bare minimum I would need to make it function as a 
nix server and still retain at least windows 98 on it for the GPS.

Thanks
Troy
>   

[SL] gnucash import script - gnc20.perl

[<rlo...@fo...>]

All,

I've been struggling trying to get this script to work. It looks like 
serious perl coding but it's utterly opaque. The file it looks for appears 
to have to be called "gnucash.xml", but what file is that? My gnucash 
file? My gnucash foobar.xac file? An export of my gnucash file? And what 
and whare is the output? Only once have I been able to get this to work 
and all it seemed to do is create a COA using my gnucash account names, 
but no actual data was loaded. Does this script not do this? I have been 
unable to repeat even that meager result by renaming any of those 
versions of my data to "gnucash.xml". I am currently using GN-2.0.5 on 
FreeBSD-6.2 and postgreSQL-8.2.3.

I have found a lot of posts from people looking to get their data into 
sql-ledger from gnucash; I have ten years worth myself, but I don't intend 
to walk away from it and start over. gnc20.perl is my ticket, but I'm a 
user, not a perl monger. It needs to "just work", and with some indication 
that is has done so. Or some indication that it hasn't. Or some indication 
of what it's looking for.

An empty install of sql-ledger works fine, so I know I have the db and 
apache stuff screwed down. I just need to get the data in there. Is there 
a recipe for that? Anywhere?

frustrated regards,

r

Re: [SL] Early Payment Discount....

[David B. <dav...@sb...>]

On Thu, 2007-03-15 at 16:05 -0500, arc...@mt... wrote:
> I have a supplier who gave me an early payment discount of 1%
> The discount is on the items, not the freight charges or GST.
> 
> Any idea on how best to handle this with SL 2.6.23 ?

My solution...your mileage may vary.

I've created a G/L account (mine is under COGS) called Discounts Earned.
After you key the vendor invoice for the full amount, key an AP
Transaction selecting the Discounts Earned account using a negative
dollar amount.  Yes, you'll have two items on your check run referring
to the same invoice number, but it works well for me.

HTH,
David Boyle
NAPCO


> Cheers !
> Roy Pennington
> 
> -------------------------------------------------------------------------
> 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] newbie question regarding laptop POS

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

There is a solution upcoming here in the Netherlands where there will be 
a syncronisation script between joomla/virtuemart and sql-ledger as well 
as sugar-crm.
In a bout a month time they will show me a demo.
I am not sure if this company will keep this code opensource. However 
they said they intended to.

If things look promising I will reply again

Luc



Matt Jackson wrote:
> PARTIALLY OFF TOPIC
>
> Hey man!
>
> No comfort here, except to say that you have asked what I've been putting
> off wondering, since I run Joomla! with VirtueMart as well for my site-based
> sales.
>
> I have actually been looking around for alternatives, because I am tired of
> fooling with odd SEO, flaky checkout and such on VirtueMart, wondering if
> there is a simpler, clearer alternative out there.
>
> For example, I have been very interested in Volusion, especially if it can
> offer me just turnkey, guaranteed rock-solid checkout (that doesn't fail or
> give errors at random times to my customers) and guaranteed best-in-class
> SEO and marketing help. Sucks that it isn't FREE FREE FREE, but hey, I am
> learning you can't trip over a dollar to save a dime.
>
> I am tired of fooling around...I have lost so many sales due to flaky, too
> long, error-prone checkout. SEO has actually not been too too terrible, but
> it is still inconsistent and gives me the "grass is greener on the other
> side of the fence" feeling that there is something that is a better VALUE
> out there, see?
>
> Anyhow, back on track, I would be very interested in what you are interested
> in. Even a pan-solution solution, a generic import that could be reworked
> from csv exports and such, would be sweet. I tried the generic SQL-Ledger
> import thing and it didn't work for me. Kept failing out.
>
> I wonder if we could pool some monetary resources and get this added to the
> project on a faster-track basis.
>
> Anyhow, just putting my vote in and saying HI to a fellow Joomla/VirtueMart
> user!
>
> Best,
> Matt
>
>
>
>
> On 3/15/07, Hall Family <hei...@io...> wrote:
>   
>> Hello, this has probably come up before but I can't find the answer I'm
>> looking for.
>> I have a mixed OS environment consisting of the following computers
>> (Linux server - Kubuntu server edition  - household lan )
>> Mac G3 - 10.3.9
>> Windows XP Home
>> Compaq Presario 1685 Laptop ( non-wireless but does have ethernet ) this
>> will be the GPS and POS machine
>> and finally another linux server that my websites are hosted on in
>> another city where I do NOT have root access nor postgresql capability.
>>
>> My thoughts are this.
>> I would like to be able to have a central place where my accounting
>> takes place that is accessible from any of the other machines.
>> I'm thinking the laptop would be a good candidate for this as it will
>> need to be used when we go to craft shows and such to sell our
>> products.  I doubt we will have wireless capability because most are in
>> farm country.
>> I need it to store the credit card processing information and sale
>> history, print a receipt/invoice for the customer.
>> I use joomla as my CMS and Virtuemart as my ecommerce software.
>> My ideal scenario is that sql-ledger would be able to import via csv or
>> some other method my days activities ( virtuemart uses mysql ) and
>> updates its accounting accordingly.  Lacking that we don't do so much
>> business via the net that we couldn't enter them by hand for now.
>> but when we come home from shows, we need to be able to synchronize the
>> data thats on the laptop with the server. ( if its not the main machine
>> already ).  Similarly when we are in the office at home I want to be
>> able to access the sql-ledger program from any of the desktop machines
>> or laptop be it xp or mac or even the linux clients.
>>
>> I don't know the best way to install/build sql-ledger to fit my needs,
>> or if it really will.  I'm not very good at accounting and really am
>> tired of looking.  I would really appreciate any and all help.
>> Thanks
>> Troy
>>
>>
>>
>> -------------------------------------------------------------------------
>> 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] Early Payment Discount....

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

I have a supplier who gave me an early payment discount of 1%
The discount is on the items, not the freight charges or GST.

Any idea on how best to handle this with SL 2.6.23 ?

Cheers !
Roy Pennington

Re: [SL] newbie question regarding laptop POS

[Matt J. <sir...@gm...>]

PARTIALLY OFF TOPIC

Hey man!

No comfort here, except to say that you have asked what I've been putting
off wondering, since I run Joomla! with VirtueMart as well for my site-based
sales.

I have actually been looking around for alternatives, because I am tired of
fooling with odd SEO, flaky checkout and such on VirtueMart, wondering if
there is a simpler, clearer alternative out there.

For example, I have been very interested in Volusion, especially if it can
offer me just turnkey, guaranteed rock-solid checkout (that doesn't fail or
give errors at random times to my customers) and guaranteed best-in-class
SEO and marketing help. Sucks that it isn't FREE FREE FREE, but hey, I am
learning you can't trip over a dollar to save a dime.

I am tired of fooling around...I have lost so many sales due to flaky, too
long, error-prone checkout. SEO has actually not been too too terrible, but
it is still inconsistent and gives me the "grass is greener on the other
side of the fence" feeling that there is something that is a better VALUE
out there, see?

Anyhow, back on track, I would be very interested in what you are interested
in. Even a pan-solution solution, a generic import that could be reworked
from csv exports and such, would be sweet. I tried the generic SQL-Ledger
import thing and it didn't work for me. Kept failing out.

I wonder if we could pool some monetary resources and get this added to the
project on a faster-track basis.

Anyhow, just putting my vote in and saying HI to a fellow Joomla/VirtueMart
user!

Best,
Matt




On 3/15/07, Hall Family <hei...@io...> wrote:
>
> Hello, this has probably come up before but I can't find the answer I'm
> looking for.
> I have a mixed OS environment consisting of the following computers
> (Linux server - Kubuntu server edition  - household lan )
> Mac G3 - 10.3.9
> Windows XP Home
> Compaq Presario 1685 Laptop ( non-wireless but does have ethernet ) this
> will be the GPS and POS machine
> and finally another linux server that my websites are hosted on in
> another city where I do NOT have root access nor postgresql capability.
>
> My thoughts are this.
> I would like to be able to have a central place where my accounting
> takes place that is accessible from any of the other machines.
> I'm thinking the laptop would be a good candidate for this as it will
> need to be used when we go to craft shows and such to sell our
> products.  I doubt we will have wireless capability because most are in
> farm country.
> I need it to store the credit card processing information and sale
> history, print a receipt/invoice for the customer.
> I use joomla as my CMS and Virtuemart as my ecommerce software.
> My ideal scenario is that sql-ledger would be able to import via csv or
> some other method my days activities ( virtuemart uses mysql ) and
> updates its accounting accordingly.  Lacking that we don't do so much
> business via the net that we couldn't enter them by hand for now.
> but when we come home from shows, we need to be able to synchronize the
> data thats on the laptop with the server. ( if its not the main machine
> already ).  Similarly when we are in the office at home I want to be
> able to access the sql-ledger program from any of the desktop machines
> or laptop be it xp or mac or even the linux clients.
>
> I don't know the best way to install/build sql-ledger to fit my needs,
> or if it really will.  I'm not very good at accounting and really am
> tired of looking.  I would really appreciate any and all help.
> Thanks
> Troy
>
>
>
> -------------------------------------------------------------------------
> 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
>



-- 
Regards,
Matt

Re: [SL] newbie question regarding laptop POS

[david <da...@ke...>]

On Wed, 2007-03-14 at 23:47 -0500, Hall Family wrote:
> Hello, this has probably come up before but I can't find the answer I'm 
> looking for.
> I have a mixed OS environment consisting of the following computers
> (Linux server - Kubuntu server edition  - household lan )
> Mac G3 - 10.3.9
> Windows XP Home
> Compaq Presario 1685 Laptop ( non-wireless but does have ethernet ) this 
> will be the GPS and POS machine
> and finally another linux server that my websites are hosted on in 
> another city where I do NOT have root access nor postgresql capability.
> 

First: All you have to worry about is your server.. .any machine can act
as client. I have a similar mixed bag.

If your server doesn't need to be online 24/7, the lapdog will do fine. 

As far as importing data, you need info from someone else.. I've never
needed to do it ;-)  It seems to me that the laptop being POS and server
makes things relatively easy. Then when you plug your laptop into your
lan you have access to everything you need.

I'm assuming that your joomla/ecommerce is off line when you are at
shows anyway, and that it's all installed on the laptop?? Or did i miss
something?

> My thoughts are this.
> I would like to be able to have a central place where my accounting 
> takes place that is accessible from any of the other machines.
> I'm thinking the laptop would be a good candidate for this as it will 
> need to be used when we go to craft shows and such to sell our 
> products.  I doubt we will have wireless capability because most are in 
> farm country.
> I need it to store the credit card processing information and sale 
> history, print a receipt/invoice for the customer.
> I use joomla as my CMS and Virtuemart as my ecommerce software. 
> My ideal scenario is that sql-ledger would be able to import via csv or 
> some other method my days activities ( virtuemart uses mysql ) and 
> updates its accounting accordingly.  Lacking that we don't do so much 
> business via the net that we couldn't enter them by hand for now.
> but when we come home from shows, we need to be able to synchronize the 
> data thats on the laptop with the server. ( if its not the main machine 
> already ).  Similarly when we are in the office at home I want to be 
> able to access the sql-ledger program from any of the desktop machines 
> or laptop be it xp or mac or even the linux clients.
> 
> I don't know the best way to install/build sql-ledger to fit my needs, 
> or if it really will.  I'm not very good at accounting and really am 
> tired of looking.  I would really appreciate any and all help.
> Thanks
> Troy
> 
> 
> 
> -------------------------------------------------------------------------
> 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] newbie question regarding laptop POS

[Hall F. <hei...@io...>]

Hello, this has probably come up before but I can't find the answer I'm 
looking for.
I have a mixed OS environment consisting of the following computers
(Linux server - Kubuntu server edition  - household lan )
Mac G3 - 10.3.9
Windows XP Home
Compaq Presario 1685 Laptop ( non-wireless but does have ethernet ) this 
will be the GPS and POS machine
and finally another linux server that my websites are hosted on in 
another city where I do NOT have root access nor postgresql capability.

My thoughts are this.
I would like to be able to have a central place where my accounting 
takes place that is accessible from any of the other machines.
I'm thinking the laptop would be a good candidate for this as it will 
need to be used when we go to craft shows and such to sell our 
products.  I doubt we will have wireless capability because most are in 
farm country.
I need it to store the credit card processing information and sale 
history, print a receipt/invoice for the customer.
I use joomla as my CMS and Virtuemart as my ecommerce software. 
My ideal scenario is that sql-ledger would be able to import via csv or 
some other method my days activities ( virtuemart uses mysql ) and 
updates its accounting accordingly.  Lacking that we don't do so much 
business via the net that we couldn't enter them by hand for now.
but when we come home from shows, we need to be able to synchronize the 
data thats on the laptop with the server. ( if its not the main machine 
already ).  Similarly when we are in the office at home I want to be 
able to access the sql-ledger program from any of the desktop machines 
or laptop be it xp or mac or even the linux clients.

I don't know the best way to install/build sql-ledger to fit my needs, 
or if it really will.  I'm not very good at accounting and really am 
tired of looking.  I would really appreciate any and all help.
Thanks
Troy

[SL] DBD-Pg For Windows

[Chandler W. R. <Cha...@Ca...>]

Can't get DBD to install under windows.  Is there a compiled DBD that would
b simple to run? Chandler

Re: [SL] Can't open perl script / File name too long -> Premature end of script headers

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

On Wednesday 14 March 2007 8:36 am, Antony Gelberg wrote:
> I don't want to bombard the list, but really, has nobody seen this?  My
> setup is pretty vanilla.
> 
> Antony Gelberg wrote:

Hi Antony
I'd check the list archives.
If i remember correctly, this similar errors have occurred for other people.
I think it was usually due to some webserver configuration issue.

but.....You say this error is happening intermittently...

Have you checked to see if this error can be reproduced when doing specific tasks ?

Looking at the URL...

If you do a url decode of:
ct.pl%3faction%3dlist_names%26direction%3dDESC%26oldsort%3dname%26db%3dvendor%26path%3dbin%2fmozilla%26login%3droma%26sessionid%3d1173017171%26status%3dall%26l_subtotal%3d%26l_name%3dY%26l_contact%3dY%26l_phone%3dY%26l_email%3dY%26l_amount%3dY%26l_tax%3dY%26l_total%3dY%26name%3dJean-Philippe%2520Blangy%26sort%3dname

you get:
ct.pl?action=list_names&direction=DESC&oldsort=name&db=vendor&path=bin/mozilla&login=roma&sessionid=1173017171&status=all&l_subtotal=&l_name=Y&l_contact=Y&l_phone=Y&l_email=Y&l_amount=Y&l_tax=Y&l_total=Y&name=Jean-Philippe%20Blangy&sort=name

Maybe the name "Jean-Philippe%20Blangy" is a problem ?
Try re-entering/editing the name and see what happens.

Could it be an encoding problem ?
What are the database, webserver and web browser language encoding settings ?

Cheers,
Roy

> > Hi,
> > 
> > I have seen the following intermittently over the past few years with
> > SL, and finally, it's annoying me enough to ask the list.
> > 
> > The web browser asks me if I want to save or open the .pl file as if I
> > had initiated a download.  The errors below appear in the apache error log.
> > 
> > I'd appreciate any assistance to debug this - can't believe I'm the only
> > one.  SL 2.6.3, Apache 2.2.3, Perl 5.8.8.
> > 
> > [Sun Mar 04 14:32:04 2007] [error] [client 82.68.107.174] Can't open
> > perl script
> > "ct.pl%3faction%3dlist_names%26direction%3dDESC%26oldsort%3dname%26db%3dvendor%26path%3dbin%2fmozilla%26login%3droma%26sessionid%3d1173017171%26status%3dall%26l_subtotal%3d%26l_name%3dY%26l_contact%3dY%26l_phone%3dY%26l_email%3dY%26l_amount%3dY%26l_tax%3dY%26l_total%3dY%26name%3dJean-Philippe%2520Blangy%26sort%3dname":
> > File name too long, referer:
> > https://xxx.wayforth.co.uk/sql-ledger/ct.pl?action=edit&id=11379&db=vendor&path=bin/mozilla&login=roma&sessionid=1173017171&status=all&callback=ct.pl%253faction%253dlist_names%2526direction%253dDESC%2526oldsort%253dname%2526db%253dvendor%2526path%253dbin%252fmozilla%2526login%253droma%2526sessionid%253d1173017171%2526status%253dall%2526l_subtotal%253d%2526l_name%253dY%2526l_contact%253dY%2526l_phone%253dY%2526l_email%253dY%2526l_amount%253dY%2526l_tax%253dY%2526l_total%253dY%2526name%253dJean-Philippe%252520Blangy%2526sort%253dname
> > [Sun Mar 04 14:32:04 2007] [error] [client 82.68.107.174] Premature end
> > of script headers: ct.pl, referer:
> > https://xxx.wayforth.co.uk/sql-ledger/ct.pl?action=edit&id=11379&db=vendor&path=bin/mozilla&login=roma&sessionid=1173017171&status=all&callback=ct.pl%253faction%253dlist_names%2526direction%253dDESC%2526oldsort%253dname%2526db%253dvendor%2526path%253dbin%252fmozilla%2526login%253droma%2526sessionid%253d1173017171%2526status%253dall%2526l_subtotal%253d%2526l_name%253dY%2526l_contact%253dY%2526l_phone%253dY%2526l_email%253dY%2526l_amount%253dY%2526l_tax%253dY%2526l_total%253dY%2526name%253dJean-Philippe%252520Blangy%2526sort%253dname

Re: [SL] Can't open perl script / File name too long -> Premature end of script headers

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

I have seen this where there was a firewall in place which was  
truncating/munging the requested URL.  Could also be caused by a  
proxy in between or mod_security if that's enabled.



On Mar 14, 2007, at 6:36 AM, Antony Gelberg wrote:

> I don't want to bombard the list, but really, has nobody seen  
> this?  My
> setup is pretty vanilla.
>
> Antony Gelberg wrote:
>> Hi,
>>
>> I have seen the following intermittently over the past few years with
>> SL, and finally, it's annoying me enough to ask the list.
>>
>> The web browser asks me if I want to save or open the .pl file as  
>> if I
>> had initiated a download.  The errors below appear in the apache  
>> error log.
>>
>> I'd appreciate any assistance to debug this - can't believe I'm  
>> the only
>> one.  SL 2.6.3, Apache 2.2.3, Perl 5.8.8.
>>
>> [Sun Mar 04 14:32:04 2007] [error] [client 82.68.107.174] Can't open
>> perl script
>> "ct.pl%3faction%3dlist_names%26direction%3dDESC%26oldsort%3dname% 
>> 26db%3dvendor%26path%3dbin%2fmozilla%26login%3droma%26sessionid% 
>> 3d1173017171%26status%3dall%26l_subtotal%3d%26l_name%3dY% 
>> 26l_contact%3dY%26l_phone%3dY%26l_email%3dY%26l_amount%3dY%26l_tax% 
>> 3dY%26l_total%3dY%26name%3dJean-Philippe%2520Blangy%26sort%3dname":
>> File name too long, referer:
>> https://xxx.wayforth.co.uk/sql-ledger/ct.pl? 
>> action=edit&id=11379&db=vendor&path=bin/ 
>> mozilla&login=roma&sessionid=1173017171&status=all&callback=ct.pl% 
>> 253faction%253dlist_names%2526direction%253dDESC%2526oldsort% 
>> 253dname%2526db%253dvendor%2526path%253dbin%252fmozilla%2526login% 
>> 253droma%2526sessionid%253d1173017171%2526status%253dall% 
>> 2526l_subtotal%253d%2526l_name%253dY%2526l_contact%253dY% 
>> 2526l_phone%253dY%2526l_email%253dY%2526l_amount%253dY%2526l_tax% 
>> 253dY%2526l_total%253dY%2526name%253dJean-Philippe%252520Blangy% 
>> 2526sort%253dname
>> [Sun Mar 04 14:32:04 2007] [error] [client 82.68.107.174]  
>> Premature end
>> of script headers: ct.pl, referer:
>> https://xxx.wayforth.co.uk/sql-ledger/ct.pl? 
>> action=edit&id=11379&db=vendor&path=bin/ 
>> mozilla&login=roma&sessionid=1173017171&status=all&callback=ct.pl% 
>> 253faction%253dlist_names%2526direction%253dDESC%2526oldsort% 
>> 253dname%2526db%253dvendor%2526path%253dbin%252fmozilla%2526login% 
>> 253droma%2526sessionid%253d1173017171%2526status%253dall% 
>> 2526l_subtotal%253d%2526l_name%253dY%2526l_contact%253dY% 
>> 2526l_phone%253dY%2526l_email%253dY%2526l_amount%253dY%2526l_tax% 
>> 253dY%2526l_total%253dY%2526name%253dJean-Philippe%252520Blangy% 
>> 2526sort%253dname
>>
>
> ---------------------------------------------------------------------- 
> ---
> 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] Cheque template help requested.

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

Hi Jim

> figure out how far *up* the page you want the bottom of your cheque,
> and put a \vfill between the top of the cheque, and the bottom of the
> summary, and then at the bottom put the \vspace that you want from the
> bottom of your cheque. 
that may work, I'll give it a try tonight.

Thanks
Jeff


Jigme Datse wrote:
>> I think it
>> may have to do with boxes?
>>     
>
> I think it's due to using a fixed /vspace instead of flexible vglue.
> I think what you want to do (and this may take some playing around) is
> figure out how far *up* the page you want the bottom of your cheque,
> and put a \vfill between the top of the cheque, and the bottom of the
> summary, and then at the bottom put the \vspace that you want from the
> bottom of your cheque.  Now I'm not sure that this gives the answer
> that you are looking for.  It would depend on how you want to lay this
> all out.  The way that you have it laid out you have the invoice
> information at the top, then the cheque below that, and it appears
> that it is just a little bit below  it.  So what you want to do if you
> want to maintain the same format is to make sure that {tabularx} is
> the same size, and I'm not familiar enough with LaTeX to know if that
> is a text box, or if it's just a lexical boundary.  If it is a textbox
> then you should be able to define the hsize and vsize of the box.  If
> it's simply lexical (has no direct effect on how things are laid out
> on the page), then you will have to find a way to put the cheque on
> the page where you want (and that's crutial).  I would suggest trying
> to place the cheque either on the top of the printed page of
> "letterpaper".  That may be easily said, but much more difficult to
> produce with the cheque paper that you are using.
>
> Jigme Datse
>
> -------------------------------------------------------------------------
> 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
>
>
>