sql-ledger-users — SQL-Ledger users

[SL] Outstanding payments on a certain date in the past

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

Hi,

My auditors need the amounts from invoices that were created before (for
example) 2006-07-01 and paid after 2006-06-30. In other words, they need
the total amount outstanding on 2006-06-30.

I can probably hack up a SQL statement to access the database directly,
but I wonder if SQL-Ledger can be coaxed into doing this from the front end?

greetings, el

Re: [SL] Printing to multiple printers

[Jeff R. <Jef...@te...>]

Thanks Ashley

That seems to have solved it, I did have to add a ctl-D (EOF) to the end 
of invoice.tex to terminate cat but now it prints all the right copies 
from all the right printers.

Jeff

Ashley J Gittins wrote:
> On Tuesday 16 January 2007 13:11, Jeff Roberts wrote:
>   
>> Hello All
>>
>> When I print an invoice I would like one copy to come out of my inkjet
>> in full colour for the customer and two copies should come out of my
>> laser for filing. Currently I find myself having to print to the inkjet
>> then back up one page, select laser, change the amount to two and print
>> again. I know this is not a lot of work but If I print 1000 invoices
>> this year it's going to drive me nuts.
>>     
>
> Hi Jeff,
> 	You could create a shell script that reads from standard input (possibly 
> putting it into a temporary file) then sends that data to two or more calls 
> to lp.
>
> We run a thermal docket printer at our shop and I use a script that prepends 
> control codes to print our logo, then send the print job, then sends more 
> data to add newlines and fire the cashdrawer. I later modified the script to 
> also keep logs of every docket, so now I have an automatic audit trail of 
> every printed POS docket which has come in handy a number of times for 
> balancing the till or finding other discrepancies.
>
> Essentially, all you'd need to do in your script is:
>
> ==============================
> #!/bin/sh
> #define a temporary file
> JOB=/tmp/sl-invprint.ps
>
> # capture the job into the temp file
> cat - > $JOB
>
> # Now print it however you like, however many times you like
> lp -d InkJet < $JOB
> lp -d Simplex -n 2 < $JOB
>
> # if you like, archive the print file:
> cat $JOB > /var/log/invoices/invoicelog-`date +%Y-$m-%d-%H%M.%S`.ps
>
> ==============================
>
> Then you just put the name of the script into the printer definition in 
> sql-ledger.conf and away you go (eg, if you save that script 
> as /usr/local/bin/invoiceprint then you just define your printer as 
> 'Invoice Printsystem' => 'invoiceprint').
>
> Doing this gives you a great deal of control over how you process printjobs - 
> eg you could use a script that parsed the invoice for fax numbers and faxed a 
> copy of the invoice to the client, or whatever else "behind the scenes" stuff 
> you wanted to do.
>
>   

Re: [SL] Printing to multiple printers

[Ashley J G. <sql...@pu...>]

On Tuesday 16 January 2007 13:11, Jeff Roberts wrote:
> Hello All
>
> When I print an invoice I would like one copy to come out of my inkjet
> in full colour for the customer and two copies should come out of my
> laser for filing. Currently I find myself having to print to the inkjet
> then back up one page, select laser, change the amount to two and print
> again. I know this is not a lot of work but If I print 1000 invoices
> this year it's going to drive me nuts.

Hi Jeff,
	You could create a shell script that reads from standard input (possibly 
putting it into a temporary file) then sends that data to two or more calls 
to lp.

We run a thermal docket printer at our shop and I use a script that prepends 
control codes to print our logo, then send the print job, then sends more 
data to add newlines and fire the cashdrawer. I later modified the script to 
also keep logs of every docket, so now I have an automatic audit trail of 
every printed POS docket which has come in handy a number of times for 
balancing the till or finding other discrepancies.

Essentially, all you'd need to do in your script is:

==============================
#!/bin/sh
#define a temporary file
JOB=/tmp/sl-invprint.ps

# capture the job into the temp file
cat - > $JOB

