sql-ledger-users — SQL-Ledger users

[SL] HTML Invoice Template - broken image

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

Hey-

All of a sudden after an upgrade, my html invoice template is broken. My Latex 
template is working fine..

the image I am trying to reference is called "new_logo.jpg"

Its location is /usr/local/sql-ledger/templates/myk.robinson/new_logo.jpg


Please advise as to the proper way to refer to this image..

thanks,
-myk

Re: [SL] Best Linux OS for SL?

[Bob C. <bo...@co...>]

On Tue, 2007-03-27 at 20:55 -0700, Wallace Roberts Consulting wrote:
> On 3/27/07, Vladimir Botka <vl...@bo...> wrote:
> > But in the
> > long run with FreeBSD you can not avoid reading the handbook. It will
> > pay you in time. I promisse.
> 
> ... OR ...
> 
> Simply use Fedora Core instead, & it will automagically work.
> 
I've had the same results with SuSE.

Bob C.

Re: [SL] Best Linux OS for SL?

[Wallace R. C. <wrc...@gm...>]

On 3/27/07, Vladimir Botka <vl...@bo...> wrote:
> But in the
> long run with FreeBSD you can not avoid reading the handbook. It will
> pay you in time. I promisse.

... OR ...

Simply use Fedora Core instead, & it will automagically work.

--
Best Regards,
Wallace

Re: [SL] Purchase Order field?

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

On Tuesday 27 March 2007 12:14 pm, Danita Zanre wrote:
> I've just taken to putting the purchase order number in the "order" field, but if there is a way to pass this info to the invoice I'd be happier.
> 
<%ponumber%>

Cheers,
Roy

Re: [SL] Payroll

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

Hi Jigme

I do the same as David, if you set up your 'deduction' liability 
accounts (tax owing, employment insurance owing, pension owing etc) they 
will appear in the drop down menus of the AP module. You can put in the 
gross pay and assign it to an expense and then use negative numbers to 
'deduct' from the gross and assign the 'deductions' to liability 
accounts. When I'm all done printing the cheques I do a GL entry to 
account for the matching expenses, I, for example, expense the amount I 
have to match on their pension contributions (Pension expense) and add 
it to a liability account called 'pension owing' (same account I used 
when cutting their cheque). This way both my contribution and their 
contribution end up in the same liability account. At the end of the 
month when it's time for remittance I pay from a bank account and 
decrease the liability account back to zero.

None of this does anything for the calculations that have to be made to 
determine how much each employee has to pay each of the various 
deductions. I have a spreadsheet with the Canadian formulas in it to do 
that and it's printout is what I use to cut the cheques and do the GL entry.

Jeff Roberts

David Boyle wrote:
> On Mon, 2007-03-26 at 18:31 -0700, Jigme Datse wrote:
>   
>> I'm looking at my setup for SL and right now I'm not seeing any
>> payroll module.  That is while I see the HR module, and the Projects
>> module, I don't see a way to print up cheques/cheque stubs for the
>> hours that my employees have put in.  Am I missing something obvious?
>> I think I've gone through a few times to figure this out, and put the
>> payroll through, but the only way that I can see this right now, is to
>> manually enter the cheques, and stubs through the general ledger.
>>     
>
> I have my associates/employees set up as vendors and pay out using Add
> AP Transaction.  Entering the transaction this way allows me to enter
> Gross Pay under whatever expense account I am paying them through and
> entering deductions in the same transaction for withheld payroll taxes,
> garnishments and other items.  Works for us, but your mileage may vary.
>
> HTH,
> David Boyle
> NAPCO
>
>
>   
>> 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
>>     
>
>
> -------------------------------------------------------------------------
> 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] Purchase Order field?

[Danita Z. <da...@ca...>]

Maybe I'm just blind, but I can't seem to find a variable to replace the =
"order" field in an invoice with "Purchase Order" - in our business, we =
really never have a need to pass our internal "Sales Order" information to =
the invoice, but we always need to pass the "purchase order" info.  I've =
just taken to putting the purchase order number in the "order" field, but =
if there is a way to pass this info to the invoice I'd be happier.

Thanks.

Danita

Re: [SL] Payroll

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

On Mon, 2007-03-26 at 18:31 -0700, Jigme Datse wrote:
> I'm looking at my setup for SL and right now I'm not seeing any
> payroll module.  That is while I see the HR module, and the Projects
> module, I don't see a way to print up cheques/cheque stubs for the
> hours that my employees have put in.  Am I missing something obvious?
> I think I've gone through a few times to figure this out, and put the
> payroll through, but the only way that I can see this right now, is to
> manually enter the cheques, and stubs through the general ledger.

