From: David J <ja...@in...> - 2007-10-08 07:07:36
|
Try login to Admin, and simply unlock the database. Hope it then works as intended. > Hi, > > I've been running 2.6.19 for a long time and I was very > happy with it. I've just tried to upgrade to 2.8.8 > > I ran upgrade with setup.pl from the root of sql-ledger > Upgrade seemed fine except that I got this warning during > the process: chown: invalid option -- s > > Then, I went to the web page and I had the following error > message: > > --------------------------------------------------- > Upgrading to Version 2.8.8 ... > Error! > > drop trigger del_recurring ON oe > ERROR: trigger "del_recurring" for table "oe" does not > exist --------------------------------------------------- > > I've refreshed the page and it says now: > Login disabled! > > > Has any one any idea of what I should do now ? > > Thanks a lot ! > > -- > Adrien Laurent > (514) 284-2020 x 202 > http://www.modulis-groupe.com > |
From: Bob G. <bo...@rc...> - 2007-10-08 20:49:45
|
I have EUR as my first defined currency. 99% of the transactions are in EUR and no exchange rate is given with the transaction I have entered exchange rates to cover the period of the reports in the Exchange Rates menu (correctly?) When I display my Income Statement, I select USD and expect to see my Income Statement displayed (and labeled) in USD. It is not. The numbers are the same as when I select EUR and the same date periods. Am I expecting too much? Bob G |
From: Paul T. <pt...@gm...> - 2007-10-09 05:07:36
|
I think you are waiting for a spontaneous conversion miracle? You tell the system to use EUR. You enter data, in EUR, and now want to know how much USD transactions are in the system? The primary currency is, as you said, EUR. Here is the lowdown: Open a new test firm. Enter some transactions in USD. Do not enter anything else. Check rate (iirc about70 eurocents per dollar at the moment). Get report, and see if it shows about 0.70 of the USD amounts you just entered. hth paul 2007/10/8, Bob Gustafson <bo...@rc...>: > > I have EUR as my first defined currency. > > 99% of the transactions are in EUR and no exchange rate is given with > the transaction > > I have entered exchange rates to cover the period of the reports in the > Exchange Rates menu (correctly?) > > When I display my Income Statement, I select USD and expect to see my > Income Statement displayed (and labeled) in USD. It is not. The numbers > are the same as when I select EUR and the same date periods. > > Am I expecting too much? > > Bob G > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. > Still grepping through log files to find problems? Stop. > Now Search log events and configuration files using AJAX and a browser. > Download your FREE copy of Splunk now >> http://get.splunk.com/ > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > |
From: Bob G. <bo...@rc...> - 2007-10-09 07:30:55
|
Yes, I have a USD account where I did as you suggested. And there are (not so little) shadow transactions generated to pull the balance down to the correct number in EUR. This is using addition and subtraction to get the account balance to read in EUR; ------------------------------- I don't think I am expecting a miracle though. Just a multiplication between numbers that are already in the system: The transactions are in EUR and are dated. The conversion factor (exchange rate) is in the system and is set up to cover date ranges. The popup on the Balance Sheet request form is asking which currency you would like to have the form displayed in. (This is the only possible use for this popup item) And then - the report is generated in EUR. And - there is no indication on the report (label) that the report had been requested in USD. Why have the popup in the Balance Sheet request form if not to generate the form in that currency? Best regards Bob G On Tue, 2007-10-09 at 07:07 +0200, Paul Tammes wrote: > I think you are waiting for a spontaneous conversion miracle? > You tell the system to use EUR. You enter data, in EUR, and now want to know > how much USD transactions are in the system? The primary currency is, as you > said, EUR. > > Here is the lowdown: > > Open a new test firm. Enter some transactions in USD. Do not enter anything > else. > Check rate (iirc about70 eurocents per dollar at the moment). > > Get report, and see if it shows about 0.70 of the USD amounts you just > entered. > > hth > paul > > 2007/10/8, Bob Gustafson <bo...@rc...>: > > > > I have EUR as my first defined currency. > > > > 99% of the transactions are in EUR and no exchange rate is given with > > the transaction > > > > I have entered exchange rates to cover the period of the reports in the > > Exchange Rates menu (correctly?) > > > > When I display my Income Statement, I select USD and expect to see my > > Income Statement displayed (and labeled) in USD. It is not. The numbers > > are the same as when I select EUR and the same date periods. > > > > Am I expecting too much? > > > > Bob G > > > > ------------------------------------------------------------------------- > > This SF.net email is sponsored by: Splunk Inc. > > Still grepping through log files to find problems? Stop. > > Now Search log events and configuration files using AJAX and a browser. > > Download your FREE copy of Splunk now >> http://get.splunk.com/ > > _______________________________________________ > > sql-ledger-users mailing list > > sql...@li... > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. > Still grepping through log files to find problems? Stop. > Now Search log events and configuration files using AJAX and a browser. > Download your FREE copy of Splunk now >> http://get.splunk.com/ > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users |