# Now print it however you like, however many times you like
lp -d InkJet < $JOB
lp -d Simplex -n 2 < $JOB

# if you like, archive the print file:
cat $JOB > /var/log/invoices/invoicelog-`date +%Y-$m-%d-%H%M.%S`.ps

==============================

Then you just put the name of the script into the printer definition in 
sql-ledger.conf and away you go (eg, if you save that script 
as /usr/local/bin/invoiceprint then you just define your printer as 
'Invoice Printsystem' => 'invoiceprint').

Doing this gives you a great deal of control over how you process printjobs - 
eg you could use a script that parsed the invoice for fax numbers and faxed a 
copy of the invoice to the client, or whatever else "behind the scenes" stuff 
you wanted to do.

-- 
Regards,
	Ashley J Gittins
	web: 	http://www.purple.dropbear.id.au
	jabber: agi...@pu...

Re: [SL] Printing to multiple printers

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

Hello Jeff...
Here is an old post from the list:

=2D---------
This is ugly but it works, create 2 cups printers, create a samba=20
printer that prints to both of them, create a cups printer that prints=20
to the samba printer.
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0-->Cups Printer 1
Cups printer 3 -> samba printer /
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0\--> Cups Printer 2


The =A0samba printer uses
print command =A0=3D =A0lpr -PPrinter1 %s/%f && lpr -P printer2 %s/%f

This is roughly how it goes, I made it work on another system years ago,=20
you will have to sort the details.

Or you could do a trick with the pipe to printer in sql-ledger.conf

=2D--------------------

I didn't get around to try this myself....
Hope this helps.
Roy




On Monday 15 January 2007 21:11, Jeff Roberts wrote:
> Hello All
>
> When I print an invoice I would like one copy to come out of my inkjet
> in full colour for the customer and two copies should come out of my
> laser for filing. Currently I find myself having to print to the inkjet
> then back up one page, select laser, change the amount to two and print
> again. I know this is not a lot of work but If I print 1000 invoices
> this year it's going to drive me nuts.
>
> I've tried playing around with the .conf file to create a printer called
> "invoice" with commands to do this without any luck. Does anyone know
> the syntax to put two print commands together so they execute one after
> another?
>
> I've tried:
>
> Invoice   =3D>   'lp -d InkJet, lp -d Simplex -n 2',
> Invoice   =3D>   'lp -d InkJet; lp -d Simplex -n 2',
> Invoice   =3D>   'lp -d InkJet: lp -d Simplex -n 2',
> Invoice   =3D>   lp -d InkJet and lp -d Simplex -n 2'.
> Invoice   =3D>   lp -d InkJet & lp -d Simplex -n 2',
> Invoice   =3D>   lp -d InkJet -d Simplex -n 2',
>
> and maybe a couple of others, no luck so far.
>
> Jeff Roberts
>
>
> -------------------------------------------------------------------------
> 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 ca=
sh
> http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

[SL] Printing to multiple printers

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

Hello All

When I print an invoice I would like one copy to come out of my inkjet 
in full colour for the customer and two copies should come out of my 
laser for filing. Currently I find myself having to print to the inkjet 
then back up one page, select laser, change the amount to two and print 
again. I know this is not a lot of work but If I print 1000 invoices 
this year it's going to drive me nuts.

I've tried playing around with the .conf file to create a printer called 
"invoice" with commands to do this without any luck. Does anyone know 
the syntax to put two print commands together so they execute one after 
another?

I've tried:

Invoice   =>   'lp -d InkJet, lp -d Simplex -n 2',
Invoice   =>   'lp -d InkJet; lp -d Simplex -n 2',
Invoice   =>   'lp -d InkJet: lp -d Simplex -n 2',
Invoice   =>   lp -d InkJet and lp -d Simplex -n 2'.
Invoice   =>   lp -d InkJet & lp -d Simplex -n 2',
Invoice   =>   lp -d InkJet -d Simplex -n 2',

and maybe a couple of others, no luck so far.

