sql-ledger-users — SQL-Ledger users

Re: DBI

[alta <al...@al...>]

Although the following steps are for SuSE 7.3, I believe some of the 
details may help you get through the installation on Red Hat, as well:


INSTALLATION INSTRUCTIONS: PostgreSQL and Perl DBD on SuSE 7.3

1. Install the following using YaST2:
  (Suggestion: Install each line-item below in a separate YaST2 
session.)

- Development/Libraries/Perl: perl-DBI
- Applications/Databases: all postgresql modules
- Development Libraries: postgresql-devl

2. Setup directories and paths for PostgreSQL:

> su -     (change to root)

  Setup disk directory for your db:
# mkdir /var/lib/pgsql/data
# chown postgres /var/lib/pgsql/data

- Put PostgreSQL path /usr/bin/psql into PATH in /etc/profile.local

3. Initialize the database, start it, and test it:

# /usr/local/pgsql/bin/initdb -D /var/lib/pgsql/data
# rcpostgresql start

  Quick-test the server:
# su postgres
> psql -d template1
  \q to exit psql
  Setup another db user:
> createuser <db-user>      (should matach an existing Linux user)
    Shall the new user be able to create databases? (y/n) y
    Shall the new user be able to create new users? (y/n) n

Note: SuSE 7.3 appears to have a Pg DBD, but I could not get it to 
work,
      so...

4. Verify the existence of the following, which are required for the 
DBD:

- /usr/include/pgsql/libpq-fe.h
- /usr/lib/libpq.so

5. Download DBD::Pg from www.CPAN.org .

6. Expand and examine the downloaded components:

- su to the <db-user> you setup for db access, but NOT root!
- Expand DBD-Pg-1.01.tar.gz into your favorite directory.
- Read the README file.

7. Prepare for the build:

> PATH=.:$PATH
> export POSTGRES_INCLUDE=/usr/include/pgsql
> export POSTGRES_LIB=/usr/lib

8. Try the build:

> perl Makefile.PL
> make
- Verify no errors from the make.
> make test
- Verify all "ok" from the make test.

9. Do the final DBD install:

> su -    (and cd back to the build directory, if necessary)
# make install

DBD-Pg is installed!


-- 
Reed White  -  ALTA RESEARCH  -  www.alta-research.com
Phone: 877-360-2582  -  Email: al...@al...

Re: pretty cool app

[John C. S. <js...@im...>]

On Wed, 2002-01-02 at 15:09, Keld J=F8rn Simonsen wrote:
>=20
> On Wed, Jan 02, 2002 at 08:22:43AM -0700, Dieter Simader wrote:
> > I think there is a bit of a misconception here. You do not need an
> > administrator to prepare the database everytime. You do it once and you
> > are done.
> >=20
> > When you lock the database and effectively create a WORM drive. You can
> > only add transactions but not delete or change them.
>=20
> OK, Maybe I did not understand it fully. So the sql statements in the FAQ
> will also lock new transactions applied after the sql statements have
> been applied?
>=20
> Then I would miss some functionality, as I would like to do some draft
> transactions, and only fixate them once every year. I understood
> that others also wanted to do something like that, eg every quarter.

Yup! You sure would. An *older* clipper-based application we used to use
some time ago *closed the books* at the end of the fiscal year. In
between, we used to enjoy the functionality that Keld has mentioned.

I suppose it would be useful to some people to have a *stricter*
criteria, more like what Dieter mentioned. Once again, it would be nice
to be able to pick and choose what you want or need  ;))).

Right????


John Christian Stoddart
Caracas - Venezuela

RE: DBI

[John C. S. <js...@im...>]

Obviously the best place to find the most up-to-date modules is
cpan.org. Just follow the links Dieter has kindly provided on the
sql-ledger.org web page.

By the way, both packages are available as rpms for Mandrake too:

perl-DBD-Pg-1.01-1mdk
perl-DBI-1.20-1mdk


Cheers,



John Christian Stoddart
Caracas - Venezuela


