sql-ledger-users — SQL-Ledger users

Re: [SL] upgrade problem

[mauricio a. <ma...@ho...>]

enter for admin.pl, apdate database , unlock database, exit  and  enter for=
 login.pl=20
=20
is all> Date: Thu, 7 Jun 2007 09:35:18 +1000> From: adr...@ie...> =
To: sql...@li...> Subject: [SL] upgrade problem> =
> I just upgraded from 2.8.2 to 2.8.5, then login -> Upgrading then an erro=
r, " dropped trigger .....??..." Tried to login again, > error message " Lo=
gin disabled!"> > from httpd/error.log> > [Thu Jun 07 09:19:28 2007] [error=
] [client 127.0.0.1] DBD::Pg::st execute failed: ERROR: trigger "del_recurr=
ing" for table "oe" > does not exist, referer: http://localhost/sql-ledger/=
login.pl> [root@adios httpd]#> > Sadness> > > Adrian> -- > Adrian Blake> Mo=
longlo Radio Observatory> University of Sydney> 1152 Hoskinstown Rd> Bungen=
dore 2621> ph. 02 80042212 mobile 0407 232 978> > http://150.101.125.30/pic=
s> > ----------------------------------------------------------------------=
---> 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/lis=
ts/listinfo/sql-ledger-users
_________________________________________________________________
With Windows Live Hotmail, you can personalize your inbox with your favorit=
e color.
www.windowslive-hotmail.com/learnmore/personalize.html?locale=3Den-us&ocid=
=3DTXT_TAGLM_HMWL_reten_addcolor_0607=

Re: [SL] Translation of Chart of Accounts descriptions

[Bob G. <bo...@rc...>]

On Jun 7, 2007, at 09:28, Dieter Simader wrote:

> On Thu, 7 Jun 2007, Bob Gustafson wrote:
>
>> I have two users:
>>  One is English speaking
>>  Two is German  speaking
>>
>> Is it possible to have the Chart of Accounts description visible  
>> in the
>> appropriate language for both of these users?
>>
>> I know that I will have to supply a translation for these  
>> descriptions,
>> but where should this translation go?
>
> For display purposes (reports) you could use the GIFI, that is if  
> you do
> not use the GIFI in lieu of DATEV.
>
> With a bit of coding you could link the chart of accounts to a  
> translation
> and retrieve the description based on the language setting.
>

I am using the German GIFI - that is linked in anyway. I was not sure  
what the DATEV was.

My assumption is that there are normally two Charts of Account, the  
(DATEV - regular ?) and the GIFI. The regular one is mostly visible  
and the GIFI is there to be linked to and would be available for  
outside financial audits, etc.  Is this the way it works?

Maybe doing the DATEV in English and the GIFI in German? Have not  
tried this.


The coding part I can figure out, I was just wondering if there was  
an easier way that was already done. Some hints here would be helpful  
though.


Bob G

Re: [SL] Translation of Chart of Accounts descriptions

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

On Thu, 7 Jun 2007, Bob Gustafson wrote:

> I have two users:
>  One is English speaking
>  Two is German  speaking
>
> Is it possible to have the Chart of Accounts description visible in the
> appropriate language for both of these users?
>
> I know that I will have to supply a translation for these descriptions,
> but where should this translation go?

For display purposes (reports) you could use the GIFI, that is if you do 
not use the GIFI in lieu of DATEV.

With a bit of coding you could link the chart of accounts to a translation 
and retrieve the description based on the language setting.

Re: [SL] Translation of Chart of Accounts descriptions

[Bob G. <bo...@rc...>]

I have read through the mainual

I do have two users.

The menus down the left are nicely translated appropriately. However
there are other non-translated items that poke through, particularly the
Chart of Accounts data.

I agree that learning German or English would be the better solution,
but that will happen with time. I am looking for a 'quick fix'.

Bob G

