sql-ledger-users — SQL-Ledger users

[SL] Question about pricegroup and pricelist

[Gianluca C. <gc...@pe...>]

When I edit a part I see at the bottom a section with items:
Customer, Pricegroup, break, ecc
Can I have more than one line for this?
So that a part can have different settings for different
customers/pricegroups ?

When I instead edit a customer I se the button pricelist. When pressed
it goes to another screen: is this supposed only for retrieving or how
can I Add itemes to this?
The numebr column is related to partnumber or what?
Thanks in advance.


Gianluca=20

Re: [SL] Invoice with full details?

[Jeff K. <jt...@ya...>]

----- Original Message ----=0AFrom: Tony Fraser <to...@sy...>=0ATo: =
sql...@li...=0ASent: Friday, July 14, 2006 8:05:0=
9 PM=0ASubject: Re: [SL] Invoice with full details?=0A> > ... I have a nice=
 summary of my notes from the related time cards. =0A> > Is there any easy =
way to get those notes onto the printed Invoice? =0A> =0A> You'd have to mo=
dify your invoice template but the field your talking =0A> about is availab=
le withing the =0A>   <%foreach number%> .... <%end number%> part as =0A>  =
 <%itemnotes%>=0A=0ACan anyone suggest a tex syntax for handling long itemn=
otes? When I make the following change to invoice.tex, get whitespace where=
 the itemnotes (a few hundred characters long) should be. Omitting <%itemno=
tes%> does display the item numbering, so it seems the loop can be reused. =
I don't generally put linebreaks in the timecard descriptions, so they may =
not be linewrapping.=0A=0A@@ -178,6 +178,9 @@=0A \vspace{12pt}=0A =0A <%not=
es%>=0A+<%foreach number%>=0A+  <%runningnumber%>) & <%itemnotes%> \\=0A+<%=
end number%>=0A }=0A =0A \vfill=0A=0AI'd also like to make sure the itemnot=
es pagebreak properly, if they run that long or are that numerous. Thanks.=
=0A=0A=0A=0A=0A

[SL] R: Moving SQL-Ledger to another server

[Gianluca C. <gc...@pe...>]

It seems quite unsecure in general as config....
With this config you:
Allow any user on the local system to connect to any database under
any database user name using Unix-domain sockets (the default for local
connections).=20
Depending on the fact that on this server there are local connected =
linux users or not, it could be a problem...
Connecting via web you use in effect unix domain sockets, if the web and =
db are the same machine.

Suppose db and web server are different and you have two different =
postgresql databases on your db-system, one used for sql-ledger (named =
gl) and the other for different purposes (es. named nogl).
In sql-ledger setup you create a database user named "sledger" to =
establish connections to the db and you want to allow access to your db =
through you local lan 192.168.0/24 and you want to use the db password =
for the authentication, so that you don't need to create  a Linux user =
for this on the db-system, you can put a line similar to this:

host    gl         sledger  192.168.0.0/24        md5 =20

In this way one can connect only to the gl db, only from 192.168.0.0/24 =
and only with the db user sledger. For authentication against the db =
will be performed md5 encryption.
Other useful examples to better understand the whole logic can be found =
for the various db versions at the links:
http://www.postgresql.org/docs/7.3/static/client-authentication.html
http://www.postgresql.org/docs/7.4/static/client-authentication.html
http://www.postgresql.org/docs/8.0/static/client-authentication.html
http://www.postgresql.org/docs/8.1/static/client-authentication.html

Probably minor differences between them
HIH
Gianluca


