sql-ledger-users — SQL-Ledger users

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
>
>

[SL] leanux.ch: Martin.Elmer@leanux.ch ist bis und mit 10. September 2007 abwesend

[<mar...@le...>]

Ich werde ab  22.08.2007 nicht im B=FCro sein. Ich kehre zur=FCck am
11.09.2007.

Vielen Dank f=FCr Ihre E-Mail.
Leider kann ich Ihre E-Mail bis und mit 10. September 2007 nicht lesen.=


Diese E-Mail wird nicht weitergeleitet!

Meine Stellvertretung =FCbernimmt Ala...@le....

Freundliche Gr=FCsse
Mar...@le...
Partner

leanux.ch AG
Industriestrasse 25
8604 Volketswil
Tel 044 947 11 22
Direkt 079 446 48 02
Fax 044 947 11 33

www.leanux.ch=

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

Re: [SL] Year end error

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

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
>
>

[SL] Year end error

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

Re: [SL] wrong rebatte calculation in invoice/SO

[Michael H. <mh...@it...>]

Any accountant will say that rounding should ALWAYS be the last step.


Thanks,

Michael


On Sep 5, 2007, at 3:17 PM, Robert Stanford wrote:

> Jeff Roberts wrote:
>> Hi Ashley
>>
>> I think I understand now, You're manually putting in 7.5% discount on
>> the line as you create the invoice right?  If that's the case it  
>> could
>> be argued that it would be better to multiply the quantity by the  
>> price
>> then apply the discount ( but the difference is in your favour :-) )
>> Maybe a future revision could move the brackets around in the  
>> equation
>> to do that.
>>
>> If you're assigning a discount to a vendor on an item then it's a
>> different story because the item is 'pulled' from the tables with a
>> price that is dependant on the date, pricegroup of the customer,  
>> and any
>> exceptions or overides in the pricing matrix and there is no way to
>> correct a rounding error once the query has run other than to start
>> carrying four or five digits on every price just in case there is  
>> a high
>> enough quantity sold to make a more than marginal difference.
>>
>> Jeff
>>
> This has been a bit of a problem from a usability point of view.
>
> SQL-Ledger rounds discounts before multiplying by qty. This causes no
> real problem when selling.
>
> However the same thing happens when purchasing and here is where it
> causes problems.
>
> Here's  where the problem arises, every supplier we have encountered
> rounds after multiplying by quantity, so when we it comes time for
> accounts to pay bills there if often a discrepancy between our  
> purchase
> order and the suppliers invoice.
>
> Dieters method of rounding first seems mathematically, however after a
> few years of encountering this I really think he should bite the  
> bullet
> on this issue and round last, unfortunately this is one of those cases
> where 'everybody else is doing it'.
>
> Kind Regards
> Robert Stanford
>
> ---------------------------------------------------------------------- 
> ---
> 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

Re: [SL] wrong rebatte calculation in invoice/SO

[Robert S. <ro...@st...>]

Jeff Roberts wrote:
> Hi Ashley
>
> I think I understand now, You're manually putting in 7.5% discount on 
> the line as you create the invoice right?  If that's the case it could 
> be argued that it would be better to multiply the quantity by the price 
> then apply the discount ( but the difference is in your favour :-) ) 
> Maybe a future revision could move the brackets around in the equation 
> to do that.
>
> If you're assigning a discount to a vendor on an item then it's a 
> different story because the item is 'pulled' from the tables with a 
> price that is dependant on the date, pricegroup of the customer, and any 
> exceptions or overides in the pricing matrix and there is no way to 
> correct a rounding error once the query has run other than to start 
> carrying four or five digits on every price just in case there is a high 
> enough quantity sold to make a more than marginal difference.
>
> Jeff
>   
This has been a bit of a problem from a usability point of view.

SQL-Ledger rounds discounts before multiplying by qty. This causes no 
real problem when selling.

However the same thing happens when purchasing and here is where it 
causes problems.

Here's  where the problem arises, every supplier we have encountered 
rounds after multiplying by quantity, so when we it comes time for 
accounts to pay bills there if often a discrepancy between our purchase 
order and the suppliers invoice.

