sql-ledger-users — SQL-Ledger users

=?iso-8859-1?Q?RE:_database_connection_problem?=

[<ro...@su...>]

"man pg_ctl" should tell you what you need to know.

Note especially the references to "-o" and
"postmaster.opts.default".

Cheers,

-- Rod
http://www.sunsetsystems.com/

> [Thomas Good] I use Lamar's script (the one in /etc/rc.d/init.d)
> without modification on RH 6.1 and RH 7.0 and it runs sql-ledger fine.
>
> In fact...
>
> ps ax | grep postmaster
> shows:
> /usr/bin/postmaster -i
>
> [Jeff] Thanks for that tip on ps -ax showing the arguments passed. I am
> using RH7.1 and PostgreSQL 7.1.2-5PGDG, installed from the RPMS. My
> '/etc/rc.d/init.d/postgres' script runs with the following arguments:
>
> ps ax | grep postmaster
> shows:
> /usr/bin/postmaster -D /var/lib/pgsql/data
>
> So, I guess I need to find out where in this init.d line the '-i'
> should be placed.
>
> su -l postgres -s /bin/sh -c "/usr/bin/pgctl  -D $PGDATA -p
> /usr/bin/postmaster start > /dev/null 2>&1" < /dev/null
>
> placing -i on either side of the 'start', or before the -D causes the
> init.d script to fail startup.
>
> Thanks for the iterative help here. This mailing list is pretty
> responsive.

RE: database connection problem

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

[Deiter] You probably have a postmaster.opts file.

Add the switch to the file, you should not change startup scripts.

Remember, when you upgrade Redhat again, you'll be wondering why the
heck it doesn't work when it worked before.

[Jeff] I agree, changing the init.d is bad. I found the postmaster.opts
file in /var/lib/pgsql. However, it looks as if there's a complete and
independent command line in the init.d script, does it even accede to
the postmaster.opts as an override when invoked by the init.d script
without any further coaxing?

My initial impression is that it doesn't, since:

1) (as su postgres) I add '-i' to /var/lib/pgsql/postmaster.opts, as
follows:
/usr/bin/postmaster '-i' '-D' '/var/lib/pgsql/data'

2) (as su root) I then run the RH7.1 standard '/etc/rc.d/init.d/postgres
restart':

3) ps -ax | grep postmaster shows:
/usr/bin/postmaster -D /var/lib/pgsql/data
indicating tha it ignored the .opts file.

4) and here's the kicker: Whatever is going on, it rewrites
postmaster.opts to the original form! All changes are lost!

This a strange startup environment, to be sure.

I would attach the RH7.1 init.d/postgres script, but it's outside of
mailinglist etiquette, AFAIK.

RE: database connection problem

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

[Thomas Good] I use Lamar's script (the one in /etc/rc.d/init.d) without
modification on RH 6.1 and RH 7.0 and it runs sql-ledger fine.

In fact...

ps ax | grep postmaster
shows:  
/usr/bin/postmaster -i

[Jeff] Thanks for that tip on ps -ax showing the arguments passed. I am
using RH7.1 and PostgreSQL 7.1.2-5PGDG, installed from the RPMS. My
'/etc/rc.d/init.d/postgres' script runs with the following arguments:

ps ax | grep postmaster
shows:  
/usr/bin/postmaster -D /var/lib/pgsql/data

So, I guess I need to find out where in this init.d line the '-i' should
be placed.

su -l postgres -s /bin/sh -c "/usr/bin/pgctl  -D $PGDATA -p
/usr/bin/postmaster start > /dev/null 2>&1" < /dev/null

placing -i on either side of the 'start', or before the -D causes the
init.d script to fail startup.

Thanks for the iterative help here. This mailing list is pretty
responsive.

RE: database connection problem

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

You probably have a postmaster.opts file.

Add the switch to the file, you should not change startup scripts.

Remember, when you upgrade Redhat again, you'll be wondering why the heck
it doesn't work when it worked before.


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 Sat, 18 Aug 2001, Jeff Kowalczyk wrote:

> I see it now, postmaster is buried in the init.d script for RedHat. I
> have a PostgreSQL 7.1.32 installation on RH7.1, can I insert '-i' in the
> init.d script?
> 
> My best guess where is the line:
> su -l postgres -s /bin/sh -c "/usr/bin/pgctl  -D $PGDATA -p
> /ur/bin/postmaster start > /dev/null 2>&1" < /dev/null
> 
> To which I tried to insert -i before and after the 'start' but that
> makes the startup script fail.
> 
> Any suggestions?
> 
> > You have to add the -i switch when you start postmaster.
> 
> 
> 

RE: database connection problem

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

On Sat, 18 Aug 2001, Jeff Kowalczyk wrote:

> I see it now, postmaster is buried in the init.d script for RedHat. I
> have a PostgreSQL 7.1.32 installation on RH7.1, can I insert '-i' in the
> init.d script?
> 
> My best guess where is the line:
> su -l postgres -s /bin/sh -c "/usr/bin/pgctl  -D $PGDATA -p
> /ur/bin/postmaster start > /dev/null 2>&1" < /dev/null
> 
> To which I tried to insert -i before and after the 'start' but that
> makes the startup script fail.
> 
> Any suggestions?

Jeff,   postmaster accepts -i as an arg:  postmaster -i
        run:  man postmaster 
        for more information.

But, I use Lamar's script (the one in /etc/rc.d/init.d) without
modification on RH 6.1 and RH 7.0 and it runs sql-ledger fine.

In fact...

ps ax | grep postmaster
shows:  
/usr/bin/postmaster -i

--------------------------------------------------------------------
               SVCMC - Center for Behavioral Health                  
--------------------------------------------------------------------
Thomas Good                          tomg@ { admin | q8 } .nrnet.org
Programmer/Analyst                              Phone:  718-354-5528 
Residential Services                            Mobile: 917-282-7359  
--------------------------------------------------------------------
/*           Die Wahrheit Ist Irgendwo Da Draussen...             */
--------------------------------------------------------------------

Re: inventory problem

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

You can create a vendor or customer invoice at any time. The inventory
level does not dictate if you can sell an item you apparently do not have.
The inventory level should always be taken as an indicator only not what
you actually have. If the goods are in the warehouse but the clerk didn't
enter them yet, you have no inventory, but it's sitting right there, it
just hasn't been put away yet.

A vendor invoice is the equivalent to a Merchandise Received function.
There is no separate module for it because it is one and the same for now.
When I go into serialization then it will be required to input or scan in
items received.


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 Fri, 17 Aug 2001, Dogleg Systems wrote:

> Hello -
> 
> 	The company I work for does not keep inventory in stock we resell hardware
> and software over the internet. Currently we update our website daily from
> our distributor's data. We are interested in setting up a web based store
> that interfaces to sql-ledger for accounting purposes. Our policy is to have
> our distributor ship directly to the customer upon payment. We need to
> create an invoice for the customer and a purchase order for our distributor.
> The question I have is this: how do we show inventory in sql-ledger that we
> do not actually possess, so that we can create the invoice and purchase
> order?
> 
> 	regards Douglas McNamara
> 
> 
> 

RE: database connection problem

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

I see it now, postmaster is buried in the init.d script for RedHat. I
have a PostgreSQL 7.1.32 installation on RH7.1, can I insert '-i' in the
init.d script?

My best guess where is the line:
su -l postgres -s /bin/sh -c "/usr/bin/pgctl  -D $PGDATA -p
/ur/bin/postmaster start > /dev/null 2>&1" < /dev/null

To which I tried to insert -i before and after the 'start' but that
makes the startup script fail.

Any suggestions?

> You have to add the -i switch when you start postmaster.

RE: database connection problem

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

What is postmaster? I saw that in the FAQ, but I've never heard the word
before.

> You have to add the -i switch when you start postmaster.

Re: AP process payments question

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

