geordie | 1 May 16:16 2009
Picon

LAN Setup

Hi
I need some help in seting LSMB to run on a household LAN. I have tried many 
attempts. Between locking up a computer and just reading way to much and 
getting confused, I decided I need some help. The senario I thought was quite 
simple, I have Debian (Sidux) box with LSMB installed and I would like the 
Windows Xp box to have assess to this information.

I believe /etc/postgresql/8.3/main/pg_hba.conf
should be setup like this

local   ledgersmb       all        	169.XXX.X.X             md5

/etc/ledgersmb/ledgersmb.conf

DBname       = ledgersmb
DBhost       = localhost (does this need to be changed to 169.XXX.X.X )
DBport       = 5432
DBUserName   = ledgersmb

Do I need to change /etc/hosts

I am assuming apache2.2 needs to be modified, but I am at a loss to figuire 
that out.

I am positive that I have missed something else.

I am open to all suggestions or links

Many thanks
Geordie
(Continue reading)

James Stevens | 1 May 17:28 2009
Picon

Re: LAN Setup

Change you point of view and you can easily accomplish this.

the pg_hba.conf file is telling Debian(postgreSQL) wher to listen and
how to authenticate sql sessions. It only needs to listen localy and
authenticate in that manner (trust). Authenticate the user ledgersmb in
your case localy.

Once that is done, meaning it works on the machine installed on you are
looking at apache to service request to remote users.
Which it should already our of the box.

Knowing the IP address of the Debian machine ( CLI-> ifconfig )
got to your Windows machine and typ http://<ipaddress of the
debian>/ledgersmb/admin.pl

What do you see?

Also go to http://<ipaddress of debian box>/ 

and tell us what you see...    i.e.
http://192.168.1.1/ledgersmb/login.pl

-----Original Message-----
From: geordie [mailto:geordi@...] 
Sent: Friday, May 01, 2009 9:16 AM
To: ledger-smb-users@...
Subject: [Ledger-smb-users] LAN Setup

Hi
I need some help in seting LSMB to run on a household LAN. I have tried
(Continue reading)

Stroller | 2 May 14:53 2009
Picon

Re: LAN Setup


On 1 May 2009, at 15:16, geordie wrote:
> ...
> DBhost       = localhost
> does this need to be changed to 169.XXX.X.X ?

I believe it does, assuming you can ping that address from the Windows  
box.

As James observes, this is a slightly unusual network range to use -  
192.168.x.y would be more common.

Stroller.

------------------------------------------------------------------------------
Register Now & Save for Velocity, the Web Performance & Operations 
Conference from O'Reilly Media. Velocity features a full day of 
expert-led, hands-on workshops and two days of sessions from industry 
leaders in dedicated Performance & Operations tracks. Use code vel09scf 
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
David A. Bandel | 2 May 15:28 2009
Picon

Re: LAN Setup

On Sat, May 2, 2009 at 7:53 AM, Stroller
<stroller@...> wrote:
>
> On 1 May 2009, at 15:16, geordie wrote:
>> ...
>> DBhost       = localhost
>> does this need to be changed to 169.XXX.X.X ?

169.254.0.0/16 is a "zeroconf" address -- it's what Windoze uses when
it gets lost (can't figure out what it's address should be), but there
are zeroconf utilities for Linux and other Unices as well.

>
> I believe it does, assuming you can ping that address from the Windows
> box.
>
> As James observes, this is a slightly unusual network range to use -
> 192.168.x.y would be more common.

RFC 1918 outlines the following addresses for use within private networks:

     10.0.0.0        -   10.255.255.255  (10/8 prefix)
     172.16.0.0      -   172.31.255.255  (172.16/12 prefix)
     192.168.0.0     -   192.168.255.255 (192.168/16 prefix)

However, 169.254.0.0/16 is considered a bogus address. It can be found
in the bogon listings and will be dropped by properly configured
routers, so can be used as a private address group (but that's not
recommended).

(Continue reading)

Michael Richardson | 3 May 05:25 2009
Picon

Re: LAN Setup


