sql-ledger-users — SQL-Ledger users

[SL] Sale Receipt

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

Hi,

I was trying to spiff up the Sales Receipt that's printed from the POS
screen and ran into the limit of my abilities.  I would like to add
color, variable fonts and a logo.
1)  Is this possible?
2)  How do I?

Thanks
Bob Crandell
ComputerBase USA

[SL] Problem with login

[Jefi S. <Jef...@op...>]

HI Everyone,
This is only the second problem I have had is 18 months of running 
SQL-Ledger
and I have been able to apply up dates with out any problem
But with going from 2.6.27 to 2.8.4 I have encountered the following error.

*DELETE FROM semaphore
WHERE login = 'Jeremy'
ERROR: relation "semaphore" does not exist
*
Does any one have any suggestions, I have not been able to resolve the 
problem


Many thanks

Jeremy*
*

Re: [SL] Corrupt PDF emails

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

Tell them to download Acrobat Reader.

el

on 5/22/07 3:35 AM Andrew @ ATM Logic said the following:

> When this happens, I tell them to forward the mail back to me...
> 95% of the time the PDF is fine...  I hear this same thing from
> MYOB/Qbooks/Simply users as well.

Re: [SL] Corrupt PDF emails

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

On Tue, May 22, 2007 at 09:45:30AM +1000, Ryan Johnson wrote:

> About 50% of user that receive a PDF invoice from the
> SQL-Ledger internal email function complain that the pdf won't
> open or is corrupt, others do not.

I've gotten this occasionally, primarily from Mac users.

It's the Latex engine, not Sql-Ledger.

m

Re: [SL] Corrupt PDF emails

[Andrew @ A. L. <atm...@km...>]

When this happens, I tell them to forward the mail back to me...  95% of the
time the PDF is fine...  I hear this same thing from MYOB/Qbooks/Simply
users as well.

 

> -----Original Message-----
> From: sql...@li... 
> [mailto:sql...@li...] On 
> Behalf Of Ryan Johnson
> Sent: Monday, May 21, 2007 6:46 PM
> To: sql...@li...
> Subject: [SL] Corrupt PDF emails
> 
> About 50% of user that receive a PDF invoice from the 
> SQL-Ledger internal email function complain that the pdf 
> won't open or is corrupt, others do not.
> 
> Is this related to templates or the pdf engine itself?
> 
> Cheers,
> Ryan
> 
> 
> 
> --------------------------------------------------------------
> -----------
> This SF.net email is sponsored by DB2 Express Download DB2 
> Express C - the FREE version of DB2 express and take control 
> of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> 

[SL] Corrupt PDF emails

[Ryan J. <ry...@ne...>]

About 50% of user that receive a PDF invoice from the SQL-Ledger
internal email function complain that the pdf won't open or is corrupt,
others do not.

Is this related to templates or the pdf engine itself?

Cheers,
Ryan

Re: [SL] Session timeout on WindowsXP

[Danilo M. <dan...@ca...>]

E. Gort escribió:
> Just recently, whenever we log into the Sql-Ledger server (on a Linux machine) 
> from WinXP we get constant session timeouts where we have log into the menu 
> window as well as the ledger window. Even when going from one section to 
> another we have the problem. Have looked in the archives and found no 
> solution so far. I think we have narrowed it down to some recent windows 
> updates because we can log in with a WinXP machine that does not have the 
> most recent updates. Has anyone else had this problem and does anyone have a 
> solution?
>
> TIA
> Evert Gort
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>   
You can solve it installing Mozilla Firefox,

there is some troble to save the cookies from sql-ledger by Iexplorer i 
think..

Re: [SL] How to make scheduled transactions continuous

[Karl L. <kar...@at...>]

On Fri, 2007-05-18 at 15:16 +0100, Kevin Bailey wrote:
> Hi,
> 
> If I create a scheduled transaction I can leave the 'Times' field 
> blank.  When going in to view/edit the scheduled transaction it shows as 
> '0'.
> 
> Does this mean that the scheduled transaction will create invoices 
> indefinitely?  Or will it create no more invoices.
> 
I don't know what 0 means but I always use 999 if I want something to
repeat "forever".

-- 
Karl Latiss <kar...@at...>
Atvert Systems

Re: [SL] Question RE scheduled invoices

[Karl L. <kar...@at...>]

