sql-ledger-users — SQL-Ledger users

[SQL-Ledger-users] Another Chart of Accounts Question

[Wild A. S. <su...@wi...>]

Hello again,

What do the 'A's and 'H's mean under the 'type' field of the Cahrt of
Accounts?

Thanks,
Murrah Boswell

[SQL-Ledger-users] 'gifi' field in Chart of Accounts

[Wild A. S. <su...@wi...>]

Hello,

What does the 'gifi' field in the Chart of Accounts stand for?

How is it used?

Thanks,
Murrah Boswell

Re: [SQL-Ledger-users] MySQL and SQL Ledger

[D S. <dsi...@sq...>]

The only other items I am aware of which differ is a case insensitive
substring search in the form of 
"SELECT * FROM parts WHERE description ~* '$form->{description}'"

This can be fixed with
$substr = lc $form->{description};
SELECT * FROM parts WHERE lower(description) LIKE '%$substr%'

affected modules include:
ap, ar, ct, gl, ic, is

and missing (as) table identifiers.
such as
  $query = qq|SELECT ap.id, ap.invnumber, ap.transdate, ap.duedate,
              ap.amount, ap.paid, ap.ordnumber, vendor.name, ap.invoice
              FROM ap,vendor
              WHERE ap.vendor = vendor.id|;


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On Mon, 18 Dec 2000, Sean Roe wrote:

> Hello all,
> 
> We just installed SQL-ledger in a MySQL enviroment, I read all the caveats so I am aware of the potential 
> problems with this setup.  I was wondering if anybody else has attempted this before and if so do they have any 
> insights into any modifications or tweeks to make it run, we are still in the debug mode right now.  We will 
> eventually be setting up transactions on MySQL (After the holidays)  but I wanted to get this up and running.
> 
> Again any insights into the MySQL conversion would be great.
> 
> Thanks,
> 
> Sean Roe
> 
> 

Re: [SQL-Ledger-users] MySQL and SQL Ledger

[OTR C. <ot...@wi...>]

Hello,

Yeah, I have sql-ledger working in MySQL.  There were a few issues, but
nothing major.  Actually some of the query language in sql-ledger is
specialized for postgresql and if you remove/rewrite it to standard sql,
it still works fine.

If you have questions, send them direct since I do not want to confuse
the sql-ledger list.

Murrah Boswell

Sean Roe wrote:
> 
> Hello all,
> 
> We just installed SQL-ledger in a MySQL enviroment, I read all the caveats so I am aware of the potential
> problems with this setup.  I was wondering if anybody else has attempted this before and if so do they have any
> insights into any modifications or tweeks to make it run, we are still in the debug mode right now.  We will
> eventually be setting up transactions on MySQL (After the holidays)  but I wanted to get this up and running.
> 
> Again any insights into the MySQL conversion would be great.
> 
> Thanks,
> 
> Sean Roe

[SQL-Ledger-users] MySQL and SQL Ledger

[Sean R. <sr...@bm...>]

Hello all,

We just installed SQL-ledger in a MySQL enviroment, I read all the caveats so I am aware of the potential 
problems with this setup.  I was wondering if anybody else has attempted this before and if so do they have any 
insights into any modifications or tweeks to make it run, we are still in the debug mode right now.  We will 
eventually be setting up transactions on MySQL (After the holidays)  but I wanted to get this up and running.

Again any insights into the MySQL conversion would be great.

Thanks,

Sean Roe

Re: [SQL-Ledger-users] Process Receipts Question

[D S. <dsi...@te...>]

The amount is recorded in the account you select from the drop down box. 

The "Process Receipts" function lists all open receivable transactions;
If an invoice/receivable has been paid for it is considered closed.

This function was put in to do away with reversing receivables just for
recording a receipt. When you edit an invoice or change a receivable entry
the invoice/receivable entry is reversed and posted again. When you use
"Process Receipts" this does not happen and only the AR record and Bank
account is updated and a record for the receipt is added.


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On Sat, 16 Dec 2000, OTR Comm wrote:

> Hello,
> 
> When I go to Receipts under the A/R menu group, the Process Receipts
> dialog is displayed.
> 
> Does anyone know how the RECEIVED portion is supposed to work?  I mean
> you can put a date there and an ammount, but does it get applied to? 
> How is this related to the invoices?
> 
> Thanks,
> Murrah Boswell
> 
> 
> _______________________________________________
> Sql-ledger-users mailing list
> Sql...@li...
> http://lists.sourceforge.net/mailman/listinfo/sql-ledger-users
> 

[SQL-Ledger-users] Process Receipts Question

[OTR C. <ot...@wi...>]

Hello,

When I go to Receipts under the A/R menu group, the Process Receipts
dialog is displayed.

