sql-ledger-users — SQL-Ledger users

Re: [SL] Session Expired! message on SQL Ledger 2.6.12 - same now on 2.6.19

[David T. <ta...@ex...>]

On Tue, 2006-07-04 at 10:13 -0400, Rich Cloutier wrote:
> 
> Neil Tancock wrote:
> > Hi All, I've been through the FAQ but can't seem to find and answer to this
> > - can you help?
> >
> > I've logged in to SL and every page comes up with "Session Expired" and I
> > have to supply the admin password again - how can I resolve this?
> >  
> > Many thanks,
> >  
> > Neil
> If it always comes up instantly, there is probably a mismatch between 
> your cookie and the server time. Try erasing your cookies.
> 
> Rich C.

I have just upgraded Ubuntu from Dapper to Edgy release: a total of over
1000 packages. Every package installed ok. However so far I have found
one problem, and its in sql-ledger. The upgrade brought SL 2.6.19 in.
Now I get the same problem as above. I cannot get any page in SL to
work.

I do not see any cookie relating to my PC, ie 192.168.x.x and expect a
sql-ledger cookie would be under that IP address.

Its seems to be related to how security is handled or not in SL and I
seem to remember this whole issue of security being discussed a few
months back. However the closest I get to this sort of problem is as per
the quoted above.

I tried setting the timeout per user from 3600 to 0 but this did not
help.

Anyway, in a nutshell, how do I get SL to work again?

Thanks.

Re: [SL] Adding extra custom reports

[Christopher M. <chr...@gm...>]

On 11/3/06, Dieter Simader <dsi...@sq...> wrote:
> > I can't quite figure out where the custom code gets loaded to debug this
> > - any pointers please?

 The custom code gets loaded early on in menu.pl. First
/bin/mozilla/foo.pl is loaded (which are a bunch of functions), then
the custom_foo.pl, followed by user_costom_foo.pl (if it exists). The
idea being that these custom scripts re-define (and therefore
over-ride) functions in foo.pl. Custom scripts are loaded before any
authentication is done, so you don't want them to actually do work,
just over-ride function definitions in the other scripts. Yes, the
flow is a bit odd.

> Maybe someone over at the ledgersmb fork can help you free of charge.
> After all that's what they wanted anyways. So, let's see if they can
> follow through with community support.

 We would be happy to. We've changed the scripts somewhat and removed
the unnecessary duplication of bin/mozilla and bin/lynx scripts, and
we've put the custom scripts into their own directory (bin/custom),
but for the most part, the customization is fairly similar. Bring your
question to the lsmb-users or lsmb-devel list, I'm sure someone there
will be able to help you out. We've got plans for a whole slew more
reports, with a lot of near-working code I believe. So, if your report
is something that needed you might have some help building it, but at
the very least you will get some advice on how to do it.

Cheers,

Chris

Re: [SL] Adding extra custom reports

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

On Wed, 1 Nov 2006, Ed W wrote:

> Hi
>
> I am trying to add some extra custom reports to some of the screens.  I
> created bin/mozilla/custom_is.pl with the following content
>
>     $form->{selectformname} .= qq|<option
> value="address_labels_a4">|.'Address Labels';
>     1;
>
>
> However, this is not affecting the resulting form.  I have tested that
> this works ok to adjust simple things like "copies" - what do I need to
> do differently to affect the list of available reports?
>
> I can't quite figure out where the custom code gets loaded to debug this
> - any pointers please?

Maybe someone over at the ledgersmb fork can help you free of charge.
After all that's what they wanted anyways. So, let's see if they can
follow through with community support.

I could help you too but since time is money and my time seems to be too
expensive for you try an alternative. East Indian and Russian labor is
cheap too.

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

Re: [SL] importing csv files

[Christopher M. <chr...@gm...>]

On 11/3/06, Ed W <li...@wi...> wrote:
> I'm getting into Rails right now and building some small apps for our
> business.  I am actually working on a web facing frontend for SQLledger
> so that people can pay their bills directly.

Hi Ed,

 We've currently got an XML/RESTful API in the planning stages for
LSMB (a fork of SQL-Ledger), and we hope that it will also work with
SQL-Ledger (any folks here intersted in that, please let me know - we
could use some testing/coding help to ensure SL compatibility). If
this sounds interesting to you, please email me off-list or join our
-devel mailing list (info at http://ledgersmb.org/help/ - follow
mailing list link).