Dieters method of rounding first seems mathematically, however after a 
few years of encountering this I really think he should bite the bullet 
on this issue and round last, unfortunately this is one of those cases 
where 'everybody else is doing it'.

Kind Regards
Robert Stanford

Re: [SL] wrong rebatte calculation in invoice/SO

[Jeff R. <je...@jr...>]

Hi Ashley

I think I understand now, You're manually putting in 7.5% discount on 
the line as you create the invoice right?  If that's the case it could 
be argued that it would be better to multiply the quantity by the price 
then apply the discount ( but the difference is in your favour :-) ) 
Maybe a future revision could move the brackets around in the equation 
to do that.

If you're assigning a discount to a vendor on an item then it's a 
different story because the item is 'pulled' from the tables with a 
price that is dependant on the date, pricegroup of the customer, and any 
exceptions or overides in the pricing matrix and there is no way to 
correct a rounding error once the query has run other than to start 
carrying four or five digits on every price just in case there is a high 
enough quantity sold to make a more than marginal difference.

Jeff


Ashley J Gittins wrote:
> On Tue, 4 Sep 2007, Jeff Roberts wrote:
>   
>> The item is discounted first, then rounded then multiplied by your
>> quantity. This allows you to discount one item while retaining other
>> items on the same invoice at full price If you applied the discount to
>> the sub total you'd lose the functionality of being able to discount
>> individual items.
>>     
>
> That is incorrect.
>
> There is nothing problematic with taking a line item, discounting it, 
> multiplying out for qty and _then_ rounding, that would have absolutely no 
> affect on other line items, and avoids that line item having a 
> rounding "error". 
>
> Additionally, it may be arguable that each invoice line should not be rounded 
> before total as well, but that's not what Robert is noting here.
>
> (btw, the math you expressed is exactly what I had said earlier - but I am 
> guessing you were replying to Robert more so than my post).
>
>   

Re: [SL] wrong rebatte calculation in invoice/SO

[Ashley J G. <agi...@pu...>]

On Tue, 4 Sep 2007, Jeff Roberts wrote:
> The item is discounted first, then rounded then multiplied by your
> quantity. This allows you to discount one item while retaining other
> items on the same invoice at full price If you applied the discount to
> the sub total you'd lose the functionality of being able to discount
> individual items.

That is incorrect.

There is nothing problematic with taking a line item, discounting it, 
multiplying out for qty and _then_ rounding, that would have absolutely no 
affect on other line items, and avoids that line item having a 
rounding "error". 

Additionally, it may be arguable that each invoice line should not be rounded 
before total as well, but that's not what Robert is noting here.

(btw, the math you expressed is exactly what I had said earlier - but I am 
guessing you were replying to Robert more so than my post).

-- 
Regards,
	Ashley J Gittins
	web: 	http://www.purple.dropbear.id.au
	jabber: agi...@pu...

Re: [SL] Need compiled DBD for windows

[Nefnifi, K. <Kas...@at...>]

Dieter,

The FAQ stil has a wrong link to Edmund page.

Best Regards / Vriendelijke Groeten / Salutations Distingu=E9es / =
Freundliche Gr=FC=DFe !!!
Kasem NEFNIFI
AtosOrigin Belux N.V.
Da Vincilaan, 5
1930 Zaventem (Belgium)
Tel : +32(0)2 690 28 30
Fax : +32(0)2 690 28 61
GSM : +32 495 25 12 33
Email : kas...@at... =20
www.atosorigin.com


-----Original Message-----
From: Dieter Simader [mailto:dsi...@sq...]=20
Sent: dinsdag 28 augustus 2007 23:12
To: sql...@li...
Subject: Re: [SL] Need compiled DBD for windows

On Tue, 28 Aug 2007, Ron LeVine wrote:

> What is used instead? I am interested in getting this going as well.

Well, take a look at the download page under the Windows section.


-------------------------------------------------------------------------=

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

Re: [SL] DB driver error

[Nefnifi, K. <Kas...@at...>]

Yes Paul,

All scripts have a right path pointing to perl install directory: =
#!c:\perl\bin\perl

I think that the message:
install_driver(Pg) failed: Can't load =
'C:/perl/site/lib/auto/DBD/Pg/Pg.dll' for module DBD::Pg: load_file:The =
specified module could not be found at  C:/perl/lib/DynaLoader.pm line =
230.\r, referer:  http://localhost/nefsoft/admin.pl

