Thread: [SL] Wrong number formating

Brought to you by: dsimader, turt1e

sql-ledger-users

[SL] Wrong number formating

From: Giedrius <zl...@nk...> - 2007-05-28 14:34:11

I have chosen "1000,00" format of number and now I receive false values
in Vendor Invoices and in Sales Invoices:

Subtotal:  	73,28
Tax 18%: 	1319,04
Total:       	1392,32

Version 2.8.5.
-- 
Giedrius

Re: [SL] Wrong number formating

From: Dirk E. S. <ds...@ca...> - 2007-05-28 16:54:29

> I have chosen "1000,00" format of number and now I receive false values
> in Vendor Invoices and in Sales Invoices:
>
> Subtotal:  	73,28
> Tax 18%: 	1319,04
> Total:       	1392,32

I have a similar observation with 2.8.4 under Audit control. When I call
the module it shows "20061231" instead of "31-12-2006". Something changed
in the date formatting?



-- 
Dirk Enrique Seiffert - Lintec S.A.
Ed. Torre del Reloj - Of. 401
Plaza de los Coches, Centro
Cartagena - Colombia
http://www.lintecsa.com

Re: [SL] Wrong number formating

From: Stroller <lin...@my...> - 2007-05-29 15:40:10

What do you think is wrong with this?

I read that as the European (German?) number format, using a comma as  
a decimal point. Not as a thousands-separator.

 From Calculator.app's "paper tape" 73.28 + 1319.04 = 1392.32

So the below all looks "ok" to me (except that I detest commas used  
as decimal points)

Stroller



On 28 May 2007, at 15:33, Giedrius wrote:

> I have chosen "1000,00" format of number and now I receive false  
> values
> in Vendor Invoices and in Sales Invoices:
>
> Subtotal:  	73,28
> Tax 18%: 	1319,04
> Total:       	1392,32
>
> Version 2.8.5.
> -- 
> Giedrius

Re: [SL] Wrong number formating

From: George O. <geo...@ya...> - 2007-05-29 22:21:31

On Wednesday 30 May 2007, Stroller wrote:
> What do you think is wrong with this?
>
> I read that as the European (German?) number format, using a comma as
> a decimal point. Not as a thousands-separator.
>
>  From Calculator.app's "paper tape" 73.28 + 1319.04 = 1392.32
>
> So the below all looks "ok" to me (except that I detest commas used
> as decimal points)

And also of course that 1319.04 is not 18% of 73.28.

> Stroller
>
> On 28 May 2007, at 15:33, Giedrius wrote:
> > I have chosen "1000,00" format of number and now I receive false
> > values
> > in Vendor Invoices and in Sales Invoices:
> >
> > Subtotal:  	73,28
> > Tax 18%: 	1319,04
> > Total:       	1392,32
> >
> > Version 2.8.5.
> > --
> > Giedrius
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users



-- 
George
AUSTRALIA
http://www.okstudio.com.au

Re: [SL] Wrong number formating

From: Michael H. <mh...@it...> - 2007-05-30 07:42:49

However, 18% of 73.28 is 13.1904, so the question is where the  
decimal point is getting shifted.

    Giedrus - if you actually post one of these invoices and then  
look at it later either directly or through seeing the values in a  
report, are the correct values actually getting posted?  That would  
help determine if the problem is just a display bug or if there is  
something deeper involved.


Thanks,

Michael


On May 29, 2007, at 3:21 PM, George Osvald wrote:

> On Wednesday 30 May 2007, Stroller wrote:
>> What do you think is wrong with this?
>>
>> I read that as the European (German?) number format, using a comma as
>> a decimal point. Not as a thousands-separator.
>>
>>  From Calculator.app's "paper tape" 73.28 + 1319.04 = 1392.32
>>
>> So the below all looks "ok" to me (except that I detest commas used
>> as decimal points)
>
> And also of course that 1319.04 is not 18% of 73.28.
>
>> Stroller
>>
>> On 28 May 2007, at 15:33, Giedrius wrote:
>>> I have chosen "1000,00" format of number and now I receive false
>>> values
>>> in Vendor Invoices and in Sales Invoices:
>>>
>>> Subtotal:  	73,28
>>> Tax 18%: 	1319,04
>>> Total:       	1392,32
>>>
>>> Version 2.8.5.
>>> --
>>> Giedrius
>>
>> --------------------------------------------------------------------- 
>> ----
>> This SF.net email is sponsored by DB2 Express
>> Download DB2 Express C - the FREE version of DB2 express and take
>> control of your XML. No limits. Just data. Click to get it now.
>> http://sourceforge.net/powerbar/db2/
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
>
> -- 
> George
> AUSTRALIA
> http://www.okstudio.com.au
>
> ---------------------------------------------------------------------- 
> ---
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Wrong number formating

From: Giedrius <zl...@nk...> - 2007-05-30 09:10:44

On Wed, 30 May 2007 00:39:42 -0700
Michael Hasse <mh...@it...> wrote:

> However, 18% of 73.28 is 13.1904, so the question is where the  
> decimal point is getting shifted.
> 
>     Giedrus - if you actually post one of these invoices and then  
> look at it later either directly or through seeing the values in a  
> report, are the correct values actually getting posted?  That would  
> help determine if the problem is just a display bug or if there is  
> something deeper involved.
> 

This is a display bug - values actually getting posted are correct.
-- 
Giedrius

Re: [SL] Wrong number formating

From: Michael H. <mh...@it...> - 2007-06-02 04:50:56

Should probably submit it as a bug then...


Thanks,

Michael



On May 30, 2007, at 2:10 AM, Giedrius wrote:

> On Wed, 30 May 2007 00:39:42 -0700
> Michael Hasse <mh...@it...> wrote:
>
>> However, 18% of 73.28 is 13.1904, so the question is where the
>> decimal point is getting shifted.
>>
>>     Giedrus - if you actually post one of these invoices and then
>> look at it later either directly or through seeing the values in a
>> report, are the correct values actually getting posted?  That would
>> help determine if the problem is just a display bug or if there is
>> something deeper involved.
>>
>
> This is a display bug - values actually getting posted are correct.
> --  
> Giedrius
>
> ---------------------------------------------------------------------- 
> ---
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Wrong number formating

From: Tom D. <td...@ro...> - 2007-06-03 01:49:47

On Fri, 1 Jun 2007, Michael Hasse wrote:

> Should probably submit it as a bug then...
>
>
> Thanks,
>
> Michael
>
>
>
> On May 30, 2007, at 2:10 AM, Giedrius wrote:
>
>> On Wed, 30 May 2007 00:39:42 -0700
>> Michael Hasse <mh...@it...> wrote:
>>
>>> However, 18% of 73.28 is 13.1904, so the question is where the
>>> decimal point is getting shifted.
>>>
>>>     Giedrus - if you actually post one of these invoices and then
>>> look at it later either directly or through seeing the values in a
>>> report, are the correct values actually getting posted?  That would
>>> help determine if the problem is just a display bug or if there is
>>> something deeper involved.
>>>
>>
>> This is a display bug - values actually getting posted are correct.

I suspect this is a known bug with a known fix. If not on 2.8.5 suggest you
upgrade. If you have support check the forum.

Regards,

-- 
Tom Diehl		td...@ro...		Spamtrap address mt...@ro...