> I have to say that SQL-Ledger is rather a pain in the arse - it's a nice
> looking product, but there is minimal support and fairly slow
> development.  The code is quite messy as well.

 While you might not like some of the style and structure of the code,
SL does have a pretty decent feature set. BTW, we've done a major
cleanup of the code (all of which Dieter is free to use or toss at his
discretion of course - our changes are in a public svn repository) and
are on the cusp of a new release which has a lot of changes and
enhancements. We have 5 active developers and are moving at a fairly
fast pace. SL users can benefit from our changes and still use SL if
that's their preference. I hope that Dieter will take our changes (or
at least the ones that he likes) and that it will save him work and
benefit his users, but I don't want to pressure him either way.

Cheers,

Chris

Re: [SL] importing csv files

[Ed W <li...@wi...>]

Oh darn.  Was supposed to be mailed offlist.  Guess I probably just 
seriously irritated Dieter now...  (Will teach me to keep my opinions to 
myself...)

Sorry folks

Ed W

Re: [SL] importing csv files

[Ed W <li...@wi...>]

Nathan Leach wrote:
> One option I have used is to write an app in Ruby on Rails that
> integrates with SL.  With Rails ActiveRecord you just give the name of
> the table representing your object and you can then address fields as
> attributes.  Ruby has built-in libraries for dealing with CSV, so
> getting data in from there is no problem.
>
> This is most effective for what I call "master" data (parts, customers,
> etc.), but be careful of the ID sequences that SL uses.  I had trouble
> with those until I found out how to specify them within ActiveRecord.
>
> I won't bore the entire list with more details, but if you are
> interested contact me off list.
>
>   

Hi Nathan

I'm getting into Rails right now and building some small apps for our 
business.  I am actually working on a web facing frontend for SQLledger 
so that people can pay their bills directly. 

I would be curious to see what kind of things you have done with rails 
because you are obviously diving directly into the data rather than 
going via the http interface?  I haven't really plugged through the 
tables - is there a quickstart guide that you can offer?

I have to say that SQL-Ledger is rather a pain in the arse - it's a nice 
looking product, but there is minimal support and fairly slow 
development.  The code is quite messy as well. (Having bought the manual 
I wrote to Dieter to request a feature and he sent me an estimate of 
$16,000 to implement it... Outside of my budget and not what I would 
call supportive - he keeps blocking my emails to the list it seems and I 
sent him at least one patch and didn't even get a reply that it was 
received...)

I would love to have the time to write an alternative in Ruby - I think 
a rip off would be possible in just a few months, the trick is having a 
few months free to write it...

Regards

Ed Wildgoose

Re: [SL] Timeouts

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

Can you access it internally via https ?

-vlado

On Thu, 2 Nov 2006, Steve Jacobs wrote:

> We have sql-ledger set up on a local ubuntu server and when accessing it
> locally across the network, we are getting time-outs at times far shorter
> than what we have set up in the user files. Any ideas as to what could cause
> this?
>
> As a matter of interest, we have set it up so that it can be accessed
> externally via https and we don't get those timeouts then.
>
> Any help greatly appreciated
>
> Steve Jacobs
> Dublin
>
>
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>

Re: [SL] ASSEMBLY

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

Stroller wrote:
> On 29 Oct 2006, at 19:27, RYAN M. vAN GINNEKEN wrote:
>   
>> Is there a was to list the individual items on the invoice for  
>> assemblies?  Example i built an assembly called basic system 1 it  
>> includes the following parts;
>> case, mainboard, cpu, ram, harddisk, dvdrw
>>
>> When I email the invoice i only get basic system 1 and no listing  
>> of the individual parts i wish to have a listing of the individual  
>> parts and want to be able to modify the discription ie for CPU  
>> INTEL P4 CORE DAUL as basic parts do not change but models seem to  
>> change almost daily.
>>
>> Am i going about this the wrong way is there a better way?
>>     
>
> Just a quick note - I don't know that I can be immensely helpful to  
> you, but seeing as no-one else has replied...
>
> I don't think assemblies are really intended to be used this way -  
> they way they seem to work is that they're more useful for a  
> manufacturer to manage a stock of parts which should be invisible to  
> the user.
If you want an assemblie's components to print out on your invoice then 
you need to check the BOM radio button for each of the components that 
you want displayed.  If the BOM button isn't checked then the invoice 
only prints the top level (assembly line).

Dunc

Re: [SL] ASSEMBLY

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