Jeff Roberts

Re: [SL] Latex errors

[Jeff R. <Jef...@te...>]

Hi Mark

That was the problem! I didn't have TeTeX installed. The manual says 
that you have to have LaTeX installed so I installed it from the ports. 
Unfortunately it doesn't install everything necessary. I had to 
uninstall Latex and install TeTex now everything works OK.

Dieter, you may want to put a note in the manual or change the 
"requirements" so that it is clear to others that it's not just Latex 
that is required but the entire TeTex package (including pdflatex). The 
way it reads now is a little confusing.

Jeff Roberts
JR Electronics

Mark Bucciarelli wrote:
> On Sat, Jan 13, 2007 at 12:13:11AM -0800, Jeff Roberts wrote:
>   
>> ! LaTeX Error: File `scrartcl.cls' not found.
>>
>>     
>
> On 6.0:
>
> $ pkg_info -L "teTeX-texmf*" | grep scrartcl.cls
> /usr/local/share/texmf-dist/tex/latex/koma-script/scrartcl.cls
> $
>
> I guess you don't have the print/teTex-texmf package installed?
>
> Make sure latex works outside SL first.
>
> 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
>
>   

Re: [SL] Latex errors

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

On Sat, Jan 13, 2007 at 12:13:11AM -0800, Jeff Roberts wrote:
> 
> ! LaTeX Error: File `scrartcl.cls' not found.
> 

On 6.0:

$ pkg_info -L "teTeX-texmf*" | grep scrartcl.cls
/usr/local/share/texmf-dist/tex/latex/koma-script/scrartcl.cls
$

I guess you don't have the print/teTex-texmf package installed?

Make sure latex works outside SL first.

m

Re: [SL] Latex errors

[Les R <ope...@gm...>]

BTW, make sure the running script has permissions to create the TeX
file that latex 'chews on'. It doesn't look like LaTeX is seeing the
script.

Les Richardson
Open Admin for Schools

On 1/13/07, Jeff Roberts <je...@jr...> wrote:
> Hi All
>
> So I finally installed latex on the server tonight to get some printing
> options but I think I've missed something.
>
> The server is a FreeBSD 5.3
> I've got SQL 2.6.22
> Apache 2
> I installed Latex from the ports collection, make/make install/make clean
> (everything worked OK, no errors)
>
> I then edited sqlledger.conf and changed Latex=0 to Latex=1
>
> I logged back into SQLLedger and the print buttons all changed to
> reflect the new options of postscript and pdf but when I try to print I get
>
>
>     Error!
>
> *This is TeX, Version 3.14159 (Web2C 7.2)
> (1168679490_invoice_4474.tex
> LaTeX2e <2003/12/01>
>
> ! LaTeX Error: File `scrartcl.cls' not found.
>
> Type X to quit or <RETURN> to proceed,
> or enter new name. (Default extension: cls)
>
> Enter file name:
> ! Emergency stop.
> <read *>
>
> l.2 \usepackage
> [latin1]{inputenc}^^M
> No pages of output.
> Transcript written on 1168679490_invoice_4474.log.
>
> *I've tried rebooting the server and restarting my browser but something
> is wrong or missing.
>
> Any ideas?
>
> Jeff Roberts
> JR Electronics
> -------------------------------------------------------------------------
> 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] Latex errors

[Les R. <le...@ce...>]

Check to see that the tex file is being created. It doesn't look like TeX 
has anything to chew on...

Les Richardson
Open Admin for Schools



On Sat, 13 Jan 2007, Jeff Roberts wrote:

> Hi All
>
> So I finally installed latex on the server tonight to get some printing
> options but I think I've missed something.
>
> The server is a FreeBSD 5.3
> I've got SQL 2.6.22
> Apache 2
> I installed Latex from the ports collection, make/make install/make clean
> (everything worked OK, no errors)
>
> I then edited sqlledger.conf and changed Latex=0 to Latex=1
>
> I logged back into SQLLedger and the print buttons all changed to
> reflect the new options of postscript and pdf but when I try to print I get
>
>
>    Error!
>
> *This is TeX, Version 3.14159 (Web2C 7.2)
> (1168679490_invoice_4474.tex
> LaTeX2e <2003/12/01>
>
> ! LaTeX Error: File `scrartcl.cls' not found.
>
> Type X to quit or <RETURN> to proceed,
> or enter new name. (Default extension: cls)
>
> Enter file name:
> ! Emergency stop.
> <read *>
>
> l.2 \usepackage
> [latin1]{inputenc}^^M
> No pages of output.
> Transcript written on 1168679490_invoice_4474.log.
>
> *I've tried rebooting the server and restarting my browser but something
> is wrong or missing.
>
> Any ideas?
>
> Jeff Roberts
> JR Electronics
> -------------------------------------------------------------------------
> 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] Latex errors

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

