sql-ledger-users — SQL-Ledger users

RE: Printing

[Jeff S. <js...@en...>]

Actually, I'm going to be administering SQL-Ledger remotely and would like
to print to the default queue on the server, so the "PRINT" buttons on the
forms would be nice if they printed locally instead of just invoking my
browser's print function.

I have a number of workarounds for this, but I just wanted to double-check
and make sure that those "PRINT"  buttons don't do anything (or maybe they
do and my install is just screwed up).

Definitely agree on the merits of CSS, but I agree more strongly with the
old "beggars can't be choosers" adage ;)

Thanks,

-Jeff

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...]On Behalf Of Sergio
A. Kessler
Sent: Tuesday, February 19, 2002 6:39 PM
To: Jeff Strope; sql...@li...
Subject: Re: Printing


actually, you can use the print button of your browser,
but you don't want the form's buttons to print right ?

the easy solution for this is to use css to define a
non printable class, like this:

@media print {
    .noprint {   /* items with this class won't print */
        display: none;
    }
}

then you modify the source to include
<div class=noprint>
..... <form's buttons> .....
</div>

hey, you even can define things that don't
display on screen but print

@media screen {
    .noscreen {   /* items with this class won't display */
        display: none;
    }
}

it would be good for sql-ledger to use more css...

/sergio

----- Original Message -----
From: "Jeff Strope" <js...@en...>


> I'm pretty sure this has been covered in the past, but I just want to make
> sure.
>
> The "Print Invoice" & "Print Order" (etc) form buttons do not actually
send
> documents to printers installed on the server, correct?


NOTICE: When replying, please Reply to the list address. This way other
members know if the issues have been resolved or not. Thanks! Your List
administrator.

Re: Printing

[Sergio A. K. <ser...@ho...>]

actually, you can use the print button of your browser,
but you don't want the form's buttons to print right ?

the easy solution for this is to use css to define a
non printable class, like this:

@media print {
    .noprint {   /* items with this class won't print */
        display: none;
    }
}

then you modify the source to include
<div class=noprint>
..... <form's buttons> .....
</div>

hey, you even can define things that don't
display on screen but print

@media screen {
    .noscreen {   /* items with this class won't display */
        display: none;
    }
}

it would be good for sql-ledger to use more css...

/sergio

----- Original Message -----
From: "Jeff Strope" <js...@en...>


> I'm pretty sure this has been covered in the past, but I just want to make
> sure.
>
> The "Print Invoice" & "Print Order" (etc) form buttons do not actually
send
> documents to printers installed on the server, correct?

Re: MySQL Port of SQL-Ledger

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

We covered this in the past. mySQL does support transactions now with the
InnoDB handler but there are no UNIONS or sub-selects available.

It would be a major undertaking to flatten out the relational model built
with unions and joins to collect data from a handful of tables.


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On Tue, 19 Feb 2002, Eric John Seneca wrote:

> Is there a MySql port of SQL-Ledger? If someone has already ported this 
> program would it be possible to get a tar of those perl scripts?
> 
> 
> 

Printing

[Jeff S. <js...@en...>]

I'm pretty sure this has been covered in the past, but I just want to make
sure.

The "Print Invoice" & "Print Order" (etc) form buttons do not actually send
documents to printers installed on the server, correct?

Thanks,

Jeff Strope

Re: MySQL Port of SQL-Ledger

[Keith H. <kwh...@ne...>]

http://www.sql-ledger.org/misc/faq.html

On Tue, 2002-02-19 at 15:21, Eric John Seneca wrote:
> Is there a MySql port of SQL-Ledger? If someone has already ported this 
> program would it be possible to get a tar of those perl scripts?
> 
> 
> -- 
> Eric John Seneca
> Phase6 Technologies, LLC.
> es...@ph...
> 
> NOTICE: When replying, please Reply to the list address. This way other members know if the issues have been resolved or not. Thanks! Your List administrator.

Unable to delete database

[Kirk V. <kv...@ga...>]

New to using Sql-Ledger and look like it will suit my needs well. However,
I am unable to delete databases or even a point where I can view database that
could be removed. After login to admin module, I get to the page to create or 
delete datasets I am able to create datasets , however when I select 
DELETE DATASET I get the following error.

FATAL 1: Database "template0" is not currently accepting connections