On Wed, 2002-01-02 at 14:49, Brian Johnson wrote:
> The packages from my Red Hat 7.2 disk are:
> perl-DBD-Pg-1.01-1.i386.rpm
> perl-DBI-1.18-1.i386.rpm
> 
> Look for something like that on your Red Hat 7.1 disks
> 
> 
> 
> 
> -----Original Message-----
> From: sql...@li...
> [mailto:sql...@li...]On Behalf Of
> Richard Lyons
> Sent: Wednesday, January 02, 2002 10:59 AM
> To: sql...@li...
> Subject: DBI
> 
> 
> Can anyone save me a lot of earching and learning and tell me:
> 
> What are DBI and DBD?
> 
> "Why do I get DBI not installed" instead of sql-ledger/admin?  
> 
> I've just installed sql-ledger on an RH7.1 workstation.  I have 
> searched Redhat's rpms for DBI to no avail.  Rpmfind has some listed, 
> but not RedHat -- and I've no idea if that is the right thing to do, as 
> I simply don't know what I'm doing here.
> 
> --
> richard
> 
> 

Re: pretty cool app

[<ke...@dk...>]

On Wed, Jan 02, 2002 at 08:22:43AM -0700, Dieter Simader wrote:
> I think there is a bit of a misconception here. You do not need an
> administrator to prepare the database everytime. You do it once and you
> are done.
> 
> When you lock the database and effectively create a WORM drive. You can
> only add transactions but not delete or change them.

OK, Maybe I did not understand it fully. So the sql statements in the FAQ
will also lock new transactions applied after the sql statements have
been applied?

Then I would miss some functionality, as I would like to do some draft
transactions, and only fixate them once every year. I understood
that others also wanted to do something like that, eg every quarter.

> While the "Delete" button is still visible on screen it is just a simple
> case of adding a few lines of code to hide it. I can only do so much.
> Adding foreign currency and multiple payments took longer than expected
> and since I wanted to release 1.8 before years end, some of the minor
> things will just have to wait.

So this is on your todo? I would really appreciate that. 

Kind regards
Keld

> 
> 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 Wed, 2 Jan 2002, Richard Lyons wrote:
> 
> > On Tuesday 01 January 2002 21:56, Keld Jørn Simonsen wrote:
> > 
> > <snip>
> > 
> > > An accountant cannot call on a system administrator, that
> > > has the appropiate systems accessabilities, and knowledge of sql 
> > database
> > > handling, every time the locking needs to be done. The locking
> > > must in principle be done for every transaction! But there is also
> > > a need for functionality to only do it when requested, eg
> > > every quarter. As far as I understand it, the requirement is
> > > considered "good accountant practice" in most countries. 
> > 
> > Can I just put in a vote for flexibility.  In an audited office 
> > environment, with competent operators, the locking ought, of course, to 
> > be automatic, and corrections would be made by contra journal entries 
> > (of course it's then important that these contras are entered as 
> > negative sums to the relevant debit and credit accounts, so that the 
> > total statistics are not distorted in management reports, VAT returns, 
> > etc.).  BUT, for the small user doing his/her own bookkeeping, 
> > mistakes, changes of heart about classification, etc. are common, and 
> > the records would become a nightmare for the poor accountant who gets 
> > the resultant output if the records cannot be simply amended.  
> > 
> > Surely the right approach (in the spirit of open software, too!) is to 
> > allow the locking to be switched on if so desired.  The switch would 
> > only be accessible to the accountant user, of course, so that strict 
> > auditing could be enforced when required.
> > 
> > --
> > richard
> > 
> > 
> 
> 

Re: DBI

[John C. S. <js...@im...>]

Maybe a shortish explanation should go in the faq.

The DBI is Tim Bunce's extremely flexible, vendor independent database
interface for the perl language.

To quote him directly, 'DBI is a database access Application Programming
Interface (API) for the Perl Language. The DBI API Specification defines
a set of functions, variables and conventions that provide a consistent 
database interface independant of the actual database being used.'.

Programmers write code using this interface. Should the
programmer/user/client/etc decide, for any reason, to use a completely
different database manager *after* the application is written, the code
stays the same and all that has to be done is change the DBD driver.

The DBD driver is the actual handling code that sits between DBI and the
database managers. There are DBD drivers for all major databases. Thus
programmers can write core code that transparently accesses a database.
Most SQL-Ledger installations will use DBD::Pg, which is the appropriate
driver for the PostgreSQL database manager but later on other options
will be available.

Good luck


John Christian Stoddart
Caracas - Venezuela


On Wed, 2002-01-02 at 11:59, Richard Lyons wrote:
> Can anyone save me a lot of earching and learning and tell me:
> 
> What are DBI and DBD?
> 
> "Why do I get DBI not installed" instead of sql-ledger/admin?  
> 
> I've just installed sql-ledger on an RH7.1 workstation.  I have 
> searched Redhat's rpms for DBI to no avail.  Rpmfind has some listed, 
> but not RedHat -- and I've no idea if that is the right thing to do, as 
> I simply don't know what I'm doing here.
> 
> --
> richard
> 

