Re: [Ledger-smb-users] At the end of my teather with LSMB

2008-05-28 Thread richard
Quoting Stroller <[EMAIL PROTECTED]>: > Not all UK businesses are VAT registered, however. VAT is the > equivalent, I think, of US sales tax, and one is only obliged to be > VAT registered if one has a turn over in excess of (approximately) > $100,000 per year. > > The accounting and reporting requ

Re: [Ledger-smb-users] At the end of my teather with LSMB

2008-05-28 Thread richard
Quoting Stroller <[EMAIL PROTECTED]>: > No. There are only 12 invoices issued in May in this example. > Presumable the issuer is a consultant, or someone who otherwise only > works for a handful of companies at day rates. > > Tch! This should be obvious! Bah. My brain hurts. I clearly hadn't con

Re: [Ledger-smb-users] POS Screen - Errors when posting an invoice

2008-05-28 Thread Luke
On Wed, 28 May 2008, [EMAIL PROTECTED] wrote: > I am having several issues trying to post an invoice via the POS Add > Invoice screen. This is a recent SQL-Ledger to LedgerSMB migration. When > I create a sale and click on Print and Post, I get two issues. > > 1. The receipt is displayed in t

Re: [Ledger-smb-users] At the end of my teather with LSMB

2008-05-28 Thread Luke
On Wed, 28 May 2008, Chris Travers wrote: > However, this doesn't get to the question as to what qualifies an > invoice number as unique, considering the following possibilities: > > "12345" > "12345." > "12345 " > "12345," > "12345-" > "12345V" > "12345[tab]" > "12345-VOID" > " 12345" > " 12345

Re: [Ledger-smb-users] Postgresql Replication

2008-05-28 Thread Luke
Would an SSH tunnel, which is port forwarding of only a single set of ports, be allowable? If not, then the SSL web option may be the best. (That one may have been posted on the SL list, not sure) Luke On Wed, 28 May 2008, [EMAIL PROTECTED] wrote: > Thanks for the reply! We do use Openvpn for

Re: [Ledger-smb-users] At the end of my teather with LSMB

2008-05-28 Thread Chris Travers
On Wed, May 28, 2008 at 6:27 PM, Stroller <[EMAIL PROTECTED]> wrote: > > On 28 May 2008, at 04:29, Chris Travers wrote: >> ...but here are a few things to consider: >> >> Invoice is printed but not posted. Gap in number occurs. > > IMO this shouldn't occur. Here in the UK, once an invoice has been

Re: [Ledger-smb-users] POS Screen - Errors when posting an invoice