>     Error!
>
> *This is TeX, Version 3.14159 (Web2C 7.2)
> (1168679490_invoice_4474.tex
> LaTeX2e <2003/12/01>
>
> ! LaTeX Error: File `scrartcl.cls' not found.

scrartcl.cls not found tells you where to look for solution. I don't know
freebsd but some Latex package is missing on your install. Check for
available latex packages, on my Linux install srcartcl.cls is in

/usr/share/texmf/tex/latex/koma-script/

Good luck

Enrique




--=20
Dirk Enrique Seiffert - Lintec S.A.
Ed. Torre del Reloj - Of. 401
Plaza de los Coches, Centro
Cartagena - Colombia
http://www.lintecsa.com

[SL] Latex errors

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

Hi All

So I finally installed latex on the server tonight to get some printing 
options but I think I've missed something.

The server is a FreeBSD 5.3
I've got SQL 2.6.22
Apache 2
I installed Latex from the ports collection, make/make install/make clean
(everything worked OK, no errors)

I then edited sqlledger.conf and changed Latex=0 to Latex=1

I logged back into SQLLedger and the print buttons all changed to 
reflect the new options of postscript and pdf but when I try to print I get


    Error!

*This is TeX, Version 3.14159 (Web2C 7.2)
(1168679490_invoice_4474.tex
LaTeX2e <2003/12/01>

! LaTeX Error: File `scrartcl.cls' not found.

Type X to quit or <RETURN> to proceed,
or enter new name. (Default extension: cls)

Enter file name:
! Emergency stop.
<read *>

l.2 \usepackage
[latin1]{inputenc}^^M
No pages of output.
Transcript written on 1168679490_invoice_4474.log.

*I've tried rebooting the server and restarting my browser but something 
is wrong or missing.

Any ideas?

Jeff Roberts
JR Electronics

Re: [SL] Vendor Returns - Printing Debit Memo

[Bill F. <fa...@po...>]

On Fri, 12 Jan 2007, Tom Diehl wrote:

> Credit/debit memos are to be included in the next release. There is also 
> something called credit/debit invoice. I am not sure what the difference 
> really is between the 2 (no docs yet, nor enough time to play) but they 
> both have the ability to be printed. They are already in the devel 
> version but you need to be a subscriber to have acccess to it at this 
> point in time.

Thanks for this.  It is good to know I'll be able to do it in the future.

For now, what we do is create the negative vendor invoice for returned 
items and post it.  We then call up the posted invoice and use the 
"Purchase Order" button on the bottom to create a purchase order.  All the 
entries from the vendor invoice flow to the purchase order, which we then 
print out but do not save (we only created the PO to have *something* to 
print).

We then hand mark up the PO, striking through "PURCHASE ORDER", replacing 
it with "Debit Memorandum" and "Order No." with "Invoice No."  Clumsy, I 
know, but I really needed something to send back with the returned items.

  -- 
Bill Faust
Optim Microwave, Inc.
818-865-8157 x302

Re: [SL] How can I get do a report on total $ amount of a specific product sold over a year ?

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

Thanks Ashley and David !

It's the "Line Total" that I missed.
You saved me a lot of manually done spreadsheet work.

Thanks again. Have a good weekend.
(I'll be hiding inside.. it probably the coldest couple days of the winter here.... great for polar bears and furnace repairmen)
 Roy 


On Thursday 11 January 2007 10:18 am, Ashley J Gittins wrote:
> On Thursday 11 January 2007 05:58, R Pennington wrote:
> > see subject for my question  ;)
> ( Re: [SL] How can I get do a report on total $ amount of a specific product 
> sold over a year ?)
> > Can't seem to find this in the manual. I missing something obvious ?
> 
> Hi Roy,
> 	It's not very obvious - run an products report (Goods&Services, Reports, All 
> Items), put in any search criteria you like, tick "sales invoices", put in a 
> date range, check "closed", change "detail" to "Summary". Check the "Line 
> Total" and "Subtotal" options to get a total at the end (and for each item).
> 
> If you do services and you use different descriptions each time you sell them 
> (eg, "Consulting: fixed network routing"), you might want to turn 
> off "description" so you don't get them all listed individually.
> 