the user is 'postgres' and Connect to is 'template1' at the administration page.
Thanks for any help
  Kirk

MySQL Port of SQL-Ledger

[Eric J. S. <es...@ph...>]

Is there a MySql port of SQL-Ledger? If someone has already ported this 
program would it be possible to get a tar of those perl scripts?


-- 
Eric John Seneca
Phase6 Technologies, LLC.
es...@ph...

Re: posting to this list

[lee j. <le...@im...>]

> > didn't miss any of it, and I must say I agree with Rod and Will: While it is 
> > "close to a non-issue", surely we are grown up enough to work out how to 
> 
> I agree that people should always check where they are sending their
> mail.

right which is alot of the reason for sending to individual ..that way
it can avoid trouble by 'accidentily' sending to the whole list when you
mean just the person...talk about embarrasing :)LOL.....anyway I have it
set to 'individual' at my carpenters list at yahoogroups for 280
people..some 'used' to complain but they're used to it now and I feel
its best.

> 
> > reply to the list.  If necessary the welcome message could just state 
> > 
> > > NOTICE: When replying, please Reply to the list address. 
> 
> The welcome message is fine, but it needs to be reinforced by adding 
> an instructive list sig to every message.

yeah true that would be efficient 

cu
lee
-===

Re: posting to this list

[Rob R. <ri...@me...>]

On Sun, 17 Feb 2002, Richard Lyons wrote:

> On Sunday 17 February 2002  3:24, se...@gt... wrote:

> didn't miss any of it, and I must say I agree with Rod and Will: While it is 
> "close to a non-issue", surely we are grown up enough to work out how to 

I agree that people should always check where they are sending their
mail.

> reply to the list.  If necessary the welcome message could just state 
> 
> > NOTICE: When replying, please Reply to the list address. 

The welcome message is fine, but it needs to be reinforced by adding 
an instructive list sig to every message.

In the postgresql lists they have several sigs which rotate or 
are randomly chosen.


rob                     Live the dream.

Re: code like AR_amount etc

[Rob R. <ri...@me...>]

On 18 Feb 2002, Jonny Birkelund wrote:

I'm just guessing and coming from a USA perspective.

> = AR_amount
  AR = accounts receivable
  amount = amount charged to "Accounts Receivable" general ledger account
> = AR_paid
  money received which defrays above
> = AR_tax
  tax amount to be collected going into "Accrued Sales tax" gen. ledger acct.
> = AP_amount
  AP = accounts payable
  amount = amount charged to "Accounts Payable" g/l account
> = AP_paid
  like ar but to ap
> = AP_tax
  ditto
> = IC_sale
  IC = Inventory Control
  sale = value (selling price) of goods sold
> = IC_cogs
  cogs = Cost of goods sold
  Naively this is what you paid for the material being sold.  But there
  are different says of determining cost.  Average cost, first-in/first-out,
  last-in/first-out, itemized.
> = IC_taxpart
  This may be an account where to charge accrued sales tax.
> = IC_income
  IC_income = sales income -- like IC_sales but this is a 
  income statement account
> = IC_expense
  IC_expense = like IC_cogs but a income statement account
> = IC_taxservice
   IC_taxservice  ? I don't know.  This may be an accrual account for sales
taxes collected on services rendered.

rob                     Live the dream.

Re: SQL Ledger on Red Hat anyone?

[Lee K. <le...@ki...>]

This turned out to be the answer to my immediate problem.

Thanks for that.

To summarise installation on Red Hat:

You can un tar the source into the default Red Hat html document root - 
/var/www/html - or into the sql-ledger default - /usr/local/www.

You have to set the various sql-ledger changes in httpd.conf to reflect the 
www directory you *do* eventually choose to un tar the source into.

Watch out for the sql-ledger manual instruction to run:
# chown nobody:nobody users templates

On a Red Hat system, this should read:
# chown apache:apache users templates

On Red Hat systems, restart apache with:
# /etc/rc.d/init.d/httpd restart

OK, I still haven't got mine working properly yet but the above was what I 
needed to do to get the admin.pl Perl script to fire up correctly. I'll add 
to the above as I get the rest of it going.

Thanks to everyone for your
help.

Lee


