Re: [SL] Year end error

[Adrian B. <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