sql-ledger-users

RE: problem adding parts

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

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/

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

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/

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...>]

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/

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

[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.