2008-05-28 Thread Stroller
Hi Steven, Any chance you could make your posts to the list in plain-text format, please? Your fixed-width font shows up very small on my system, and is quite difficult to read; even when enlarged (which is an inconvenience) is it still grey, rather than black. On 28 May 2008, at 22:36, [E

Re: [Ledger-smb-users] At the end of my teather with LSMB

2008-05-28 Thread Stroller
On 28 May 2008, at 12:00, Luke wrote: > > So it requires you to print in order to post? That's what it > sounds like. > > This requirement to print would drive a great many US based companies > crazy--they (domain registrars, for example) never deal with paper in > connection with the customer:

Re: [Ledger-smb-users] At the end of my teather with LSMB

2008-05-28 Thread Stroller
On 28 May 2008, at 08:41, Luke wrote: > On Wed, 28 May 2008, [EMAIL PROTECTED] wrote: >> Quoting Stroller <[EMAIL PROTECTED]>: >> >>> I did a "starting your own business" course at the local Chamber of >>> Commerce before I became self-employed 3 or 4 years ago, and my >>> understanding at that ti

Re: [Ledger-smb-users] At the end of my teather with LSMB

2008-05-28 Thread Stroller
On 28 May 2008, at 04:29, Chris Travers wrote: > ...but here are a few things to consider: > > Invoice is printed but not posted. Gap in number occurs. IMO this shouldn't occur. Here in the UK, once an invoice has been printed - and one must assume that it may be sent automatically to the cu

Re: [Ledger-smb-users] At the end of my teather with LSMB

2008-05-28 Thread Stroller
On 28 May 2008, at 19:12, [EMAIL PROTECTED] wrote: > Quoting Stroller <[EMAIL PROTECTED]>: > >> Yes, but there's an obvious difference between: >> >> 00042 >> 00043 >> 00044 >> 00046(missing number precedes) >> >> and: >> >> 20080501 >> 20080502 >> 20080503 >> 20080512 (issued on the last

Re: [Ledger-smb-users] Postgresql Replication

2008-05-28 Thread lai
Chris: Thank you for the response! As we really need the data near real time so we are probably going to head down the Slony-I direction. Thanks for the pointer on the primary key and it just darn on me when I read your email. However, it probably shouldn't be a show stoper as it should be alright

Re: [Ledger-smb-users] Postgresql Replication

2008-05-28 Thread lai
Thanks for the reply! We do use Openvpn for our offices but as this server is hosted so by company policy it is not allowed to have a VPN connection into to our network. Further, when it comes to the data layer we would like to have it be managed by our databases. I apologize that we still use SL,

[Ledger-smb-users] POS Screen - Errors when posting an invoice

2008-05-28 Thread steven . marshall
I am having several issues trying to post an invoice via the POS Add Invoice screen. This is a recent SQL-Ledger to LedgerSMB migration. When I create a sale and click on Print and Post, I get two issues. 1. The receipt is displayed in the browser window instead of being sent to the receipt p

Re: [Ledger-smb-users] Postgresql Replication

2008-05-28 Thread Charley Tiggs
Chris Travers wrote: > One simple option is a shell script like such: > > dropdb -h $EXTERNAL_HOST -U postgres $SL_DATASET > createdb -h $EXTERNAL_HOST -U postgres $SL_DATASET > pg_dump -h $INTERNAL_HOST -U postgres $SL_DATASET | psql -U postgres > -h $EXTERNAL_HOST $SL_DATASET > > Set the approp

Re: [Ledger-smb-users] At the end of my teather with LSMB

2008-05-28 Thread richard
Quoting Stroller <[EMAIL PROTECTED]>: > Yes, but there's an obvious difference between: > > 00042 > 00043 > 00044 > 00046 (missing number precedes) > > and: > > 20080501 > 20080502 > 20080503 > 20080512 (issued on the last day of May) > 20080601 > ... > 20090101 > > If one accepts that date-based

Re: [Ledger-smb-users] Postgresql Replication

2008-05-28 Thread Josh Berkus
Tim, > hello all...our business has now the need to replicate our sl/postgres db > from our main office in ca to ny as the ny system (public and outside of > our firewall) has the need to generate non-critical read only invoice and > inventory reports. our requirements are real simple and slony-i

Re: [Ledger-smb-users] Postgresql Replication

2008-05-28 Thread Chris Travers
On Wed, May 28, 2008 at 10:16 AM, Stroller <[EMAIL PROTECTED]> wrote: > > On 28 May 2008, at 08:00, [EMAIL PROTECTED] wrote: > >> hello all...our business has now the need to replicate our sl/ >> postgres db >> from our main office in ca to ny as the ny system (public and >> outside of >> our firew

Re: [Ledger-smb-users] Postgresql Replication

2008-05-28 Thread Stroller
On 28 May 2008, at 08:00, [EMAIL PROTECTED] wrote: > hello all...our business has now the need to replicate our sl/ > postgres db > from our main office in ca to ny as the ny system (public and > outside of > our firewall) has the need to generate non-critical read only > invoice and > inven

Re: [Ledger-smb-users] At the end of my teather with LSMB

2008-05-28 Thread Stroller
On 28 May 2008, at 07:58, [EMAIL PROTECTED] wrote: > Quoting Stroller <[EMAIL PROTECTED]>: > >> >> On 27 May 2008, at 18:06, [EMAIL PROTECTED] wrote: >>> ... In the UK ... there is a requirement that invoices be >>> consecutively >>> numbered. >> >> Is this new? >> >> I did a "starting your own b

Re: [Ledger-smb-users] Postgresql Replication

2008-05-28 Thread Chris Travers
On Wed, May 28, 2008 at 12:45 AM, Luke <[EMAIL PROTECTED]> wrote: > On Wed, 28 May 2008, [EMAIL PROTECTED] wrote: > >> hello all...our business has now the need to replicate our sl/postgres db >> from our main office in ca to ny as the ny system (public and outside of >> our firewall) has the need

Re: [Ledger-smb-users] At the end of my teather with LSMB

2008-05-28 Thread Chris Travers
On Wed, May 28, 2008 at 7:59 AM, beamends <[EMAIL PROTECTED]> wrote: > > On Wed, 2008-05-28 at 10:06 +0100, [EMAIL PROTECTED] wrote: >> Quoting Luke <[EMAIL PROTECTED]>: >> >> >> From the web site: >> > >> > http://www.hmrc.gov.uk/vat/records-valid-invoice.htm >> > >> > We get this: >> > >> > " >>

Re: [Ledger-smb-users] At the end of my teather with LSMB

2008-05-28 Thread Chris Travers
On Wed, May 28, 2008 at 12:03 AM, <[EMAIL PROTECTED]> wrote: > Quoting Chris Travers <[EMAIL PROTECTED]>: > >> Now for midsize businesses entering lots of invoices, this may not be >> reasonable. Basically it means you are extremely limited in terms of >> scalability, and after you have a few peo

Re: [Ledger-smb-users] Problem w/POS after SQL-Ledger to Ledgersmb migration

2008-05-28 Thread Chris Travers
On Tue, May 27, 2008 at 8:21 PM, <[EMAIL PROTECTED]> wrote: > > >> Ok. When you run top on the server during this process, what takes up >> most of the time. >> >> I would bet it is postgres, right? >> >> 1) Do you use departments or projects? >> 2) Do you vacuum frequently? >> >>Best WIshes, >