I have my associates/employees set up as vendors and pay out using Add
AP Transaction.  Entering the transaction this way allows me to enter
Gross Pay under whatever expense account I am paying them through and
entering deductions in the same transaction for withheld payroll taxes,
garnishments and other items.  Works for us, but your mileage may vary.

HTH,
David Boyle
NAPCO


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

Re: [SL] Project details for each timecard

[Rune B. <run...@co...>]

Tom Diehl wrote:
> On Mon, 26 Mar 2007, Rune Bromer wrote:
> 
>> Tom Diehl wrote:
>>> Yep, This is my exact situation. When you generate the sales order click
>>> the details button and you will get entries on the sales order for each
>>> timecard.
>>>
>>> Regards,
>> When I click the generate button I get blank list. Should the sale order
>> be visible somewhere? And how do you generate a invoice from it?
> 
> Look under sales orders and you should see the new sales orders. The timecards
> will be gone from view because they are allocated.

Thanks for the reply, but I'm still lost. Where in the menu do I find 
this? I can find "something" in the consolidate submenu, but there I can 
see 3 entries (2, 2 and -2 hours). Where can I generate an invoice?

Rune

Re: [SL] SQL-Ledger from Windows Mobile 5.0

[Colin M. <co...@it...>]

Awesome.

Lynx style menu works better with dopod anyway - Display is small.

Dieter Simader wrote:
> pass terminal=lynx on the URL
>
> http://localhost/sql-ledger/login.pl?terminal=lynx
>
> Looks like the browser does not like the Javascript code.
>
> If you don't like the lynx style menu force Javascript off
>
> http://localhost/sql-ledger/login.pl?action=login&login=the_login&password=the_password
>
>   

-- 
Regards,

*Colin Manning* B Sc.

/Computer service, sales and support./
I.T. Navigate Pty Ltd
Phone: (08) 9574 0200
Mobile: 0412 384 242
ABN:61 108 296 288

<http://www.itnavigate.com.au>
www.itnavigate.com.au <http://www.itnavigate.com.au>

Re: [SL] Best Linux OS for SL?

[Andrei K. <and...@ma...>]

On Monday 26 March 2007 8:31 pm, ATM Logic wrote:
> Thanks, tried it on my VM Ware unit and it failed, will try on the server
> (re-installing the 6.2 now)
>
csup is already in FreeBSD 6.2 base system- I referred to 6.1 in case you have 
older installation.

Re: [SL] Best Linux OS for SL?

[Vladimir B. <vl...@bo...>]

Hello,
if you installed from CD then you can install the port collection much
faster this way:
1. put your CD in
2. as a root type # sysinstal
3. go to CONFIGURE->DISTRIBUTIONS
4. check out the [x] ports
5. and press [OK]
The port collection will be installed from your CD. Then you can find
the SL in /usr/ports/finance directory. <gently flame=off> But in the
long run with FreeBSD you can not avoid reading the handbook. It will
pay you in time. I promisse.

Cheers, -vlado

> Any Idea what I am missing??
> 
> I have freeBSD installed, and I go to cd /usr/ports/ and ... There is
> nothing there... I cannot go to finance  etc...  Tried and failed
> with the VMWare, then on the full meal deal??
> 
> 
> 
> ??
> > > 
> > > If you're really insistent on having a GUI check out 
> > www.pcbsd.org - 
> > > FBSD + KDE
> > > 
> > 
> > Looks like I cannot install SQL on the VMWare package of this  :(
> > 
> > At least not using:
> > cd /usr/ports/finance/sql-ledger/ && make install clean
> > 
> > 
> > --------------------------------------------------------------
> > -----------
> > 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] Best Linux OS for SL?

[ATM L. <atm...@km...>]

Thanks for taking the time for the help, however I have tried 2 flavors of
FreeBSD, and as much as I would like it to work, I am getting little
failures here here and there (pkg_add -r csup, fails, even when I get
sql-ledger installed, I don't have pico to edit, so forced to use other
apps, then I am a little confused... No Lynx, or links, not even mc...

So... Going with CentOS, I know it well enough, and will try FreeBSD as a
project, not a production unit.


> >
> 
> I reccomend using Portsnap instead of cvsup.
> 
> http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/port
> snap.html
> 
> --------------------------------------------------------------
> -----------
> 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] Payroll

