Re: [Ledger-smb-users] Start a new system -> initial filling of the stock

2014-01-29 Thread John Griessen
On 01/29/2014 03:38 AM, Pongrácz István wrote: > So, my question, how can I handle this properly? I mean, how to receive goods > into my stock in ledgersmb, when the "vendor" is myself? > From equity. On 01/29/2014 06:46 AM, Pongrácz István wrote:> If I put amounts on the invoice for the goods

Re: [Ledger-smb-users] Receiving inventory is not working.

2014-01-29 Thread Chris Travers
On Wed, Jan 29, 2014 at 7:17 AM, Pongrácz István wrote: > > You should run setup.pl again against your existing database, as you have > missing column: > > DBD::Pg::st execute failed: ERROR: column a.crdate does not exist > > I use the same version of lsmb, with some additional patches, but could

Re: [Ledger-smb-users] Receiving inventory is not working.

2014-01-29 Thread Pongrácz István
You should run setup.pl again against your existing database, as you have missing column: DBD::Pg::st execute failed: ERROR: column a.crdate does not exist I use the same version of lsmb, with some additional patches, but could you explain, how to reproduce this error? Cheers, István

Re: [Ledger-smb-users] Centos 6.5 Install troubles - Solved

2014-01-29 Thread Dave
Thanks to all who responded. On 01/28/2014 07:25 PM, Chris Travers wrote: > I wrote > > I tried hardcoding the directories (/usr/lib/pgsql/pg_trgm.so > /usr/lib/pgsql/pg_trgm) but still the same error Snip. > psql:/usr/share/pgsql/contrib/tablefunc.sql:88: ERROR: could not access

Re: [Ledger-smb-users] Receiving inventory is not working.

2014-01-29 Thread Chris Travers
Thanks. Looking through the code it looks like an issue with your database schema not being fully upgraded as expected. Please try to run the following commands via psql: ALTER TABLE ar DISABLE TRIGGER ALL; ALTER TABLE ap DISABLE TRIGGER ALL; ALTER TABLE ap ADD COLUMN crdate date; ALTER TABLE a

Re: [Ledger-smb-users] Receiving inventory is not working.

2014-01-29 Thread M Lubratt
Thanks, Chris! That part is now working again and I see my error now. I did encounter the following regression on 1.3.37-rc3 when I tried to view a specific invoice. >From the Apache error.log: [Wed Jan 29 08:46:24 2014] [error] [client 192.168.1.108] Math::BigInt: couldn't load specified math

Re: [Ledger-smb-users] opening balances, including stock

2014-01-29 Thread Pongrácz István
Hi, Thanks for the comments! I spoke with my accountant and we found that, this question is in a special case of opening a new book, using some numbers from the old book. In other words: - we close the financial year in one book - we open the next financial year in a new book. We have to tran

Re: [Ledger-smb-users] Start a new system -> initial filling of thestock

2014-01-29 Thread Chris Travers
On Wed, Jan 29, 2014 at 5:24 AM, Nigel Titley wrote: > On 29/01/2014 12:46, Pongrácz István wrote: > > > > > > Hi, > > > > > Enter a vendor invoice against "Inventory Entity" for your initial > > inventory. > > > > Thanks Chris, I tried it, it works in that case, it increases the > > stock as ex

Re: [Ledger-smb-users] Start a new system -> initial filling of thestock

2014-01-29 Thread Nigel Titley
On 29/01/2014 12:46, Pongrácz István wrote: > > > Hi, > > > Enter a vendor invoice against "Inventory Entity" for your initial > inventory. > > Thanks Chris, I tried it, it works in that case, it increases the > stock as expected. > > So, you mean, the vendor could be the Inventory entity? > > If

Re: [Ledger-smb-users] Start a new system -> initial filling of thestock

2014-01-29 Thread Pongrácz István
Hi, > Enter a vendor invoice against "Inventory Entity" for your initial inventory. Thanks Chris, I tried it, it works in that case, it increases the stock as expected. So, you mean, the vendor could be the Inventory entity? If I put amounts on the invoice for the goods, it will increase som

Re: [Ledger-smb-users] Start a new system -> initial filling of the stock

2014-01-29 Thread Chris Travers
On Wed, Jan 29, 2014 at 1:38 AM, Pongrácz István wrote: > Hi, > > I abandon my old SL system and I started using a fresh installed > ledgersmb. I do not want to import all the data from the old system, only > enter valid and clarified items, vendors, customers etc. > > In my real stock I have some

[Ledger-smb-users] Start a new system -> initial filling of the stock

2014-01-29 Thread Pongrácz István
Hi, I abandon my old SL system and I started using a fresh installed ledgersmb. I do not want to import all the data from the old system, only enter valid and clarified items, vendors, customers etc. In my real stock I have some stuff and I would like to add them to my new system, so, populat