Re: [SL] Vendor Returns - Printing Debit Memo

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

On Fri, 12 Jan 2007, Bill Faust wrote:

>
> I have a question about vendor returns.
>
> The way we have dealt with returns to vendor is to open up the vendor
> invoice containing the item for return, editting it to have a negative
> quantity for the amount we are returning, including price, date it with
> the date of the return, place some verbose notes in the "Notes" field
> documenting why it is being returned, and "Post as New".  This we consider
> to be a Debit Memorandum, a copy of which we would give to the vendor
> along with the return.
>
> If we wish to have a replacement, then we issue a new purchase order for
> the items.
>
> This technique has worked well with one exception.  I know of no good way
> to print out the Vendor Invoice reversal, that is, the Debit Memorandum.
> Since you don't normally print out Vendor Invoices, there is no nice
> "Print" button with a LaTeX form.  I have tried just printing the screen
> from the browser, but my Mozilla and Firefox do not properly print out the
> comments in the "Notes" field -- they are clipped.  I have also tried
> Lynx, without joy.
>
> What I would really like is a "Print" button for the vendor invoices which
> would allow me to print them out (or email) as a nice "Debit Memorandum".
>
> Any ideas or comments on this?

Credit/debit memos are to be included in the next release. There is also
something called credit/debit invoice. I am not sure what the difference
really is between the 2 (no docs yet, nor enough time to play) but they
both have the ability to be printed. They are already in the devel version
but you need to be a subscriber to have acccess to it at this point in time.

Regards,

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

[SL] Vendor Returns - Printing Debit Memo

[Bill F. <fa...@po...>]

I have a question about vendor returns.

The way we have dealt with returns to vendor is to open up the vendor 
invoice containing the item for return, editting it to have a negative 
quantity for the amount we are returning, including price, date it with 
the date of the return, place some verbose notes in the "Notes" field 
documenting why it is being returned, and "Post as New".  This we consider 
to be a Debit Memorandum, a copy of which we would give to the vendor 
along with the return.

If we wish to have a replacement, then we issue a new purchase order for 
the items.

This technique has worked well with one exception.  I know of no good way 
to print out the Vendor Invoice reversal, that is, the Debit Memorandum. 
Since you don't normally print out Vendor Invoices, there is no nice 
"Print" button with a LaTeX form.  I have tried just printing the screen 
from the browser, but my Mozilla and Firefox do not properly print out the 
comments in the "Notes" field -- they are clipped.  I have also tried 
Lynx, without joy.

What I would really like is a "Print" button for the vendor invoices which 
would allow me to print them out (or email) as a nice "Debit Memorandum".

Any ideas or comments on this?


  -- 
Bill Faust
Optim Microwave, Inc.
818-865-8157 x302

[SL] 'Compare to' Reports

[Jerome J. A. <jer...@bo...>]