On Thu, 2007-06-07 at 11:46 +0100, Dr Eberhard Lisse wrote:
> Read the Manual :-)-O
> 
> Define two users, select appropriate language, for each.
> 
> 
> Though, personally speaking, I find this hard to believe that
> one would allow someone not speaking the language of the tax
> authority concerned, especially one as aggressive as the IRS,
> access to a book keeping system.
> 
> greetings, el
> 
> on 6/7/07 10:19 AM Bob Gustafson said the following:
> > I have two users:
> >   One is English speaking
> >   Two is German  speaking
> > 
> > Is it possible to have the Chart of Accounts description visible in the
> > appropriate language for both of these users?
> > 
> > I know that I will have to supply a translation for these descriptions,
> > but where should this translation go?
> > 
> > Thanks for your hints
> > 
> > Bob G
> 

Re: [SL] Translation of Chart of Accounts descriptions

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

Read the Manual :-)-O

Define two users, select appropriate language, for each.


Though, personally speaking, I find this hard to believe that
one would allow someone not speaking the language of the tax
authority concerned, especially one as aggressive as the IRS,
access to a book keeping system.

greetings, el

on 6/7/07 10:19 AM Bob Gustafson said the following:
> I have two users:
>   One is English speaking
>   Two is German  speaking
> 
> Is it possible to have the Chart of Accounts description visible in the
> appropriate language for both of these users?
> 
> I know that I will have to supply a translation for these descriptions,
> but where should this translation go?
> 
> Thanks for your hints
> 
> Bob G

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

[SL] Translation of Chart of Accounts descriptions

[Bob G. <bo...@rc...>]

I have two users:
  One is English speaking
  Two is German  speaking

Is it possible to have the Chart of Accounts description visible in the
appropriate language for both of these users?

I know that I will have to supply a translation for these descriptions,
but where should this translation go?

Thanks for your hints

Bob G

[SL] Direct link to Cash Payments report

[Prem P. <pre...@gm...>]

I would like to create a direct link to the cash payments report in
sql-ledger.
I know I only can do that with a user without password, but still i'm unable
to make it work.
The settings page before the report has this address:
http://server/sql-ledger/rp.pl?path=bin/mozilla&action=report&level=Cash--Reports--Payments&login=loginname&js=1&report=payments
Therefore I thought the direct link to the report should be something like:
http://server/sql-ledger/rp.pl?path=bin/mozilla&action=report&level=Cash--Reports--Payments&login=loginname&js=1&action=list_payments
The result of this direct link is the payments report without any items in
it, just header and no payments visible!
Thats strange since the normal way for accessing the report does show all
payments.

What should I include in the direct link address?

Thanks
Prem

Re: [SL] upgrade problem & solved

[Adam V. M. <amv...@gm...>]

Yes, and the upgrade docs say you must unlock again if you see that error
after attempting to login.  There is a more detailed explanation on the
forum, and perhaps in the mailing list archive.  Suffice it to say there is
a reason, and it's not supposed to happen again (except for the scenario I
stated earlier).

On 6/6/07, Adrian Blake <adr...@ie...> wrote:
>
> Thanks,
>
> I did unlock before login but the process must have locked again and thus
> required a second unlock operation.
>
> This does not explain the error.
>
> All appears to be working now.
>
> Adam Vande More wrote:
> > Read the upgrade docs.  You must unlock the system again.  As an
> additional
> > note, you'll have to repeat this process for every dataset you have.
> >
> > On 6/6/07, Adrian Blake <adr...@ie...> wrote:
> >> I just upgraded from 2.8.2 to 2.8.5, then login ->  Upgrading   then an
> >> error, " dropped trigger .....??..." Tried to login again,
> >> error message " Login disabled!"
> >>
> >> from httpd/error.log
> >>
> >> [Thu Jun 07 09:19:28 2007] [error] [client 127.0.0.1] DBD::Pg::st
> execute
> >> failed: ERROR:  trigger "del_recurring" for table "oe"
> >> does not exist, referer: http://localhost/sql-ledger/login.pl
> >> [root@adios httpd]#
> >>
> >> Sadness
> >>
> >>
> >> Adrian
> >> --
> >> Adrian Blake
> >> Molonglo Radio Observatory
> >> University of Sydney
> >> 1152 Hoskinstown Rd
> >> Bungendore 2621
> >> ph. 02 80042212  mobile 0407 232 978
> >>
> >> http://150.101.125.30/pics
> >>
> >>
> -------------------------------------------------------------------------
> >> 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
> >>
> >
> >
> >
>
> --
> Adrian Blake
> Molonglo Radio Observatory
> University of Sydney
> 1152 Hoskinstown Rd
> Bungendore 2621
> ph. 02 80042212  mobile 0407 232 978
>
> http://150.101.125.30/pics
>
> -------------------------------------------------------------------------
> 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
>