[Jigme D. <jig...@gm...>]

I'm looking at my setup for SL and right now I'm not seeing any
payroll module.  That is while I see the HR module, and the Projects
module, I don't see a way to print up cheques/cheque stubs for the
hours that my employees have put in.  Am I missing something obvious?
I think I've gone through a few times to figure this out, and put the
payroll through, but the only way that I can see this right now, is to
manually enter the cheques, and stubs through the general ledger.

Jigme Datse

Re: [SL] Best Linux OS for SL?

[Oliver H. <sl...@he...>]

Op Monday 26 March 2007 19:31:22 schreef ATM Logic:
> Thanks, tried it on my VM Ware unit and it failed, will try on the server
> (re-installing the 6.2 now)
>

I reccomend using Portsnap instead of cvsup.

http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/portsnap.html

Re: [SL] Project details for each timecard

[Tom D. <td...@ro...>]

On Mon, 26 Mar 2007, Rune Bromer wrote:

> Tom Diehl wrote:
>> Yep, This is my exact situation. When you generate the sales order click
>> the details button and you will get entries on the sales order for each
>> timecard.
>>
>> Regards,
>
> When I click the generate button I get blank list. Should the sale order
> be visible somewhere? And how do you generate a invoice from it?

Look under sales orders and you should see the new sales orders. The timecards
will be gone from view because they are allocated.

Regards,

-- 
Tom Diehl		td...@ro...		Spamtrap address mt...@ro...

[SL] Scheduled transactions - include payment

[Craig I. <cr...@da...>]

Can someone explain to me how the "include payment" feature works w/in
Scheduled Transactions?  I've looked through the manual and searched online
but I can't quite piece it together.

I have a recurring monthly expense charged automatically to my Debit Card
and I'd like to setup a Scheduled AP Transaction to record the expense (no
problem w/this part).  I'd also like to record the payment portion to the
appropriate checking account and thought I could use "include payment" to do
this but so far no luck.

Maybe I am overcomplicating things, should the "checking account" be
selectable on the AP screen as the "credit" account?

Thanks!
Craig

Re: [SL] Best Linux OS for SL?

[ATM L. <atm...@km...>]

 
Thanks, tried it on my VM Ware unit and it failed, will try on the server
(re-installing the 6.2 now)


> -----Original Message-----
> From: sql...@li... 
> [mailto:sql...@li...] On 
> Behalf Of Andrei Kolu
> Sent: Monday, March 26, 2007 11:08 AM
> To: sql...@li...
> Subject: Re: [SL] Best Linux OS for SL?
> 
> On Monday 26 March 2007 6:12 am, ATM Logic wrote:
> > Any Idea what I am missing??
> >
> > I have freeBSD installed, and I go to cd /usr/ports/ and 
> ... There is 
> > nothing there... I cannot go to finance  etc...  Tried and 
> failed with 
> > the VMWare, then on the full meal deal??
> >
> 
> # pkg_add -r csup
> # rehash
> # csup -h cvsup.se.freebsd.org /usr/share/examples/cvsup/ports-supfile
> # cd /usr/ports/databases/postgresql74-server
> # make install clean
> # cd /usr/ports/www/apache22
> # make install clean
> # cd /usr/ports/finance/sql-ledger
> # make install clean
> 
> Edit config files and follow installation instructions. All 
> other dependencies would be installed automatically.
> 
> --------------------------------------------------------------
> -----------
> 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] SQL-Ledger from Windows Mobile 5.0

[Dieter S. <dsi...@sq...>]

pass terminal=lynx on the URL

http://localhost/sql-ledger/login.pl?terminal=lynx

Looks like the browser does not like the Javascript code.

If you don't like the lynx style menu force Javascript off

http://localhost/sql-ledger/login.pl?action=login&login=the_login&password=the_password

-- 
Dieter Simader       http://www.sql-ledger.com   Tel: (780) 472-8161
DWS Systems Inc.        Accounting Software      Fax: (780) 478-5281
============== On a clear disk you can seek forever ================

On Mon, 26 Mar 2007, Colin Manning wrote:

> Hi All,
>
> Has anyone had any success accessing sql-ledger from a Windows Mobile
> device?
>
> I have a dopod 837pro running Windows Mobile 5.0, and have tried
> accessing sql-ledger on my server, but I cannot get into any of the menu
> items listed above "Recurring Transactions"
>
> Any hints?
>
> I also tried abacus.sql-ledger.com with no joy.
>