On 29 Oct 2006, at 19:27, RYAN M. vAN GINNEKEN wrote:
>
> Is there a was to list the individual items on the invoice for  
> assemblies?  Example i built an assembly called basic system 1 it  
> includes the following parts;
> case, mainboard, cpu, ram, harddisk, dvdrw
>
> When I email the invoice i only get basic system 1 and no listing  
> of the individual parts i wish to have a listing of the individual  
> parts and want to be able to modify the discription ie for CPU  
> INTEL P4 CORE DAUL as basic parts do not change but models seem to  
> change almost daily.
>
> Am i going about this the wrong way is there a better way?

Just a quick note - I don't know that I can be immensely helpful to  
you, but seeing as no-one else has replied...

I don't think assemblies are really intended to be used this way -  
they way they seem to work is that they're more useful for a  
manufacturer to manage a stock of parts which should be invisible to  
the user.

For example, if you're selling an action man figure then it might  
consist of 2 x leg, 2 x arm, 1 x body, 1 x male head, 1 x cropped  
hair; a barbie doll would consist of 2 x leg, 2 x arm, 1 x body, 1 x  
female head, 1 x blonde wig; assuming the body parts are the same for  
both male and female figures (eg Lego) then the manufacturer will  
know stock from the number of units assembled. If an Aliens product  
range featuring a Sigourney Weaver action figure is added to the  
range then the female head can be used with the cropped hair - stock  
is managed appropriately but is not of interest to the customer, who  
just wants the doll.

Assuming that SL will always hide the components of assemblies on the  
invoice (as I think it must, because an assembly is a new item) there  
seem to be two possible approaches when assembling PCs:
- build the assembly and give the basic system a descriptive name: eg  
the ComputerKing 64. At the end of the day many customers buying a  
computer just want something that works, and don't care about the  
specific components within it. If they did then they'd build it  
themselves.
- sell the user individual components and charge an "assembly fee"  
for building the computer for them. If the user really needs to know  
the exact model of the graphics card & the size of the RAM then  
they're able to make comparison pricing of those parts, anyway, and  
work out what you're effectively charging them for building them.

Sorry if this isn't immensely helpful - I think that this feature  
isn't intended to work the way that suits you, and I can see why.  
Really, the assembly is no longer a collection of parts but a whole  
new item; this makes particular sense when building (for instance) an  
electronic circuit-board - after they have been soldered to the board  
& their legs clipped off resistors cannot not be returned to stock  
and sold separately.

Stroller.

Re: [SL] pdf and freebsd

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

On 1 Nov 2006, at 08:33, Luc van Stappershoef wrote:
>>
>>> Any good tutorials or threads on customizing pdf templates
>>
>> There are no pdf templates per se but latex templates. You can get  
>> a lot
>> of literature at http://www.tug.org
>
> FYI: Openoffice 2.04 is now able to export to latex

In desperation, trying to work out why a format wasn't working on my  
invoice.tex, I tried Openoffice's exported LaTeX this week. For our  
purposes, at least, it seems quite terrible, and I wouldn't recommend  
it.

The release notes for OO 2.04 say:
    Feature list for the latex export filter Note: We can not establish
    any further contact to the developer so I write this Changes mail
    on basis of the features I found while testing.

And yesterday I would have told you that there was no apparent  
activity on the website for Writer2LaTeX - the convertor on which  
this feature of OO is based - in the last 15 months. <http://www.hj- 
gym.dk/~hj/writer2latex/>

I think that something like lyx would be far more useful if you want  
a graphical mark-up for LaTeX. After a gew days of stumbling with  
this language I am finally finding it very effective.

Stroller.

[SL] Conditionals in invoice.tex template?

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

Hi there,

I want to make an SQL-Ledger variable field display in my invoice =20
only if the value is greater than one. Is there any way to achieve =20
this? I'm guessing not, but throw it out for discussion just in case; =20=

I don't want to modify SL itself to do this - it's not important =20
enough for me to maintain a patchset, but it'd be kinda cute for me =20
if it were possible.

What I want to do is make the quantity & price fields display only if =20=

the customer has bought more than one item:

Part no.	Description				Price	Qty	=
Amount
FH001	French Hen				=A310		x 3	=
=A330=09
TD001	Turtle Dove				=A310		x 2	=
=A320
PA001	Partridge in a Pear Tree					=
=A310
TOTAL										=
=A360

I've laid out the above with tabs, so I hope it displays as well on =20
other clients as it does on my Mac. Anyway, I suspect this is an =20
unusual request & not possible, but I would prefer being able to use =20
such a simplified & "user friendly" format in my invoices.

