From: rfthomas <rf...@as...> - 2014-09-22 15:26:45
|
The BOM now carries a location and workcenter on each record. There should be a header and detail for BOM's, so that the defaults for the whole BOM may be set and maintained in one place. Our business needs to maintain control on BOMs per US DOD, and other US and foreign country traceability and configuration control requirements. If by location a BOM differs, i.e. items utilized differ or manufacturing method differs outside of certain strict parameters, then it is not the same inventory item. The usual convention is to keep the main inventory code the same and for this marginally different BOM, add a part revision code, a routing code and a routing revision code. Inventory code example: <part code>_<design revision>_<routing>_<Routing process revision> BLISC_010_A_001 It is recognized that properly handling equivalent parts, i.e. BLISC_010_A_001 and BLISC_010_B_120 are interchangeable items, i.e. all BLISC_010. The customer would order BLISC_010 and higher level BOMs would reference BLISC_010. The actual build/sale operation would then pull any parts with a code starting with BLISC_010 irrespective of routing and routing revision, In any case the current BOMs.php does not allow for defaults for location or workstation, but merely shows the first location and workcenter in alphabetical order. In order to have a reasonable default location, i.e. the DefaultFactoryLocation, we have changed BOMs.php around line 705 as follows: while ($myrow = DB_fetch_array($result)) { if (isset($_POST['LocCode']) AND $myrow['loccode']==$_POST['LocCode']) { echo '<option selected="selected" value="'; } else { if($myrow['loccode']==$_SESSION['DefaultFactoryLocation']) { echo '<option selected="selected" value="'; } else { echo '<option value="'; } } The code should/could be further modified to use the loccode and code (field name on BOM table for WorkCenter) of the first member of the BOM as the default. Bob Thomas -- View this message in context: http://weberp-accounting.1478800.n4.nabble.com/BOMs-php-Location-Defaults-tp4657663.html Sent from the web-ERP-developers mailing list archive at Nabble.com. |