>>>>> "David" == David A Bandel <david.bandel@...> writes:
    David> 169.254.0.0/16 is a "zeroconf" address -- it's what Windoze
    David> uses when it gets lost (can't figure out what it's address
    David> should be), but there are zeroconf utilities for Linux and

  That's not fair.
  Windoz does get lost lots, but 169.254.0.0/16 was allocated
specifically for zeroconf, and it's a legitimate way to do networking.
  That windoz fails into using their network, and often route 0.0.0.0/0
to this LAN, so anyone within wireless listening of you can hijack *ALL*
your traffic, is certainly a sin, but...

  As you say, Linux and Mac (and Cisco and ...) can easily participate
in such a network, which usually is what you would permit to be
configured if you and your friends are having a LAN party in the middle
of the park.

  I would not call it a bogus address for this reason.
  It's not crazy to use this on your LAN, given Bonjour/LLDMS/mDNS/Avahi
(whichever you want to call it), you can use it along with a stable
name.
  I just don't recommend it either.

--

-- 
]     Y'avait une poule de jammé dans l'muffler!!!!!!!!!        |  firewalls  [
]   Michael Richardson, Sandelman Software Works, Ottawa, ON    |net architect[
] mcr@... http://www.sandelman.ottawa.on.ca/
|device driver[
] panic("Just another Debian GNU/Linux using, kernel hacking, security guy"); [
(Continue reading)

John Bell | 3 May 15:54 2009

Re: LAN Setup

Michael Richardson wrote:
>>>>>> "David" == David A Bandel <david.bandel@...> writes:
>>>>>>             
>     David> 169.254.0.0/16 is a "zeroconf" address -- it's what Windoze
>     David> uses when it gets lost (can't figure out what it's address
>     David> should be), but there are zeroconf utilities for Linux and
>
>   
"Autoconfiguration" IP Addresses:

        169.254.0.0 - 169.254.255.255

Addresses in the range 169.254.0.0 to 169.254.255.255 are used 
automatically by some PCs and Macs when they are configured to use IP, 
do not have a static IP Address assigned, and are unable to obtain an IP 
address using DHCP.

This traffic is intended to be confined to the local network, so the 
administrator of the local network should look for misconfigured hosts. 
Some ISPs inadvertently also permit this traffic, so you may also want 
to contact your ISP. This is documented in RFC 3330 
<http://www.rfc-editor.org/rfc/rfc3330.txt>.  
http://www.iana.org/abuse/faq.html

So, to answer the original question...

A LAN address of 169.*.*.* implies that the server is set up for 
networking, using DHCP, but no DHCP server is present.

SO... 1st setup your LAN and give your server a static IP address 
(Continue reading)

Matthijs Lambregts | 3 May 21:50 2009
Picon

Re: Ledger-smb-users Digest, Vol 33, Issue 1

ik kan tot 17.00

On Sun, May 3, 2009 at 5:25 AM, <ledger-smb-users-request-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org> wrote:
Send Ledger-smb-users mailing list submissions to
       ledger-smb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org

To subscribe or unsubscribe via the World Wide Web, visit
       https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
or, via email, send a message with subject or body 'help' to
       ledger-smb-users-request-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org

You can reach the person managing the list at
       ledger-smb-users-owner-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Ledger-smb-users digest..."


Today's Topics:

  1. Re: Question about effects of installing LSMB on  template1
     (Chris Bennett)
  2. Re: Question about effects of installing LSMB on  template1
     (Roderick A. Anderson)
  3. Re: Question about effects of installing LSMB on  template1
     (Chris Travers)
  4. LAN Setup (geordie)
  5. Re: LAN Setup (James Stevens)
  6. Re: LAN Setup (Stroller)
  7. Re: LAN Setup (David A. Bandel)
  8. Re: LAN Setup (Michael Richardson)


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

Message: 1
Date: Tue, 28 Apr 2009 16:30:00 -0500
From: Chris Bennett <chris-86bi167hAaZd27BlJj9ntlztOkhRWOSc@public.gmane.org>
Subject: Re: [Ledger-smb-users] Question about effects of installing
       LSMB on template1
To: ledger-smb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
Message-ID: <49F77558.8010405-86bi167hAaZd27BlJj9ntlztOkhRWOSc@public.gmane.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed



Chris Travers wrote:
> On Tue, Apr 28, 2009 at 2:09 PM, Chris Bennett
> <chris <at> bennettconstruction.biz> wrote:
>
>> I have someone struggling to install LSMB.
>> He is concerned that because he has an Adempiere app installed already,
>> that connecting to template1 in admin interface will cause trouble for
>> other app.
>>
>> I understand that template1 is used to create new databases, but I saw
>> that some alterations are made to it.
>> Is there any real concern that any database app will cause problems for
>> another?
>>
>
> When a db is created, the template db (usually Template1) is copied to
> that location.
>
>
Let me see if I understand clearly.
You are saying that there is a difference between copying from template1
and installing INTO template1?
> If you install into Template1 you can create new LedgerSMB databases
> just by using createdb.
>
> It won't affect existing db's, but you might find some unpleasent
> surprises when trying to create new databases for other applications.
> And, it is a pain to clean up :-)
>
>
I saw a thread somewhere about how to use template0 to recreate template1.
Does LedgerSMB create databases copying from template1 or installing
into template1?

