BOM Problem

[n-art-m]

Hey, here I am again *g*.
A few days ago I created a BOM for an assembly. At time this BOM should be a "current BOM". But it's not.
It doesn't appear in the BOM Tab for this part. Trying add a work order results with the same problem "need a current BOM ID".
Then I created a new BOM with a future startdate. Perp automatically set the "effectiv to" one day before the new BOM starts.  I can't find a reason.  

Thanks

[Nathan Gray]

On 9-Apr-09, at 5:32 AM, n-art-m wrote:

>
> Hey, here I am again *g*.
> A few days ago I created a BOM for an assembly. At time this BOM  
> should be a
> "current BOM". But it's not.
> It doesn't appear in the BOM Tab for this part. Trying add a work  
> order
> results with the same problem "need a current BOM ID".
> Then I created a new BOM with a future startdate. Perp automatically  
> set the
> "effectiv to" one day before the new BOM starts.  I can't find a  
> reason.

The most common cause of headaches with things that vary over time  
(BOMs, pricing, build options) is the effective date(s).
To start with, unless you need it, turn off Force history of BOMs in  
Admin -> Manufacturing -> Site config.  That option creates a new BOM  
every time you make a change, and could be the source of your problem.

Check the BOM list for conflicting dates.

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

[Nathan Gray]

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

[Nathan Gray]

On 13-Apr-09, at 2:08 PM, Dudás Zsolt wrote:

> Dear Nathan,
>
> Some versions of PHP handle badly the order of math relationship.
> If effective_to_date is null and you try to compare this way,
> first is 'OR' relation then 'NOW()<='.
> That's why the get_bill_of_material_list function retuns empty.

Which versions of PHP have this issue?

That's SQL, not PHP.
http://dev.mysql.com/doc/refman/5.0/en/operator-precedence.html

You did not address my concern:
>
>> 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?
>

In example form, given the following BOMs:
#1
Effective from: 2009-01-01
Effective to: null

#2
Effective from: 2009-06-01
Effective to: null

#3
Effective from: 2009-01-01
Effective to: 2009-06-01

and
NOW() = 2009-04-13, the expected result is #1, #3
NOW() = 2009-01-01, the expected result is #1, #3
NOW() = 2009-06-10, the expected result is #1, #2
assuming all other parameters are equal.

> ps. You can see the hungarian transilation of your system in  
> attached file.
> Not final, but it's good enoungth. Use it,if you want.

Thanks, I'll wait until you get it done.  When you do get it ready,  
please send it as a zip.

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