Because you posted one transaction from the AP screen and the other one
from an invoice. Both will created an AP entry if it wasn't paid for in
full.


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 Fri, 17 Aug 2001, Dogleg Systems wrote:

> Hello
> 
> 	I was wondering why some invoices under AP process payments go to the "Edit
> Vendor Invoice" screen and others go to the "Edit Accounts Payables" screen?
> 
> 	regards Douglas McNamara
> 
> 
> 

Re: database connection problem

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

You have to add the -i switch when you start postmaster.


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 Sat, 18 Aug 2001, Jeff Kowalczyk wrote:

> I need some assistance getting SQL-Ledger 1.6 to run on RH7.1 with
> PostgreSQL 7.1.x. I have database connection problems. I'm wondering if
> I need to do some sort of "GRANT ALL" on the postgres user or something.
> 
> I've installed DBD::Pg and tested it successfully. There is a pgsqltest
> database as a result, in fact. I have (for the moment) postgres open
> with a blank password and listening with 'no authentication required',
> although I don't yet know how to tell the postgres-specific distinction
> between 'local connection' and localhost connection. How do I tell if
> postgres is listening on 5434? I easily can access postgres via webmin,
> for example.
> 
> Database 
> Host:localhost				Port:5432  
> Database Administrator: postgres	Password: (blank)  
> Connect to: mypgdb
> (choose 'create database' results in:)
> Error! connectDBStart() -- connect() failed: Connection refused 
> 
> 
> Likewise, I have a sql-ledger user with the following profile:
> Driver: Pg		Host: localhost  
> Name: mypgdb	Port: 5432  
> User: postgres	Password: (blank) 
> (Logging in as this user results in:)
> Error! Database is offline; please try again later
> 
> Looking at the 'Granted Priveledges" thru webmin, I see no tables having
> any explicitly granted priviledges. Isn't the 'postgres' user implicitly
> granted permission?
> 
> Can anyone help me figure this out? I have to deploy this sql-ledger
> test ASAP. Thanks.
> 
> 
> 

Re: database connection problem

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

On Sat, 18 Aug 2001, Jeff Kowalczyk wrote:

> I need some assistance getting SQL-Ledger 1.6 to run on RH7.1 with
> PostgreSQL 7.1.x. I have database connection problems. I'm wondering if
> I need to do some sort of "GRANT ALL" on the postgres user or something.
> 
> I've installed DBD::Pg and tested it successfully. There is a pgsqltest
> database as a result, in fact. I have (for the moment) postgres open
> with a blank password and listening with 'no authentication required',
> although I don't yet know how to tell the postgres-specific distinction
> between 'local connection' and localhost connection. How do I tell if
> postgres is listening on 5434? I easily can access postgres via webmin,
> for example.

Hi.  Have a look in /tmp 

# ls -al /tmp

See if you have a lock file (looks like .s.PGSQL.5432)
If not:
as root run:

/etc/rc.d/init.d/postgresql start

Good luck!

--------------------------------------------------------------------
               SVCMC - Center for Behavioral Health                  
--------------------------------------------------------------------
Thomas Good                          tomg@ { admin | q8 } .nrnet.org
Programmer/Analyst                              Phone:  718-354-5528 
Residential Services                            Mobile: 917-282-7359  
--------------------------------------------------------------------
/*           Die Wahrheit Ist Irgendwo Da Draussen...             */
--------------------------------------------------------------------

database connection problem

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

I need some assistance getting SQL-Ledger 1.6 to run on RH7.1 with
PostgreSQL 7.1.x. I have database connection problems. I'm wondering if
I need to do some sort of "GRANT ALL" on the postgres user or something.

I've installed DBD::Pg and tested it successfully. There is a pgsqltest
database as a result, in fact. I have (for the moment) postgres open
with a blank password and listening with 'no authentication required',
although I don't yet know how to tell the postgres-specific distinction
between 'local connection' and localhost connection. How do I tell if
postgres is listening on 5434? I easily can access postgres via webmin,
for example.

