Re: [SL] Year end error

[Paul T. <pt...@gm...>]

You may not want to, if you use AUD as well as USD that might ruin your data
and database!!

If you just enterted them without using them, you can change the systems
defaults.
IIRC: (No SQL Ledger running at the moment)  Go to to the menu side, system
settings (where the CoA setup etc is located) and look for preferences and
System Defaults..

Did you try to use ADMIN.pl iso login.pl and look if SQL-Ledger itself
thinks the dataset needs to be updated?


2007/9/7, Adrian Blake <adr...@ie...>:
>
> I am using version 2.8.7.
>
> When I list currencies  I have 1 AUD & 3 USD   but no 2
>
> This may be where the problem is hiding.
>
> I cannot find where to delete currencies.
>
> Adrian
>
> Paul Tammes wrote:
> > SQL-Ledger changes every so often ;-)
> > Check your settings and see if you are using exchange rates, setting is
> > something like
> > USD:GBP:EUR or CAD:AUD:USD in the preferences or default screen iirc.
> >
> > Either get rid of those foreign currency settings (if you do not use
> them)
> > or update to newer version of SQL-Ledger before running year-end would
> seem
> > a neat work around.
> >
> > HtH.
> > 2007/9/7, Adrian Blake <adr...@ie...>:
> >> While attempting to do yearend processing I get the following error:
> >>
> >> Error!
> >>
> >> Illegal division by zero at SL/RP.pm line 995.
> >>
> >> And here is the code
> >>
> >>    while ($ref = $sth->fetchrow_hashref(NAME_lc)) {
> >>
> >>      # get last heading account
> >>      @accno = grep { $_ le "$ref->{accno}" } @headingaccounts;
> >>      $accno = pop @accno;
> >>
> >>      $ref->{amount} /= $form->{exchangerate};
> >> ***************************** error line
> >>
> >>      if ($accno && ($accno ne $ref->{accno}) ) {
> >>        if ($last_period)
> >>        {
> >>         $form->{$ref->{category}}{$accno}{last} += $ref->{amount};
> >>        } else {
> >>         $form->{$ref->{category}}{$accno}{this} += $ref->{amount};
> >>        }
> >>      }
> >>
> >> My Jan 17 2006 copy of the manual does not include "exchangerate"
> >> information.
> >>
> >> Adrian
> >>
> >> --
> >> Adrian Blake
> >> Molonglo Radio Observatory
> >> University of Sydney
> >> 1152 Hoskinstown Rd
> >> Bungendore 2621
> >> ph. 02 80042212  mobile 0407 232 978
> >>
> >> http://150.101.125.30/images
> >>
> >>
> -------------------------------------------------------------------------
> >> 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
> >
>
> --
> Adrian Blake
> Molonglo Radio Observatory
> University of Sydney
> 1152 Hoskinstown Rd
> Bungendore 2621
> ph. 02 80042212  mobile 0407 232 978
>
> http://150.101.125.30/images
>
> -------------------------------------------------------------------------
> 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
>
>