Does anyone know how the RECEIVED portion is supposed to work?  I mean
you can put a date there and an ammount, but does it get applied to? 
How is this related to the invoices?

Thanks,
Murrah Boswell

[SQL-Ledger-users] Everything's fine, Except Can't Login. :)

[Metin O. <me...@tu...>]

Dear Mr. Simader and SQL-Ledger Users,

First off, thanks for trying to answer my question about sql-ledger before.
Could you open your comment below a little bit more please??.

I did remove your name from .htpasswd. And also removed the
dsimader user through "setup.cgi". But "login.cgi" still gives an
"500 Internal server error" when I try to login, as if something
went wrong while processing this login.cgi script.

Here are the little checks I can offer for you from my system now:

1. Postgresql and Perl, DBI:DBD:Pg works are the latest and
they work fine. Beacuse I wrote a fairly developed app on them
myself.
2. psql dbname < acc-Pg.sql did load/work without a hitch.
3. As a trivial final check Perl -c login.cgi gives syntax ok, too.
4. My system is Solaris 2.6 on Sparc hardware with latest patches loaded.
5. My Perl installation is: "This is perl, v5.6.0 built for sun4-solaris"

So obviously, login cgi is being fed something it doesn't like. So could
there be a step I may be missing here when creating an sql-ledger user?

For example, do I need to create a database user from postgreql console before
creating a user through my /cgi-bin/sql-ledger/admin/setup.cgi ??

Looking forward to hear from you guys soon, really :)

Kind Regards to All,

Metin Ozsavran.


Are there any critacal parts l may be skipping

At 12:54 16.11.2000 -0700, you wrote:
>You have to edit the .ht* files and remove my name.
>
>
>Dieter Simader    http://www.sql-ledger.com   (780) 472-8161
>DWS Systems Inc.  http://www.simtax.ca         Fax: 478-5281
>                   http://www.partsfinder.net
>=========== On a clear disk you can seek forever ===========
>
>On Thu, 16 Nov 2000, Metin Ozsavran wrote:
>
> > Dear Sql-Ledger community,
> >
> > On may Sparc PostGreSQL and DBI/DBD-Pg are installed fine, and I am
> > succesfully using them
> > for a customer of mine. Using a different database of course.  acc-Pg.sql
> > has also performed
> > without any warnings/errors.
> >
> > However I can't any response from sql-ledger yet. The admin area
> > user/password is
> > still dsimader/(no password).
> >
> > Can you tell me a list of things to check for a situation like that?
> >
> > Thanks in advance!.
> >
> > Metin Ozsavran.
> >
>

Re: [SQL-Ledger-users] customer receipt problem

[Koot <kd...@dg...>]

Adding is what I want to do, but it only change the entries.
So how do I go about to add and not change an entry?


Navneet Karnani wrote:
> 
> I am not a user currently but am planning to install the SQL Ledger
> envirponment for a test round.
> 
> I feel that you should be adding rather than changing. That will aloow
> you to keep track of everything.
> 
> - Navneet
> 
> > -----Original Message-----
> > From: sql...@li...
> > [mailto:sql...@li...]On Behalf Of Koot
> > Sent: Thursday, December 14, 2000 14:28
> > To: sql...@sq...
> > Subject: [SQL-Ledger-users] customer receipt problem
> >
> >
> > Hi everyone
> >
> > I am a new user of SQL-Ledger and find it very interesting.
> > I do however have the following problem and do not know how
> > to "fix" it
> > or work around it, so now I'm calling for help.
> >
> > I created a customer under the accounts receivable and then
> > invoiced the
> > customer.
> > The customer only pays a part of the amount owing and arrange
> > for terms
> > (say 6 months).
> > If I now go and do a receipts the first payment is showing,
> > with a date
> > and amount paid.
> > If I change this to reflect the new payment (enter a date and amount)
> > the previous record is removed and gets replaced by the new entry.
> > This is bad because I lost my previous record of what happened, so the
> > question is how to add a payment without losing the previous record of
> > what has been paid?
> >
> > Also, I can not go back on my customers account and get a
> > history of his
> > payments on a specific transaction, how do I correct or do this?
> >
> > All help appreciated

Re: [SQL-Ledger-users] customer receipt problem

[D S. <dsi...@te...>]

You could split the invoice or use the A/R -> 'Add Transaction' function
to add a receivable for each payment.


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On Thu, 14 Dec 2000, Koot wrote:

> Hi everyone
> 
> I am a new user of SQL-Ledger and find it very interesting.
> I do however have the following problem and do not know how to "fix" it
> or work around it, so now I'm calling for help.
> 
> I created a customer under the accounts receivable and then invoiced the
> customer.
> The customer only pays a part of the amount owing and arrange for terms
> (say 6 months).
> If I now go and do a receipts the first payment is showing, with a date
> and amount paid.
> If I change this to reflect the new payment (enter a date and amount)
> the previous record is removed and gets replaced by the new entry.
> This is bad because I lost my previous record of what happened, so the
> question is how to add a payment without losing the previous record of
> what has been paid?
> 
> Also, I can not go back on my customers account and get a history of his
> payments on a specific transaction, how do I correct or do this?
> 
> All help appreciated
> _______________________________________________
> Sql-ledger-users mailing list
> Sql...@li...
> http://lists.sourceforge.net/mailman/listinfo/sql-ledger-users
> 

[SQL-Ledger-users] sql-ledger Print Invoice

[pro-red (M. D. R. - B. A. SRL) <ma...@pr...>]

I am evaluating th software

I could net print Invoices, i just receive an empty page when printing

Any idea?

Thanks

--------------------------------------------------------
Marcos Dalla Rosa
PRO-RED "Especialistas en Web Hosting"
BCD Asociados SRL
Montevideo - URUGUAY
Tel. 598 (2) 9082725
Tel./Fax. 598 (2) 9024333
http://www.bcdasociados.com
http://www.pro-red.com

RE: [SQL-Ledger-users] customer receipt problem

[Navneet K. <na...@cy...>]

I am not a user currently but am planning to install the SQL Ledger
envirponment for a test round.

I feel that you should be adding rather than changing. That will aloow
you to keep track of everything.

- Navneet

> -----Original Message-----
> From: sql...@li...
> [mailto:sql...@li...]On Behalf Of Koot
> Sent: Thursday, December 14, 2000 14:28
> To: sql...@sq...
> Subject: [SQL-Ledger-users] customer receipt problem
>
>
> Hi everyone
>
> I am a new user of SQL-Ledger and find it very interesting.
> I do however have the following problem and do not know how
> to "fix" it
> or work around it, so now I'm calling for help.
>
> I created a customer under the accounts receivable and then
> invoiced the
> customer.
> The customer only pays a part of the amount owing and arrange
> for terms
> (say 6 months).
> If I now go and do a receipts the first payment is showing,
> with a date
> and amount paid.
> If I change this to reflect the new payment (enter a date and amount)
> the previous record is removed and gets replaced by the new entry.
> This is bad because I lost my previous record of what happened, so the
> question is how to add a payment without losing the previous record of
> what has been paid?
>
> Also, I can not go back on my customers account and get a
> history of his
> payments on a specific transaction, how do I correct or do this?
>
> All help appreciated
> _______________________________________________
> Sql-ledger-users mailing list
> Sql...@li...
> http://lists.sourceforge.net/mailman/listinfo/sql-ledger-users
>
>

[SQL-Ledger-users] customer receipt problem

[Koot <kd...@dg...>]

Hi everyone

I am a new user of SQL-Ledger and find it very interesting.
I do however have the following problem and do not know how to "fix" it
or work around it, so now I'm calling for help.

I created a customer under the accounts receivable and then invoiced the
customer.
The customer only pays a part of the amount owing and arrange for terms
(say 6 months).
If I now go and do a receipts the first payment is showing, with a date
and amount paid.
If I change this to reflect the new payment (enter a date and amount)
the previous record is removed and gets replaced by the new entry.
This is bad because I lost my previous record of what happened, so the
question is how to add a payment without losing the previous record of
what has been paid?

Also, I can not go back on my customers account and get a history of his
payments on a specific transaction, how do I correct or do this?

All help appreciated

Re: [SQL-Ledger-users] Inquiry

[D S. <dsi...@te...>]

Add Transaction is for adding receivables without generating an invoice. 

Customer Invoice creates an invoice and posts a receivables entry.
It also keeps a record of parts and services sold and makes the
appropriate entries in the income, expense and inventory accounts.


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On Thu, 30 Nov 2000 dr...@ih... wrote:

> Hi,
> 
> I am new to this accounting system. Please tell me the 
> difference between \'Add transaction\' and \'Customer 
> invoice\' in AR.
> Besides that I only could get one row (instesd of 
> multiple rows) when entering data in \"Customer invoice\". 
> 
> Thanks
> 
> Liwauddin
> _______________________________________________
> SQL-Ledger-users mailing list
> SQL...@li...
> http://lists.sourceforge.net/mailman/listinfo/sql-ledger-users
> 

[SQL-Ledger-users] Inquiry

[<dr...@ih...>]

Hi,

I am new to this accounting system. Please tell me the 
difference between \'Add transaction\' and \'Customer 
invoice\' in AR.
Besides that I only could get one row (instesd of 
multiple rows) when entering data in \"Customer invoice\". 

Thanks

Liwauddin