I have tried:

\begin{tabularx}{\textwidth}{lXrlr}
   Part & Description & Price & & Amount \\
   <%foreach number%>
     <%number%> &
     <%description%> &
     \pounds <%sellprice%> &
     <%if qty%> x <%qty%> <%end qty%> &
     \pounds <%linetotal%> \\    % end of table row
   <%end number%>
\end{tabularx}

But of course the minimum quantity of 1 always triggers the if-=20
statement.

Stroller.=

[SL] Timeouts

[Steve J. <st...@db...>]

We have sql-ledger set up on a local ubuntu server and when accessing it
locally across the network, we are getting time-outs at times far shorter
than what we have set up in the user files. Any ideas as to what could =
cause
this?

As a matter of interest, we have set it up so that it can be accessed
externally via https and we don't get those timeouts then.=20

Any help greatly appreciated

Steve Jacobs
Dublin

[SL] Backup/Restore ?

[<yb...@gm...>]

Hi ALL;

I did backup..How can I restore it (System > Back-To-File)
(I've phppgadmin & webmin installed)
Sarge3.1-3 & Sql-Ledger 2.6.19
---
Thanks  &  All  the  Best;
YassinB

[SL] cell phone number

[RYAN M. v. G. <lu...@co...>]

In the customers menu there does not seem to be a field for a cell phone most of my clients need to be reached via this number. I have added it in the notes section for the time being but am working on a custom latex quotation and invoice and would also like the cell phone # to show up there. 

This would be very helpful for me because i sometimes need to call the client for directions/instructions during deliveries, and always have there invoices handy. 

-- 
Computer King/ CaNMail 

http :// www . computerking .ca http :// www . canmail .org 

Sales, Service, and Hosting 
Email, Data, and Web Packages 
Ask about web design specials 

Affiliates 
http :// www . computerking .ca/pages/links/affiliates/affiliates. htm 

Maybe Computer Science should be in the College of Theology. -- R. S. Barton 

Re: [SL] importing csv files

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

r.v...@ch... wrote:=20
> Well maybe you should write something yourself, i've done so by =
writing=20
> a php script that's able to import our suppliers products by reading =
a=20
> comma delimited file.
> PHP is great language to use for such kinda things i think...
>=20
> Remco

Well, maybe for someone who can actually WRITE PHP <g>.

Danita

[SL] Adding extra custom reports

[Ed W <li...@wi...>]

Hi

I am trying to add some extra custom reports to some of the screens.  I 
created bin/mozilla/custom_is.pl with the following content

    $form->{selectformname} .= qq|<option 
value="address_labels_a4">|.'Address Labels';
    1;


However, this is not affecting the resulting form.  I have tested that 
this works ok to adjust simple things like "copies" - what do I need to 
do differently to affect the list of available reports?

I can't quite figure out where the custom code gets loaded to debug this 
- any pointers please?

Thanks

Ed W

Re: [SL] importing csv files

[Nathan L. <nat...@ph...>]

One option I have used is to write an app in Ruby on Rails that
integrates with SL.  With Rails ActiveRecord you just give the name of
the table representing your object and you can then address fields as
attributes.  Ruby has built-in libraries for dealing with CSV, so
getting data in from there is no problem.

This is most effective for what I call "master" data (parts, customers,
etc.), but be careful of the ID sequences that SL uses.  I had trouble
with those until I found out how to specify them within ActiveRecord.

I won't bore the entire list with more details, but if you are
interested contact me off list.

Thanks,
Nathan

On Wed, 2006-11-01 at 04:27 -0700, Dieter Simader wrote:
> On Wed, 1 Nov 2006, Graeme Bruton wrote:
>
> > Hi all
> >
> > This may be slightly off the real topic, but I import clients from a csv
> > sheet using the command line in psql every once in a while (new members to a
> > sports club), but I can't find the field to select "Tax Included", so I have
> > to manually go and select the radio button on each new client. Does anyone
> > know how I can get around this?
>
> You could purchase technical support which includes the ERD.
>

Re: [SL] importing csv files

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

On Wed, 1 Nov 2006, Graeme Bruton wrote:

> Hi all
>
> This may be slightly off the real topic, but I import clients from a csv
> sheet using the command line in psql every once in a while (new members to a
> sports club), but I can't find the field to select "Tax Included", so I have
> to manually go and select the radio button on each new client. Does anyone
> know how I can get around this?

You could purchase technical support which includes the ERD.

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

Re: [SL] importing csv files

[Graeme B. <gb...@te...>]

Hi all

This may be slightly off the real topic, but I import clients from a csv
sheet using the command line in psql every once in a while (new members to a
sports club), but I can't find the field to select "Tax Included", so I have
to manually go and select the radio button on each new client. Does anyone
know how I can get around this?

Graeme

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...]On Behalf Of
Remco van Vugt - Chris Hectors Compuvision
Sent: Wednesday, November 01, 2006 10:59 AM
To: sql...@li...
Subject: Re: [SL] importing csv files


