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

2008-05-29 Thread Chris Travers
> That would be good for some things, but whitespace at the ends of the > string should be safe to eliminate everywhere, and spaces within as well, > but with a checkbox in defaults. > Allowable characters configurable in defaults, with a starting (default) > effective value of the regexp "[a-zA-Z0

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

2008-05-29 Thread Joshua D. Drake
Chris Travers wrote: > One important point here which gets lost: Accounting knowledge is > vital to running a business. > > I don't care what accounting system you get, you really want to have > an accountant you can ask accounting questions to. The reason is that > no system is going to meet eve

Re: [Ledger-smb-users] Incorrect credit records in ap table (v1.2.12 with some individual ar/ap updates)

2008-05-29 Thread Gerald Chudyk
On 5/29/08, Chris Travers <[EMAIL PROTECTED]> wrote: > On Thu, May 29, 2008 at 7:42 PM, Gerald Chudyk <[EMAIL PROTECTED]> wrote: > > On 5/29/08, Chris Travers <[EMAIL PROTECTED]> wrote: > >> On Thu, May 29, 2008 at 1:27 PM, Gerald Chudyk <[EMAIL PROTECTED]> wrote: > >> > Hi all, > >> > > >>

Re: [Ledger-smb-users] Incorrect credit records in ap table (v1.2.12 with some individual ar/ap updates)

2008-05-29 Thread Chris Travers
On Thu, May 29, 2008 at 7:42 PM, Gerald Chudyk <[EMAIL PROTECTED]> wrote: > On 5/29/08, Chris Travers <[EMAIL PROTECTED]> wrote: >> On Thu, May 29, 2008 at 1:27 PM, Gerald Chudyk <[EMAIL PROTECTED]> wrote: >> > Hi all, >> > >> > While researching issues in the ar/ap reports, I have discovered >>

Re: [Ledger-smb-users] Incorrect credit records in ap table (v1.2.12 with some individual ar/ap updates)

2008-05-29 Thread Gerald Chudyk
On 5/29/08, Chris Travers <[EMAIL PROTECTED]> wrote: > On Thu, May 29, 2008 at 1:27 PM, Gerald Chudyk <[EMAIL PROTECTED]> wrote: > > Hi all, > > > > While researching issues in the ar/ap reports, I have discovered > > records in the ap table which appear to be incorrect. One example: > > > >

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

2008-05-29 Thread steven . marshall
[EMAIL PROTECTED] wrote on 05/29/2008 06:26:21 PM: > "Chris Travers" <[EMAIL PROTECTED]> > > defaults should be dumped. If it is not being dumped, I wonder why. > > Any errors in the PostgreSQL error log? > > Best Wishes, > Chris Travers > > Yes. Here are the errors I received. I cut out

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

2008-05-29 Thread Luke
On Thu, 29 May 2008, Stroller wrote: > You snipped too early. > > Without the linebreak, he said: > >[EMAIL PROTECTED]:~> grep -i printer >/usr/local/ledgersmb/ledgersmb.conf -A 3 >[printers] ># Available printers >#Laser = lpr -Plaser >#Epson = lpr -PEpson >

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