And since I'm writing my own app for my vendors, customers and current
prices,
what is the right/wrong way to create new databases to avoid problems
with other apps?
> Best Wishes,
> Chris Travers
>
> ------------------------------------------------------------------------------
> Register Now & Save for Velocity, the Web Performance & Operations
> Conference from O'Reilly Media. Velocity features a full day of
> expert-led, hands-on workshops and two days of sessions from industry
> leaders in dedicated Performance & Operations tracks. Use code vel09scf
> and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
> _______________________________________________
> Ledger-smb-users mailing list
> Ledger-smb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
>

--
A human being should be able to change a diaper, plan an invasion,
butcher a hog, conn a ship, design a building, write a sonnet, balance
accounts, build a wall, set a bone, comfort the dying, take orders,
give orders, cooperate, act alone, solve equations, analyze a new
problem, pitch manure, program a computer, cook a tasty meal, fight
efficiently, die gallantly. Specialization is for insects.
  -- Robert Heinlein




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

Message: 2
Date: Tue, 28 Apr 2009 14:37:12 -0700
From: "Roderick A. Anderson" <raanders-7IaPL7KgwnzfEv0LIimHRA@public.gmane.org>
Subject: Re: [Ledger-smb-users] Question about effects of installing
       LSMB on template1
To: ledger-smb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
Message-ID: <49F77708.8080002-7IaPL7KgwnzfEv0LIimHRA@public.gmane.org>
Content-Type: text/plain; charset=UTF-8; format=flowed

Chris Bennett wrote:
> I have someone struggling to install LSMB.
> He is concerned that because he has an Adempiere app installed already,
> that connecting to template1 in admin interface will cause trouble for
> other app.
>
> I understand that template1 is used to create new databases, but I saw
> that some alterations are made to it.
> Is there any real concern that any database app will cause problems for
> another?

Should not.  To elaborate on what Chris Travers said.  To do anything
with PostgreSQL you need to be connected to "a database".  Template1 is
just convenient and happens to be the "template" other databases are
created from.  You could connect to postgres users database - postgres.

The process of installing LSMB makes a new database from template1 then
connects to it.

If memory serves me nothing besides the creation of the LSMB database
happens in/to template1.

Sometimes a DBA/DBM may decide to add languages and other functionality
into template1 so new databases get them when created.


\\||/
Rod
--
>
> Chris Bennett
>




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

Message: 3
Date: Tue, 28 Apr 2009 14:39:00 -0700
From: Chris Travers <chris.travers-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
Subject: Re: [Ledger-smb-users] Question about effects of installing
       LSMB on template1
To: ledger-smb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
Message-ID:
       <f5cca7ed0904281439m6da37144o8a4740c5b072c342 <at> mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

On Tue, Apr 28, 2009 at 2:30 PM, Chris Bennett
<chris <at> bennettconstruction.biz> wrote:
>

> I saw a thread somewhere about how to use template0 to recreate template1.
> Does LedgerSMB create databases copying from template1 or installing
> into template1?

