Menu
▾
▴
sql-ledger-users
|
From: Adrian B. <adr...@ie...> - 2007-09-07 05:26:14
|
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
|
|
From: Paul T. <pt...@gm...> - 2007-09-07 06:27:01
|
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
>
>
|
|
From: Adrian B. <adr...@ie...> - 2007-09-07 07:34:00
|
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
|
|
From: Paul T. <pt...@gm...> - 2007-09-07 13:21:49
|
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
>
>
|
|
From: Dieter S. <dsi...@sq...> - 2007-09-07 22:35:35
|
On Fri, 7 Sep 2007, Adrian Blake wrote:
> 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
>
Add this before the while loop.
$form->{exchangerate} ||= 1;
> 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.
that's because GL transactions didn't have an exchange rate but now they
do.
|
|
From: Adrian B. <adr...@ie...> - 2007-09-09 11:32:31
|
Thanks for the assistance, it works.
Adrian
Dieter Simader wrote:
> On Fri, 7 Sep 2007, Adrian Blake wrote:
>
>> 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
>>
>
> Add this before the while loop.
>
> $form->{exchangerate} ||= 1;
>
>
>> 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.
>
> that's because GL transactions didn't have an exchange rate but now they
> do.
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2005.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> 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
|
|
From: Bob G. <bo...@rc...> - 2007-10-01 14:49:55
|
To reconcile bank balances with the number given by the bank, the function: Cash -> Reconciliation Is very useful. It could be made more useful if one could store the date and balance numbers given by the banks, so this reconciliation could be easier to do, and perhaps more automatic. I wonder if anyone has a good procedure for doing this? Bob G |
|
From: Wallace R. C. <wrc...@gm...> - 2007-10-01 18:48:30
|
On 10/1/07, Bob Gustafson <bo...@rc...> wrote: > To reconcile bank balances with the number given by the bank, the > function: > > Cash -> Reconciliation > > Is very useful. > > It could be made more useful if one could store the date and balance > numbers given by the banks, so this reconciliation could be easier to > do, and perhaps more automatic. > > I wonder if anyone has a good procedure for doing this? Because my bank provides online access to my accounts (as do most banks, I imagine), I record and reconcile my accounts on a daily basis. This makes reconciliation an easy task for me. -- Best Regards, Wallace |
|
From: Bob G. <bo...@rc...> - 2007-10-01 19:13:31
|
On Mon, 2007-10-01 at 11:48 -0700, Wallace Roberts Consulting wrote: > On 10/1/07, Bob Gustafson <bo...@rc...> wrote: > > To reconcile bank balances with the number given by the bank, the > > function: > > > > Cash -> Reconciliation > > > > Is very useful. > > > > It could be made more useful if one could store the date and balance > > numbers given by the banks, so this reconciliation could be easier to > > do, and perhaps more automatic. > > > > I wonder if anyone has a good procedure for doing this? > > Because my bank provides online access to my accounts (as do most > banks, I imagine), I record and reconcile my accounts on a daily > basis. This makes reconciliation an easy task for me. > Yes, I also have on-line access, but I have a 'catch-up' job that needs all the help technology can provide. Bob G |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X