web-erp-developers

[WebERP-developers] Sort ascending in tables does not work OK

[Pak R. <pak...@gm...>]

Hi all:

The nice feature allowing to sort a table does not work OK, once the number
has been formatted.

Please check the attachement file, a fragment of top sales Items list,
sorted by Value of Sales ascenting. Positions 4 and 5 are wrong, 7, 10 are
wrong, etc.

Total Invoiced column works OK, so I guess it has to do with the format of
the number.

I have no clue on how it works or how to fix it. Could someone smart ,
please take a look? :-)

Regards,
Ricard

[WebERP-developers] Sort ascending in tables does not work OK

[Pak R. <pak...@gm...>]

Hi all:

I just applied commit 6972 to correct the bug previously reported, and it's
working OK.

FYI, browser cache had to be cleaned first (using Chrome, js files probably
live longer on the cache)

Many thanks Tim and Phil.

Regards,
Ricard

[WebERP-developers] Z_DeleteInvoice don't clear invoiced_qty correctly

[Alessandro S. <ADS...@ac...>]

Hi all
Z_DeleteInvoice do not clear the qty_invoiced from the invoice to the sales order see line 121
	$SQL = "UPDATE salesorderdetails SET qtyinvoiced = qtyinvoiced - " . $OrderLine['qty'] . “,
as  $OrderLine[‘qty’] from stock moves is negative internally it’s adding it in reality so at the end of the deletion you end up with salesorderdetails.qtyinvoiced doubled instead of cleared.
Can i simply change the “-“ with “+” and all is well ? or there is a finer point that i don’t get ? 
thanks all 
Alessandro Saporetti

Re: [WebERP-developers] Z_DeleteInvoice don't clear invoiced_qty correctly

[ExsonQu <hex...@gm...>]

Hi, Alessandro Saporetti,

       You're right. 
       It should be changed to '+' instead of '-'.

     I've commit your fix to the trunk. 

     Best regards!

     Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Sort-ascending-in-tables-does-not-work-OK-tp4657803p4657809.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Sort ascending in tables does not work OK

[gilberto d. s. a. <gs...@gm...>]

please what is specific url of weberp you are running for exemple:

[1] http://www.weberp.org/weberp/SelectCompletedOrder.php

[2] http://pastebin.com/6yEAk6aJ

look in your browser (if chrome use <ctrl+shit+i> for develop menu and on
scripts you will see [2] search for functions sortselect and you will
understant what is magic using javascript and jquery. But please post what
is url of your report or what is menu options for access your report to all
of we understand. thanks.

2014-11-07 5:23 GMT-02:00 Pak Ricard <pak...@gm...>:

> Hi all:
>
> The nice feature allowing to sort a table does not work OK, once the
> number has been formatted.
>
> Please check the attachement file, a fragment of top sales Items list,
> sorted by Value of Sales ascenting. Positions 4 and 5 are wrong, 7, 10 are
> wrong, etc.
>
> Total Invoiced column works OK, so I guess it has to do with the format of
> the number.
>
> I have no clue on how it works or how to fix it. Could someone smart ,
> please take a look? :-)
>
> Regards,
> Ricard
>
>
> ------------------------------------------------------------------------------
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>


-- 
gilberto dos santos alves
+55.11.98646-5049
sao paulo - sp - brasil

[WebERP-developers] Sort ascending in tables does not work OK

[Pak R. <pak...@gm...>]

Hi all:

The nice feature allowing to sort a table does not work OK, once the number
has been formatted.

Please check the attachement file, a fragment of top sales Items list,
sorted by Value of Sales ascenting. Positions 4 and 5 are wrong, 7, 10 are
wrong, etc.

Total Invoiced column works OK, so I guess it has to do with the format of
the number.

I have no clue on how it works or how to fix it. Could someone smart ,
please take a look? :-)

Regards,
Ricard

Re: [WebERP-developers] Sort ascending in tables does not work OK

[Pak R. <pak...@gm...>]

Hi Gilberto:

It happens in ALL table sorts in webERP if you use , (comma) as the
thousand separator and . (decimal point) as decimal separator.

The example given was from Main Menu / Sales / Inquiries and Reports / Top
Sales Items Report, but any table shows the same issue.

Thanks!

Regards,
Ricard

2014-11-08 6:03 GMT+08:00 gilberto dos santos alves <gs...@gm...>:

> please what is specific url of weberp you are running for exemple:
>
> [1] http://www.weberp.org/weberp/SelectCompletedOrder.php
>
> [2] http://pastebin.com/6yEAk6aJ
>
> look in your browser (if chrome use <ctrl+shit+i> for develop menu and on
> scripts you will see [2] search for functions sortselect and you will
> understant what is magic using javascript and jquery. But please post what
> is url of your report or what is menu options for access your report to all
> of we understand. thanks.
>
> 2014-11-07 5:23 GMT-02:00 Pak Ricard <pak...@gm...>:
>
>> Hi all:
>>
>> The nice feature allowing to sort a table does not work OK, once the
>> number has been formatted.
>>
>> Please check the attachement file, a fragment of top sales Items list,
>> sorted by Value of Sales ascenting. Positions 4 and 5 are wrong, 7, 10 are
>> wrong, etc.
>>
>> Total Invoiced column works OK, so I guess it has to do with the format
>> of the number.
>>
>> I have no clue on how it works or how to fix it. Could someone smart ,
>> please take a look? :-)
>>
>> Regards,
>> Ricard
>>
>>
>> ------------------------------------------------------------------------------
>>
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web...@li...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>
>
>
> --
> gilberto dos santos alves
> +55.11.98646-5049
> sao paulo - sp - brasil
>
>
>
>
>
>
> ------------------------------------------------------------------------------
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>

Re: [WebERP-developers] Sort ascending in tables does not work OK

[gilberto d. s. a. <gs...@gm...>]

thanks i will try to reproduce.

2014-11-07 20:52 GMT-02:00 Pak Ricard <pak...@gm...>:

> Hi Gilberto:
>
> It happens in ALL table sorts in webERP if you use , (comma) as the
> thousand separator and . (decimal point) as decimal separator.
>
> The example given was from Main Menu / Sales / Inquiries and Reports / Top
> Sales Items Report, but any table shows the same issue.
>
> Thanks!
>
> Regards,
> Ricard
>
> 2014-11-08 6:03 GMT+08:00 gilberto dos santos alves <gs...@gm...>:
>
>> please what is specific url of weberp you are running for exemple:
>>
>> [1] http://www.weberp.org/weberp/SelectCompletedOrder.php
>>
>> [2] http://pastebin.com/6yEAk6aJ
>>
>> look in your browser (if chrome use <ctrl+shit+i> for develop menu and on
>> scripts you will see [2] search for functions sortselect and you will
>> understant what is magic using javascript and jquery. But please post what
>> is url of your report or what is menu options for access your report to all
>> of we understand. thanks.
>>
>> 2014-11-07 5:23 GMT-02:00 Pak Ricard <pak...@gm...>:
>>
>>> Hi all:
>>>
>>> The nice feature allowing to sort a table does not work OK, once the
>>> number has been formatted.
>>>
>>> Please check the attachement file, a fragment of top sales Items list,
>>> sorted by Value of Sales ascenting. Positions 4 and 5 are wrong, 7, 10 are
>>> wrong, etc.
>>>
>>> Total Invoiced column works OK, so I guess it has to do with the format
>>> of the number.
>>>
>>> I have no clue on how it works or how to fix it. Could someone smart ,
>>> please take a look? :-)
>>>
>>> Regards,
>>> Ricard
>>>
>>>
>>> ------------------------------------------------------------------------------
>>>
>>> _______________________________________________
>>> Web-erp-developers mailing list
>>> Web...@li...
>>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>>
>>>
>>
>>
>> --
>> gilberto dos santos alves
>> +55.11.98646-5049
>> sao paulo - sp - brasil
>>
>>
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>>
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web...@li...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>
>
>
> ------------------------------------------------------------------------------
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>


-- 
gilberto dos santos alves
+55.11.98646-5049
sao paulo - sp - brasil

Re: [WebERP-developers] Z_DeleteInvoice don't clear invoiced_qty correctly

[gilberto d. s. a. <gs...@gm...>]

please what verstion that you is talking? thanks.

2014-11-07 13:37 GMT-02:00 Alessandro Saporetti <ADS...@ac...
>:

> Hi all
> Z_DeleteInvoice do not clear the qty_invoiced from the invoice to the
> sales order see line 121
>         $SQL = "UPDATE salesorderdetails SET qtyinvoiced = qtyinvoiced - "
> . $OrderLine['qty'] . “,
> as  $OrderLine[‘qty’] from stock moves is negative internally it’s adding
> it in reality so at the end of the deletion you end up with
> salesorderdetails.qtyinvoiced doubled instead of cleared.
> Can i simply change the “-“ with “+” and all is well ? or there is a finer
> point that i don’t get ?
> thanks all
> Alessandro Saporetti
>
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>



-- 
gilberto dos santos alves
+55.11.98646-5049
sao paulo - sp - brasil

Re: [WebERP-developers] Z_DeleteInvoice don't clear invoiced_qty correctly

[Alessandro S. <ADS...@ac...>]

latest available on the official web  4.11.5

Il giorno 10/nov/2014, alle ore 22:24, gilberto dos santos alves <gs...@gm...> ha scritto:

> please what verstion that you is talking? thanks.
> 
> 2014-11-07 13:37 GMT-02:00 Alessandro Saporetti <ADS...@ac...>:
> Hi all
> Z_DeleteInvoice do not clear the qty_invoiced from the invoice to the sales order see line 121
>         $SQL = "UPDATE salesorderdetails SET qtyinvoiced = qtyinvoiced - " . $OrderLine['qty'] . “,
> as  $OrderLine[‘qty’] from stock moves is negative internally it’s adding it in reality so at the end of the deletion you end up with salesorderdetails.qtyinvoiced doubled instead of cleared.
> Can i simply change the “-“ with “+” and all is well ? or there is a finer point that i don’t get ?
> thanks all
> Alessandro Saporetti
> 
> 
> ------------------------------------------------------------------------------
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> 
> 
> 
> -- 
> gilberto dos santos alves
> +55.11.98646-5049
> sao paulo - sp - brasil
> 
> 
> 
> 
> ------------------------------------------------------------------------------
> Comprehensive Server Monitoring with Site24x7.
> Monitor 10 servers for $9/Month.
> Get alerted through email, SMS, voice calls or mobile push notifications.
> Take corrective actions from your mobile device.
> http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk_______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [WebERP-developers] Z_DeleteInvoice don't clear invoiced_qty correctly

[gilberto d. s. a. <gs...@gm...>]

i am try to reproduce and understand what is going on, before our migration
from 4.11.3 to 4.11.5. thanks.

2014-11-17 20:45 GMT-02:00 Alessandro Saporetti <ADS...@ac...
>:

> latest available on the official web  4.11.5
>
> Il giorno 10/nov/2014, alle ore 22:24, gilberto dos santos alves <
> gs...@gm...> ha scritto:
>
> > please what verstion that you is talking? thanks.
> >
> > 2014-11-07 13:37 GMT-02:00 Alessandro Saporetti <
> ADS...@ac...>:
> > Hi all
> > Z_DeleteInvoice do not clear the qty_invoiced from the invoice to the
> sales order see line 121
> >         $SQL = "UPDATE salesorderdetails SET qtyinvoiced = qtyinvoiced -
> " . $OrderLine['qty'] . “,
> > as  $OrderLine[‘qty’] from stock moves is negative internally it’s
> adding it in reality so at the end of the deletion you end up with
> salesorderdetails.qtyinvoiced doubled instead of cleared.
> > Can i simply change the “-“ with “+” and all is well ? or there is a
> finer point that i don’t get ?
> > thanks all
> > Alessandro Saporetti
> >
> >
> >
> ------------------------------------------------------------------------------
> > _______________________________________________
> > Web-erp-developers mailing list
> > Web...@li...
> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> >
> >
> >
> > --
> > gilberto dos santos alves
> > +55.11.98646-5049
> > sao paulo - sp - brasil
> >
> >
> >
> >
> >
> ------------------------------------------------------------------------------
> > Comprehensive Server Monitoring with Site24x7.
> > Monitor 10 servers for $9/Month.
> > Get alerted through email, SMS, voice calls or mobile push notifications.
> > Take corrective actions from your mobile device.
> >
> http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk_______________________________________________
> > Web-erp-developers mailing list
> > Web...@li...
> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
> ------------------------------------------------------------------------------
> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
> with Interactivity, Sharing, Native Excel Exports, App Integration & more
> Get technology previously reserved for billion-dollar corporations, FREE
>
> http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>



-- 
gilberto dos santos alves
+55(11)9-8646-5049
sao paulo - sp - brasil