It is possible to install into template1, but normally it copies from
template 1.  I suppose we should probably catch this at create
database time and throw an error (we haven't done this yet because
SQL-Ledger didn't and we haven't gotten around to this point).

>
> And since I'm writing my own app for my vendors, customers and current
> prices,
> what is the right/wrong way to create new databases to avoid problems
> with other apps?

Ok.  On the first screen (which includes login info), you can leave it
at template1.  All this does is connect and get a list of current
db's.

On the second screen (with the chart of accounts options), you should
type the db you want to install into.  This should generally not be
template1.

Best Wishes,
Chris Travers



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

Message: 4
Date: Fri, 1 May 2009 10:16:21 -0400
From: geordie <geordi-cy0mvYQKRb0@public.gmane.org>
Subject: [Ledger-smb-users] LAN Setup
To: ledger-smb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
Message-ID: <200905011016.21736.geordi-cy0mvYQKRb0@public.gmane.org>
Content-Type: text/plain;  charset="us-ascii"

Hi
I need some help in seting LSMB to run on a household LAN. I have tried many
attempts. Between locking up a computer and just reading way to much and
getting confused, I decided I need some help. The senario I thought was quite
simple, I have Debian (Sidux) box with LSMB installed and I would like the
Windows Xp box to have assess to this information.

I believe /etc/postgresql/8.3/main/pg_hba.conf
should be setup like this

local   ledgersmb       all             169.XXX.X.X             md5

/etc/ledgersmb/ledgersmb.conf

DBname       = ledgersmb
DBhost       = localhost (does this need to be changed to 169.XXX.X.X )
DBport       = 5432
DBUserName   = ledgersmb

Do I need to change /etc/hosts

I am assuming apache2.2 needs to be modified, but I am at a loss to figuire
that out.

I am positive that I have missed something else.

I am open to all suggestions or links

Many thanks
Geordie



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

Message: 5
Date: Fri, 1 May 2009 10:28:06 -0500
From: "James Stevens" <jstevens-i+tpyP9RE+TR7s880joybQ@public.gmane.org>
Subject: Re: [Ledger-smb-users] LAN Setup
To: <ledger-smb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org>
Message-ID:
       <4680436EBAE96A4381400DC3C7B1C4FB03C3E9-Eq7w66SWOw5vAr953HGj7A@public.gmane.orgnk.net>
Content-Type: text/plain;       charset="us-ascii"

Change you point of view and you can easily accomplish this.

the pg_hba.conf file is telling Debian(postgreSQL) wher to listen and
how to authenticate sql sessions. It only needs to listen localy and
authenticate in that manner (trust). Authenticate the user ledgersmb in
your case localy.

Once that is done, meaning it works on the machine installed on you are
looking at apache to service request to remote users.
Which it should already our of the box.

Knowing the IP address of the Debian machine ( CLI-> ifconfig )
got to your Windows machine and typ http://<ipaddress of the
debian>/ledgersmb/admin.pl

What do you see?

Also go to http://<ipaddress of debian box>/

and tell us what you see...    i.e.
http://192.168.1.1/ledgersmb/login.pl

-----Original Message-----
From: geordie [mailto:geordi-cy0mvYQKRb0@public.gmane.org]
Sent: Friday, May 01, 2009 9:16 AM
To: ledger-smb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
Subject: [Ledger-smb-users] LAN Setup

Hi
I need some help in seting LSMB to run on a household LAN. I have tried
many
attempts. Between locking up a computer and just reading way to much and

getting confused, I decided I need some help. The senario I thought was
quite
simple, I have Debian (Sidux) box with LSMB installed and I would like
the
Windows Xp box to have assess to this information.

I believe /etc/postgresql/8.3/main/pg_hba.conf
should be setup like this

local   ledgersmb       all             169.XXX.X.X             md5

/etc/ledgersmb/ledgersmb.conf

DBname       = ledgersmb
DBhost       = localhost (does this need to be changed to 169.XXX.X.X )
DBport       = 5432
DBUserName   = ledgersmb

Do I need to change /etc/hosts

I am assuming apache2.2 needs to be modified, but I am at a loss to
figuire
that out.

I am positive that I have missed something else.

I am open to all suggestions or links

Many thanks
Geordie