> -----Messaggio originale-----
> Da: sql...@li...=20
> [mailto:sql...@li...] Per=20
> conto di Danita Zanre
> Inviato: mercoled=EC 18 ottobre 2006 3.38
> A: sql...@li...
> Oggetto: Re: [SL] Moving SQL-Ledger to another server
>=20
> >If your new configuration is the same as your old one...=20
> maybe you can=20
> >use your old pg_hba file from the old server ?
>=20
> Alas, I managed to get the database backed up, along with my=20
> users and templates directories, and now that former server=20
> is all but dead!  Of course, I would swear that I had tried=20
> this once before, but I'm not going to fret over it - just be=20
> happy it's working now!
>=20
> I got this to work by using "trust" in the local line - not=20
> sure I like that, but until I can understand it better, at=20
> least that's something :)
>=20
> Thanks!
>=20
> Danita
>=20
>=20
>=20
> --------------------------------------------------------------
> -----------
> Using Tomcat but need to do more? Need to support web=20
> services, security?
> Get stuff done quickly with pre-integrated technology to make=20
> your job easier Download IBM WebSphere Application Server=20
> v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&
dat=3D121642
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>=20

Re: [SL] Is there any restrictions on which characters can be used in the part descrption field ?

[Charley T. <li...@ti...>]

Stroller wrote:
> I am allowed to enter such customer details but if I then go into AR  
>  > Sales Invoice and enter "stroll" (without the quotes) only "Joe  
> Bill" (without the quotes) will be shown in the customer field. The  
> correct customer is identified, but not shown correctly.

This is an html formatting error.  Go to the Sales Invoice as you 
normally would and view source code of the frame.  I'm willing to bet 
that the entire name, including the double quotes, is there.

To fix this, the double quotes need to be encoded to the html equivalent 
before being output to the browser.  This will only happen within an 
input field of type text.

Charley

Re: [SL] Is there any restrictions on which characters can be used in the part descrption field ?

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

On 17 Oct 2006, at 20:53, Dieter Simader wrote:
> ...
> quotation marks are used to initiate an exact search. In order to do a
> search for a name with quotation marks you'd have to specify the  
> exact name
> including the quotation marks.

Sorry, I think you're misunderstanding my explanation. Sorry if I was  
unclear.

The correct way in English to include a nickname when writing a  
person's full name is just before the surname, in quotes.

So:
- George "Dubya" Bush
- Joe Bill "Stroller" Strollowowski
- Dieter "SQGuru" Simader

It does not seem possible to enter customer details in this way.

I am allowed to enter such customer details but if I then go into AR  
 > Sales Invoice and enter "stroll" (without the quotes) only "Joe  
Bill" (without the quotes) will be shown in the customer field. The  
correct customer is identified, but not shown correctly.

I am not sure what happens if you post a transaction in this state,  
but if you open another window, go back into AR > Customers > Reports  
 > Search and remove the customer's nickname from the entry then all  
is well again.

Stroller.

Re: [SL] Moving SQL-Ledger to another server

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

>If your new configuration is the same as your old one... maybe you can =
use=20
>your old pg_hba file from the old server ?

Alas, I managed to get the database backed up, along with my users and =
templates directories, and now that former server is all but dead!  Of =
course, I would swear that I had tried this once before, but I'm not going =
to fret over it - just be happy it's working now!

I got this to work by using "trust" in the local line - not sure I like =
that, but until I can understand it better, at least that's something :)

Thanks!

Danita

Re: [SL] Early payment discount and GST

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

On Sun, 15 Oct 2006 16:37:17 -0600, Dan R. Hunt wrote
> On 10/15/06, Andrew Dalgleish <op...@aj...> wrote:
> > I want to offer my customers a discount for early payment.
> >
> > If I set up an expense account to make partial payments
> > I end up paying (.au) GST on the full invoice.
> >
> > I want the discount to apply to the pre-tax amount.
> >
> > Any suggestions?
> 
> Andrew
> 
> I work with "payment terms discounts" here in Canada and our G.S.T. 
> is calculated on the full invoice price. If you were to choose to 
> "pay the invoice early" the Tax has been calculated and is set in 
> stone. ( No messing with taxes if you pay early just deduct the cash 
> amount from your payment.)
> 
> Despite the confusion I find it effective incentive to maintain cash 
> flow.
> 
> If they pay early you could issue them a credit invoice with a 
> expense account that is taxable also.
> 
> -- 
> Dan Hunt  Saint Brieux Saskatchewan Canada
> 
> -------------------------------------------------------------------------
> 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