RE: DBI

[Brian J. <bjo...@je...>]

The packages from my Red Hat 7.2 disk are:
perl-DBD-Pg-1.01-1.i386.rpm
perl-DBI-1.18-1.i386.rpm

Look for something like that on your Red Hat 7.1 disks




-----Original Message-----
From: sql...@li...
[mailto:sql...@li...]On Behalf Of
Richard Lyons
Sent: Wednesday, January 02, 2002 10:59 AM
To: sql...@li...
Subject: DBI


Can anyone save me a lot of earching and learning and tell me:

What are DBI and DBD?

"Why do I get DBI not installed" instead of sql-ledger/admin?  

I've just installed sql-ledger on an RH7.1 workstation.  I have 
searched Redhat's rpms for DBI to no avail.  Rpmfind has some listed, 
but not RedHat -- and I've no idea if that is the right thing to do, as 
I simply don't know what I'm doing here.

--
richard

Re: The gory details

[<ma...@li...>]

Great idea.  Thanks.

Matt

On Wed, 2 Jan 2002, Dieter Simader wrote:

> For anyone who is interested in the API, I published a short paper on how
> the it works.
>
> http://www.sql-ledger.org/feature/api.html
>
>
> 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 ===========
>
>

-- 

Matt Benjamin

The Linux Box
206 South Fifth Ave. Suite 150
Ann Arbor, MI  48104

tel. 734-761-4689
fax. 734-769-8938
cel. 734-216-5309
pgr. 734-431-0118

The gory details

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

For anyone who is interested in the API, I published a short paper on how
the it works.

http://www.sql-ledger.org/feature/api.html


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

Accounting/Bookkeeping Question

[Roderick A. A. <raa...@ti...>]

I think I've asked this before but now I have a better understanding
after taking a elementary bookkeeping class and hope it will really sink
in this time.

I produce and ship CD's to North American customers for a German
company.  Sometimes the customer prefers sending me the total cost.  
Since I don't want to report the whole amount as income (I only charge a
portion of the cost for production, shipping and handling) I've created
a Liability account for these payments.

   Should I have a part/inventory item thingy? 

   When I create an invoice for the CDs shipped I'm wondering how do I
post the credit for the CDs I got paid the whole amount for?

This making sense?


TIA,
Rod
-- 
                      Let Accuracy Triumph Over Victory

                                                       Zetetic Institute
                                                        "David's Sling"
                                                         Marc Stiegler

Re: DBI

[John B. <Jo...@be...>]

You probably don't want to use the cpan.pm module; the packages are
available from Red Hat in /pub/redhat/linux/7.1/en/os/i386/RedHat/RPMS
on ftp.redhat.com.   Just get perl-DB*.

Using the cpan.pm module causes (in some cases) base perl to be upgraded
to the latest available, currently 5.6.1.  Upgrading to 5.6.1 causes
many things in Red Hat Linux to break - thinks like autoconf, libtool,
automake, and printing.  If you need a module upgraded that's not
provided by Red Hat, use the /usr/lib/rpm/cpanflute script (provided in
the rpm-build package) to create an RPM from a CPAN tarball; much better
that way.

On Wed, 02 Jan 2002, gha...@fr... wrote:

> 
> On Wed, 2 Jan 2002, Richard Lyons wrote:
> 
> > Can anyone save me a lot of earching and learning and tell me:
> 
> Sure.
> 
> > What are DBI and DBD?
> 
> DBI and DBD are (families of) Perl modules.  DBI is a fairly
> high level of abstration for dealing with DataBase Interfaces
> (hence the name DBI).  DBD modules are the DataBase Drivers
> used by the DBI to talk to the actual database.  You can get
> the DBI module, and the particular DBD (in this case, it's
> PG for PostgreSQL) from some place called CPAN (Comprehensive
> Perl Archive Network) at http://www.cpan.org/  I am a Debian
> user, so I don't know how much of CPAN is available from Redhat.
> Certainly a good chunk of CPAN is available using apt-get from
> Debian (but they always change the names of the modules).  If
> DBI and DBD::Pg are not available from Redhat, hopefully they
> do have cpan.pm available, which is a relatively painless
> way of downloading, compiling, testing and installing perl
> modules from CPAN.
> 
> Gord
> 

