web-erp-developers — Discussion on development of webERP

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] Bug in SystemParameters.php

[Phil D. <ph...@lo...>]

Bob's thing as I recall to default the quantity left to invoice to zero 
rather than the quantity outstanding on the order.

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 18/11/14 01:19, Pak Ricard wrote:
> Hi all:
>
> I think it was part of Thomas (sorry if I'm wrong) mod to change the 
> defaulr quantity when invoicing an order. Now you can choose 0 or 
> outstanding. This parameter is being currently used.
>
>
> Regards,
> Ricard
>
> 2014-11-17 12:05 GMT+08:00 ExsonQu <hex...@gm... 
> <mailto:hex...@gm...>>:
>
>     *Hi, Richard*
>
>            It's fixed!
>            Not sure why we introduce this new parameter.
>
>            Best regards!
>
>            Exson
>
>
>
>     --
>     View this message in context:
>     http://weberp-accounting.1478800.n4.nabble.com/Bug-in-SystemParameters-php-tp4657838p4657839.html
>     Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
>     ------------------------------------------------------------------------------
>     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...
>     <mailto: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

Re: [WebERP-developers] Bug in SystemParameters.php

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

Hi all:

I think it was part of Thomas (sorry if I'm wrong) mod to change the
defaulr quantity when invoicing an order. Now you can choose 0 or
outstanding. This parameter is being currently used.


Regards,
Ricard

2014-11-17 12:05 GMT+08:00 ExsonQu <hex...@gm...>:

> *Hi, Richard*
>
>        It's fixed!
>        Not sure why we introduce this new parameter.
>
>        Best regards!
>
>        Exson
>
>
>
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/Bug-in-SystemParameters-php-tp4657838p4657839.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> 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
>

Re: [WebERP-developers] Commit 6758

[Phil D. <ph...@lo...>]

Thanks for the feedback Brian, good points.

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 17/11/14 02:00, Br...@do... wrote:
> Just my 2 cents,
> I agree having my part number on the vendor purchase order does not make
> sense, (i like the new format).  However, it is nice to see the vendor part
> number when creating the purchase order or receiving the purchase order.
> When i create purchase orders, many times i am also ordering the parts
> online at the same time.  Now I cannot really do that.
>
> Then when the parts are received, its nice to see the vendor part number so
> i can see what our part number is in the receiving screen.
>
>
>
> --
> View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Commit-6758-tp4657825p4657837.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> 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] Bug in SystemParameters.php

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

*Hi, Richard*

       It's fixed! 
       Not sure why we introduce this new parameter. 

       Best regards! 

       Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Bug-in-SystemParameters-php-tp4657838p4657839.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

[WebERP-developers] Bug in SystemParameters.php

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

Hi all:

When updating the parameters in SystemParameters.php,
the InvoiceQuantityDefault gets empty. I had to go via phpMyAdmin to
restore the value to 1. Then as a test modify the value and save. Check
again in phpMyAdmin and was empty again.

Regards,
Ricard

Re: [WebERP-developers] Commit 6758

[<Br...@do...>]

Just my 2 cents,
I agree having my part number on the vendor purchase order does not make
sense, (i like the new format).  However, it is nice to see the vendor part
number when creating the purchase order or receiving the purchase order. 
When i create purchase orders, many times i am also ordering the parts
online at the same time.  Now I cannot really do that.

Then when the parts are received, its nice to see the vendor part number so
i can see what our part number is in the receiving screen.



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Commit-6758-tp4657825p4657837.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] MRP CANNOT get correct result

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

Thanks to you Exson!

We'll test the new MRP asap, and let you know.

Regards,
Ricard

2014-11-13 10:05 GMT+08:00 ExsonQu <hex...@gm...>:

> *Hi, Richard,*
>
>           Thank you for your feedback.
>
>           I've fixed the problem and remove some redundant code according
> to
> what I found. It can get the correct result now.
>
>           Thank you all for your feedback. It makes me have more
> understanding for this.
>
>           Best regards!
>
>           Exson
>
>
>
>
>
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/MRP-CANNOT-get-correct-result-tp4657811p4657829.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> 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] MRP CANNOT get correct result

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

*Hi, Richard,*

          Thank you for your feedback. 

          I've fixed the problem and remove some redundant code according to
what I found. It can get the correct result now. 
 
          Thank you all for your feedback. It makes me have more
understanding for this. 

          Best regards!

          Exson

             



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/MRP-CANNOT-get-correct-result-tp4657811p4657829.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

[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

Re: [WebERP-developers] Commit 6758

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

Thanks Phil:

I can understand your point.

PO is for the supplier, but someone from the company should verify that the
items received are the items requested on the PO. It helps a lot if it's in
company's language (stockid). Probably our case is a bit special, so I will
code it and maintain it in my private repository. If someone else needs
this change, then we can make it configurable.

BTW: I'm using SourceTree for few weeks and my "maintaining private files
for webERP" problems have been simplified a lot. Merges can be done in a
tiny fraction of the time I used to spend. Really worth a try :-)


Regards,
Ricard

2014-11-11 16:25 GMT+08:00 Phil Daintree <ph...@lo...>:

>  I am not sure I understand why?
>
> The PO is a document for the supplier.
>
> If the supplier code exists then it should be printed as the most accurate
> description to the supplier of what it is we are wanting to purchase.
>
> Putting our item code in the description could mean something different to
> the supplier so - following some off-list discussion - I removed this -
> concurring with the logic that the PO is a supplier facing document and we
> have a record of what item it relates to for us from any webERP PO inquiry.
>
> If you wish to make it configurable ok - but I think it is better NOT to
> have it on a PO if there is a supplier code which more accurately describes
> the item to the supplier.
>
> Phil
>
> Phil Daintree
> Logic Works Ltd - +64 (0)275 567890http://www.logicworks.co.nz
>
> On 11/11/14 20:26, Pak Ricard wrote:
>
> Hi Phil:
>
>  SOmeone from my team complained that when printing the PDF for PO, the
> stockid is not shown anymore (if there's any supplier code for this item).
> Seems like you introduced this change in commit 6758, but we think it is
> useful to always have the webERP stockid in printed PO
>
>  It's useful n reception checking time of PO's as company employees are
> normally used to stockid, not supplier id's.
>
>  Could we reverse this or find a way to always show the stockid? What
> about if first column is always stockid and "Item Description" column is
> supplierid + description?
>
>  Regards,
> Ricard
>
>
> ------------------------------------------------------------------------------
> 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 lis...@li...https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
>
> ------------------------------------------------------------------------------
> 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] Commit 6758

[Phil D. <ph...@lo...>]

I am not sure I understand why?

The PO is a document for the supplier.

If the supplier code exists then it should be printed as the most 
accurate description to the supplier of what it is we are wanting to 
purchase.

Putting our item code in the description could mean something different 
to the supplier so - following some off-list discussion - I removed this 
- concurring with the logic that the PO is a supplier facing document 
and we have a record of what item it relates to for us from any webERP 
PO inquiry.

If you wish to make it configurable ok - but I think it is better NOT to 
have it on a PO if there is a supplier code which more accurately 
describes the item to the supplier.

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 11/11/14 20:26, Pak Ricard wrote:
> Hi Phil:
>
> SOmeone from my team complained that when printing the PDF for PO, the 
> stockid is not shown anymore (if there's any supplier code for this 
> item). Seems like you introduced this change in commit 6758, but we 
> think it is useful to always have the webERP stockid in printed PO
>
> It's useful n reception checking time of PO's as company employees are 
> normally used to stockid, not supplier id's.
>
> Could we reverse this or find a way to always show the stockid? What 
> about if first column is always stockid and "Item Description" column 
> is supplierid + description?
>
> Regards,
> Ricard
>
>
> ------------------------------------------------------------------------------
> 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