Re: [SL] Best Linux OS for SL?

[Andrei K. <and...@ma...>]

On Monday 26 March 2007 6:12 am, ATM Logic wrote:
> Any Idea what I am missing??
>
> I have freeBSD installed, and I go to cd /usr/ports/ and ... There is
> nothing there... I cannot go to finance  etc...  Tried and failed with the
> VMWare, then on the full meal deal??
>

# pkg_add -r csup
# rehash
# csup -h cvsup.se.freebsd.org /usr/share/examples/cvsup/ports-supfile
# cd /usr/ports/databases/postgresql74-server
# make install clean
# cd /usr/ports/www/apache22
# make install clean
# cd /usr/ports/finance/sql-ledger
# make install clean

Edit config files and follow installation instructions. All other dependencies 
would be installed automatically.

Re: [SL] Project details for each timecard

[Rune B. <run...@co...>]

Tom Diehl wrote:
> Yep, This is my exact situation. When you generate the sales order click 
> the details button and you will get entries on the sales order for each
> timecard.
> 
> Regards,

When I click the generate button I get blank list. Should the sale order 
be visible somewhere? And how do you generate a invoice from it?

BR,
Rune

[SL] SQL-Ledger from Windows Mobile 5.0

[Colin M. <co...@it...>]

Hi All,

Has anyone had any success accessing sql-ledger from a Windows Mobile =

device?

I have a dopod 837pro running Windows Mobile 5.0, and have tried =

accessing sql-ledger on my server, but I cannot get into any of the menu =

items listed above "Recurring Transactions"

Any hints?

I also tried abacus.sql-ledger.com with no joy.
-- =

Regards,

*Colin Manning* B Sc.

/Computer service, sales and support./
I.T. Navigate Pty Ltd
Phone: (08) 9574 0200
Mobile: 0412 384 242
ABN:61 108 296 288

<http://www.itnavigate.com.au>
www.itnavigate.com.au <http://www.itnavigate.com.au>

Re: [SL] Best Linux OS for SL?

[ATM L. <atm...@km...>]

Any Idea what I am missing??

I have freeBSD installed, and I go to cd /usr/ports/ and ... There is
nothing there... I cannot go to finance  etc...  Tried and failed with the
VMWare, then on the full meal deal??



??
> > 
> > If you're really insistent on having a GUI check out 
> www.pcbsd.org - 
> > FBSD + KDE
> > 
> 
> Looks like I cannot install SQL on the VMWare package of this  :(
> 
> At least not using:
> cd /usr/ports/finance/sql-ledger/ && make install clean
> 
> 
> --------------------------------------------------------------
> -----------
> 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] searching for customers

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

You're looking for AJAX.  Personally, I think it would be wonderful to 
have AJAX used in all of the search fields on the AR, AP, etc. screens.  
AJAX has been discussed several times on the list, but it always gets 
dismissed.  Perhaps it's time has come.

Dunc

Andrew McGeachy wrote:
> 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...
>  
> 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?
>  
> 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.

[SL] user logout , sessions timeout

[Alpha A. D. <ald...@ya...>]

hi to everyone
I' ve installed sql ledger on windows xp and everything works fine
except when i try to check on AR transaction or Sales invoices from the transaction report, the user  logout, so u have to log in again; by default i have the session time at 3600s .
  Do i miss something
  Would u please help.
  sorry for my english, hope u understand


Alpha Alimou Diallo
Technicien en Micro pc
et Programmeur web
Tel: +224-60 55 54 95
Fax: +33-826416296
web perso: http://www.alphadiallo.free.fr
 		
---------------------------------
 Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses.

Re: [SL] searching for customers

[Jigme D. <jig...@gm...>]

On 3/22/07, Andrew McGeachy <atm...@km...> wrote:
> 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...
>
> 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?
>
> 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.

One way to do this is to go to AR->Customers->Reports->Search and do
it through there, then once you have found the customer that you are
looking for  you can do a variety of transactions by clicking on the
customer.  If the customer that you are looking for is not in there,
then you can put the customer in as a new customer.  This is not the
ideal situation, though I don't know what, if anything happens when
you have a long list of customers.  I currently have three customers
listed on my customer list, and it simply presents an alphabetical
pull down list.  Which if you have more than about 10 customers seems
like it would become cumbersome.

Jigme Datse