-- 
Adam Vande More
Systems Administrator
Mobility Sales

Re: [SL] upgrade problem & solved

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

Thanks,

I did unlock before login but the process must have locked again and thus required a second unlock operation.

This does not explain the error.

All appears to be working now.

Adam Vande More wrote:
> Read the upgrade docs.  You must unlock the system again.  As an additional
> note, you'll have to repeat this process for every dataset you have.
> 
> On 6/6/07, Adrian Blake <adr...@ie...> wrote:
>> I just upgraded from 2.8.2 to 2.8.5, then login ->  Upgrading   then an
>> error, " dropped trigger .....??..." Tried to login again,
>> error message " Login disabled!"
>>
>> from httpd/error.log
>>
>> [Thu Jun 07 09:19:28 2007] [error] [client 127.0.0.1] DBD::Pg::st execute
>> failed: ERROR:  trigger "del_recurring" for table "oe"
>> does not exist, referer: http://localhost/sql-ledger/login.pl
>> [root@adios httpd]#
>>
>> Sadness
>>
>>
>> Adrian
>> --
>> Adrian Blake
>> Molonglo Radio Observatory
>> University of Sydney
>> 1152 Hoskinstown Rd
>> Bungendore 2621
>> ph. 02 80042212  mobile 0407 232 978
>>
>> http://150.101.125.30/pics
>>
>> -------------------------------------------------------------------------
>> 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
>>
> 
> 
> 

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

http://150.101.125.30/pics

Re: [SL] upgrade problem

[Adam V. M. <amv...@gm...>]

Read the upgrade docs.  You must unlock the system again.  As an additional
note, you'll have to repeat this process for every dataset you have.

On 6/6/07, Adrian Blake <adr...@ie...> wrote:
>
> I just upgraded from 2.8.2 to 2.8.5, then login ->  Upgrading   then an
> error, " dropped trigger .....??..." Tried to login again,
> error message " Login disabled!"
>
> from httpd/error.log
>
> [Thu Jun 07 09:19:28 2007] [error] [client 127.0.0.1] DBD::Pg::st execute
> failed: ERROR:  trigger "del_recurring" for table "oe"
> does not exist, referer: http://localhost/sql-ledger/login.pl
> [root@adios httpd]#
>
> Sadness
>
>
> Adrian
> --
> Adrian Blake
> Molonglo Radio Observatory
> University of Sydney
> 1152 Hoskinstown Rd
> Bungendore 2621
> ph. 02 80042212  mobile 0407 232 978
>
> http://150.101.125.30/pics
>
> -------------------------------------------------------------------------
> 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
>



-- 
Adam Vande More
Systems Administrator
Mobility Sales

[SL] upgrade problem

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

I just upgraded from 2.8.2 to 2.8.5, then login ->  Upgrading   then an error, " dropped trigger .....??..." Tried to login again, 
error message " Login disabled!"

from httpd/error.log

[Thu Jun 07 09:19:28 2007] [error] [client 127.0.0.1] DBD::Pg::st execute failed: ERROR:  trigger "del_recurring" for table "oe" 
does not exist, referer: http://localhost/sql-ledger/login.pl
[root@adios httpd]#