Database 
Host:localhost				Port:5432  
Database Administrator: postgres	Password: (blank)  
Connect to: mypgdb
(choose 'create database' results in:)
Error! connectDBStart() -- connect() failed: Connection refused 


Likewise, I have a sql-ledger user with the following profile:
Driver: Pg		Host: localhost  
Name: mypgdb	Port: 5432  
User: postgres	Password: (blank) 
(Logging in as this user results in:)
Error! Database is offline; please try again later

Looking at the 'Granted Priveledges" thru webmin, I see no tables having
any explicitly granted priviledges. Isn't the 'postgres' user implicitly
granted permission?

Can anyone help me figure this out? I have to deploy this sql-ledger
test ASAP. Thanks.

RE: SQL-Ledger Evaluation

[Federico S. I. <ji...@le...>]

On Fri, 17 Aug 2001 at 21:40, Ing. Antonio A. Gallardo wrote:
> Thanks for your comments. Some of those features you requesteed are
> implemented in the new 1.6.0 version.

Would you know which ones? Anyway, I'll upgrade soon and let our
accounting manager give it another spin.

> Help us to develop SQL-Ledger to live out of the endless upgrade cycle
> of the Microsoft environment.

I wish I knew my accounting theory enough, but I don't. I'd love to pitch
in. The SQL-Ledger code is clean enough to understand. The farthest I've
gone was to work on that "ORDER BY" incompatibility with PostgreSQL
v7.1.x.

Anyway, I'll be hanging around. I won't give up, and the budget is helping
me. We're tight on cash so we can't get any commercial app anyway. Hahaha.
There are plusses to being in a third world country. :)

 --> Jijo

--
Federico Sevilla III  :: ji...@le...
Network Administrator :: The Leather Collection, Inc.
GnuPG Key: <http://jijo.leathercollection.ph/jijo.gpg>

RE: SQL-Ledger Evaluation

[Ing. A. A. G. <ag...@ma...>]

Federico:

Thanks for your comments. Some of those features you requesteed are
implemented in the new 1.6.0 version.

Help us to develop SQL-Ledger to live out of the endless upgrade cycle of
the Microsoft environment.

Regards,

Antonio Gallardo


-----Mensaje original-----
De: sql...@li...
[mailto:sql...@li...]En nombre de
Federico Sevilla III
Enviado el: Viernes, 17 de Agosto de 2001 09:04 p.m.
Para: SQL Ledger Mailing List
Asunto: SQL-Ledger Evaluation


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi everyone,

I'm the network administrator for our company, an SME based in the
Philippines. I'm working with our accounting department to hopefully get
SQL Ledger in place. We are currently using SQL-Ledger v1.4.13, slightly
patched to fix the previous issue I mentioned with the "ORDER BY" and
PostgreSQL v7.1. I intend to upgrade this system to SQL-Ledger v1.6.0 as
soon as possible, but in the meantime I'd like to share the report sent to
me by our company's accounting manager.

I have very minimal knowledge as far as accounting procedures are
concerned, so I hope those in the list who know more than me will be
patient. I'd like to get help validating the points of our accounting
manager, in the hopes that we will see if these can actually be
implemented with SQL Ledger but he just hasn't figured out how, yet.
Alternatively some of the points may be useful to the development team for
the next versions to come.

I am not giving up on SQL Ledger and will keep upgrading and pushing for
its evaluation lest someone here buy Quickbooks (ugh, but the guy's good
at Quickbooks it seems although we don't have that installed here in the
office [yet, and I hope it will stay that way]) and need me to maintain
yet more Windows computers. I hope fellow list members can help me in my
"crusade". :)

Here's the report (sometimes it looks like more of a wishlist):

- -----[ Start of Report ]-----
I. Recording
   A. A/R A/P
      1. Although it supports Double entry accounting it has no feature
         that shows the accounting entry behind the transaction posted.
         This is critical for audit trail.
      2. We were not able to enter transactions with compound entries.
         Without this feature it will double our accounting work.
      3. VAT & Withholding tax automatic computation or recalculation.
      4 Limited search function.
      5. Due date recalculation.
      6. Add transaction is not linked with the complete cycle of a
         transaction to eliminate redundancy of accounting work. Eg. for
         AR transaction, SO is linked with SI and the journal entry behind
         the transaction.
      7. Add transaction template can not be edited for additional field for
         reporting purposes.