say something about the problem. But the dll Pg.dll exists in this =
directory. Is this the right one? Should be there or in another =
dir...????

Best Regards / Vriendelijke Groeten / Salutations Distingu=E9es / =
Freundliche Gr=FC=DFe !!!
Kasem NEFNIFI
AtosOrigin Belux N.V.
Da Vincilaan, 5
1930 Zaventem (Belgium)
Tel : +32(0)2 690 28 30
Fax : +32(0)2 690 28 61
GSM : +32 495 25 12 33
Email : kas...@at... =20
www.atosorigin.com

-----Original Message-----
From: Paul Tammes [mailto:pt...@gm...]=20
Sent: maandag 3 september 2007 21:15
To: sql...@li...
Subject: Re: [SL] DB driver error

You did run the famous shebang thing that takes care of the pathname
conversions? Linux & Unix /, Win \?

2007/9/3, Nefnifi, Kasem <Kas...@at...>:
>
> Get the error:
>
> [Mon Sep 03 13:24:41 2007] [error] [client 127.0.0.1] Premature end of
> script headers: admin.pl, referer: http://localhost/nefsoft/admin.pl
> [Mon Sep 03 13:24:41 2007] [error] [client 127.0.0.1] =
install_driver(Pg)
> failed: Can't load 'C:/perl/site/lib/auto/DBD/Pg/Pg.dll' for module =
DBD::Pg:
> load_file:The specified module could not be found at
> C:/perl/lib/DynaLoader.pm line 230.\r, referer:
> http://localhost/nefsoft/admin.pl
> [Mon Sep 03 13:24:41 2007] [error] [client 127.0.0.1]  at (eval 11) =
line
> 3\r, referer: http://localhost/nefsoft/admin.pl
> [Mon Sep 03 13:24:41 2007] [error] [client 127.0.0.1] Compilation =
failed
> in require at (eval 11) line 3.\r, referer:
> http://localhost/nefsoft/admin.pl
> [Mon Sep 03 13:24:41 2007] [error] [client 127.0.0.1] Perhaps a =
required
> shared library or dll isn't installed where expected\r, referer:
> http://localhost/nefsoft/admin.pl
> [Mon Sep 03 13:24:41 2007] [error] [client 127.0.0.1]  at SL/User.pm =
line
> 243\r, referer: http://localhost/nefsoft/admin.pl
> [Mon Sep 03 13:24:41 2007] [error] [client 127.0.0.1] Compilation =
failed
> in require at C:/Program Files/Apache2.2/sql-ledger/admin.pl line =
84.\r,
> referer: http://localhost/nefsoft/admin.pl
>
> Any idea what can be the reason ?
>
> Best Regards / Vriendelijke Groeten / Salutations Distingu=E9es /
> Freundliche Gr=FC=DFe !!!
> Kasem NEFNIFI
> AtosOrigin Belux N.V.
> Da Vincilaan, 5
> 1930 Zaventem (Belgium)
> Tel : +32(0)2 690 28 30
> Fax : +32(0)2 690 28 61
> GSM : +32 495 25 12 33
> Email : kas...@at...
> www.atosorigin.com
>
>
>
>
> =
-------------------------------------------------------------------------=

> 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

Re: [SL] DB driver error

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

You did run the famous shebang thing that takes care of the pathname
conversions? Linux & Unix /, Win \?