early payment discount calculations are different in other parts of the 
world. The next mayor release will feature both types. The development 
version already has early payment discounts per GAAP.


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] Is there any restrictions on which characters can be used in the part descrption field ?

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

On Mon, 16 Oct 2006 12:28:51 +0100, Stroller wrote
> On 13 Oct 2006, at 22:06, R Pennington wrote:
> > Is there any restrictions on which characters can be used in alpha  
> > numeric fields like the part description ?
> > ... Are  /  and "  ok ?
> 
> I don't know what characters are supposed to be ok or not, but I can 
>  tell you that regular quotes (") don't work in the company name field.
> 
> If I save a customer called George "Dubya" Bush then create a new  
> sales invoice only `George` (without the quotes) will display in the 
>  customer field of the invoice entry page.
> 
> I would imagine there are very few people who are affected by this  
> feature in the way I am, however I have a database of several 
> hundred  customers, mostly individuals, some of whom might not call 
> me for 2  years. When preparing the invoice it would be easier to 
> search for  "Dubya", because I might not remember his real name -
>  he'll call me  up and say, "Hey, this is Dubya here, can you come 
> round & do some  work for me?" I can't make the invoice out to 
> "Dubya", but equally  I'd prefer not to have to admit to not 
> remembering a pertinent detail  about one of my customers (most of 
> whom treat me like a great, long- lost friend).
> 
> Like I say, there are probably few customers affected by this the 
> way  I am, they're probably all sole traders like me who will not be 
>  investing in adding quotes as a feature to SL, and it's not a big 
>  deal anyway as I can work around finding the guy's name by first  
> searching for his address. But ,y experience does help answer your 
>  question, I think.
> 
> I seem to recall that slashes have the same problem, but you can  
> check this on one of the demo installations of SL linked to from  
> Dieter's website - just create a new part, and try making a new  
> invoice in which it features.
> 
> Stroller.
> 
> -------------------------------------------------------------------------
> 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

quotation marks are used to initiate an exact search. In order to do a 
search for a name with quotation marks you'd have to specify the exact name 
including the quotation marks.

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] Early payment discount and GST

[John H. <jo...@dh...>]

Andrew Dalgleish writes:
> I want to offer my customers a discount for early payment.  If I set up
> an expense account to make partial payments I end up paying (.au) GST on
> the full invoice.

When you receive a payment that properly takes a discount Accounts
Receivable should be credited for the full amount of the invoice.  Cash
should be debited for the amount paid and Sales Discounts[1] debited for
the amount of the discount.  If the sale was taxed the latter debit should
be divided appropriately between Sales Discounts and Sales Tax.

> I want the discount to apply to the pre-tax amount.


[1] Sales Discounts used to be an expense but now it seems to be a
contra-revenue account.
-- 
John Hasler 
jo...@dh...
Elmwood, WI USA

Re: [SL] Is there any restrictions on which characters can be used in the part descrption field ?

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

On 13 Oct 2006, at 22:06, R Pennington wrote:
> Is there any restrictions on which characters can be used in alpha  
> numeric fields like the part description ?
> ... Are  /  and "  ok ?