II. Reporting
   A. Customizable reports
      1. Limited customizable reports templates.
      2. Additional fields for filtering report purposes.
      3. Linking of SO, SI, and journal entry transaction to eliminate
         redundancy.
      4. Segment Reporting, & Cost center reporting???

III. Inventory
   A. Inventory Tracking and Costing
      1. Costing by FIFO, LIFO or average costing?

IV. Fixed asset monitoring
   A. Lapsing schedule

V. Audit Trail
   A. Account analysis for audit review and schedule preparation.

Comments:
The version we are evaluating basically supports bookkeeping and standard
reporting. Although I have not seen the changes in the new version, these
changes are basic accounting features in a computerized environment. We
may need a lot of time in the development before we can migrate to the
system.
- -----[ End of Report ]-----

Thanks in advance, everyone!

 --> Jijo

- --
Federico Sevilla III  :: ji...@le...
Network Administrator :: The Leather Collection, Inc.
GnuPG Key: <http://jijo.leathercollection.ph/jijo.gpg>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE7fdsw5rCBSJO3Rr4RAp6IAJoCBZXyGhUFkX/1cCBvq68ExqnZAACfbJln
HCVvbrlMqrhtQznsK/gkFS0=
=prie
-----END PGP SIGNATURE-----

SQL-Ledger Evaluation

[Federico S. I. <ji...@le...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi everyone,

I'm the network administrator for our company, an SME based in the
Philippines. I'm working with our accounting department to hopefully get
SQL Ledger in place. We are currently using SQL-Ledger v1.4.13, slightly
patched to fix the previous issue I mentioned with the "ORDER BY" and
PostgreSQL v7.1. I intend to upgrade this system to SQL-Ledger v1.6.0 as
soon as possible, but in the meantime I'd like to share the report sent to
me by our company's accounting manager.

I have very minimal knowledge as far as accounting procedures are
concerned, so I hope those in the list who know more than me will be
patient. I'd like to get help validating the points of our accounting
manager, in the hopes that we will see if these can actually be
implemented with SQL Ledger but he just hasn't figured out how, yet.
Alternatively some of the points may be useful to the development team for
the next versions to come.

I am not giving up on SQL Ledger and will keep upgrading and pushing for
its evaluation lest someone here buy Quickbooks (ugh, but the guy's good
at Quickbooks it seems although we don't have that installed here in the
office [yet, and I hope it will stay that way]) and need me to maintain
yet more Windows computers. I hope fellow list members can help me in my
"crusade". :)

Here's the report (sometimes it looks like more of a wishlist):

- -----[ Start of Report ]-----
I. Recording
   A. A/R A/P
      1. Although it supports Double entry accounting it has no feature
         that shows the accounting entry behind the transaction posted.
         This is critical for audit trail.
      2. We were not able to enter transactions with compound entries.
         Without this feature it will double our accounting work.
      3. VAT & Withholding tax automatic computation or recalculation.
      4 Limited search function.
      5. Due date recalculation.
      6. Add transaction is not linked with the complete cycle of a
         transaction to eliminate redundancy of accounting work. Eg. for
         AR transaction, SO is linked with SI and the journal entry behind
         the transaction.
      7. Add transaction template can not be edited for additional field for
         reporting purposes.
II. Reporting
   A. Customizable reports
      1. Limited customizable reports templates.
      2. Additional fields for filtering report purposes.
      3. Linking of SO, SI, and journal entry transaction to eliminate
         redundancy.
      4. Segment Reporting, & Cost center reporting???

III. Inventory
   A. Inventory Tracking and Costing
      1. Costing by FIFO, LIFO or average costing?

IV. Fixed asset monitoring
   A. Lapsing schedule