2007/9/3, Nefnifi, Kasem <Kas...@at...>:
>
> Get the error:
>
> [Mon Sep 03 13:24:41 2007] [error] [client 127.0.0.1] Premature end of
> script headers: admin.pl, referer: http://localhost/nefsoft/admin.pl
> [Mon Sep 03 13:24:41 2007] [error] [client 127.0.0.1] install_driver(Pg)
> failed: Can't load 'C:/perl/site/lib/auto/DBD/Pg/Pg.dll' for module DBD::=
Pg:
> load_file:The specified module could not be found at
> C:/perl/lib/DynaLoader.pm line 230.\r, referer:
> http://localhost/nefsoft/admin.pl
> [Mon Sep 03 13:24:41 2007] [error] [client 127.0.0.1]  at (eval 11) line
> 3\r, referer: http://localhost/nefsoft/admin.pl
> [Mon Sep 03 13:24:41 2007] [error] [client 127.0.0.1] Compilation failed
> in require at (eval 11) line 3.\r, referer:
> http://localhost/nefsoft/admin.pl
> [Mon Sep 03 13:24:41 2007] [error] [client 127.0.0.1] Perhaps a required
> shared library or dll isn't installed where expected\r, referer:
> http://localhost/nefsoft/admin.pl
> [Mon Sep 03 13:24:41 2007] [error] [client 127.0.0.1]  at SL/User.pm line
> 243\r, referer: http://localhost/nefsoft/admin.pl
> [Mon Sep 03 13:24:41 2007] [error] [client 127.0.0.1] Compilation failed
> in require at C:/Program Files/Apache2.2/sql-ledger/admin.pl line 84.\r,
> referer: http://localhost/nefsoft/admin.pl
>
> Any idea what can be the reason ?
>
> Best Regards / Vriendelijke Groeten / Salutations Distingu=E9es /
> Freundliche Gr=FC=DFe !!!
> Kasem NEFNIFI
> AtosOrigin Belux N.V.
> Da Vincilaan, 5
> 1930 Zaventem (Belgium)
> Tel : +32(0)2 690 28 30
> Fax : +32(0)2 690 28 61
> GSM : +32 495 25 12 33
> Email : kas...@at...
> www.atosorigin.com
>
>
>
>
> -------------------------------------------------------------------------
> 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
>
>

Re: [SL] wrong rebatte calculation in invoice/SO

[Jeff R. <je...@jr...>]

it's not

180 x 81.50 x (100-7.5)/100 = 13569.75

It's

180 x (RND,2,(81.50 x .925)) = 13570.20

The item is discounted first, then rounded then multiplied by your 
quantity. This allows you to discount one item while retaining other 
items on the same invoice at full price If you applied the discount to 
the sub total you'd lose the functionality of being able to discount 
individual items.

Jeff


Hi,
a customer bought bought 180 pcs of an item at $ 81.50 with a rebatt of
7.5% Normally the amount should be
180 x 81.50 x (100-7.5)/100 = 13569.75, so I am wondering why I am
getting 13,570.20 in sql-ledger invoice and sale order.
regards

[SL] DB driver error

[Nefnifi, K. <Kas...@at...>]

Get the error:

[Mon Sep 03 13:24:41 2007] [error] [client 127.0.0.1] Premature end of =
script headers: admin.pl, referer: http://localhost/nefsoft/admin.pl
[Mon Sep 03 13:24:41 2007] [error] [client 127.0.0.1] install_driver(Pg) =
failed: Can't load 'C:/perl/site/lib/auto/DBD/Pg/Pg.dll' for module =
DBD::Pg: load_file:The specified module could not be found at =
C:/perl/lib/DynaLoader.pm line 230.\r, referer: =
http://localhost/nefsoft/admin.pl
[Mon Sep 03 13:24:41 2007] [error] [client 127.0.0.1]  at (eval 11) line =
3\r, referer: http://localhost/nefsoft/admin.pl
[Mon Sep 03 13:24:41 2007] [error] [client 127.0.0.1] Compilation failed =
in require at (eval 11) line 3.\r, referer: =
http://localhost/nefsoft/admin.pl
[Mon Sep 03 13:24:41 2007] [error] [client 127.0.0.1] Perhaps a required =
shared library or dll isn't installed where expected\r, referer: =
http://localhost/nefsoft/admin.pl
[Mon Sep 03 13:24:41 2007] [error] [client 127.0.0.1]  at SL/User.pm =
line 243\r, referer: http://localhost/nefsoft/admin.pl
[Mon Sep 03 13:24:41 2007] [error] [client 127.0.0.1] Compilation failed =
in require at C:/Program Files/Apache2.2/sql-ledger/admin.pl line 84.\r, =
referer: http://localhost/nefsoft/admin.pl

Any idea what can be the reason ?

