Ok, I think the best solution would be to build a custom report using
> the report_framework add-on. Basically that provides a basic
> framework for taking parameters, passing them to a stored procedure
> and taking the results and displaying it in a template that can
> produce csv, html, or pdf.
Thanks, Chris
Ok, so as I understand your problem:
>
> 1) you need all transactions associated with a specific account
> 2) You need all lines on all these transactions.
>
1) Yes, I need all transactions associated with a specific account
2) Yes, all lines, but the only information needed is the
Thanks for the quick response, Chris
> Can you provide a clear specification for the report output you are
> looking for?
>
> 1) What subset of transactions should be listed?
> 2) What lines in these transactions should be listed?
>
> 1) I need the opposing Account name of the trans
action on th
> My guess is that they are both on the report but on different dates,
> and ordered by date first and then transaction.
>
> Thanks, Chris!
Does anyone have any ideas on how to get the corresponding Account printed
on the ledger page?
For example, for a utility paid and booked into the Utilities A
Thanks, Chris
>
> I am not quite sure I understand what you are trying to do.
>
> You aren't likely to see cabbage sales on both sides unless that is
> your invoice description. More likely you might see:
>
> Cabbage Inventory (right side credit), Cabbage Cost of Goods Sold
> (Left Side Debit) if
Hi,
I'm using LSMB 1.3.12.
I want to print out the ledger with the corresponding double-entry category.
For example, if I had a transaction where I made a cash sale of cabbage to
someone:
Cabbage Cash 1.00 (left side debit) Cabbage Sales 1:00 (right side credit)
I've tried checking 'Account' i
Thanks, Erik,
> Error!*
>> *DELETE FROM gl WHERE id = '1'*
>> *
>> ERROR: permission denied for relation yearend*
>> *CONTEXT: SQL statement "delete from yearend where trans_id = old.id"*
>> PL/pgSQL function "del_yearend" line 3 at SQL statement*
>>
>
> To solve that you need to ru:
>
> GRANT del
Thanks, Erik,
> Well the short term solution would be to use psql to log into your
> database and issue
>
> GRANT delete ON gl TO ;
>
> OK. I did that and now get the following:
Error!*
*DELETE FROM gl WHERE id = '1'*
*ERROR: permission denied for relation yearend*
*CONTEXT: SQL statement "delete
>
> Hope that helps!
>
> Bye,
>
>
> Erik.
> Thanks, Erik
>
I'm using 1.3 and would really like to be able to delete the transactions.
I file a corporate return and my tax accountant works off the paper ledger
printout underscored by the copies of the paper double-entry invoices I
furnish so the au
Hi,
I'm trying to delete transactions from the Edit General Ledger Transaction
screen, but keep getting the following error:
Error!*
*DELETE FROM gl WHERE id = '1'*
ERROR: permission denied for relation gl*
I tried going to Admin Users > Search Users and making sure all the
permissions boxes were
Oops!
The last part should have read as follows:
> I checked
> root@AELS:/var/log/apache2# find / -name tablefunc.control
> and found:
> /usr/share/postgresql/9.1/extension/tablefunc.control
> *Changed the line in ledgersmb.conf from:
> contrib_dir = /usr/share/pgsql/contrib/
>
to:
contrib_dir = /
Hi Chris,
> ok, so here's a sort of fix of last resort.
> >
> > Change the alias line from /ledgersmb/ to /lsmb_13/
>
> you'd also have to change the urls you use from ledgersmb to lsmb_13
> in your browser. However, just do that for the login url and the rest
> will work fine.
>
Did those step
Hi again,
You have another ledgersmb-httpd.conf file somewhere which is masking
> this. Try searching /etc/ for it.
>
> I did a search and found a number of files with same name and I removed
all of them.
Now,
/# find / -name ledgersmb-httpd.conf
/usr/share/1.3/ledgersmb-httpd.conf
root@AELS:/#
Hi Chris,
>
> Yep.
>
> Progress.
>
Now I get the following error message after restart:
root@AELS:/usr/share/1.3# /etc/init.d/apache2 restart
Restarting web server: apache2[Fri Mar 23 10:51:53 2012] [warn] The Alias
directive in /usr/share/1.3/ledgersmb-httpd.conf at line 3 will probably
never mat
Hi again,
sed -e "s|WORKING_DIR|$PWD|g" ledgersmb-httpd.conf.template >
> ledgersmb-httpd.conf
>
> That should work.
It worked. Thanks. Now I have a ledgersmb-httpd.conf file in:
/usr/share/1.3
However, the apache2 restart gives:
> apache2: Syntax error on line 231 of /etc/apache2/apache2.conf
Hi again, Chris,
>
> sed -e "s/WORKING_DIR/$PWD/g" ledgersmb-httpd.conf.template >
> ledgersmb-httpd.conf
>
> I tried the above and got this:
root@AELS:/# sed -e "s/WORKING_DIR/$PWD/g" ledgersmb-httpd.conf.template >
ledgersmb-httpd.conf
sed: -e expression #1, char 16: unknown option to `s'
Thank
Hi Chris,
"What errors did you get starting Apache? Maybe there is a conflict
between some configuration files somewhere?"
I just tried to reboot apache and got this:
root@AELS:/var/log/apache2# /etc/init.d/apache2 restart
apache2: Syntax error on line 231 of /etc/apache2/apache2.conf: Could n
Hi Chris,
On Fri, Mar 23, 2012 at 9:18 AM, Chris Travers wrote:
> >
> I think at this point 1.3 can be run from branches/1.3.
>
> Yes, I'd like to try.
At the moment, I've used the commands you suggested:
"cd /usr/share/
rm -rf ledger-smb
svn co
https://ledger-smb.svn.sourceforge.net/svnroot/led
On Thu, Mar 22, 2012 at 3:18 PM, Håvard Sørli wrote:
>
> "Suggestions for Google Mail's Web Browser Client"
> https://www.haiku-os.org/community/ml/etiquette
>
> Thank you. Very helpful.
> >>
> http://sourceforge.net/projects/ledger-smb/files/latest/download?source=files
> >
> Yes. With Chris'
On Wed, Mar 21, 2012 at 5:38 PM, Chris Travers wrote:
> Hi Billy;
>
> I went back and checked and it looks like you installed trunk from
> svn.
Thank you for checking.
I haven't had trouble creating databases in trunk. This being
> said there are a number of known-broken features in trunk at
On Wed, Mar 21, 2012 at 7:05 PM, Håvard Sørli wrote:
> On 21. mars 2012 09:23, billy akazawa wrote:
> > I'm trying to answer all questions, but perhaps the way I'm putting them
> > into the e-mails is confusing – my apologies.
>
> A tip: http://learn.to/quote/
>
4:27 PM, Chris Travers wrote:
> On Wed, Mar 21, 2012 at 12:11 AM, Håvard Sørli wrote:
> > On 20. mars 2012 21:53, billy akazawa wrote:
> >> Super-user login postgres
> >> Password postgres
> >> Database aels
> >
> > What happens in the postgres an
Sorry, Håvard,
Thanks for pointing this out.
Parameters for http://localhost/ledgersmb/setup.pl
The screen says Database Management Console
http://localhost/ledgersmb/setup.pl
Superuser Credentials
Super-user login postgres
Password postgres
Database aels
Clicking on Login
brings up the
tions
On Tue, Mar 20, 2012 at 10:36 AM, Chris Travers wrote:
> On Mon, Mar 19, 2012 at 2:11 PM, billy akazawa
> wrote:
> > Hi everyone,
> > How do I connect to the database I want to use through ledgersmb?
> > The endless loop still keeps me from logging in.
> >
!*
Database is not the expected version. Was 1.3.0, expected 1.3.12. Please
re-run setup.pl against this database to correct.*
Thanks in advance.
Billy
On Mon, Mar 19, 2012 at 8:27 PM, Chris Travers wrote:
> On Sun, Mar 18, 2012 at 2:37 PM, billy akazawa
> wrote:
> > Hi,
> >
> &
ft_edit
1 | lsmb_aels__file_attach_order
1 | lsmb_aels__file_attach_part
:
this continues for many pages and ends with
1 | lsmb_aels__warehouse_edit
1 | lsmb_aels__yearend_run
(113 rows)
(END):
Thanks again!
Billy
On Mon, Mar 19, 2012 at 7:06 AM, Erik Huelsmann wrote:
> hi Billy,
>
> On Sun, Mar 18, 2012
e only database created
by ledgersmb is 'aels'
Håvard,
Logging in at setup.pl gives the database as 'postgres'
Thanks in advance.
Billy
On Sun, Mar 18, 2012 at 8:21 PM, Håvard Sørli wrote:
> On 17. mars 2012 23:51, billy akazawa wrote:
>
Hi,
I'm starting a new thread for this error.
Thanks to everyone, ledgersmb now can create databases, but they cannot be
accessed through the application.
Attempting to log in at the screen displayed by
http://localhost/ledgersmb/login.pl
Results in the error message:
Error!
Database is not
2012 at 3:49 PM, Chris Travers wrote:
> On Fri, Mar 16, 2012 at 11:35 PM, billy akazawa
> wrote:
> > Here I am again,
> >
> > Thanks Jame and Chris!
> >
> > Jame, you're right. I had 8.4 and 9.0 installed before. I removed them
> using
> > the Syn
Here I am again,
Thanks Jame and Chris!
Jame, you're right. I had 8.4 and 9.0 installed before. I removed them
using the Synaptic Package Manager in System.
Chris,
Changed from localhost to 127.0.0.1
Now the section in ledgersmb.conf is set as follows:
port = 5432
default_db = lsmb13
host = 1
Fri, Mar 16, 2012 at 10:02 PM, billy akazawa
> wrote:
> > Hi,
> >
> > Thank you for the super-fast response.
> >
> > I can get up to the Data Management Console now and fill in the
> information.
> > The problem is the next screen demands the ledgersmb
tions on
port 5432? at /usr/local/share/perl/5.10.1/LedgerSMB.pm line 981, referer:
http://localhost/ledgersmb/setup.pl
Thanks again!!
Billy
On Sat, Mar 17, 2012 at 1:36 PM, Chris Travers wrote:
> On Fri, Mar 16, 2012 at 9:35 PM, Chris Travers
> wrote:
> > On Fri, Mar 16, 2012 at 9
Hi again,
Thanks for all the help so far!
I can get the Data Management Console now, but can't get past the Ledgersmb
password box.
How can I change the Ledgersmb password? I tried changing it in postgres
but it doesn't work for the password window.
Regarding postgres, here's what it produces.
referer:
http://localhost/ledgersmb/setup.pl
[Sat Mar 17 10:55:40 2012] [error] [client ::1] Premature end of script
headers: setup.pl, referer: http://localhost/ledgersmb/setup.pl
Thanks for taking the time to read through this!
Best Regards,
Billy
On Sat, Mar 17, 2012 at 10:48 AM, billy ak
[error] [client ::1] Directory index forbidden
by Op$
[Sat Mar 17 10:38:01 2012] [error] [client ::1] Directory index forbidden
by Op$
Thanks in advance. I really want to get this thing up and running.
Billy
On Sat, Mar 17, 2012 at 9:15 AM, Chris Travers wrote:
> On Fri, Mar 16, 2012 at 1:59 PM,
Hi again,
After a lot of frustration with installing ledgersmb, I decided to install
postgres 9.1, reinstall ledgersmb and do a dist upgrade for Squeeze.
Now I can get to the Data Management Console with
http://localhost/ledgersmb/setup.pl
but when I type in the Superuser credentials and try to
.sql:4629: NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "cr_report_line_pkey" for table "cr_report_line"
I hope this helps.
Thanks again.
Billy
On Thu, Mar 15, 2012 at 6:03 AM, billy akazawa wrote:
> Hi again,
>
> Thanks for all the help, Chris. I know
einstall postgres
again?
Thanks in advance.
Billy
On Wed, Mar 14, 2012 at 10:16 AM, Chris Travers wrote:
> Hi;
>
> On Tue, Mar 13, 2012 at 4:15 PM, billy akazawa
> wrote:
> > Hi again, everyone,
> >
> > I decided to start a new thread because the problem now seems to
wrote:
> On Mon, Mar 12, 2012 at 06:38:31PM +0900, billy akazawa wrote:
> > I've tried the following, but I'm definitely doing something wrong.
> >
> > root@AELS:/home/billy# su postgres
> > postgres@AELS:/home/billy$ ALTER USER ledgersmb SUPERUSER;
> > ba
not found
Any help is greatly appreciated.
Thanks again.
Billy
On Mon, Mar 12, 2012 at 5:36 PM, Håvard Sørli wrote:
> On 12. mars 2012 08:30, billy akazawa wrote:
> > In answer to Jame's question, I'm more or less doing this manually.
> > I'm not very familiar wi
or the inconvenience.
Thank you.
Billy
On Mon, Mar 12, 2012 at 3:43 PM, billy akazawa wrote:
> Dear Chris and Jame,
>
> Thanks so much for your quick responses.
>
> In answer to Jame's question, I'm more or less doing this manually. I'm
> not very familiar with Linux
41 matches
Mail list logo