V. Audit Trail
   A. Account analysis for audit review and schedule preparation.

Comments:
The version we are evaluating basically supports bookkeeping and standard
reporting. Although I have not seen the changes in the new version, these
changes are basic accounting features in a computerized environment. We
may need a lot of time in the development before we can migrate to the
system.
- -----[ End of Report ]-----

Thanks in advance, everyone!

 --> Jijo

- --
Federico Sevilla III  :: ji...@le...
Network Administrator :: The Leather Collection, Inc.
GnuPG Key: <http://jijo.leathercollection.ph/jijo.gpg>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE7fdsw5rCBSJO3Rr4RAp6IAJoCBZXyGhUFkX/1cCBvq68ExqnZAACfbJln
HCVvbrlMqrhtQznsK/gkFS0=
=prie
-----END PGP SIGNATURE-----

AP process payments question

[Dogleg S. <dog...@wo...>]

Hello

	I was wondering why some invoices under AP process payments go to the "Edit
Vendor Invoice" screen and others go to the "Edit Accounts Payables" screen?

	regards Douglas McNamara

inventory problem

[Dogleg S. <dog...@wo...>]

Hello -

	The company I work for does not keep inventory in stock we resell hardware
and software over the internet. Currently we update our website daily from
our distributor's data. We are interested in setting up a web based store
that interfaces to sql-ledger for accounting purposes. Our policy is to have
our distributor ship directly to the customer upon payment. We need to
create an invoice for the customer and a purchase order for our distributor.
The question I have is this: how do we show inventory in sql-ledger that we
do not actually possess, so that we can create the invoice and purchase
order?

	regards Douglas McNamara

where are the po's

[Dogleg S. <dog...@wo...>]

Hello

	Where are the purchase orders in sql-ledger? Is vendor invoice a purchase
order?

	regards Douglas McNamara

RE: problem adding parts

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

On Thu, 16 Aug 2001, Don Wellington wrote:

> I was thinking the same thing, until I realized that
> it would screw up the double entry bookkeeping.  Which
> then begs the question how do you put in initial
> inventory without messing up the books balanced?  

You have established your inventory value aggregate
in your g/l and are now adding detail:

    Debit and credit against the same inventory account.

rob                     Live the dream.

Re: problem adding parts

[Steve D. <sd...@sw...>]

Hi Don.

That last post may not have the appropriate offset.  I was thinking you
were contributing inventory to a new business.

Regardless, you can invoice yourself at cost and you will have the a/p and
the inventory on your books.  You can offset the a/p with a journal entry
to whatever account is appropriate.

Don Wellington wrote:

> Hi Dieter-
>
> I don't think that really cuts it.  Then the value of
> the parts doesn't show up on the balance sheets or in
> the inventory account. I think you actually need to
> create a dummy AP_paid account and generate a vendor
> invoice with yourself as the vendor paid from that
> account.  Would that work?
>
> Don
> BRJ Wine Cellars - Idaho
> SysAdmin
>
> --- Dieter Simader <dsi...@sq...> wrote:
> > You create a zero cost vendor invoice, the vendor in
> > this case is
> > you.
> >
> >
> > 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 Thu, 16 Aug 2001, Don Wellington wrote:
> >
> > > I was thinking the same thing, until I realized
> > that
> > > it would screw up the double entry bookkeeping.
> > Which
> > > then begs the question how do you put in initial
> > > inventory without messing up the books balanced?
> > >
> > > > Hello
> > >
> > > > should the add part form in sql-ledger have
> > boxes >
> > > for LastCost and OnHand?
> > > > currently it does not.
> > >
> > > > regards Douglas McNamara
> > >
> > >
> > >
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Make international calls for as low as $.04/minute
> > with Yahoo! Messenger
> > > http://phonecard.yahoo.com/
> > >
> > >
> >
> >
> >
>
> __________________________________________________
> Do You Yahoo!?
> Make international calls for as low as $.04/minute with Yahoo! Messenger
> http://phonecard.yahoo.com/

Purchase orders and code updates