Best Regards / Vriendelijke Groeten / Salutations Distingu=E9es / =
Freundliche Gr=FC=DFe !!!
Kasem NEFNIFI
AtosOrigin Belux N.V.
Da Vincilaan, 5
1930 Zaventem (Belgium)
Tel : +32(0)2 690 28 30
Fax : +32(0)2 690 28 61
GSM : +32 495 25 12 33
Email : kas...@at... =20
www.atosorigin.com

[SL] get error 500 internal server error by create dataset

[Nefnifi, K. <Kas...@at...>]

Please, don't ask or tell me why you didn't use Linux or why i'm still =
using windows if you can't help. I'm running a version 2.6.12 on =
production and want to test the version 2.8.6 on my notebook before =
installing it.

When i try to create a db set I get the following error:

Internal Server Error
The server encountered an internal error or misconfiguration and was =
unable to complete your request.

Please contact the server administrator, be...@at... and =
inform them of the time the error occurred, and anything you might have =
done that may have caused the error.

More information about this error may be available in the server error =
log.

Any idea? why

Best Regards / Vriendelijke Groeten / Salutations Distingu=E9es / =
Freundliche Gr=FC=DFe !!!
Kasem NEFNIFI
AtosOrigin Belux N.V.
Da Vincilaan, 5
1930 Zaventem (Belgium)
Tel : +32(0)2 690 28 30
Fax : +32(0)2 690 28 61
GSM : +32 495 25 12 33
Email : kas...@at... =20
www.atosorigin.com


-----Original Message-----
From: Dieter Simader [mailto:dsi...@sq...]=20
Sent: dinsdag 28 augustus 2007 23:12
To: sql...@li...
Subject: Re: [SL] Need compiled DBD for windows

On Tue, 28 Aug 2007, Ron LeVine wrote:

> What is used instead? I am interested in getting this going as well.

Well, take a look at the download page under the Windows section.


-------------------------------------------------------------------------=

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

Re: [SL] wrong rebatte calculation in invoice/SO

[Ashley J G. <agi...@pu...>]

On Mon, 3 Sep 2007, R. Quansah wrote:
> Hi,
> a customer bought bought 180 pcs of an item at $ 81.50 with a rebatt of
> 7.5% Normally the amount should be
> 180 x 81.50 x (100-7.5)/100 = 13569.75, so I am wondering why I am
> getting 13,570.20 in sql-ledger invoice and sale order.
> regards

Looks like the unit price is being discounted, then rounded to two decimal 
places, then the qty is multiplied out. You could probably call that a bug, 
but I suspect rounding is a matter of policy as much as mathematical 
correctness.

-- 
Regards,
	Ashley J Gittins
	web: 	http://www.purple.dropbear.id.au
	jabber: agi...@pu...

[SL] wrong rebatte calculation in invoice/SO

[R. Q. <rq...@gm...>]

Hi,
a customer bought bought 180 pcs of an item at $ 81.50 with a rebatt of 7.5%
Normally the amount should be
180 x 81.50 x (100-7.5)/100 = 13569.75, so I am wondering why I am
getting 13,570.20 in sql-ledger invoice and sale order.
regards

Robert

Re: [SL] Multiple payments question

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

2007/9/2, Adrien Laurent <ad...@mo...>:
>
> Hi,
>
> Most of our service invoices are paid in multiple terms (generally 50% at
> order - 50% on delivery).
> My question is simple, how do I display this on one invoice ? (with a
> scheduled due date for each payment if possible)
>
> Thanks a lot,
>
> Adrien


Adrien,

Orders are NOT invoices. They may be binding legal documents, but they are
NOT invoices. So a prepayment on an order is NOT a payment on an invoice.

I suggest you put a line in the order template stating that for the services
the customer wants / needs, a 50% prepayment is a conditional part of the
ordering proces. I.e. work will start AFTER receipt of cash / cheque.

On the invoice you send out AFTER the work is done, you simply apply the
check or cash allready received.

Now the remaining 50% have payment conditions as defined for A/R customers
in general (or if needen, you can do that as fancy as you like).

HtH
Paul

[SL] Multiple payments question

[Adrien L. <ad...@mo...>]

Hi,

Most of our service invoices are paid in multiple terms (generally 50% at
order - 50% on delivery).
My question is simple, how do I display this on one invoice ? (with a
scheduled due date for each payment if possible)

Thanks a lot,