Well maybe you should write something yourself, i've done so by writing
a php script that's able to import our suppliers products by reading a
comma delimited file.
PHP is great language to use for such kinda things i think...

Remco


Danita Zanre schreef:
>> Quickbooks is pretty much a 'Hotel California' for transaction data. They
go
>> to great lengths to  prevent you from getting transaction data.
>>
>
> I know - that's why I don't use it any longer <g>.  I'm not actually
looking to convert Quickbooks data.  I'm looking to import data into
SQL-Ledger through ascii delimited files.  For example, we moved to Paypal
Website Payments Pro for our online credit card processing company - we can
download transactions in various formats: comma delimited, tab delimited,
Quicken or Quickbooks.  I'd be happy with an import tool that could handle
any of those really.
>
> Danita
>
>
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job
easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

--
Met vriendelijke groet,

Remco van Vugt
- Chris Hectors Compuvision
E: r.v...@ch...
T: 0164-674935


-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job
easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] importing csv files

[Remco v. V. - C. H. C. <r.v...@ch...>]

Well maybe you should write something yourself, i've done so by writing 
a php script that's able to import our suppliers products by reading a 
comma delimited file.
PHP is great language to use for such kinda things i think...

Remco


Danita Zanre schreef:
>> Quickbooks is pretty much a 'Hotel California' for transaction data. They go 
>> to great lengths to  prevent you from getting transaction data.
>>     
>
> I know - that's why I don't use it any longer <g>.  I'm not actually looking to convert Quickbooks data.  I'm looking to import data into SQL-Ledger through ascii delimited files.  For example, we moved to Paypal Website Payments Pro for our online credit card processing company - we can download transactions in various formats: comma delimited, tab delimited, Quicken or Quickbooks.  I'd be happy with an import tool that could handle any of those really.
>
> Danita
>
>
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>   

-- 
Met vriendelijke groet,

Remco van Vugt
- Chris Hectors Compuvision
E: r.v...@ch...
T: 0164-674935

Re: [SL] pdf and freebsd

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

FYI: Openoffice 2.04 is now able to export to latex


Asante, Emmanuel [ING-WBK] wrote:
>  
>
>   
>> WOW that was to easy it just worked thank you all i had to do 
>> was intall tetex from the ports tree and everything is 
>> working. I love FreeBSD when it works which is almost always, 
>> but seriously that was the easiest intall ever.
>>
>> Any good tutorials or threads on customizing pdf templates
>>
>> THANK YOU ALL
>>     
>
> There are no pdf templates per se but latex templates. You can get a lot
> of literature at http://www.tug.org
>
> This message and any attached files may contain information that is confidential and/or subject of legal privilege intended only for use by the intended recipient. If you are not the intended recipient or the person responsible for delivering the message to the intended recipient, be advised that you have received this message in error and that any dissemination, copying or use of this message or attachment is strictly forbidden, as is the disclosure of the information therein. If you have received this message in error please notify the sender immediately and delete the message.
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
>
>   

Re: [SL] pdf and freebsd

[Asante, E. [ING-WBK] <Emm...@bh...>]

=20

>=20
> WOW that was to easy it just worked thank you all i had to do=20
> was intall tetex from the ports tree and everything is=20
> working. I love FreeBSD when it works which is almost always,=20
> but seriously that was the easiest intall ever.
>=20
> Any good tutorials or threads on customizing pdf templates
>=20
> THANK YOU ALL

There are no pdf templates per se but latex templates. You can get a lot
of literature at http://www.tug.org

This message and any attached files may contain information that is=
 confidential and/or subject of legal privilege intended only for use by=
 the intended recipient. If you are not the intended recipient or the=
 person responsible for delivering the message to the intended recipient,=
 be advised that you have received this message in error and that any=
 dissemination, copying or use of this message or attachment is strictly=
 forbidden, as is the disclosure of the information therein. If you have=
 received this message in error please notify the sender immediately and=
 delete the message.