On Fri, 2007-05-18 at 14:44 +0100, Kevin Bailey wrote:
> Hi,
> 
> I think I have a basic handle on the scheduled invoices.
> 
> You open the create invoice screen - build up your invoice by clicking 
> update.
> 
> Then click schedule to go to the schedule screen - and create your 
> schedule for future invoices.
> 
> Click save and then you are back at the invoice screen - which you 
> *must* then post.  The scheduled invoices depend on this invoice existing.
> 
> The difficulty I have is in putting in schedules which start in the future.
> 
> i.e. I want to add an invoice for 01/06/2007 and then send out the same 
> invoice every 3 months.  And I want all invoices to get emailed out.
> 
> If I create an invoice for 01/06/2007 and then start the schedule on 
> 01/09/2007 which includes emailing means that the invoice for the 
> 01/06/2007 will not be emailed out.
> 
I think you have to email the first one by clicking the Email button, ie
treat it as a normal (non scheduled) invoice.

-- 
Karl Latiss <kar...@at...>
Atvert Systems

[SL] How to make scheduled transactions continuous

[Kevin B. <kb...@fr...>]

Hi,

If I create a scheduled transaction I can leave the 'Times' field 
blank.  When going in to view/edit the scheduled transaction it shows as 
'0'.

Does this mean that the scheduled transaction will create invoices 
indefinitely?  Or will it create no more invoices.

I have paid for support and have a manual but nothing is mentioned.

Cheers,

Kevin

-- 
Kevin Bailey
IT Consultant

Email: kb...@fr...
Tel: 01752 268923
W: www.freewayprojects.com

[SL] Question RE scheduled invoices

[Kevin B. <kb...@fr...>]

Hi,

I think I have a basic handle on the scheduled invoices.

You open the create invoice screen - build up your invoice by clicking 
update.

Then click schedule to go to the schedule screen - and create your 
schedule for future invoices.

Click save and then you are back at the invoice screen - which you 
*must* then post.  The scheduled invoices depend on this invoice existing.

The difficulty I have is in putting in schedules which start in the future.

i.e. I want to add an invoice for 01/06/2007 and then send out the same 
invoice every 3 months.  And I want all invoices to get emailed out.

If I create an invoice for 01/06/2007 and then start the schedule on 
01/09/2007 which includes emailing means that the invoice for the 
01/06/2007 will not be emailed out.

If I create an invoice for 01/06/2007 and then start the schedule on 
01/06/2007 which includes emailing then after the 01/06/2007 an extra 
invoice will be created (which gets emailed) and the system now has two 
invoices for 01/06/2007.

Does anyone have any ideas?  Or am I missing something dumb!

Thanks,

Kevin

-- 
Kevin Bailey
IT Consultant

Email: kb...@fr...
Tel: 01752 268923
W: www.freewayprojects.com

[SL] Session timeout on WindowsXP

[E. G. <ev...@mi...>]

Just recently, whenever we log into the Sql-Ledger server (on a Linux machine) 
from WinXP we get constant session timeouts where we have log into the menu 
window as well as the ledger window. Even when going from one section to 
another we have the problem. Have looked in the archives and found no 
solution so far. I think we have narrowed it down to some recent windows 
updates because we can log in with a WinXP machine that does not have the 
most recent updates. Has anyone else had this problem and does anyone have a 
solution?

TIA
Evert Gort

[SL] Pricegroup: Print on Latex Form

[Sean E. <ske...@gm...>]

Hi all

Is there a variable for printing the pricegroup ID or other onto a latex
form?
Is there a way to have the pricegroup show up on a sales order or pick list?

Thanks in advance for your help.

Regards,
Sean

Re: [SL] Cheques & CPA

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

Hi Roger

I mucked around with the check.tex file and got it to conform with the 
new standards. If you copy this code into a file and name it check.tex 
(rename your old cheque.tex file first!!) it will give you a starting 
point. You may also want to play around a little to suit your particular 
brand of pre-printed cheque. This one is for Nebs 9039 and it prints the 
info on the bottom third.

Jeff

\documentclass{scrartcl}
\usepackage[latin1]{inputenc}
\usepackage{tabularx}
\usepackage[letterpaper,top=2cm,bottom=-3cm,left=2.25cm,right=2cm]{geometry}
\usepackage{graphicx}

\begin{document}

\pagestyle{myheadings}
\thispagestyle{empty}

\fontfamily{cmss}\fontsize{12pt}{12pt}\selectfont

\vspace*{7cm}

\hfill <%source%>

\vspace*{.75cm}

\hfill <%datepaid%>

\vspace*{2cm}

\textbf{ } <%text_amount%> \dotfill <%decimal%>/100 \hspace{1cm} 
<%amount%> \makebox[1cm]{\hfill}

% \hfill <%datepaid%> \makebox[2cm]{\hfill} <%amount%>

% \hfill <%amount%>  \makebox[1cm]{\hfill}

% different date format for datepaid
% <%DD%><%MM%><%YYYY%>

\vspace{0.25cm}

\textbf{ } <%name%>