------------------------------------------------------------------------
------
Register Now & Save for Velocity, the Web Performance & Operations
Conference from O'Reilly Media. Velocity features a full day of
expert-led, hands-on workshops and two days of sessions from industry
leaders in dedicated Performance & Operations tracks. Use code vel09scf
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

--
This message has been scanned for viruses and
dangerous content by SISLINK.NET. Come join us!


--
This message has been scanned for viruses and
dangerous content by SISLINK.NET. Come join us!




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

Message: 6
Date: Sat, 2 May 2009 13:53:04 +0100
From: Stroller <stroller-J8c/PZ/aHpCP1P/rox5WkSp2UmYkHbXO@public.gmane.org>
Subject: Re: [Ledger-smb-users] LAN Setup
To: ledger-smb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
Message-ID:
       <C2B60AE7-D94D-4555-BE4B-705285B2B4D0-J8c/PZ/aHpDUCtIbO7P5FQ@public.gmane.org.co.uk>
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes


On 1 May 2009, at 15:16, geordie wrote:
> ...
> DBhost       = localhost
> does this need to be changed to 169.XXX.X.X ?

I believe it does, assuming you can ping that address from the Windows
box.

As James observes, this is a slightly unusual network range to use -
192.168.x.y would be more common.

Stroller.





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

Message: 7
Date: Sat, 2 May 2009 08:28:11 -0500
From: "David A. Bandel" <david.bandel-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
Subject: Re: [Ledger-smb-users] LAN Setup
To: ledger-smb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
Message-ID:
       <ea6cc0c70905020628p280e2521m1e9c8626b411acba <at> mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

On Sat, May 2, 2009 at 7:53 AM, Stroller <stroller-J8c/PZ/aHpCP1P/rox5WkSp2UmYkHbXO@public.gmane.org> wrote:
>
> On 1 May 2009, at 15:16, geordie wrote:
>> ...
>> DBhost ? ? ? = localhost
>> does this need to be changed to 169.XXX.X.X ?

169.254.0.0/16 is a "zeroconf" address -- it's what Windoze uses when
it gets lost (can't figure out what it's address should be), but there
are zeroconf utilities for Linux and other Unices as well.

>
> I believe it does, assuming you can ping that address from the Windows
> box.
>
> As James observes, this is a slightly unusual network range to use -
> 192.168.x.y would be more common.

RFC 1918 outlines the following addresses for use within private networks:

    10.0.0.0        -   10.255.255.255  (10/8 prefix)
    172.16.0.0      -   172.31.255.255  (172.16/12 prefix)
    192.168.0.0     -   192.168.255.255 (192.168/16 prefix)

However, 169.254.0.0/16 is considered a bogus address. It can be found
in the bogon listings and will be dropped by properly configured
routers, so can be used as a private address group (but that's not
recommended).

>
> Stroller.
>
>
>
>

Ciao,

David A. Bandel
--
Focus on the dream, not the competition.
           - Nemesis Air Racing Team motto



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

Message: 8
Date: Sat, 02 May 2009 23:25:38 -0400
From: Michael Richardson <mcr <at> sandelman.ca>
Subject: Re: [Ledger-smb-users] LAN Setup
To: ledger-smb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
Message-ID: <28671.1241321138-mBdsjq6qcbCdmVUUUnPabdsHgeflEswW@public.gmane.org>
Content-Type: text/plain; charset=iso-8859-1


>>>>> "David" == David A Bandel <david.bandel-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> writes:
   David> 169.254.0.0/16 is a "zeroconf" address -- it's what Windoze
   David> uses when it gets lost (can't figure out what it's address
   David> should be), but there are zeroconf utilities for Linux and

 That's not fair.
 Windoz does get lost lots, but 169.254.0.0/16 was allocated
specifically for zeroconf, and it's a legitimate way to do networking.
 That windoz fails into using their network, and often route 0.0.0.0/0
to this LAN, so anyone within wireless listening of you can hijack *ALL*
your traffic, is certainly a sin, but...

 As you say, Linux and Mac (and Cisco and ...) can easily participate