Hi, is it possible to make to 'Compare to' reports to work with more 
than two dates?  It is very handy to compare two sets of income 
statements or balance sheets and being able to generate 4 quarters of 
reports would be an excellent addition to SL.

Re: [SL] How can I get do a report on total $ amount of a specific product sold over a year ?

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

On Wed, 2007-01-10 at 13:58 -0600, R Pennington wrote:
> see subject for my question  ;)
> 
> Can't seem to find this in the manual. I missing something obvious ?

Goods & Services --> Reports --> Parts
Select open & closed sales invoices and choose the date range.  Check
the lower buttons as needed...last cost, sell price, etc.  As an aside,
you can also select name & subtotal to show you who and how many.  This
is a good way (imo) to watch movement on items to manager the ROP, but
your mileage may vary.

HTH,
David Boyle
NAPCO

> Cheers,
> Roy P.
> 
> -------------------------------------------------------------------------
> 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] How can I get do a report on total $ amount of a specific product sold over a year ?

[Ashley J G. <agi...@pu...>]

On Thursday 11 January 2007 05:58, R Pennington wrote:
> see subject for my question  ;)
( Re: [SL] How can I get do a report on total $ amount of a specific product 
sold over a year ?)
> Can't seem to find this in the manual. I missing something obvious ?

Hi Roy,
	It's not very obvious - run an products report (Goods&Services, Reports, All 
Items), put in any search criteria you like, tick "sales invoices", put in a 
date range, check "closed", change "detail" to "Summary". Check the "Line 
Total" and "Subtotal" options to get a total at the end (and for each item).

If you do services and you use different descriptions each time you sell them 
(eg, "Consulting: fixed network routing"), you might want to turn 
off "description" so you don't get them all listed individually.

-- 
Regards,
	Ashley J Gittins
	web: 	http://www.purple.dropbear.id.au
	jabber: agi...@pu...

[SL] department gets reset after 'update'

[Bernd P. <bp...@ch...>]

Hi all,

probably I'm doing something wrong here but whenever I enter the
department for a invoice (maybe the same for other transactions as
well) and I press 'update' the department is reset to blank and I have
to re-select it again.
Is there a way around it or some other way to prevent this?

Any hint is welcome!

Thanks!

Bernd

-- 
プラゲ ベェアント - Bernd Plagge
ファースト・チョイス・インターネット(有)
First Choice Internet Ltd., Tokyo
Tel. 03-4500-7799
Fax. 03-4400-3723
mail: bp...@ch...
url: http://www.choicenet.ne.jp

Re: [SL] Attachments P:roblem

[Davin M. <da...@me...>]

Found a work around.. Disappearing attachment problem seems to specifically
happen to HTML attachments. Sending PDF attachments, or inline HTML works
fine. Who knows why? But at least I can finally send some invoices again!

On 12/21/06, Davin Menhinick <da...@me...> wrote:
>
> I have a problem where many of my clients running Outlook 2000, 2002
> find they can see my attached HTML invoice the first time they open the
> mail, but when they open it a second time its been removed?
>

[SL] How can I get do a report on total $ amount of a specific product sold over a year ?

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

see subject for my question  ;)

Can't seem to find this in the manual. I missing something obvious ?

Cheers,
Roy P.

Re: [SL] Currency Field Type

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

On 1/9/07, Les R <ope...@gm...> wrote:
> Hi,
>
> What kind of SQL field type is used to store currency values in Sql-Ledger?

=> \d acc_trans
                    Table "public.acc_trans"
     Column     |       Type       |          Modifiers
----------------+------------------+-----------------------------
 trans_id       | integer          |
 chart_id       | integer          |
 amount         | double precision |
 transdate      | date             | default ('now'::text)::date
 source         | text             |
 cleared        | boolean          | default false
 fx_transaction | boolean          | default false
 project_id     | integer          |

-- 
Best Regards,
Wallace

Re: [SL] Currency Field Type

[Seneca C. <te...@gm...>]