Re: [SL] pdf and freebsd

[RYAN M. v. G. <lu...@co...>]

WOW that was to easy it just worked thank you all i had to do was intall tetex from the ports tree and everything is working. I love FreeBSD when it works which is almost always, but seriously that was the easiest intall ever.

Any good tutorials or threads on customizing pdf templates

THANK YOU ALL


----- Mark Blackman <ma...@ex...> wrote:
> On 31 Oct 2006, at 09:04, Asante, Emmanuel [ING-WBK] wrote:
> 
> >
> >
> >>
> >> Hello can anyone give me some pointers on where to begin
> >> creating pdf invoces?  Using FreeBSD and all i get for clues
> >> i a big red error message.  Not sure where to begin guessing
> >> i need some packages installed first.
> >>
> >> --
> >
> > Ryan,
> >
> > You need to install Latex. On my Debian box I installed tetex but I 
> 
> > don't know what the Latex package is called on FreeBSD. Find out  
> > what it's called and install it.
> 
> It will be tetex as well.
> 
> http://www.freshports.org/print/teTeX
> 
> >
> > Regards,
> > Emmanuel
> >
> > This message and any attached files may contain information that is 
> 
> > confidential and/or subject of legal privilege intended only for  
> > use by the intended recipient. If you are not the intended  
> > recipient or the person responsible for delivering the message to  
> > the intended recipient, be advised that you have received this  
> > message in error and that any dissemination, copying or use of this 
> 
> > message or attachment is strictly forbidden, as is the disclosure  
> > of the information therein. If you have received this message in  
> > error please notify the sender immediately and delete the message.
> >
> >
> ----------------------------------------------------------------------
> 
> > ---
> > Using Tomcat but need to do more? Need to support web services,  
> > security?
> > Get stuff done quickly with pre-integrated technology to make your 
> 
> > job easier
> > Download IBM WebSphere Application Server v.1.0.1 based on Apache  
> > Geronimo
> > http://sel.as-us.falkag.net/sel? 
> > cmd=lnk&kid=120709&bid=263057&dat=121642
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> 
> 
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services,
> security?
> Get stuff done quickly with pre-integrated technology to make your job
> easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache
> Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users


-- 
Computer King/CaNMail

http://www.computerking.ca     http://www.canmail.org

Sales, Service, and Hosting
Email, Data, and Web Packages
Ask about web design specials

Affiliates
http://www.computerking.ca/pages/links/affiliates/affiliates.htm

Maybe Computer Science should be in the College of Theology. -- R. S. Barton 

Re: [SL] importing csv files

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

>Quickbooks is pretty much a 'Hotel California' for transaction data. They =
go=20
>to great lengths to  prevent you from getting transaction data.

I know - that's why I don't use it any longer <g>.  I'm not actually =
looking to convert Quickbooks data.  I'm looking to import data into =
SQL-Ledger through ascii delimited files.  For example, we moved to Paypal =
Website Payments Pro for our online credit card processing company - we =
can download transactions in various formats: comma delimited, tab =
delimited, Quicken or Quickbooks.  I'd be happy with an import tool that =
could handle any of those really.

Danita

Re: [SL] Carrect VAT amount

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

Paul.. that is brilliant !

Thanks for the reply.

Cheers,
Roy P

On Monday 30 October 2006 4:24 pm, Paul Langard wrote:
> WIth regard to adjusting VAT rounding differences on AP invoices, we  
> found this works well to adjust the tax:
> 
> - set up a service "VATable rounding" which is taxable (price 0.01)
> - set up another service "NON VATable service" which is non taxable  
> (price 0.01)
> 
> You can then combine different quantities of these services, positive  
> and negative, to adjust your tax without affecting the net total.
> 
> For example, to increase tax, add a positive quantity of VATable  
> rounding service and then add an equal negative quantity of NON  
> VATable rounding - this leaves your net total unchanged but increases  
> the amount of tax.
> 
> We have been using this for a few years now and whilst we end up with  
> two extra lines on the occasional AP invoice, we find it works really  
> neatly and our ledger then balances to our suppliers without having  
> to write amounts off or back etc.
> 
> Does that sound useful?
> 
> Paul.
> 
> On 30 Oct 2006, at 21:13, R Pennington wrote:
> 
> > Not a bad idea Olle.
> > That should help a few people.
> >
> > But, the problem is, that method adjusts the subtotal...not the TAX.
> > I need a way to adjust the tax....not the subtotal.
> >
> >
> > Cheers !
> > Roy