I don't know what characters are supposed to be ok or not, but I can  
tell you that regular quotes (") don't work in the company name field.

If I save a customer called George "Dubya" Bush then create a new  
sales invoice only `George` (without the quotes) will display in the  
customer field of the invoice entry page.

I would imagine there are very few people who are affected by this  
feature in the way I am, however I have a database of several hundred  
customers, mostly individuals, some of whom might not call me for 2  
years. When preparing the invoice it would be easier to search for  
"Dubya", because I might not remember his real name - he'll call me  
up and say, "Hey, this is Dubya here, can you come round & do some  
work for me?" I can't make the invoice out to "Dubya", but equally  
I'd prefer not to have to admit to not remembering a pertinent detail  
about one of my customers (most of whom treat me like a great, long- 
lost friend).

Like I say, there are probably few customers affected by this the way  
I am, they're probably all sole traders like me who will not be  
investing in adding quotes as a feature to SL, and it's not a big  
deal anyway as I can work around finding the guy's name by first  
searching for his address. But ,y experience does help answer your  
question, I think.

I seem to recall that slashes have the same problem, but you can  
check this on one of the demo installations of SL linked to from  
Dieter's website - just create a new part, and try making a new  
invoice in which it features.

Stroller.

Re: [SL] Early payment discount and GST

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

Monday, 16 October 2006

Andrew
Settlement discounts are mostly best handled as a negative
adjustment (ie reduction) to the sale price, rather than as
an expense. 
If you treat the discount as an expense, is there GST "paid"
on this expense ?
You risk overstating both your GST collected, and GST paid,
(by the same amount).
Also, have a look at 29-75 of the GST Act, and be horrified
to see that you're supposed to issue an "Adjustment Note"
each time an original Tax Invoice is revised.
See also Tax Ruling GSTR 2000/1 for the specific details of
what your Adjustment Notes must contain.
IMHO, its best to issue a "Credit Note" (aka "Adjustment
Note"), in the usual way.  Whether you actually send the
note to your customers is another matter, but refer above.
The only downside to this approach is that your accounts
might not easily report the true costs to your business of
giving settlement discounts.
Cheers
David J


> I want to offer my customers a discount for early payment.
> 
> If I set up an expense account to make partial payments
> I end up paying (.au) GST on the full invoice.
> 
> I want the discount to apply to the pre-tax amount.
> 
> Any suggestions?
> 
> Regards,
> Andrew Dalgleish
>

Re: [SL] Early payment discount and GST

[Dan R. H. <dan...@gm...>]

On 10/15/06, Andrew Dalgleish <op...@aj...> wrote:
> I want to offer my customers a discount for early payment.
>
> If I set up an expense account to make partial payments
> I end up paying (.au) GST on the full invoice.
>
> I want the discount to apply to the pre-tax amount.
>
> Any suggestions?

Andrew

I work with "payment terms discounts" here in Canada and our G.S.T. is
calculated on the full invoice price. If you were to choose to "pay
the invoice early" the Tax has been calculated and is set in stone. (
No messing with taxes if you pay early just deduct the cash amount
from your payment.)

Despite the confusion I find it effective incentive to maintain cash flow.

If they pay early you could issue them a credit invoice with a expense
account that is taxable also.


-- 
Dan Hunt  Saint Brieux Saskatchewan Canada

Re: [SL] Early payment discount and GST

[GeorgeOsvald <geo...@ya...>]

On Monday 16 October 2006 06:48, Andrew Dalgleish wrote:
> I want to offer my customers a discount for early payment.
>
> If I set up an expense account to make partial payments
> I end up paying (.au) GST on the full invoice.
>
> I want the discount to apply to the pre-tax amount.


Set up a service called "Early payment discount" and make another invoice but 
with negative amount. GST will also be in negative.

[SL] Early payment discount and GST

[Andrew D. <op...@aj...>]

I want to offer my customers a discount for early payment.

If I set up an expense account to make partial payments
I end up paying (.au) GST on the full invoice.

I want the discount to apply to the pre-tax amount.

Any suggestions?

Regards,
Andrew Dalgleish

Re: [SL] Escaping "&" in command line interface

[Charley T. <li...@ti...>]

Jeff Vian wrote:
> On Sun, 2006-10-15 at 10:06 -0500, Charley Tiggs wrote:
>> Howdy,
>>
>> Is it possible to escape the "&" char within the command-line interface?
>>
>> Below is a sample of what I have to import for a vendor.  There are 
>> about 40 vendors within my file of some 480 to import (I'm moving client 
>> from an old solution to SL).  Is it possible to escap the "&" so that it 
>> doesn't throw off everything else?  If so, how do I do so?
>>
> That looks nasty and AFAIK cannot be directly imported.
> You need to do some manipulation of the data format to create records
> from that so an sql command can do the import.
> 
> Text fields require delimiters to define the field, periods are a
> problem since they are an sql operator, and data has to be in fields of
> a record structure in order to do any of that.
> 
> name, address1, address2, city, state, zipcode, country, \ 
> contact, phone, fax, email, shiptoname, shiptoaddress1, ...
> 
> "J&B Imports,Inc.", "PO Box XXXXX", "", "Miami", "FL", 55555, "USA",\
> "John", "", "", "", "J&B Imports,Inc.", "PO Box XXXXX", ...

Thanks for the reply, Jeff.  Your reply clued me in to a possible way to 
handle it that worked.  Convert the "&" to the url-encoded equivalent: 
"%26".  Now all of my vendors import just jim dandy.  Thanks again for 
the help!

Charley

Re: [SL] Escaping "&" in command line interface

[Jeff V. <jv...@ch...>]

On Sun, 2006-10-15 at 10:06 -0500, Charley Tiggs wrote:
> Howdy,
> 
> Is it possible to escape the "&" char within the command-line interface?
> 
> Below is a sample of what I have to import for a vendor.  There are 
> about 40 vendors within my file of some 480 to import (I'm moving client 
> from an old solution to SL).  Is it possible to escap the "&" so that it 
> doesn't throw off everything else?  If so, how do I do so?
> 
That looks nasty and AFAIK cannot be directly imported.
You need to do some manipulation of the data format to create records
from that so an sql command can do the import.

Text fields require delimiters to define the field, periods are a
problem since they are an sql operator, and data has to be in fields of
a record structure in order to do any of that.

name, address1, address2, city, state, zipcode, country, \ 
contact, phone, fax, email, shiptoname, shiptoaddress1, ...

"J&B Imports,Inc.", "PO Box XXXXX", "", "Miami", "FL", 55555, "USA",\
"John", "", "", "", "J&B Imports,Inc.", "PO Box XXXXX", ...

Are examples of conversions that AFAIK are needed. The first line is the
header line which gives the field names, the next is the matching data
from your example.  Note that I only included some of the fields.

-------------------------

To explicitly answer your question about the &,  a simple perl script
can read each line and return the line minus the & characters, so it can
do a quick pass and conversion for you.  
Sed and awk are two other tools that can do similar conversions.

> Charley
> 
> ./ct.pl "name=J&B Imports,Inc.
> &address1=PO Box XXXXX
> &address2=
> &city=Miami
> &state=FL
> &zipcode=55555
> &country=USA
> &contact=John
> &phone=
> &fax=
> &email=
> &shiptoname=J&B Imports,Inc.
> &shiptoaddress1=PO Box XXXXX
> &shiptoaddress2=
> &shiptocity=Miami
> &shiptostate=FL
> &shiptozipcode=55555
> &shiptocountry=USA
> &shiptocontact=John
> &shiptophone=
> &shiptofax=
> &shiptoemail=
> &tax_2150=1
> &startdate=10-15-2006
> &creditlimit=
> &terms=Pre-Pd
> &curr=USD
> &employee=turkey--11186
> &notes=
> &id=
> &taxaccounts=2150
> &path=bin/mozilla
> &login=turkey
> &password=badonkydonk
> &db=vendor
> &action=Save"
> 

Re: [SL] =?iso-8859-1?q?Is_there_any_restrictions_on_which_characters?= =?iso-8859-1?q?_can_be=09used=09in_the_part_descrption_field_=3F?=

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

On Sunday 15 October 2006 11:28 am, Jeff Vian wrote:
> On Fri, 2006-10-13 at 16:06 -0500, R Pennington wrote:
> > Is there any restrictions on which characters can be used in alpha
> > numeric fields like the part description ? I seem to remember some
> > problems in the past with certain characters. Does the manual mention it
> > anywhere ?
> > Are  /  and "  ok ?
>
> I think you need to check which characters are valid per the SQL
> definition standards.  IIRC the two you list are explicitly prohibited
> since the first is a mathematical operator (division) and the " is a
> delimiter for text fields. You can use any characters in a text field
> that are allowed by the SQL language definition.
>
> The documentation at http://www.postgresql.org/docs/8.1/static/sql.html
> or http://www.postgresql.org/docs/8.1/static/index.html may be a good
> starting point.

Thanks Jeff !

That makes perfect sense for entries directly into the database tables, but
in this case i was concerned about what is valid in the sql-ledger 
application.

I would assume that the the sql-ledger code would try escape all the problem 
characters, but I seem to remember a thread at one time that mentioned that 
some characters are not usable even in the sql-ledger application itself.
I can't find anything in the archives though.


In the next few months I'm going to have to import a whole new catalog of 
parts and.. unlike last time... i'm going to import them via the SQL-ledger 
api.

I guess i'll just stuff a string of all the possible characters into the add 
part form and see if it works.  :)


