Re: [WebERP-developers] Standard costs not updated/editable

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

The logic described below works the same for either weighted average or 
standard costing - it is irrelevant.

Phil

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

On 02/05/14 20:28, Phil Daintree wrote:
> Hi Bob,
>
> Each time you create a WO for the item the system recalculates the
> standard cost expected and updates the cost based on the BOM - producing
> GL journals as necessary to revalue the stock. When you receive
> completed items against this work order they will be valued at this cost
> and the WIP reduced by the value of finished goods received.
>
> When you close the WO the cost of received/completed manufactured items
> is compared against the cost of the components issued to the WO and the
> variance written off.
>
> You can change the standard cost at any time with the cost change utility.
>
> When you change a BOM the cost is not automatically recalculated ...
> only when you raise a WO and receive the first completed item -
>
> See WorkOrderReceive.php
>
> //Recalculate the standard for the item if there were no items
> previously received against the work order
>           if ($WORow['qtyrecd']==0){
>               $CostResult = DB_query("SELECT
> SUM((materialcost+labourcost+overheadcost)*bom.quantity) AS cost
>                                       FROM stockmaster INNER JOIN bom
>                                       ON stockmaster.stockid=bom.component
>                                       WHERE bom.parent='" .
> $_POST['StockID'] . "'
>                                       AND bom.loccode='" .
> $WORow['loccode'] . "'",
>                                       $db);
>               $CostRow = DB_fetch_row($CostResult);
>               if (is_null($CostRow[0]) OR $CostRow[0]==0){
>                       $Cost =0;
>               } else {
>                       $Cost = $CostRow[0];
>               }
>               //Need to refresh the worequirments with the bom components
> now incase they changed
>               $DelWORequirements = DB_query("DELETE FROM worequirements
>                                               WHERE wo='" . $_POST['WO'] . "'
>                                               AND parentstockid='" .
> $_POST['StockID'] . "'",
>                                               $db);
>
>               //Recursively insert real component requirements
>               WoRealRequirements($db, $_POST['WO'], $WORow['loccode'],
> $_POST['StockID']);
>
>               //Need to check this against the current standard cost and
> do a cost update if necessary
>               $sql = "SELECT materialcost+labourcost+overheadcost AS cost,
>
> HTH
>
> Phil
>
> Phil Daintree
> Logic Works Ltd - +64 (0)275 567890
> http://www.logicworks.co.nz
>
> On 01/05/14 05:25, rfthomas wrote:
>> I have searched the archives and find nothing that addresses our problem.
>>
>> We have a BOM for a part that is as below:
>>
>> Actuator Control Module AACM-PA-2G-20110214 : per each
>> Component	Description	Quantity	Unit Cost	Total Cost
>> BAACM-PA-2G-20110214	Actuator Control Board no software no eui	1	90.58	90.58
>> SAACM-L-20120412	AACM software for linear actuators 4/12/12	1	2.00	2.00
>> Labour Cost	2.00
>> Overhead Cost	0.00
>> Total Cost	94.58
>>
>> The standard cost displayed for this item is:
>>
>> Item Code:
>> AACM-PA-2G-20110214 - Actuator Control Module AACM-PA-2G-20110214
>> Total Quantity On Hand: 83 each
>> Last Cost update on: 04/30/2014
>> Last Cost:	25.9400
>> Standard Material Cost Per Unit:	25.9400
>> Standard Labour Cost Per Unit:	
>> Standard Overhead Cost Per Unit:	
>>
>> Is is not updating to use the total cost from the BOM and the costs at the
>> higher levels reflect the price of $25.94 instead of $94.58.  The Standard
>> Material Code Per Unit is a display only field.
>>
>> We are very confused with how standard costs are determined and how to
>> effectively maintain them.  We have run the Utilities/Update costs for all
>> BOM items, from the bottom up but that did not make the required changes.
>>
>> What are we missing with respect to maintaining standard costs?
>>
>> Thank you,
>> Bob Thomas
>>
>>
>>
>> --
>> View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Standard-costs-not-updated-editable-tp4657399.html
>> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>>
>> ------------------------------------------------------------------------------
>> "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
>> Instantly run your Selenium tests across 300+ browser/OS combos.  Get
>> unparalleled scalability from the best Selenium testing platform available.
>> Simple to use. Nothing to install. Get started now for free."
>> http://p.sf.net/sfu/SauceLabs
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web...@li...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>
> ------------------------------------------------------------------------------
> "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
> Instantly run your Selenium tests across 300+ browser/OS combos.  Get
> unparalleled scalability from the best Selenium testing platform available.
> Simple to use. Nothing to install. Get started now for free."
> http://p.sf.net/sfu/SauceLabs
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>