[Don W. <das...@ya...>]

Two things:

In discussions, while I was installing SQL ledger a
question came up about how to handle orders.  We would
like to keep track of what is on order.  And, we don't
want stuff that is ordered to show up on the books
until it is received, especially since received
doesn't necessarily match ordered.  So, I have or will
be changing a few things:

1) I added a received checkbox to each line of the
invoice, and added a received (int) field to the
invoice table.  I modified the ir.pl to display this
field, and IR.pm to only update the books when a line
of an invoice is received.

2) Our vendors don't require any special forms for PO,
so I am going to add a template just like customer
invoice to generate printed vendor invoices, to
e-mail/mail to vendors.

3) Finally, I will add a "on order" field to parts,
and the code to handle updating that field.

Are these things that would be good in the general
sense?  Would you like me to send my modification?

Any problems with #1 or can you think of a better
solution?

Don

__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/

Re: problem adding parts

[Steve D. <sd...@sw...>]

Actually, from an accounting perspective you should probably invoice yourself
at the inventory's cost.
Then create a 3000 series account like below and book a journal entry like
the following:

dr.  2100 - Accounts Payable    10,000
cr.  3100 - Contributed Capital  -Inventory  10,000

You initial inventory is an owner's or shareholder's equity item in the
company.  Might be an issue if you start dealing with banks or auditors.
Ideally, your total investment in the company should be reflected in equity.

Dieter Simader wrote:

> You create a zero cost vendor invoice, the vendor in this case is
> you.
>
> 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 Thu, 16 Aug 2001, Don Wellington wrote:
>
> > I was thinking the same thing, until I realized that
> > it would screw up the double entry bookkeeping.  Which
> > then begs the question how do you put in initial
> > inventory without messing up the books balanced?
> >

RE: problem adding parts

[Don W. <das...@ya...>]

Hi Dieter-

I don't think that really cuts it.  Then the value of
the parts doesn't show up on the balance sheets or in
the inventory account. I think you actually need to
create a dummy AP_paid account and generate a vendor
invoice with yourself as the vendor paid from that
account.  Would that work?

Don
BRJ Wine Cellars - Idaho
SysAdmin

--- Dieter Simader <dsi...@sq...> wrote:
> You create a zero cost vendor invoice, the vendor in
> this case is
> you.
> 
> 
> 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 Thu, 16 Aug 2001, Don Wellington wrote:
> 
> > I was thinking the same thing, until I realized
> that
> > it would screw up the double entry bookkeeping. 
> Which
> > then begs the question how do you put in initial
> > inventory without messing up the books balanced?  
> > 
> > > Hello
> > 
> > > should the add part form in sql-ledger have
> boxes >
> > for LastCost and OnHand?
> > > currently it does not.
> > 
> > > regards Douglas McNamara
> > 
> > 
> > 
> > __________________________________________________
> > Do You Yahoo!?
> > Make international calls for as low as $.04/minute
> with Yahoo! Messenger
> > http://phonecard.yahoo.com/
> > 
> > 
> 
> 
> 


__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/

RE: problem adding parts

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

You create a zero cost vendor invoice, the vendor in this case is
you.


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 Thu, 16 Aug 2001, Don Wellington wrote:

> I was thinking the same thing, until I realized that
> it would screw up the double entry bookkeeping.  Which
> then begs the question how do you put in initial
> inventory without messing up the books balanced?  
> 
> > Hello
> 
> > should the add part form in sql-ledger have boxes >
> for LastCost and OnHand?
> > currently it does not.
> 
> > regards Douglas McNamara
> 
> 
> 
> __________________________________________________
> Do You Yahoo!?
> Make international calls for as low as $.04/minute with Yahoo! Messenger
> http://phonecard.yahoo.com/
> 
> 

Delivery Failure: RE: problem adding parts

[iComMand S. <su...@co...>]

Your message, RE: problem adding parts,
was not delivered to the following recipient:
gla...@xs...

Reason: System error: Please re-send your message later.
Recipient: gla...@xs...