in such a network, which usually is what you would permit to be
configured if you and your friends are having a LAN party in the middle
of the park.

 I would not call it a bogus address for this reason.
 It's not crazy to use this on your LAN, given Bonjour/LLDMS/mDNS/Avahi
(whichever you want to call it), you can use it along with a stable
name.
 I just don't recommend it either.

--
]     Y'avait une poule de jamm? dans l'muffler!!!!!!!!!        |  firewalls  [
]   Michael Richardson, Sandelman Software Works, Ottawa, ON    |net architect[
] mcr-SWp7JaYWvATD9fKxiKbVOGG8O1WwMoTE@public.gmane.org http://www.sandelman.ottawa.on.ca/ |device driver[
] panic("Just another Debian GNU/Linux using, kernel hacking, security guy"); [





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

------------------------------------------------------------------------------
Register Now & Save for Velocity, the Web Performance & Operations
Conference from O'Reilly Media. Velocity features a full day of
expert-led, hands-on workshops and two days of sessions from industry
leaders in dedicated Performance & Operations tracks. Use code vel09scf
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf

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

_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users


End of Ledger-smb-users Digest, Vol 33, Issue 1
***********************************************

------------------------------------------------------------------------------
Register Now & Save for Velocity, the Web Performance & Operations 
Conference from O'Reilly Media. Velocity features a full day of 
expert-led, hands-on workshops and two days of sessions from industry 
leaders in dedicated Performance & Operations tracks. Use code vel09scf 
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Phil Ross | 4 May 11:18 2009

Year end functionality? version 1.2.18

Hi everyone

I am looking for some information on the Year End functionality of
LedgerSMB. Unfortunately, I can't find much in the manual (excerpt
included below).

Can any users on this fine list (esp. any in the UK) shed any light on
what they do with LedgerSMB at year-end, and whether this
functionality is useful or any pitfalls or caveats?

Thanks
Phil

4.7.4 Year-end
Although the Year-end functionality in Ledger-SMB is very useful, it
does not entirely make the pro-
cess simple and painless. One must still manually enter adjustments
prior to closing the books. The
extent to which these adjustments are necessary for any given business
is a matter best discussed
with an accountant.
The standard way books are normally closed at the end of the year is
by moving all adjusted1
income and expenses to an equity account usually called "Retained
Earnings." Assets and liabilities
are not moved. Equity drawing/dividend accounts are also moved, but
the investment accounts are
not. The reasoning behind this process is that one wants a permanent
record of the amount invested
in a business, but any dividends ought not to count against their
recipients when new investors are
brought on board.
Ledger-SMB automatically moves all income and expense into the
specified year-end/retained
earnings account. It does not move the drawing account, and this must
be done manually, nor does
it automate the process of making adjustments.
Contrary to its name, this function can close the books at any time,
though this would likely be of
limited use.

------------------------------------------------------------------------------
Register Now & Save for Velocity, the Web Performance & Operations 
Conference from O'Reilly Media. Velocity features a full day of 
expert-led, hands-on workshops and two days of sessions from industry 
leaders in dedicated Performance & Operations tracks. Use code vel09scf 
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
GMAIL - James McDonald | 15 May 01:52 2009
Picon

Instructions on Setting Up the Account Tree

There are 2 Australia chart of accounts.

For each business they would have to be edited.

Is there any documented way of creating the COA in a spreadsheet format 
and then doing a load?

------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables 
unlimited royalty-free distribution of the report engine 
for externally facing server and web deployment. 
http://p.sf.net/sfu/businessobjects
Chris Travers | 15 May 06:38 2009
Picon

Re: Instructions on Setting Up the Account Tree

On Thu, May 14, 2009 at 4:52 PM, GMAIL - James McDonald
<james@...> wrote:
> There are 2 Australia chart of accounts.
>
> For each business they would have to be edited.
>
> Is there any documented way of creating the COA in a spreadsheet format
> and then doing a load?

Not documented, but....

you could:
1) save as a csv...
2) Upload into pgsql temporary table
3)  Use sql queries to move the info into the "chart" table.

Best Wishes,
Chris Travers

------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables 
unlimited royalty-free distribution of the report engine 
for externally facing server and web deployment. 
http://p.sf.net/sfu/businessobjects

Gmane