Adrien



-- 
Adrien Laurent
(514) 284-2020 x 202
http://www.modulis-groupe.com

[SL] Extended value results

[R. Q. <rq...@gm...>]

Hi,
considering the example below -
Normally the extended value should be
180 x 81.50 x (100-7.5)/100 = 13569.75, so I am wondering why I am 
getting the value below.
regards
Robert

Item 	Number 	Description 		Qty 	Ship 	Unit 	Price 	% 	Extended
									13,570.20
------------------------------------------------------------------------
									2,613.96

Re: [SL] Need compiled DBD for windows

[Dieter S. <dsi...@sq...>]

On Tue, 28 Aug 2007, Ron LeVine wrote:

> What is used instead? I am interested in getting this going as well.

Well, take a look at the download page under the Windows section.

[SL] Margins and character set when printing

[Oscar A. V. <ov...@en...>]

I have two questions regarding printed output:

1) My dataset is UTF-8 encoded, and everything displays properly on
screen. However, when printing, accented and other "foreign" characters
are not properly printed. How can I fix this?

2) How or where can I set margins and select form size (letter vs. A4)
for printed output?

Thanks in advance.
-- 
Oscar A. Valdez

Re: [SL] Need compiled DBD for windows

[Ron L. <lev...@gm...>]

What is used instead? I am interested in getting this going as well.

Thanks,
Ron

On 8/28/07, Dieter Simader <dsi...@sq...> wrote:
>
> Where did you find the link? All instances to Mergl's compiled driver
> were removed because it is outdated.
>
>
> On Tue, 28 Aug 2007, Nefnifi, Kasem wrote:
>
> > Need compiled DBD for windows, the link naar Edmund Mergl site is not
> okay should deleted from the site of sql-ledger.
> >
> > Any one give atip
> >
> > Best Regards / Vriendelijke Groeten / Salutations Distingu=E9es /
> Freundliche Gr=FC=DFe !!!
> > Kasem NEFNIFI
> > AtosOrigin Belux N.V.
> > Da Vincilaan, 5
> > 1930 Zaventem (Belgium)
> > Tel : +32(0)2 690 28 30
> > Fax : +32(0)2 690 28 61
> > GSM : +32 495 25 12 33
> > Email : kas...@at...
> > www.atosorigin.com
> >
> >
> >
> >
> -------------------------------------------------------------------------
> > 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
>

Re: [SL] Need compiled DBD for windows

[Dieter S. <dsi...@sq...>]

Where did you find the link? All instances to Mergl's compiled driver =

were removed because it is outdated.


On Tue, 28 Aug 2007, Nefnifi, Kasem wrote:

> Need compiled DBD for windows, the link naar Edmund Mergl site is not oka=
y should deleted from the site of sql-ledger.
>
> Any one give atip
>
> Best Regards / Vriendelijke Groeten / Salutations Distingu=E9es / Freundl=
iche Gr=FC=DFe !!!
> Kasem NEFNIFI
> AtosOrigin Belux N.V.
> Da Vincilaan, 5
> 1930 Zaventem (Belgium)
> Tel : +32(0)2 690 28 30
> Fax : +32(0)2 690 28 61
> GSM : +32 495 25 12 33
> Email : kas...@at...
> www.atosorigin.com
>
>
>
> -------------------------------------------------------------------------
> 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
>

Re: [SL] Need compiled DBD for windows

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

No need whatsoever if you use Linux. Cheaper and more reliable as well.

2007/8/28, Nefnifi, Kasem <Kas...@at...>:
>
> Need compiled DBD for windows, the link naar Edmund Mergl site is not oka=
y
> should deleted from the site of sql-ledger.
>
> Any one give atip
>
> Best Regards / Vriendelijke Groeten / Salutations Distingu=E9es /
> Freundliche Gr=FC=DFe !!!
> Kasem NEFNIFI
> AtosOrigin Belux N.V.
> Da Vincilaan, 5
> 1930 Zaventem (Belgium)
> Tel : +32(0)2 690 28 30
> Fax : +32(0)2 690 28 61
> GSM : +32 495 25 12 33
> Email : kas...@at...
> www.atosorigin.com
>
>
>
> -------------------------------------------------------------------------
> 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
>
>