[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Re : Re : Quick question



This is a known issue with an SQL query that was rewritten in 1.2.5.
We expect to have a fixed version released sometime soon.

In the mean time, you can take your pick of:
1)  Install 1.2.4 over the top (you lose the Unicode fixes, and there
is a performance penalty)
2)  Download the latest Form.pm from svn (branches/1.2/LedgerSMB/Form.pm)
3)  If you want, I can email you the corrected version.

Best Wishes,
Chris Travers

On 5/25/07, Khalil Foundy <..hidden..> wrote:
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