2008-05-29 Thread Chris Travers
On Thu, May 29, 2008 at 3:04 PM, Stroller <[EMAIL PROTECTED]> wrote: > > On 29 May 2008, at 22:16, [EMAIL PROTECTED] wrote: >> ... it >> doesn't appear that my data from the defaults table was included in my >> backup, therefore, it didn't get restored into my test database >> >> >> [EMAIL PROTECT

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

2008-05-29 Thread Stroller
On 29 May 2008, at 22:16, [EMAIL PROTECTED] wrote: > ... it > doesn't appear that my data from the defaults table was included in my > backup, therefore, it didn't get restored into my test database > > > [EMAIL PROTECTED]:~/data> pg_dump -a tatylee > tatyleebackup.sql > [EMAIL PROTECTED]:~/data>

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

2008-05-29 Thread Stroller
On 29 May 2008, at 16:30, Luke wrote: > On Thu, 29 May 2008, [EMAIL PROTECTED] wrote: > >>> Have you set up the printer in Ledger-SMB? > [.] >> Yes, I have setup the printer in LedgerSMB. Here is my printer >> configuration. I am mainly concerned with the Star Receipt Printer. >> >> [EMAIL PROT

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

2008-05-29 Thread steven . marshall
I am still researching my issue and have come to the conclusion that the SQL-Ledger to LedgerSMB migration has screwed up my database. I am hoping someone can help me fix this. 1. I created two new datasets via the LedgerSMB admin.pl. I then compared these two databases, via pgAdmin, with m

Re: [Ledger-smb-users] Incorrect credit records in ap table (v1.2.12 with some individual ar/ap updates)

2008-05-29 Thread Chris Travers
On Thu, May 29, 2008 at 1:27 PM, Gerald Chudyk <[EMAIL PROTECTED]> wrote: > Hi all, > > While researching issues in the ar/ap reports, I have discovered > records in the ap table which appear to be incorrect. One example: > > ap.amount = -4919.89 > ap.netamount = 5198.36 (should be -4641.42) > The

[Ledger-smb-users] Incorrect credit records in ap table (v1.2.12 with some individual ar/ap updates)

2008-05-29 Thread Gerald Chudyk
Hi all, While researching issues in the ar/ap reports, I have discovered records in the ap table which appear to be incorrect. One example: ap.amount = -4919.89 ap.netamount = 5198.36 (should be -4641.42) The AP transaction report gets real excited about this and reports tax= (2 * netamount) + (n

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

2008-05-29 Thread steven . marshall
OK. I fixed the issue where I couldn't generate a PDF. It turns out that when I copied my settings from sql-ledger.conf to ledgersmb.conf I had a typo in the following line: WRONG: PATH: /usr/local/texlive/2007/bin/i386-linux"; CORRECT:PATH: /usr/local/texlive/2007/bin/i386-linux Thi

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

2008-05-29 Thread steven . marshall
Yes, I can print to this using the `lpr -P Star_TSP643U file.txt' using the command line from a Unix shell. I do not appear to be able to generate a PDF via LedgerSMB either. I have SQL-Ledger also installed on the same machine with a previous backup dataset. From SQL-Ledger I am able to gen

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

2008-05-29 Thread Luke
On Thu, 29 May 2008, [EMAIL PROTECTED] wrote: > > Have you set up the printer in Ledger-SMB? [.] > Yes, I have setup the printer in LedgerSMB. Here is my printer > configuration. I am mainly concerned with the Star Receipt Printer. > > [EMAIL PROTECTED]:~> grep -i printer > /usr/local/ledgers

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

2008-05-29 Thread Stroller
On 29 May 2008, at 15:55, [EMAIL PROTECTED] wrote: >> 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 an

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

2008-05-29 Thread Stroller
On 29 May 2008, at 15:45, [EMAIL PROTECTED] wrote: > ... > Yes, I have setup the printer in LedgerSMB. Here is my printer > configuration. I am mainly concerned with the Star Receipt Printer. > > [EMAIL PROTECTED]:~> grep -i printer > /usr/local/ledgersmb/ledgersmb.conf -A 3 > [printers] > # Ava

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

2008-05-29 Thread steven . marshall
Mine defaults to my Star Receipt Printer and also defaults to Postscript. If I create a regular Sales Invoice from AR/Sales Invoice and click the print button, I get returned an HTML page with the text "Error!". Nothing more. [EMAIL PROTECTED] wrote on 05/28/2008 11:51:59 PM: > Luke <[EMAIL

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

2008-05-29 Thread steven . marshall
> > Have you set up the printer in Ledger-SMB? > >$ grep -i printer /usr/local/ledgersmb/ledgersmb.conf -A 3 >[printers] ># Available printers >#Laser = lpr -Plaser >#Epson = lpr -PEpson >Laserjet4000 = lpr -PLaserjet4000 >$ > Yes, I have setup the printer