Re: [Ledger-smb-users] At the end of my teather with LSMB

2008-05-28 Thread beamends
On Wed, 2008-05-28 at 10:06 +0100, [EMAIL PROTECTED] wrote: > Quoting Luke <[EMAIL PROTECTED]>: > > >> From the web site: > > > > http://www.hmrc.gov.uk/vat/records-valid-invoice.htm > > > > We get this: > > > > " > > How VAT sales invoices must be numbered > > > >You must number your sales i

Re: [Ledger-smb-users] A fun accounting tutorial, find out what 'Debit' really means :)

2008-05-28 Thread Pascal Vallet
Thanks that's great. Pascal Vallet Chef d'établissement / Principal -- Adresse : Ecole Internationale Française de Bali Jalan Umalas Kauh n. 76 Kerobokan - Kuta Bali 80117 Indonésie -- Tel : +62 361 732 314 Fax : +62 361 732 315 -- Site web : http://www.eifbali.com

[Ledger-smb-users] Mukti currencies

2008-05-28 Thread Pascal Vallet
I am a new user of ledger smb, i have tried many software and it looks like this open source i pretty complete. Before going further in my investigation and also because I'm not a specialist, i would like to know something about the multiple currencies. We are a school in Indonesia, the pare

[Ledger-smb-users] A fun accounting tutorial, find out what 'Debit' really means :)

2008-05-28 Thread Terry Porter
Gday, Following the recent posts, I thought I'd fix up and make available an excellent and simple tutorial I downloaded years ago, and which allowed me to finally understand what a "debit" is !!! I Downloaded this tutorial from http://www.access.wvu.edu/class/acctutor/accthome.htm but this URL

Re: [Ledger-smb-users] At the end of my teather with LSMB

