« Return to Thread: BOM Problem

Re: BOM Problem

by Nathan Gray :: Rate this Message:

Reply to Author | View in Thread


On 10-Apr-09, at 4:51 AM, Dudás Zsolt wrote:

> Current boom problem cause  in line 23 of  
> class.so_perp_bill_of_material.nc.php.
>
> bad: $where[] = "(NOW() >= effective_after_date AND (NOW() <=  
> effective_to_date OR effective_to_date IS NULL))";
>
> good:
> $where[] = "(NOW() >= effective_after_date AND (NOW() <=  
> effective_to_date) OR effective_to_date IS NULL)";


Thank you for hunting and contributing.

I may need some coffee, but I don't understand what situation that  
fixes.

In addition, in the case where a future BOM for a new product is to  
take effect in one week, with no effective_to_date, would it not show  
as a current BOM as well as future?
I've committed it to SVN, rev 3313 so everyone can have a look, but  
I'm not sure about it.

Nathan Gray
nathan at goarctic dot com


------------------------------------------------------------------------------
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
_______________________________________________
Perp-developers mailing list
Perp-developers@...
https://lists.sourceforge.net/lists/listinfo/perp-developers

 « Return to Thread: BOM Problem