Re: [WebERP-developers] BOM effective dates mismatch

[Vitaly S. <vsh...@so...>]

This is the current trunk revision 7091.
Some of the files are BOMExtendedQty.php, BOMIndented.php, 
BOMInquiry.php, SQL_CommonFunctions.inc and some other.

Vitaly


On 1/21/2015 1:51 PM, Andrew Galuski wrote:
>
> Also which version of the code?
>
> Best Regards,
>
> Andrew Galuski
>
> ResMart LLC.
>
> 817.615.2038 (Office)
>
> 817.821.0544 (Cell)
>
> www.resmart.com <http://www.resmart.com>
>
> resmart_logo
>
> *From:*gilberto dos santos alves [mailto:gs...@gm...]
> *Sent:* Wednesday, January 21, 2015 1:50 PM
> *To:* webERP Developers
> *Subject:* Re: [WebERP-developers] BOM effective dates mismatch
>
> Hi. Please could you describe (if possible) what scripts you are 
> talking (tools like diff or others similar). Thanks for your time.
>
> 2015-01-21 16:48 GMT-02:00 Vitaly Shevkunov <vsh...@so... 
> <mailto:vsh...@so...>>:
>
> Hello all,
>
> I just noticed, that there is a discrepancy in how different scrips
> access the BOM table. Some of them do this
>
>              AND bom.effectiveafter < '" . Date('Y-m-d') . "'
>              AND (bom.effectiveto > '" . Date('Y-m-d') . "'
>               OR bom.effectiveto='0000-00-00')";
>
> Others have
> AND bom.effectiveto >= '" . date('Y-m-d') . "'
>                AND bom.effectiveafter <= '" . date('Y-m-d') . "'";
>
> And yet others do not check effective dates at all.
>
> I would like to fix this, but I am not sure if I am supposed to use '>'
> or '>='.
>
> Thanks,
>
> Vitaly
>
>
> ------------------------------------------------------------------------------
> New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
> GigeNET is offering a free month of service with a new server in Ashburn.
> Choose from 2 high performing configs, both with 100TB of bandwidth.
> Higher redundancy.Lower latency.Increased capacity.Completely compliant.
> http://p.sf.net/sfu/gigenet
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li... 
> <mailto:Web...@li...>
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
>
> -- 
>
> gilberto dos santos alves
> +55(11)9-8646-5049
> sao paulo - sp - brasil
>
>
>
>
>
> ------------------------------------------------------------------------------
> New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
> GigeNET is offering a free month of service with a new server in Ashburn.
> Choose from 2 high performing configs, both with 100TB of bandwidth.
> Higher redundancy.Lower latency.Increased capacity.Completely compliant.
> http://p.sf.net/sfu/gigenet
>
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
> No virus found in this message.
> Checked by AVG - www.avg.com <http://www.avg.com>
> Version: 2015.0.5645 / Virus Database: 4260/8972 - Release Date: 01/21/15
>