An other issue now. And this one seems more serious. Under AP menu (AP/Add transaction, AP/Vendor Invoice, AP/Reposrts/{Transactions,Outstanding}) I got a SQL error: column customer_id not found. The error is from the subquery (... where ct.id = (select customer_id from ap ...)).
There's of course no customer_id column in ap table.
I am using ledgerSMB 1.2.5 downloaded from sf (not from SVN).
Is this a production stable release ? or should I used a different version ? in any case what file should I edit to change the query ?
Thanks for your help.
Khalil Foundy
----- Message initial ----
De : Chris Travers <..hidden..>
À : ..hidden..
Envoyé le : vendredi 25 mai 2007, 14 h 05 min 26 s
Objet : Re: [Ledger-smb-users] Re : Quick question
Thanks. Inconsistancy fixed. ledgersmb-httpd.conf now uses
/ledgersmb/ for the alias.
On 5/25/07, Khalil Foundy <..hidden..> wrote:
> Thanks Chris,
> I've figured out the GL transaction part but not the inventory.
>
> Thanks again.
>
> BTW, yesterday while doing a manual installation I found an inconsistency between INSTALL file line 161 and ledgersmb-httpd.conf line 2.
> the former is refering to a URL with ledgersmb in it and the later is configuring an httpd ledger-smb alias. Confusing.
>
>
> Khalil Foundy
>
> ----- Message initial ----
> De : Chris Travers <..hidden..>
> À : ..hidden..
> Envoyé le : vendredi 25 mai 2007, 12 h 07 min 10 s
> Objet : Re: [Ledger-smb-users] Quick question
>
> Enter initial inventory as an AP invoice. Then enter any other
> information in as a GL transaction.
>
> Best Wishes,
> Chris Travers
>
> On 5/25/07, Khalil Foundy <..hidden..> wrote:
> > Sorry if this is documented somewhere. But I searched both the mailing lists archives and the SF forums and found no answer.
> >
> > I have just installed successfully ledgerSMB on a centos 5 box and I would like to know how to setup the initial trial balance (balance de vérification in french). I am migrating from a windows accounting app. to ledgerSMB. So basicaly I need to setup the same (or equivalent) acounts (I know how to do this) and setup their initial values.
> >
> > Thanks for your help.
> >
> > Khalil Foundy
>
>
>
>
>
>
> Changez de tête et de tenue tous les jours si vous le voulez ! Volez la vedette sur Yahoo! Québec Avatars
> http://cf.avatars.yahoo.com/
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Combattez les méchants pourriels... Le filtre SpamGuard vous aide à lutter efficacement contre les pourriels sur le Tout-nouveau Yahoo! Courriel
http://us.rd.yahoo.com/evt=40705/*http://mrd.mail.yahoo.com/try_beta?.intl=cf
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users