At 09:01 AM 2/13/2002 -0500, Ed Wiget wrote:
>-----BEGIN PGP SIGNED MESSAGE-----
>Hash: SHA1
>
>on redhat 7.2 it should be apache.apache
> >
> > Mmmm, I've run "chown nobody:nobody users templates" and I can see that a
> > user and group called 1000 own most of these files, including admin.pl.

Re: SQL Ledger on Red Hat anyone?

[Lee K. <le...@ki...>]

This turned out to be the answer to my immediate problem.

Thanks for that.

To summarise installation on Red Hat:

You can un tar the source into the default Red Hat html document root - 
/var/www/html - or into the sql-ledger default - /usr/local/www.

You have to set the various sql-ledger changes in httpd.conf to reflect the 
www directory you *do* eventually choose to un tar the source into.

Watch out for the sql-ledger manual instruction to run:
# chown nobody:nobody users templates

On a Red Hat system, this should read:
# chown apache:apache users templates

On Red Hat systems, restart apache with:
# /etc/rc.d/init.d/httpd restart

OK, I still haven't got mine working properly yet but the above was what I 
needed to do to get the admin.pl Perl script to fire up correctly. I'll add 
to the above as I get the rest of it going.

Thanks to everyone for your
help.

Lee


At 09:01 AM 2/13/2002 -0500, Ed Wiget wrote:
>-----BEGIN PGP SIGNED MESSAGE-----
>Hash: SHA1
>
>on redhat 7.2 it should be apache.apache
> >
> > Mmmm, I've run "chown nobody:nobody users templates" and I can see that a
> > user and group called 1000 own most of these files, including admin.pl.

Re: permission denied users/members

[<gha...@fr...>]

On Mon, 18 Feb 2002, kevin bailey wrote:

> here are the notes - i have cut and pasted the instructions - and added 
> some comments in amongst them,
[...]
> Debian Installation
> unpack into /var/www/sql-ledger
[...]
> # other packages required
> 
> libdib-perl libdbd-pg-perl libpgperl
  ^^^^^^^^^^^ libdbi-perl

Just the one typo that I can see.

Gord

Re: permission denied users/members

[kevin b. <kev...@bi...>]

kevin bailey wrote:

> thanks for all the help - with a newsgroup like this sql-ledger is going 
> to be huge!!!
> 
> i now have sql-ledger working on my debian woody machine - i will post 
> up some notes during the week.
> 

here are the notes - i have cut and pasted the instructions - and added 
some comments in amongst them,

kev


Debian Installation
unpack into /var/www/sql-ledger
install postgresql (Dselect)

install apache

# this did not seem to be necessary
install libpg-dev (Dselect)


# other packages required

libdib-perl libdbd-pg-perl libpgperl


# should be /etc/postgresql/postmaster.conf
modify /etc/postgresql/postmaster.init

PGALLOWTCPIP=yes

# this produced an error when restarting postgres - i left it out cos 
this port seems to be the default anyway.
PGPORT=5432

create a user for managing SQL-Ledger databases
from root
su postgres
$ createuser
name of user- (create a postgres user who is also a Linux user
this user will be an account manager. Enable this user to create db and 
users)

# not required cos of the packages installed earlier. 
---------------------------------------
install DBI

perl Makefile.PL

make

make test

login as root

make install

$ export POSTGRES_INCLUDE=/usr/include/postgresql
$ export POSTGRES_LIB=/var/lib/postgres
install DBD-Pg

login as account manager (above)

perl Makefile.PL

make

make test

login as root

make install

#--------------------------------------------------------------------------------------

change /etc/apache/httpd.conf and add
AddHandler cgi-script .pl
ScriptAlias /sql-ledger/ /var/www/sql-ledger/
<Directory /var/www/sql-ledger>
   Options ExecCGI Includes FollowSymlinks
</Directory> restart apache


# the apahce server on woody runs under the user www-data - so use
chown www-data: users templates users/members

the ':' menas that the default group for www-data is set.


Make sure the web server has write permission to write to the following

users/
templates/
users/members

# chown nobody:nogroup users templates users/members



# i found the file was not created automatically - i 'touched' it and 
then set the ownership to www-data
users/members might not exist. Not to worry, the file will be created
when you use admin.pl for the first time.
Of course, the permission has to be set correctly for the users directory.


# finally the settings in pg_hba.conf were too restrictive and i set 
them to
host         all         127.0.0.1     255.0.0.0           trust