Sadness


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

http://150.101.125.30/pics

Re: [SL] balance sheet / AP outstanding

[Lenny L. <lle...@ma...>]

The numbers are lining up when I look at the AP Outstanding report as of =
12-31-2006 with the in depth view of the account to 12-31-2006 (by =
clicking on the account name from the Reports->Chart of Accounts =
screen).

However when I look at the balance sheet and the trial balance the =
accounts payable is out by $628.92 for which I don't even have a =
transaction recorded for this amount. ?? (looking at these reports for =
the period ending 12-31-2006).

Any ideas what might be causing this.  How can it get different results =
for the same account on different reports?


--
Lenny Leblanc
=A0


-----Original Message-----
From: sql...@li... =
[mailto:sql...@li...] On Behalf Of =
Michael Hasse
Sent: June-01-07 11:52 PM
To: sql...@li...
Subject: Re: [SL] balance sheet / AP outstanding

What do you get if you look at the actual accounts?


Thanks,

Michael


On Jun 1, 2007, at 1:50 PM, Lenny Leblanc wrote:

> I'm having a problem with my year-end reports after using SQL-Ledger.
> When looking at December 31, 2006 balance sheet and ap outstanding =20
> list
> I don't get the same values for each.
>
>
>
> The number on the balance sheet is more than the ap outstanding by =20
> about
> $400.  Any ideas where I can start looking to try and resolve =20
> this?  Is
> it something with the software or just a problem with my entries?
>
>
>
> I just recently upgrade to 2.8.5.
>
>
>
> --
>
> Lenny Leblanc
>
>
>
> ---------------------------------------------------------------------- =

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


-------------------------------------------------------------------------=

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

Re: [SL] printing

[Bill D. <wa...@gm...>]