[WebERP-developers] Commit 6758

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

Hi Phil:

SOmeone from my team complained that when printing the PDF for PO, the
stockid is not shown anymore (if there's any supplier code for this item).
Seems like you introduced this change in commit 6758, but we think it is
useful to always have the webERP stockid in printed PO

It's useful n reception checking time of PO's as company employees are
normally used to stockid, not supplier id's.

Could we reverse this or find a way to always show the stockid? What about
if first column is always stockid and "Item Description" column is
supplierid + description?

Regards,
Ricard

Re: [WebERP-developers] MRP CANNOT get correct result

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

Hi Exson: Probably you are right :-), as we don't use "issue to".

When we have enough components, we grab the components from the stock, and
produce the goods (usually done the same day) and just close the WO, so we
don't have issued materials dancing in the DB. I can't help much on this,
sorry.

Regards,
Ricard

2014-11-11 14:12 GMT+08:00 ExsonQu <hex...@gm...>:

> *Dear all,*
>
>        Thank you for your response. I'll pay more time to investigate my
> issue later.
>
>        Copy to Richard,
>
>            Is the demand result still correct when you issue some
> components
> to these WOs?
>
>        Best regards!
>
>        Exson
>
>
>
>
>
>
>
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/MRP-CANNOT-get-correct-result-tp4657811p4657822.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> 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] MRP CANNOT get correct result

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

*Dear all,*

       Thank you for your response. I'll pay more time to investigate my
issue later. 

       Copy to Richard,

           Is the demand result still correct when you issue some components
to these WOs? 

       Best regards!

       Exson

    

      



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/MRP-CANNOT-get-correct-result-tp4657811p4657822.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] MRP CANNOT get correct result

[Phil D. <ph...@lo...>]

WOs also demand components as well as supplying finished stuff
Regards
Phil
Phil Daintree
Cell: +64 (0) 275 567890
http://www.logicworks.co.nz

On 11 November 2014 12:56:49 PM NZDT, Pak Ricard <pak...@gm...> wrote:
>Hi all:
>
>We use MRP in a weekly basis to recalculate all our PO and WO, and we
>think
>the module is working OK, but probably there are some bugs there we
>haven't
>discovered yet.
>
>IMO, WO belong to the supply side of the company, and I don't get the
>point
>to make WO interchangeable with Wo. Could you please elaborate?
>
>Thanks!
>
>Regards,
>Ricard
>
>2014-11-11 5:10 GMT+08:00 gilberto dos santos alves <gs...@gm...>:
>
>> and version too! i continue using v4.11.3 and i need understant what
>is
>> exact case for tests. regards.
>>
>> 2014-11-09 10:37 GMT-02:00 ExsonQu <hex...@gm...>:
>>
>> *Dear all,*
>>>
>>>            I've found that the MRP cannot calculate a correct result
>when
>>> Work Orders created and materials issued.
>>>
>>>           The logic is wrong for Work Orders demands and supplies.
>It is
>>> only correct when the WO created and no materials issued or finished
>goods
>>> received properly according to the BOM. Unfortunately, most of time,
>it's
>>> not the story.
>>>
>>>          Not sure if I've made a mistakes. Does anyone use the MRP
>>> successfully?
>>>
>>>          Best regards!
>>>
>>>          Exson
>>>
>>>
>>>
>>>
>>> --
>>> View this message in context:
>>>
>http://weberp-accounting.1478800.n4.nabble.com/MRP-CANNOT-get-correct-result-tp4657811.html
>>> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>>>
>>>
>>>
>------------------------------------------------------------------------------
>>> _______________________________________________
>>> 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
>>
>>
>
>
>------------------------------------------------------------------------
>
>------------------------------------------------------------------------------
>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] MRP CANNOT get correct result

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

Hi all:

We use MRP in a weekly basis to recalculate all our PO and WO, and we think
the module is working OK, but probably there are some bugs there we haven't
discovered yet.

IMO, WO belong to the supply side of the company, and I don't get the point
to make WO interchangeable with Wo. Could you please elaborate?

Thanks!

Regards,
Ricard

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

> and version too! i continue using v4.11.3 and i need understant what is
> exact case for tests. regards.
>
> 2014-11-09 10:37 GMT-02:00 ExsonQu <hex...@gm...>:
>
> *Dear all,*
>>
>>            I've found that the MRP cannot calculate a correct result when
>> Work Orders created and materials issued.
>>
>>           The logic is wrong for Work Orders demands and supplies. It is
>> only correct when the WO created and no materials issued or finished goods
>> received properly according to the BOM. Unfortunately, most of time, it's
>> not the story.
>>
>>          Not sure if I've made a mistakes. Does anyone use the MRP
>> successfully?
>>
>>          Best regards!
>>
>>          Exson
>>
>>
>>
>>
>> --
>> View this message in context:
>> http://weberp-accounting.1478800.n4.nabble.com/MRP-CANNOT-get-correct-result-tp4657811.html
>> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>>
>>
>> ------------------------------------------------------------------------------
>> _______________________________________________
>> 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...>]

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] MRP CANNOT get correct result

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

and version too! i continue using v4.11.3 and i need understant what is
exact case for tests. regards.

2014-11-09 10:37 GMT-02:00 ExsonQu <hex...@gm...>:

> *Dear all,*
>
>            I've found that the MRP cannot calculate a correct result when
> Work Orders created and materials issued.
>
>           The logic is wrong for Work Orders demands and supplies. It is
> only correct when the WO created and no materials issued or finished goods
> received properly according to the BOM. Unfortunately, most of time, it's
> not the story.
>
>          Not sure if I've made a mistakes. Does anyone use the MRP
> successfully?
>
>          Best regards!
>
>          Exson
>
>
>
>
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/MRP-CANNOT-get-correct-result-tp4657811.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> 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 the 'debtortrans' table.

[Rafael C. <raf...@gm...>]

Hi,

I had to sort the the 'debtortrans' table. If someone has to do the same,
feel free to use and modify the enclosed code.

Best regards, Rafael.

Re: [WebERP-developers] MRP CANNOT get correct result

[Phil D. <ph...@lo...>]

This seems quite a radical fix.... could you provide some details of the 
issues you are having please.

Thanks

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 10/11/14 14:13, ExsonQu wrote:
> *Dear all,*
>
>              I think we have to redesign the MRP to make it workable.
>
>              The initial idea is remove work orders from supplies side and
> make sales orders and work orders exchangeable.
>           
>             Any comments are highly appreciated!
>
>              Best regards!
>
>              Exson
>
>
>
> --
> View this message in context: http://weberp-accounting.1478800.n4.nabble.com/MRP-CANNOT-get-correct-result-tp4657811p4657812.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

Re: [WebERP-developers] MRP CANNOT get correct result

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

*Dear all,*

            I think we have to redesign the MRP to make it workable. 

            The initial idea is remove work orders from supplies side and
make sales orders and work orders exchangeable.
         
           Any comments are highly appreciated!

            Best regards!

            Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/MRP-CANNOT-get-correct-result-tp4657811p4657812.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

[WebERP-developers] MRP CANNOT get correct result

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

*Dear all,*

           I've found that the MRP cannot calculate a correct result when
Work Orders created and materials issued. 

          The logic is wrong for Work Orders demands and supplies. It is
only correct when the WO created and no materials issued or finished goods
received properly according to the BOM. Unfortunately, most of time, it's
not the story. 

         Not sure if I've made a mistakes. Does anyone use the MRP
successfully? 

         Best regards!

         Exson




--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/MRP-CANNOT-get-correct-result-tp4657811.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

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

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