-- 
John Berninger

GPG Key ID: A8C1D45C
        Fingerprint: B1BB 90CB 5314 3113 CF22  66AE 822D 42A8 A8C1 D45C

It is a known fact that developers cannot document.  That's why we have 
documentation specialists.  If developers could document, they'd all be
system administrators!
--

Re: DBI

[Damon T. <da...@ra...>]

"The DBI is a database interface module for Perl. It defines a set of methods, variables and 
conventions that provide a consistent database interface independent of the actual database being 
used."

The DBD is a database driver for a specific database engine.  For example, DBD::Pg is the DBI 
implementation for Postgresql.  

Here is a FAQ

http://dbi.symbolstone.org/doc/faq.html

If you perform a search with your favourite search engine for "DBI" you will find lots of 
information.

Damon

Quoting Richard Lyons <ri...@th...>:

> Can anyone save me a lot of earching and learning and tell me:
> 
> What are DBI and DBD?
> 
> "Why do I get DBI not installed" instead of sql-ledger/admin?  
> 
> I've just installed sql-ledger on an RH7.1 workstation.  I have 
> searched Redhat's rpms for DBI to no avail.  Rpmfind has some listed, 
> but not RedHat -- and I've no idea if that is the right thing to do, as 
> I simply don't know what I'm doing here.
> 
> --
> richard
> 
> 


Ranksix Solutions Inc.
da...@ra...
250.514.6616

Re: DBI

[Thomas G. <to...@ad...>]

On Wed, 2 Jan 2002, Richard Lyons wrote:

> Can anyone save me a lot of earching and learning and tell me:
>=20
> What are DBI and DBD?
>=20
> "Why do I get DBI not installed" instead of sql-ledger/admin? =20
>=20
> I've just installed sql-ledger on an RH7.1 workstation.  I have=20
> searched Redhat's rpms for DBI to no avail.  Rpmfind has some listed,=20
> but not RedHat -- and I've no idea if that is the right thing to do, as=
=20
> I simply don't know what I'm doing here.
>=20
> --
> richard

Richard, check out the FAQ and email archive(s)...DBI is Database Interface
a perl module and after you install it you need DBD-Pg, which is a=20
'database driver' for P(ost)g(res)...you can get these at www.cpan.org
You'll want to make sure you have perl installed...

good luck

--------------------------------------------------------------------
              Saint Vincent Catholic Medical Centers               =20
--------------------------------------------------------------------
Thomas Good                          tomg@ { admin | q8 } .nrnet.org
Programmer/Analyst                              Phone:  718-818-5528=20
Behavioral Health Services                      Fax:    718-818-5056 =20
Residential Services                            Mobile: 917-282-7359 =20
--------------------------------------------------------------------
/*         Rekordmeister ist nur der FC Bayern M=FCnchen!           */
--------------------------------------------------------------------

Re: DBI

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

On Wed, 2 Jan 2002, Richard Lyons wrote:

> Can anyone save me a lot of earching and learning and tell me:

Sure.

> What are DBI and DBD?

DBI and DBD are (families of) Perl modules.  DBI is a fairly
high level of abstration for dealing with DataBase Interfaces
(hence the name DBI).  DBD modules are the DataBase Drivers
used by the DBI to talk to the actual database.  You can get
the DBI module, and the particular DBD (in this case, it's
PG for PostgreSQL) from some place called CPAN (Comprehensive
Perl Archive Network) at http://www.cpan.org/  I am a Debian
user, so I don't know how much of CPAN is available from Redhat.
Certainly a good chunk of CPAN is available using apt-get from
Debian (but they always change the names of the modules).  If
DBI and DBD::Pg are not available from Redhat, hopefully they
do have cpan.pm available, which is a relatively painless
way of downloading, compiling, testing and installing perl
modules from CPAN.

Gord

DBI

[Richard L. <ri...@th...>]

Can anyone save me a lot of earching and learning and tell me:

What are DBI and DBD?

"Why do I get DBI not installed" instead of sql-ledger/admin?  

I've just installed sql-ledger on an RH7.1 workstation.  I have 
searched Redhat's rpms for DBI to no avail.  Rpmfind has some listed, 
but not RedHat -- and I've no idea if that is the right thing to do, as 
I simply don't know what I'm doing here.

--
richard

Re: relation of expense to a service

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

There is no expense when you sell a service, however you will have an
expense when you purchase a service.


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 Mon, 31 Dec 2001, Caffeinate The World wrote:

> We sell ad space on our web site. I think it would be considered a
> service in inventor and not a part. So I needed to add a service:
> 
> 1. Inventory / Add Service
> 2. Number: BRS120120 
>    ...
> Then I get to Links Accounts:
> 
> Income: 4050-Sales/Banner Ads
> Expense: *** THIS IS WHERE I DON'T GET IT ***
> 
> How does expense relate to the service being sold?
> 
> __________________________________________________
> Do You Yahoo!?
> Send your FREE holiday greetings online!
> http://greetings.yahoo.com
> 
> 

Re: Payroll progress??

[<to...@In...>]

Yes i 2nd that question.. [ as i sit here out of immediate
need writing a payroll system in VB/Crystal/MSSql :( ]


----- Original Message ----- 
From: "Oscar Buijten" <os...@el...>
To: <sql...@li...>
Sent: Wednesday, January 02, 2002 10:35 AM
Subject: Payroll progress??


> Hi!
> 
> I was just wondering if the payroll development is progressing.
> Any news on this one?
> 
> Thanks,
> 
> Oscar
> 
> 
> 
> 
> 
> 

Payroll progress??

[Oscar B. <os...@el...>]

Hi!

I was just wondering if the payroll development is progressing.
Any news on this one?

Thanks,

Oscar

Re: pretty cool app

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

I think there is a bit of a misconception here. You do not need an
administrator to prepare the database everytime. You do it once and you
are done.

When you lock the database and effectively create a WORM drive. You can
only add transactions but not delete or change them.

While the "Delete" button is still visible on screen it is just a simple
case of adding a few lines of code to hide it. I can only do so much.
Adding foreign currency and multiple payments took longer than expected
and since I wanted to release 1.8 before years end, some of the minor
things will just have to wait.


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

On Wed, 2 Jan 2002, Richard Lyons wrote:

> On Tuesday 01 January 2002 21:56, Keld J=F8rn Simonsen wrote:
>=20
> <snip>
>=20
> > An accountant cannot call on a system administrator, that
> > has the appropiate systems accessabilities, and knowledge of sql=20
> database
> > handling, every time the locking needs to be done. The locking
> > must in principle be done for every transaction! But there is also
> > a need for functionality to only do it when requested, eg
> > every quarter. As far as I understand it, the requirement is
> > considered "good accountant practice" in most countries.=20
>=20
> Can I just put in a vote for flexibility.  In an audited office=20
> environment, with competent operators, the locking ought, of course, to=
=20
> be automatic, and corrections would be made by contra journal entries=20
> (of course it's then important that these contras are entered as=20
> negative sums to the relevant debit and credit accounts, so that the=20
> total statistics are not distorted in management reports, VAT returns,=20
> etc.).  BUT, for the small user doing his/her own bookkeeping,=20
> mistakes, changes of heart about classification, etc. are common, and=20
> the records would become a nightmare for the poor accountant who gets=20
> the resultant output if the records cannot be simply amended. =20
>=20
> Surely the right approach (in the spirit of open software, too!) is to=20
> allow the locking to be switched on if so desired.  The switch would=20
> only be accessible to the accountant user, of course, so that strict=20
> auditing could be enforced when required.
>=20
> --
> richard
>=20
>=20

Re: pretty cool app

[Richard L. <ri...@th...>]

On Tuesday 01 January 2002 21:56, Keld J=F8rn Simonsen wrote:

<snip>

> An accountant cannot call on a system administrator, that
> has the appropiate systems accessabilities, and knowledge of sql=20
database
> handling, every time the locking needs to be done. The locking
> must in principle be done for every transaction! But there is also
> a need for functionality to only do it when requested, eg
> every quarter. As far as I understand it, the requirement is
> considered "good accountant practice" in most countries.=20

Can I just put in a vote for flexibility.  In an audited office=20
environment, with competent operators, the locking ought, of course, to=20
be automatic, and corrections would be made by contra journal entries=20
(of course it's then important that these contras are entered as=20
negative sums to the relevant debit and credit accounts, so that the=20
total statistics are not distorted in management reports, VAT returns,=20
etc.).  BUT, for the small user doing his/her own bookkeeping,=20
mistakes, changes of heart about classification, etc. are common, and=20
the records would become a nightmare for the poor accountant who gets=20
the resultant output if the records cannot be simply amended. =20

Surely the right approach (in the spirit of open software, too!) is to=20
allow the locking to be switched on if so desired.  The switch would=20
only be accessible to the accountant user, of course, so that strict=20
auditing could be enforced when required.

--
richard

Re: HELP! Permissions Denied

[Edmund L. <el...@in...>]

Dieter,

Thanks for the reply. My apologies for not seeing this in the FAQ--I
looked, but missed it completely!

...Edmund.

Re: HELP! Permissions Denied

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

This is from the FAQ

* Database permission denied

The user you entered in the "Database section" must be a valid database
user. Use the same name you used when you created the database and tables
or another special user who has the rights to access the 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, 1 Jan 2002, Edmund Lian wrote:

> 
> On 12/29/2001 17:00:50 Terry wrote:
> 
> >>I finally got everthing loaded and was able to pull up sql-ledger in
> Netscape
> browser. Finished admin process and was able to login as user but when I
> try
> to run setup items or reports such as list the chart of accounts I get the
> following errors:
> 
> [all snipped]
> 
> I got this error too, and started to dig now. I've noticed that that
> permissions, user preferences, etc. in SQL-Ledger do not seem to be stored
> in PostgreSQL at all! Very strange, since I'd have thought that this should
> either be handled at the RDBMS level with SQL access privileges, or at the
> application level using some kind of user/group permissions model that
> takes advantage of the security and safety of the RDBMS. I hope I'm wrong!
> 
> Is there a developer's list or documentation somewhere that someone can
> point me to? I can't find a developer's mailing list or any documentation
> at all...
> 
> ...Edmund.
> 
> 
> 

Re: COGS

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

The cost for goods are posted as an expense when the goods are sold.

You buy ten of item A, the cost of the items is recorded in inventory,
when you sell four of them, four are removed from inventory and the cost
for the four items is posted as an expense.


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 Mon, 31 Dec 2001, Caffeinate The World wrote:

> could someone help me understand how Cost Of Goods Sold (COGS) is used
> in a transaction?
> 
> __________________________________________________
> Do You Yahoo!?
> Send your FREE holiday greetings online!
> http://greetings.yahoo.com
> 
> 

Re: HELP! Permissions Denied

[Edmund L. <el...@in...>]

On 12/29/2001 17:00:50 Terry wrote:

>>I finally got everthing loaded and was able to pull up sql-ledger in
Netscape
browser. Finished admin process and was able to login as user but when I
try
to run setup items or reports such as list the chart of accounts I get the
following errors:

[all snipped]

I got this error too, and started to dig now. I've noticed that that
permissions, user preferences, etc. in SQL-Ledger do not seem to be stored
in PostgreSQL at all! Very strange, since I'd have thought that this should
either be handled at the RDBMS level with SQL access privileges, or at the
application level using some kind of user/group permissions model that
takes advantage of the security and safety of the RDBMS. I hope I'm wrong!

Is there a developer's list or documentation somewhere that someone can
point me to? I can't find a developer's mailing list or any documentation
at all...

...Edmund.

SQL-Ledger FAQ/How-To started

[Caffeinate T. W. <moc...@ya...>]

I read the mailing list from start to finish. I grabbed what I thought
might be helpful to other new people starting out in SQL-Ledger and put
them in one place.

  http://www.minnesota.com/sql-ledger/faq/

I will continue to update the page with more of my own tutorials from
daily business transactions and probably break it up into a DocBook
format later. I hope it is of some use for someone.

__________________________________________________
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com

Re: upgrading

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

The only caveat would be if you have no room between the last account
number in the 'I' and 'E' ranges. Two new accounts are added, one for
exchange rate gains and one for exchange rate losses.

I use the next highest number available in the 'I' and 'E' account
categories to add these accounts.

So, if your last account in the 'I' category is 4999 and the first account
in the 'E' category is 5000 there is no room to insert an account.

In my opinion it is very highly unlikely that this situation will ever
arise in a real world situation. If it does, the upgrade will not work as
expected and I will hear about it anyway.


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 Wed, 2 Jan 2002, adrian wrote:

> I am about to upgrade to version 1.8.1 from 1.6.11. 
> 
> I will do all the backups etc but I am concerned as last time I upgraded
> from 1.4. to 1.6 some of the data fields got mixed up and I lost a lot
> of information. Some of it was was totally my own fault.
> 
> I have been using sql-ledger for over 12 months with live data and it
> has been excellent.
> 
> Has anyone experienced and serious problems in the upgrade process ? 
> Any tips, do and don't ??
> 
> 
> Adrian
>