Have a good day !
Roy

Re: [SL] Moving SQL-Ledger to another server

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

On Saturday 14 October 2006 3:21 pm, Danita Zanre wrote:
> > I just did this.  The only problem I had was importing the Sql
> > Ledger backup file into Postgres as the sql- ledger user.
>
> I had this problem trying to import it back as the sql-ledger user, but was
> able to import it okay as postgres.  However, now, when I try to login, I
> get
>
> Error!
>
> FATAL: IDENT authentication failed for user "sql-ledger"


As you have deduced, this is a problem with authentication against the 
database.
This is configured in the pg_hba file.

This file contains the configuration of which computers can connect to the 
database and how to check their authentication.
NOTE: In this specific case, this is for the SQL-Ledger app connecting to the 
database NOT for the people who will actually be using sql-ledger

There is not one specific way to configure this.  Once you understand how it's 
configured, you have to configure it to your specific network and security 
needs.

for example: Do you have sql-ledger and postgresql on the same server ? Do you 
use SSL ? MD5 ? Kerberos ? Do you have other applications using the 
postgresql server ?

If your new configuration is the same as your old one... maybe you can use 
your old pg_hba file from the old server ?


if you search the list archives you should hit a large number of threads that 
discuss this issue and how configure it depending on your needs and network 
environment.
http://sourceforge.net/search/?ml_name=sql-ledger-users&type_of_search=mlists&group_id=4320&words=IDENT+authentication+failed