On 6/3/07, Stroller <lin...@my...> wrote:
> Please don't top-post in reply to a bottom-post. Top-post all you
> like if you're the first respondent to a thread and I would ask
> anyone replying to you not to bottom-post when they follow you. But
> mixing the two is more annoying and less legible than either.
>
> I've fixed it for you:
>
> On 3 Jun 2007, at 05:38, Bob Gustafson wrote:
> > On Sat, 2007-06-02 at 12:46 +0100, Stroller wrote:
> >> On 1 Jun 2007, at 22:14, Bill Dika wrote:
> >>> ...
> >>> I have cups installed.
> >>> ...
> >>> The problem is I can't print to the printer from SL. When I try to
> >>> print an invoice to the printer using either postscript or pdf, I
> >>> get
> >>> nothing. The browser seems to refresh but the printer is silent.
> >>> Nothing happens.
> >>
> >> CUPS has a web-interface which runs on port 631 - i.e. you can access
> >> it via http://localhost:631/ (by default it is only accessible from
> >> the local machines, not the network).
> >>
> >> Do the invoices show up under the "Jobs" tab of that webpage?
> >> I believe they should show as "Name: (stdin)" "User: apache".
> >
> > On my system, every once in awhile, cups has a problem. Using the
> > http://localhost:631/ gui interface, my printer appears to be printing
> > and then completes, but nothing appears on the printer (the printer
> > even
> > blinks and then stops blinking).
> >
> > I just 'stop' the printer, and restart it. Usually this fixes the
> > problem. (probably a design flaw in the printer protocol).
>
> Yes - I meant to mention in my previous post that CUPS misbehaves for
> me, too. For no apparent reason It'll often need a restart (`/etc/
> init.d/cupsd restart`), but this is sufficient to start printing again.
>
> Stroller.
>
>
>
>
> -------------------------------------------------------------------------
> 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
>

Hi Stroller:

Thanks for the reply. Sorry to take so long to get back to you.

The "print test page" option in the cups web admin interface
(localhost:631) works fine. Also I emailed myself an invoice in
postscript form and tried the following:

cat ./invoice_1.ps | lpr -Php_lj_1020

and the invoice printed out perfectly.

I tried a cups restart but it didn't make any difference in trying to
print from SL.

I am using SL 2.8.4.

Thanks.

Bill Dika

[SL] Foreign currency issue/bug in 2.8.5

[Armaghan S. <sa...@le...>]

Hi everybody,

In 2.8.5 Transfer cash functionality with FX flag for
foreign currencies has been removed in favour of
currency/exchange rate in GL.

The transactions I was able to make in previous
versions are now no longer possible.

Here is a step by step description of the problem:

NEW WAY
========
1. I enter currency code, exchange rate and
Debit CAD with 1000, Credit USD with 1000.

2. Exchange rate gets applied to both transactions
and there are four transactions in 'acc_trans' table as:
(1) Debit CAD with 1000
(2) Debit CAD with 320 marked AS FX
(3) Credit USD with 1000
(4) Credit USD with 320 marked AS FX

The cash report shows CAD=1000 (when FX suppressed)
whereas it should should 1320. NOT CORRECT.

The cash report shows USD=1000 (when FX suppressed)
which is CORRECT.


OLD WAY
========
(1) Debit CAD with 1320
(2) Credit USD with 1000
(3) Credit USD with 320 AS fx

Cash report for CAD as well as USD is correct.

----
Am I missing something or this is a missing
feature or bug in 2.8.5.

As per my testing, currency code and conversion
rate in 2.8.5 has no use because the conversion
rate gets applied to all transaction lines.

Plz help by suggesting some workaround or
pointing me in the right direction.


Thanks in advance and my regards
Armaghan

[SL] Print +Post when printing to screen

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

If you print an invoice to a conected printer print an post works. When
you print to screen or send invoices by email you still have to save them.

Is there a way to force registration when sending invoice by mail or
printing to  screen?

Thanks for any hint!

Enrique


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

Re: [SL] Duplicate invoice numbers

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

Ryan
Perhaps reconsider your decision to post zero value invoices
?
There might be a better way to adjust stock levels.
David J

> Ok I found a bit more information how these duplicate
> numbers are occurring.
> 
> We make use of the API for posting some invoices and it
> appears that when an invoice is posted with a zero amount,
> the invoice gets put into the database and is allocated a
> number. But the auto increment value doesn't appear to
> increase. This looks like it could be a small bug.
> 
> Cheers,
> Ryan
>

Re: [SL] Duplicate invoice numbers

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

Ok I found a bit more information how these duplicate numbers are occurring.

We make use of the API for posting some invoices and it appears that
when an invoice is posted with a zero amount, the invoice gets put into
the database and is allocated a number. But the auto increment value
doesn't appear to increase. This looks like it could be a small bug.

Cheers,
Ryan




C. Duncan Hudson wrote:
> Ryan Johnson wrote:
>   
>> Hey ..
>>
>> I'm on a roll today.! (sorry)
>>
>> Since we've been using SQL ledger every so often the same invoice number
>> gets used from an existing invoice!! We have 62 duplicate entries out of
>> 560 invoices
>>
>> Would I be correct in thinking that invoice numbers should be unique ??
>>   
>>     
> I would think that invoice numbers should be unique, and I have argued 
> that point for several years on this list.  However, the powers that be 
> feel that this is a user training issue  (eg 'tell your users not to 
> make duplicates').  I think you'll find that you're probably using the 
> 'Post As New' function which easily allows you to create duplicate 
> invoice numbers.  A long time ago we put a unique index on the AR and OE 
> tables to stop duplicates, and we also modified the code to get a new 
> Invoice (or PO) number if posting as new and a number is already assigned.
>
> Dunc
>
> -------------------------------------------------------------------------
> 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] How to make/print Delivery Order?

[Selina <elv...@ya...>]

Please, is there a way to make and print a Delivery Order? The transaction will deduct accordingly items from the inventory. No sales invoice or payments are made yet. And the product may be returned to the inventory anytime. Really need this feature.


Elv.






      ___________________________________________________________
Yahoo! Answers - Got a question? Someone out there knows the answer. Try it
now.
http://uk.answers.yahoo.com/ 

[SL] Confirmation/warning on itemising zero or negative balance Inventory Item in POS/Invoice Sales

[Selina <elv...@ya...>]

Is there a way to have a confirmation or warning come out when itemising sales for inventory items that have zero or negative balance ?


Elv




	
	
		
___________________________________________________________ 
New Yahoo! Mail is the ultimate force in competitive emailing. Find out more at the Yahoo! Mail Championships. Plus: play games and win prizes. 
http://uk.rd.yahoo.com/evt=44106/*http://mail.yahoo.net/uk 

[SL] Logged in user only is shown or automatcally shown in the Salesperson drop-down menu in POS Sales/Invoice Sales screen

[Selina <elv...@ya...>]

Is there a way to have only the user that is logged in have his or her name=
 automatically chosen or to be the only choice in the Salesperson drop down=
 menu in the POS Sales/Invoice Sales/Vendor Invoice screen??=0A=0AElv=0A=0A=
=0A=0A=0A=09=09=0A_________________________________________________________=
__ =0AAll New Yahoo! Mail =96 Tired of unwanted email come-ons? Let our Spa=
mGuard protect you. http://uk.docs.yahoo.com/nowyoucan.html

[SL] Post And Print

[Selina <elv...@ya...>]

I am using SQL-Ledger installed in Windows XP Environment. Can someone please guide me to get SQL-Ledger have Post and Print button in POS Sales Screen. I have a dot matrik printer attached to the server PC. 

Elv




      ___________________________________________________________
Yahoo! Answers - Got a question? Someone out there knows the answer. Try it
now.
http://uk.answers.yahoo.com/ 

[SL] Remove Locks

[Selina <elv...@ya...>]

Ok.. I just upgraded to the latest version of SQL-Ledger. Looks like the latest version lock the posted POS invoice so that it cannot be deleted by users. Wonderful... But I decided to try the new Remove Locks button. ... now posted POS invoice got all this button at the bottom again.... Now... May I know how to Lock them back again please???


Elv






      ___________________________________________________________ 
Yahoo! Mail is the world's favourite email. Don't settle for less, sign up for
your free account today http://uk.rd.yahoo.com/evt=44106/*http://uk.docs.yahoo.com/mail/winter07.html 

Re: [SL] printing

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

Please don't top-post in reply to a bottom-post. Top-post all you
like if you're the first respondent to a thread and I would ask
anyone replying to you not to bottom-post when they follow you. But
mixing the two is more annoying and less legible than either.

I've fixed it for you:

On 3 Jun 2007, at 05:38, Bob Gustafson wrote:
> On Sat, 2007-06-02 at 12:46 +0100, Stroller wrote:
>> On 1 Jun 2007, at 22:14, Bill Dika wrote:
>>> ...
>>> I have cups installed.
>>> ...
>>> The problem is I can't print to the printer from SL. When I try to
>>> print an invoice to the printer using either postscript or pdf, I  
>>> get
>>> nothing. The browser seems to refresh but the printer is silent.
>>> Nothing happens.
>>
>> CUPS has a web-interface which runs on port 631 - i.e. you can access
>> it via http://localhost:631/ (by default it is only accessible from
>> the local machines, not the network).
>>
>> Do the invoices show up under the "Jobs" tab of that webpage?
>> I believe they should show as "Name: (stdin)" "User: apache".
>
> On my system, every once in awhile, cups has a problem. Using the
> http://localhost:631/ gui interface, my printer appears to be printing
> and then completes, but nothing appears on the printer (the printer  
> even
> blinks and then stops blinking).
>
> I just 'stop' the printer, and restart it. Usually this fixes the
> problem. (probably a design flaw in the printer protocol).

Yes - I meant to mention in my previous post that CUPS misbehaves for  
me, too. For no apparent reason It'll often need a restart (`/etc/ 
init.d/cupsd restart`), but this is sufficient to start printing again.

Stroller.

Re: [SL] printing

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

Please don't top-post in reply to a bottom-post. Top-post all you
like if you're the first respondent to a thread and I would ask
anyone replying to you not to bottom-post when they follow you. But
mixing the two is more annoying and less legible than either.

I've fixed it for you:

On 2 Jun 2007, at 16:20, Bill Dika wrote:
> On 6/2/07, Stroller <lin...@my...> wrote:
>> On 1 Jun 2007, at 22:14, Bill Dika wrote:
>>>  ...
>>>  I have cups installed.
>>>  ...
>>>  The problem is I can't print to the printer from SL. When I try to
>>>  print an invoice to the printer using either postscript or pdf,  
>>> I get
>>>  nothing. The browser seems to refresh but the printer is silent.
>>>  Nothing happens.
>>
>> CUPS has a web-interface which runs on port 631 - i.e. you can access
>> it via http://localhost:631/ (by default it is only accessible from
>> the local machines, not the network).
>>
>> Do the invoices show up under the "Jobs" tab of that webpage?
>> I believe they should show as "Name: (stdin)" "User: apache".
>
> Thanks for the reply.
>
> The CUPS administration web-interface shows no jobs, neither active
> nor completed after I try to print an invoice to printer with
> postscript or pdf in SL. The web-interface also doesn't show anything
> for active jobs or completed jobs when I print from OpenOffice Calc,
> although the sheet prints out.
>
> Does this indicate a problem with CUPS?

This would tend to suggest to me that your printer configuration is  
not using CUPS, but (presumably?) old-fangled lpr instead. Or maybe  
CUPS simply isn't logging?

I'm afraid I can't add much helpful to this part of the conversation  
because CUPS has worked seamlessly for me on the couple of occasions  
I've set it up, and I have had to do very little debugging.

The CUPS webpage has an option to send a test page to the printer.  
Does this work?

Actually, this should make little difference to your problem - if you  
can `cat textfile | lpr -Php_lj_1020` then I think printing from SL  
should work. I think this failure to do so indicates an SL problem or  
bug.

To be absolutely sure you could grab a copy of the invoice.ps or  
invoice.pdf (by emailing it to yourself, for instance) and try  `cat  
invoice.ps |  | lpr -Php_lj_1020`. I'm not familiar with the LJ1020  
but it would be good to demonstrate that postscript is working with  
your printer, as that is required to interpret SL's output. I don't  
believe that Postscript is needed for printing a textfile.

Stroller.

Re: [SL] printing

[Bob G. <bo...@rc...>]

On my system, every once in awhile, cups has a problem. Using the
http://localhost:631/ gui interface, my printer appears to be printing
and then completes, but nothing appears on the printer (the printer even
blinks and then stops blinking).

I just 'stop' the printer, and restart it. Usually this fixes the
problem. (probably a design flaw in the printer protocol).

On Sat, 2007-06-02 at 12:46 +0100, Stroller wrote:
> On 1 Jun 2007, at 22:14, Bill Dika wrote:
> > ...
> > I have cups installed.
> > ...
> > The problem is I can't print to the printer from SL. When I try to
> > print an invoice to the printer using either postscript or pdf, I get
> > nothing. The browser seems to refresh but the printer is silent.
> > Nothing happens.
> 
> CUPS has a web-interface which runs on port 631 - i.e. you can access  
> it via http://localhost:631/ (by default it is only accessible from  
> the local machines, not the network).
> 
> Do the invoices show up under the "Jobs" tab of that webpage?
> I believe they should show as "Name: (stdin)" "User: apache".
> 
> Stroller.
> 
> 
> -------------------------------------------------------------------------
> 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