2008-05-28 Thread beamends
On Wed, 2008-05-28 at 07:00 -0400, Luke wrote: > On Wed, 28 May 2008, beamends wrote: > > > My current system only generates invoice (or anything else) numbers when > > printing. If you subsequently want to e-mail it, it has an e-mail button > > to do that. After printing, you can re-open (for e-

Re: [Ledger-smb-users] At the end of my teather with LSMB

2008-05-28 Thread Luke
On Wed, 28 May 2008, beamends wrote: > My current system only generates invoice (or anything else) numbers when > printing. If you subsequently want to e-mail it, it has an e-mail button > to do that. After printing, you can re-open (for e-mailing etc) or > re-printing etc, but cannot change the i

Re: [Ledger-smb-users] At the end of my teather with LSMB

2008-05-28 Thread richard
Quoting Luke <[EMAIL PROTECTED]>: >> From the web site: > > http://www.hmrc.gov.uk/vat/records-valid-invoice.htm > > We get this: > > " > How VAT sales invoices must be numbered > >You must number your sales invoices in sequential order. If you spoil >or cancel a serially numbered invoice,

Re: [Ledger-smb-users] At the end of my teather with LSMB

2008-05-28 Thread beamends
On Wed, 2008-05-28 at 03:52 -0400, Luke wrote: > On Wed, 28 May 2008, [EMAIL PROTECTED] wrote: > > > Quoting Chris Travers <[EMAIL PROTECTED]>: > > > > > Now for midsize businesses entering lots of invoices, this may not be > > > reasonable. Basically it means you are extremely limited in terms

Re: [Ledger-smb-users] At the end of my teather with LSMB

2008-05-28 Thread richard
Quoting Luke <[EMAIL PROTECTED]>: > Require printing, emailing, etc., to be done *after* the fact of invoice > generation and postal, not prior to posting. This seems perfectly reasonable to me. I can't think of any circumstances in which I would want to print or email an invoice that has no

Re: [Ledger-smb-users] At the end of my teather with LSMB

2008-05-28 Thread richard
Quoting Luke <[EMAIL PROTECTED]>: > Or is it just because of the gaps? If because of the gaps, then the only > invoice numbering possible, is sequential with zero gaps. > This no gaps thing is most strange from a U.S. prospective. It's the gaps. I'll double-check this with my accountant when I

Re: [Ledger-smb-users] At the end of my teather with LSMB

2008-05-28 Thread Luke
On Wed, 28 May 2008, [EMAIL PROTECTED] wrote: > Quoting Chris Travers <[EMAIL PROTECTED]>: > > > Now for midsize businesses entering lots of invoices, this may not be > > reasonable. Basically it means you are extremely limited in terms of > > scalability, and after you have a few people in your

Re: [Ledger-smb-users] Postgresql Replication

2008-05-28 Thread Luke
On Wed, 28 May 2008, [EMAIL PROTECTED] wrote: > hello all...our business has now the need to replicate our sl/postgres db > from our main office in ca to ny as the ny system (public and outside of > our firewall) has the need to generate non-critical read only invoice and > inventory reports. our

Re: [Ledger-smb-users] At the end of my teather with LSMB

2008-05-28 Thread Luke
On Wed, 28 May 2008, [EMAIL PROTECTED] wrote: > Quoting Stroller <[EMAIL PROTECTED]>: > > > > > I did a "starting your own business" course at the local Chamber of > > Commerce before I became self-employed 3 or 4 years ago, and my > > understanding at that time was that invoice numbers had to be

Re: [Ledger-smb-users] At the end of my teather with LSMB

2008-05-28 Thread Luke
On Wed, 28 May 2008, [EMAIL PROTECTED] wrote: > > The default is already to increment them (except that they don't reset at > > the start of the month, if you use something like > ?>-001 as your default). I think they should always seek the lowest > > possible number, which would cause a reset.

Re: [Ledger-smb-users] At the end of my teather with LSMB

2008-05-28 Thread richard
Quoting Chris Travers <[EMAIL PROTECTED]>: > Now for midsize businesses entering lots of invoices, this may not be > reasonable. Basically it means you are extremely limited in terms of > scalability, and after you have a few people in your AR department, > they end up waiting on eachothers' tran

[Ledger-smb-users] Postgresql Replication

2008-05-28 Thread lai
hello all...our business has now the need to replicate our sl/postgres db from our main office in ca to ny as the ny system (public and outside of our firewall) has the need to generate non-critical read only invoice and inventory reports. our requirements are real simple and slony-i seems to be an