OR.... A more detailed explanation is here in the Postgresql docs
http://www.postgresql.org/docs/8.1/interactive/client-authentication.html

For that matter.. the installation info on the Sql-ledger website has basic 
info about how to configure this too :)


Hope this helps.
Roy

Re: [SL] Is there any restrictions on which characters can be used in the part descrption field ?

[Jeff V. <jv...@ch...>]

On Fri, 2006-10-13 at 16:06 -0500, R Pennington wrote:
> Is there any restrictions on which characters can be used in alpha numeric fields like the part description ?
> I seem to remember some problems in the past with certain characters.
> Does the manual mention it anywhere ?
> Are  /  and "  ok ?
> 
I think you need to check which characters are valid per the SQL
definition standards.  IIRC the two you list are explicitly prohibited
since the first is a mathematical operator (division) and the " is a
delimiter for text fields. You can use any characters in a text field
that are allowed by the SQL language definition.

The documentation at http://www.postgresql.org/docs/8.1/static/sql.html 
or http://www.postgresql.org/docs/8.1/static/index.html may be a good
starting point.


> Thanks !
> Roy
> 
> -------------------------------------------------------------------------
> 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

[SL] Escaping "&" in command line interface

[Charley T. <li...@ti...>]

Howdy,

Is it possible to escape the "&" char within the command-line interface?

Below is a sample of what I have to import for a vendor.  There are 
about 40 vendors within my file of some 480 to import (I'm moving client 
from an old solution to SL).  Is it possible to escap the "&" so that it 
doesn't throw off everything else?  If so, how do I do so?

Charley

./ct.pl "name=J&B Imports,Inc.
&address1=PO Box XXXXX
&address2=
&city=Miami
&state=FL
&zipcode=55555
&country=USA
&contact=John
&phone=
&fax=
&email=
&shiptoname=J&B Imports,Inc.
&shiptoaddress1=PO Box XXXXX
&shiptoaddress2=
&shiptocity=Miami
&shiptostate=FL
&shiptozipcode=55555
&shiptocountry=USA
&shiptocontact=John
&shiptophone=
&shiptofax=
&shiptoemail=
&tax_2150=1
&startdate=10-15-2006
&creditlimit=
&terms=Pre-Pd
&curr=USD
&employee=turkey--11186
&notes=
&id=
&taxaccounts=2150
&path=bin/mozilla
&login=turkey
&password=badonkydonk
&db=vendor
&action=Save"

