Re: [Ledger-smb-users] total newbie questions

2007-02-09 Thread John Locke
Hi Keith, Keith Lowe wrote: > Here's an example: I can enter a new vendor, and go to A/R-->Add > Transaction to enter a vendor bill, but then what's next? The manual > kind of says use Cash-->Payment or Payments, but I can't figure out > how that should work. And after I've entered several bill

Re: [Ledger-smb-users] Printing checks for transfers?

2007-02-09 Thread John Locke
Hi, Tony, Thanks a lot for your reply... I figured out exactly this method before seeing your response! Just coming back to the list to post the same solution to the archives ;-) Tony Fraser wrote: > Setup your CC company as a vendor. Mark you CC liability account > AP_amount. > > Do an AP Transa

Re: [Ledger-smb-users] Transition from sql-l to lsmb

2007-02-09 Thread Chris Travers
Thanks. Will review and probably apply. On 2/9/07, Rich Walker <[EMAIL PROTECTED]> wrote: > > Hi, > > This is a few comments on trying to do a transition from one to the > other, using the instructions on the Wiki. > > 1. Nothing told me to make sure ledgersmb.conf was set up. > > 2. The sl2ls.sh

[Ledger-smb-users] Transition from sql-l to lsmb

2007-02-09 Thread Rich Walker
Hi, This is a few comments on trying to do a transition from one to the other, using the instructions on the Wiki. 1. Nothing told me to make sure ledgersmb.conf was set up. 2. The sl2ls.sh script didn't work very well for me. It assumes an installation directory, and has DOS line-endings wh

Re: [Ledger-smb-users] Locale-specific issues?

2007-02-09 Thread Rich Walker
Ed W <[EMAIL PROTECTED]> writes: >> 1.2 has an ability to use loadable tax modules. This allows one to >> handle questions like "if I buy a muffin in a Toronto coffee shop, is >> it taxable?" where the answer is "It depends on what else you buy." >> The loadable tax modules have access to everyth

Re: [Ledger-smb-users] Locale-specific issues?

2007-02-09 Thread Ed W
> 1.2 has an ability to use loadable tax modules. This allows one to > handle questions like "if I buy a muffin in a Toronto coffee shop, is > it taxable?" where the answer is "It depends on what else you buy." > The loadable tax modules have access to everything on the invoice. > In the UK

Re: [Ledger-smb-users] Locale-specific issues?

2007-02-09 Thread Ed W
Hi > If you are supposed to put the VAT per line, how is this rounded? Or > do you round per line? Do you eat pennies at your report? > An additional complexity is that I seem to remember that you can either calculate the total vat based on the sub of the net line items, or you can calcula

Re: [Ledger-smb-users] Error on creating new customer

2007-02-09 Thread DK
I have 8.1.7 and will upgrade. Thank you all a lot. On 09/02/07, Seneca Cunningham <[EMAIL PROTECTED]> wrote: > > On Fri, Feb 09, 2007 at 09:22:25AM +0200, DK wrote: > > I new that I'm lucky. > > === > > test1=> insert into customer(name) values ('something'); > > ERROR: at

Re: [Ledger-smb-users] Error on creating new customer

2007-02-09 Thread Seneca Cunningham
On Fri, Feb 09, 2007 at 09:22:25AM +0200, DK wrote: > I new that I'm lucky. > === > test1=> insert into customer(name) values ('something'); > ERROR: attribute 9 has wrong type > DETAIL: Table has type character varying, but query expects character > varying. > ==

Re: [Ledger-smb-users] Error on creating new customer

2007-02-09 Thread Paul Browne
Managed to replicate the error below DBD::Pg::db do failed: ERROR: attribute 2 has wrong type DETAIL: Table has type character varying, but query expects character varying. Error! UPDATE vendor SET vendornumber = '2', name = 'L & M', address1 = 'L & M (Heating) Supplies LTD', address2 = 'Mike Jon

Re: [Ledger-smb-users] Error on creating new customer

2007-02-09 Thread Paul Browne
Have you modified the tables in any way, i.e. connected directly with MS Access or some other management tool? It looks like the update you are trying to do is in the wrong format, rather than a wrong value i.e. system is expecting a number and you are putting in alpha numeric. Just a thought??

Re: [Ledger-smb-users] Error on creating new customer

2007-02-09 Thread Chris Travers
Which version of PostgreSQL? You may also want to try on the PostgreSQL list (pg-general). We have a few PostgreSQL geeks on this list, but they have more, and better :-) Best Wishes, Chris Travers On 2/8/07, DK <[EMAIL PROTECTED]> wrote: > I new that I'm lucky. > === > test