obviously this should be tighter but it was late at the time!!!


 From browser enter http://my_domain/sql-ledger/admin.pl
Login as the postgres user (account manager) you have created (above)
Create a DB
Create users

then enter http://my_domain/sql-ledger/login.pl
Login as one of the users you have just created

part / assembly + pricing : FIXED

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

Turns out the bug fix for the missing assembly flag on orders is a one
line fix.

edit OE.pm and change line 313 to

        p.partnumber, p.assembly, o.description, o.qty, o.sellprice,

If you don't want to edit the file download the file
http://www.sql-ledger.org/source/upgrade-1.8.2.tar.gz and untar over top.


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

SQL-Ledger journal/ transaction data schema

[Todd B. <tb...@co...>]

Would your projects be willing to provide documentation of
your transaction ledger or journal data schema, and if available,
your GL interface, to this collection, at
  http://www.arapxml.net/research.htm ?

Clearly, it would be of value to general ledger researchers and
analysts on several levels.  It would contribute another viewpoint
of how GL and other transaction data should be represented
within a working system, and it would inform them of the
existence of your software.

Please feel free to include whatever graphics or other static
content you feel appropriate, and of course any IP statement
or other boilerplate,

Thank you,
TOdd
Todd Boyle CPA  9745-128th Ave NE  Kirkland WA
International Accounting Services, LLC  www.gldialtone.com
tb...@ro...  425-827-3107  project www.arapxml.net 

Re: part / assembly + pricing

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

The indicator that the item is an assembly item is not retained in the
table and therefore not carried forward from the order to the invoice.
This makes the assembly item look like a service item and the onhand
quantity is not updated. I'll fix that for the next release. In the
meantime, when you have assemblies on an order and create an invoice,
remove the assembly item from the invoice and add it back in.

This only happens when you convert an order to an invoice.


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On Sun, 17 Feb 2002,  Justin Reynolds wrote:

> NOTICE: When replying, please Reply to the list address. This way other members know if the issues at hand have been resolved or not.
> a few quick questions:
> 
> 1) is there a way to auto-update all assemblies when their component parts change price? i.e., we make 'partA' and set it's price to $50, use that in 'assemblyA'. when 'partA' jumps in price to, say, $150, is it possible to automatically adjust the price of the assembly, rather than doing it manually? (if it's possible to do this as a script/cronjob/whatever, that's fine -- just need a way to do it that doesn't require the user to manually update 1000 assemblies.)
> 
> 2) quantity on hand seems broken, or i'm not understanding something.
> 
> example: i create three parts, and stock them with a vendor invoice. i create an assembly using those parts, and stock, say, 50 of them. the quantity on hand of the parts changes as expected. create a new customer, create a sales order for 50 of the assembly.
> 
> now, it's my understanding that when i create an invoice for that order and post it to the system, the quantity on hand should change, yes? (invoice equating to 'this order needs to be shipped and the customer will pay us in 'x' days?)
> 
> i would guess that as soon as i post the invoice, the quantity on hand for the assembly should drop to 0. from the tests i've done, it doesn't. i've tried leaving the original sales order intact, or deleting it when prompted. nothing seems to make the quantity change at all.
> 
> when i delete the posted invoice, however, i end up with 100 of the that assembly in inventory, opposed to the 50 i started with.
> 
> huh?
> 
> (this is using the most current version btw, 1.8.2)
> 
> thanks in advance -
> justin
> ho...@ea...
> 

code like AR_amount etc

[Jonny B. <jo...@op...>]

Hi, I'm trying to convert account information in sql-ledger to
Norwegian. We are highly bureaucratic here so there is a lot of
different accaount numbers in a NS4102 (Norwegian Standard). In size is
seems bigger than the french one. To get this right I'll include them
all. But I do have problem to find what different code means.

= AR_amount
= AR_paid
= AR_tax
= AP_amount
= AP_paid
= AP_tax
= IC_sale
= IC_cogs
= IC_taxpart
= IC_income
= IC_expense
= IC_taxservice
-- 
/Jonny
Opera Software
phone:+47-24164370 fax:+47-24164002

Re: permission denied users/members

[<gha...@fr...>]

On Mon, 18 Feb 2002, Kenneth Gonsalves wrote:
> On Monday 18 February 2002 00:25, kevin bailey wrote:
> 
> > if not - where do i get hold of
> > DBI-1.14.tar.gz
> CPAN