On Tue, Jan 09, 2007 at 08:57:33AM -0600, Les R wrote:
> What kind of SQL field type is used to store currency values in Sql-Ledger?

float or float8.  Check sql/Pg-tables.sql to confirm if you wish.

-- 
Seneca
te...@gm...

Re: [SL] New customer does not show on Edit Sales Invoice screen

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

Doh!  Bless you!  That was it.  Thanks!

> -----Original Message-----
> From: sql...@li... [mailto:sql-ledger-
> use...@li...] On Behalf Of Lenny Leblanc
> Sent: Tuesday, January 09, 2007 11:30 AM
> To: sql...@li...
> Subject: Re: [SL] New customer does not show on Edit Sales Invoice screen
> 
> This may have something to do with the customers Start Date.  I believe
> if the start date is set before the invoice date then the customer won't
> show up in the list.  This is an editable field in the customers
> details.
> 
> --
> Lenny Leblanc
> 
> 628 Leila Avenue
> Winnipeg, Manitoba  R2V 3N7
> P: 204.338.0233
> 
> -----Original Message-----
> From: sql...@li...
> [mailto:sql...@li...] On Behalf Of
> Craig Isdahl
> Sent: Tuesday, January 09, 2007 10:24 AM
> To: sql...@li...
> Subject: [SL] New customer does not show on Edit Sales Invoice screen
> 
> Happy New Year Everyone!!
> 
> I have a small issue with which I hope someone can provide guidance.
> 
> We have an existing customer who has split their business to create 2
> separate entities.  We previously invoiced 100% of our services to the
> original entity but now they would like 50% of our services invoiced to
> each
> entity.  No problem.
> 
> In SL I did the following:
> - pulled up the (original) 1/5/07 invoice and issued a credit memo
> - pulled up the (original) 1/5/07 invoice and edited; did a "post as
> new"
> - pulled up the (original) 1/5/07 invoice and edited; did a "post as
> new"
> 
> I now have reversed the original invoice and created 2 new invoices (50%
> of
> our services on each).  At this point both new invoices are still
> assigned
> to the original entity.
> 
> In SL I did the following:
> - added the new entity (company) to SL
> - pulled up the new invoice I created above which should be assigned to
> the
> new entity.  The new entity is not available for selection from the
> "company" dropdown list.
> 
> I have tried "refreshing" from every relevant screen in all ways in
> which I
> know how to "refresh".  I have logged out and back in to the system.  I
> restarted postgresql.  I waited over 24 hours thinking it might be
> cached
> someplace.  No luck.
> 
> How can I re-assign this invoice to the new entity (company)?
> 
> We provide services and do not have inventory so reposting an invoice is
> not
> a concern for us.
> 
> Thanks!
> Craig
> 
> 
> ------------------------------------------------------------------------
> -
> 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=DEVDE
> V
> _______________________________________________
> 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] returning goods

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

On Tue, 2007-01-09 at 04:50 -0800, ma ga wrote:
> Hello All,
>   First, thanks a lot for this informative list.
>   After wroking for some time with the package, one of my customers wanted to return to me some goods.  How can I do this in the system to affect the inventory.    One fast solution is to update my invoice by deleting the returned item? but  I am not sure if this is the correct way as I would like to track items returned....,
> The optimum is to create an account for sales returns, and affect it....
> 
> Any thoughts are appreciated,
> -Mahmoud
We handle this through a sales order/sales invoice with negative
quantities.  This allows inventory to be affected correctly as well as
hitting that customers A/R account with the proper credit.  This also
allows us to issue an RMA/RGA (whatever you want to call it...returned
goods authorization) and to bring the product back using a sales order
(so the driver can route it for pick up) for inspection to insure it is
still sellable prior to cutting an invoice against it.  You can also add
a service charge to your invoice, if you want, for restock fee etc.

Hope that helps,
David Boyle
NAPCO

> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around 
> http://mail.yahoo.com 
> 
> -------------------------------------------------------------------------
> 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