\textbf{ }<%address1%>
<%address2%>

\textbf{ }<%city%>
<%if state%>
\hspace{-0.1cm}, <%state%>
<%end state%>
<%zipcode%>

\textbf{ }<%country%>

\vspace{0.25cm}

\textbf{ } Memo: <%memo%>

\vspace*{4cm}

%<%company%>

%\vspace{0.5cm}

<%name%> \hfill <%datepaid%> \hfill <%source%>

\vspace{0.5cm}
\begin{tabularx}{\textwidth}{lXrr@{}}
\textbf{Invoice \#} & \textbf{Invoice Date}
  & \textbf{Amount Due} & \textbf{Applied} \\
<%foreach invnumber%>
<%invnumber%> & <%invdate%> \dotfill
  & <%due%> & <%paid%> \\
<%end invnumber%>
\end{tabularx}

\vspace{1cm}

\text{Memo: } \
<%memo%>

\vfill

\end{document}


HTH :-)

Roger Miranda wrote:
> Good Day Everyone,
>
> I need to get a new cheques that conform with CPA (Canadian Payments 
> Association).  Is there a standard in the sql-ledger already that I can use 
> for this?  Is there some commercial support to create a latex report for us?
>
> Thanks in advance
> Roger
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
>   

[SL] Cheques & CPA

[Roger M. <rmi...@di...>]

Good Day Everyone,

I need to get a new cheques that conform with CPA (Canadian Payments 
Association).  Is there a standard in the sql-ledger already that I can use 
for this?  Is there some commercial support to create a latex report for us?

Thanks in advance
Roger

[SL] Credit Invoice Error

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

Hi,

has anyone seen this when trying to email or post a Credit Invoice in
2.8.4?


DBD::Pg::st execute failed: ERROR: invalid input syntax for integer:
"customer_id" at SL/AA.pm line 1260.
Error!

Assertion i == (((((SV *) (name_av))->sv_flags & 0x00008000)) ?
Perl_mg_size(my_perl, (SV *) name_av) : ((XPVAV*)
(name_av)->sv_any)->xav_fill)+1 failed: file "DBI.xs", line 1752 at
SL/AA.pm line 1261.
Database handle destroyed without explicit disconnect at SL/AA.pm line 1261.


I can email and post Sales Invoices, I can email and post Sales Invoices
with negative Quantities, which then print out Credit Notes in my LaTeX
Scheme of Things as a work around, but it is new behaviour :-)-O.

el

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

Re: [SL] Upgrade 2.8.2 - 2.8.4 failed

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

Please read the UPGRADE files in the doc directory. They are there for a 
good reason.

3. If you receive the following error while upgrading

    ERROR:  trigger "del_recurring" for table "oe" does not exist

    load admin.pl and "Unlock" the system.

4. log in


-- 
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 Sat, 12 May 2007, Glen Morris wrote:

> I've just run the upgrade (via the internet) from 2.8.2 to 2.8.4 and now
> can't login to my accounts. I get the message:
>
> Upgrading to Version 2.8.4 ...
> Error!
>
> drop trigger del_recurring ON oe
> ERROR: trigger "del_recurring" for table "oe" does not exist
>
> Glen
>
>

Re: [SL] Upgrade 2.8.2 - 2.8.4 failed

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

> I've just run the upgrade (via the internet) from 2.8.2 to 2.8.4 and now
> can't login to my accounts. I get the message:
>
> Upgrading to Version 2.8.4 ...
> Error!
>
> drop trigger del_recurring ON oe
> ERROR: trigger "del_recurring" for table "oe" does not exist

Same here, upgrading from 2.6.22 to 2.8.4

Enrique

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

[SL] Upgrade 2.8.2 - 2.8.4 failed

[Glen M. <gl...@au...>]

I've just run the upgrade (via the internet) from 2.8.2 to 2.8.4 and now
can't login to my accounts. I get the message:

Upgrading to Version 2.8.4 ...
Error!

drop trigger del_recurring ON oe
ERROR: trigger "del_recurring" for table "oe" does not exist

Glen

-- 
Glen Morris: Arachnoid Australia
613 90175780 Melbourne | 612 90164032 Sydney
613 98961811 VoIP | Mbl 0419299140
Skype=glenmo. PO Box 214, Healesville VIC 3777, Australia

Re: [SL] Feature Request

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