Re: [SL] Moving SQL-Ledger to another server

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

> I just did this.  The only problem I had was importing the Sql
> Ledger backup file into Postgres as the sql- ledger user.

I had this problem trying to import it back as the sql-ledger user, but =
was able to import it okay as postgres.  However, now, when I try to =
login, I get=20

Error!

FATAL: IDENT authentication failed for user "sql-ledger"=20

I've tried recreating the sql-ledger user a few times, but I'm not getting =
very far.  I can log into the admin.pl and everything looks "right" there =
as far as the two users I had created before, so I am pretty certain the =
database imported okay - but I just can't get past the authentication =
error, and I'm admittedly no database guru.

Any ideas?

Thanks.

Danita

[SL] Is there any restrictions on which characters can be used in the part descrption field ?

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

Is there any restrictions on which characters can be used in alpha numeric fields like the part description ?
I seem to remember some problems in the past with certain characters.
Does the manual mention it anywhere ?
Are  /  and "  ok ?

Thanks !
Roy

Re: [SL] Links to good double-entry explanations

[Angus C. <ang...@gm...>]

Have a look at the help for GnuCash, too. It was helpful to me. It's
at gnucash.org.

On 10/12/06, Scott Martin <sm...@st...> wrote:
>
>
> Doug Poland wrote:
> > On Thu, Oct 12, 2006 at 11:11:17AM -0500, John Hasler wrote:
> >> I'm collecting links to good explanations of double-entry bookkeeping for
> >> the manual.  Suggestions?
> >>
> > http://www.accounting-and-bookkeeping-tips.com/learning-accounting/accounting-basics-credit.htm
> > http://homepages.cambrianc.on.ca/tutorial/thetutorialcentre/accounting/recording_transactions.htm
> > http://www.computer-consulting.com/accttips.htm
> > http://www.minnesota.com/~tom/sql-ledger/howtos/
> > http://bitscafe.com/pub2/etp/sql-ledger-notes#expenses
> > http://en.wikipedia.org/wiki/List_of_accounting_topics
> >
>
> http://tenonline.org/art/bsr.html
>
> -------------------------------------------------------------------------
> 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] Links to good double-entry explanations

[Scott M. <sm...@st...>]

Doug Poland wrote:
> On Thu, Oct 12, 2006 at 11:11:17AM -0500, John Hasler wrote:
>> I'm collecting links to good explanations of double-entry bookkeeping for
>> the manual.  Suggestions?
>>
> http://www.accounting-and-bookkeeping-tips.com/learning-accounting/accounting-basics-credit.htm
> http://homepages.cambrianc.on.ca/tutorial/thetutorialcentre/accounting/recording_transactions.htm
> http://www.computer-consulting.com/accttips.htm
> http://www.minnesota.com/~tom/sql-ledger/howtos/
> http://bitscafe.com/pub2/etp/sql-ledger-notes#expenses
> http://en.wikipedia.org/wiki/List_of_accounting_topics
> 

http://tenonline.org/art/bsr.html

Re: [SL] Links to good double-entry explanations

[Doug P. <do...@po...>]

On Thu, Oct 12, 2006 at 11:11:17AM -0500, John Hasler wrote:
> I'm collecting links to good explanations of double-entry bookkeeping for
> the manual.  Suggestions?
>
http://www.accounting-and-bookkeeping-tips.com/learning-accounting/accounting-basics-credit.htm
http://homepages.cambrianc.on.ca/tutorial/thetutorialcentre/accounting/recording_transactions.htm
http://www.computer-consulting.com/accttips.htm
http://www.minnesota.com/~tom/sql-ledger/howtos/
http://bitscafe.com/pub2/etp/sql-ledger-notes#expenses
http://en.wikipedia.org/wiki/List_of_accounting_topics

-- 
Regards,
Doug