He wanted to apt-get them as Debian packages.  Knowing the
CPAN name for something doesn't always help in finding the
Debian name for the same package.  It is preferred you get
packages as debs, if possible to make keeping things consistent
as easy as possible.

Gord

Re: posting to this list

[Kenneth G. <la...@th...>]

the proof of the pudding is in the eating - since my original mail on this 
subject this list has really taken off - and will reach the stratosphere when 
the footer regarding replying to the list becomes a header (most people are 
on yahoo type lists where they have trained themselves to ignore the ads in 
the footer)
kg
On Monday 18 February 2002 05:48, Vagn Scott wrote:
> "Sergio A. Kessler" wrote:
> > hey, take it easy...
> > I did not write that, it's the new mailist footer...
>
> OK. Apologies offered.
>
> > I've read that document some years ago, but you can't
> > ask every new list member to read that document
>
> Agreed. They should be told, not asked.
>
> > NOTICE: When replying, please Reply to the list address.
> > This way other members know if the issues have been resolved or not.
> > Thanks! Your List administrator.
>
> This is still wrong.  Send them to the FAQ.  How is it better
> that everyone should wade through more useless text, than that
> the ignorant few should be enlightened?

Re: permission denied users/members

[Kenneth G. <la...@th...>]

On Monday 18 February 2002 00:25, kevin bailey wrote:

> if not - where do i get hold of
> DBI-1.14.tar.gz
CPAN
kg

Re: posting to this list

[Vagn S. <va...@ra...>]

"Sergio A. Kessler" wrote:

> hey, take it easy...
> I did not write that, it's the new mailist footer...

OK. Apologies offered.

> I've read that document some years ago, but you can't
> ask every new list member to read that document

Agreed. They should be told, not asked.
 
> NOTICE: When replying, please Reply to the list address. 
> This way other members know if the issues have been resolved or not. 
> Thanks! Your List administrator.

This is still wrong.  Send them to the FAQ.  How is it better
that everyone should wade through more useless text, than that
the ignorant few should be enlightened?

-- 
         _~|__
   >@   (vagn(     /
    \`-ooooooooo-'/
  ^^^^^^^^^^^^^^^^^^^^

DateStyle parse error

[Craig N. <scr...@ea...>]

Has anyone ever gotten a DateStyle parse error? 

After logging in and clicking on any module action the screen displays the follwing error:
	Error: Set DateStyle to "ISO"
	Parse error at or near ISO

I checked my Apache error log and found the following entry.
	DBD::Pg:db do failed: ERROR: parse error at or near "iso" at SL/Form.pm line 
	431
	Error: set DateStyle to ISO<br>ERROR: parser: parse error at otr near "iso"
	Database handle destroyed without explicit disconnect.

I examined SL/Form.pm but could not figure out how the code itself would raise an error.

Re: permission denied users/members

[kevin b. <kev...@bi...>]

thanks for all the help - with a newsgroup like this sql-ledger is going 
to be huge!!!

i now have sql-ledger working on my debian woody machine - i will post 
up some notes during the week.

next challenge is to get it working on slackware!

thanks again - kev

gha...@fr... wrote:

> On Sun, 17 Feb 2002, kevin bailey wrote:
> 
> 
>>i am currently tring to create a new database - and am getting the message
>>
>>IDENT authentication failed
>>
> 
> You need to edit /etc/postgresql/pg_hba.conf to set up how
> you want Host Based Authentication (that's what hba is in pg_hba)
> working.  I think dpkg installs a line like:
> #host   all   127.0.0.1   255.255.255.255   password
> I changed mine to
> host   all   192.168.10.2   255.255.255.255   password
>              ^^^^^^^^^^^^ IP of your interface
> 
> 
> Gord
> 
> 
> NOTICE: When replying, please Reply to the list address. This way other members know if the issues have been resolved or not. Thanks! Your List administrator.
> 
> 
> 
> 

configuring

[P. J. <pi...@vi...>]

Gentlemen:
I find nothing in the installation instructions on how to set up 
ksql-ledger using a remote web server and dtabase (Apache & postgresql). I 
can set them up on 1 machine, but I already have them set up on another 
machine on my network. As I am not a programmer, I don't know how to 
configure either Apache or sql-ledger in this situation.
Thanks for any help.
Philip Jourdan