Dr Eberhard W Lisse wrote:
> Dieter,
>
> I have two feature requests (I use 2.8.2):
>
> in the Cash->Receipt Module I would like, if I change the customer on 
> the pulldown to automatically re-draw (as in the invoice screen), and 
> then display with the open invoices for that customer. Saves a few 
> clicks :-)-O
>
> When I use the wildcart parts/service in the invoice, I would like to
> have on the lines that are shown in the "Select Items" Screen, also a 
> column for the quantity that would be taken back to the invoice so I 
> don't have to add the quantity there and hit update. Saves another 
> few clicks :-)-O
>   
I have two feature requests.  I would love to see a more flexible tax 
system - the ability to make invoices tax free or taxed on the fly (or 
based upon shipto address - whichever is easiest.  And, I'd love to be 
able to search by Shipto address.

Dunc

[SL] Add Debit Invoice

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

I just upgraded from 2.6.22 to 2.8.4, get the following error on "Add
Debit Invoice"


DBD::Pg::db selectrow_array failed: ERROR: syntax error at end of input at
character 38
DBD::Pg::db selectrow_array failed: ERROR: current transaction is aborted,
commands ignored until end of transaction block
DBD::Pg::db selectrow_array failed: ERROR: current transaction is aborted,
commands ignored until end of transaction block
DBD::Pg::db selectrow_array failed: ERROR: current transaction is aborted,
commands ignored until end of transaction block
DBD::Pg::db selectrow_array failed: ERROR: current transaction is aborted,
commands ignored until end of transaction block

Any idea where the problem is?

Thanks

Enrique

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

[SL] error in Invoice Vendor

[Danilo M. <dan...@ca...>]

Hi

im using SL 2.8.0 when i try to get in a vendor invoice under AP this 
error appear:

*DBD::Pg::st execute failed: called with 1 bind variables when 3 are 
needed at SL/IR.pm line 1374.
*


    Error!

*
called with 1 bind variables when 3 are needed
*

*
Please Help
*

[SL] gzip: sql-ledger-2.8.2.tar.gz: not in gzip format

[Mark C. <ma...@cy...>]

Hi all,

When running setup.pl to upgrade from 2.6.23 to 2.8.2 I get the error
message

gzip: sql-ledger-2.8.2.tar.gz: not in gzip format

It seems most of the repositories dont have this version either. Whats
up? How do I fix this?

thanks

Mark

[SL] Associating Projects to Quotes, Invoices and Sales orders

[Ryan J. <ry...@ne...>]

Hey,

I recall SQL-Ledger doing the above in the past. Has this functionality
been removed?

Cheers,
Ryan
-- 

Re: [SL] Data migration...

[Jersey <je...@ib...>]

Just as a curiosity....

Ditter.... I presume the system did not know where to start upgrades as
I installed new version without upgrade. If I deleted all the upgrade
scripts below 2.4.4 -> 2.5.0 would it work? It looks for me the new
installation tried to update datasets right from beginning of time :).

Best regards
"Jersey"

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of
Jersey
Sent: 09 May 2007 03:26 PM
To: sql...@li...
Subject: Re: [SL] Data migration...

Thnx...

RTFM... :). I installed 2.4.7. System works, when I get a bit more time
I'll start to move up with upgrades.

Best regards
"Jersey"

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of
Paul Tammes
Sent: 09 May 2007 08:18 AM
To: sql...@li...
Subject: Re: [SL] Data migration...

Jersey schreef:
> Hello all,
>
> I installed sql-ledger on a new machine with Debian testing. The
current
> version of sql-ledger supplied is 2.6.22. I restored my data created
in
> version 2.4.4 and update the dataset. This is what I am getting:
>
> **************************
> Upgrading to Version 2.6.22 ... 
> Error!
> create table recurring (id int, reference text, startdate date,
nextdate
> date, enddate date, repeat int2, unit varchar(6), howmany int, payment
> bool default 'f')
> ERROR: relation "recurring" already exists
> **************************
>
> Any help will be highly appreciated
>
> Best regards
> "Jersey"
>
> No virus found in this outgoing message.
> Checked by AVG Free Edition. 
> Version: 7.5.467 / Virus Database: 269.6.5/793 - Release Date:
> 2007/05/07 02:55 PM
>  
>
>
>
------------------------------------------------------------------------
-
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
>
>   
Try installing the corrct older version, restore backup and then uodate 
would seem logical.
Otherwise: run the various update scripts in the \sql-ledger\sql\ 
directory, starting with Update_2.44 >2.xx might do the trick.

Hth
Paul


------------------------------------------------------------------------
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.467 / Virus Database: 269.6.6/794 - Release Date:
2007/05/08 02:23 PM
 

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.467 / Virus Database: 269.6.6/794 - Release Date:
2007/05/08 02:23 PM
 


------------------------------------------------------------------------
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.467 / Virus Database: 269.6.6/794 - Release Date:
2007/05/08 02:23 PM
 

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.467 / Virus Database: 269.6.6/794 - Release Date:
2007/05/08 02:23 PM