Menu
▾
▴
web-erp-developers
|
From: rfthomas <rf...@as...> - 2014-04-30 17:26:30
|
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. |
|
From: Phil D. <ph...@lo...> - 2014-05-02 08:28:14
|
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
>
|
|
From: Phil D. <ph...@lo...> - 2014-05-02 08:56:38
|
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 > |
|
From: rfthomas <rf...@as...> - 2014-05-02 13:35:24
|
Phil, weberp/Z_BottomUpCosts.php is not updating the standard cost. For item AACM-PA-2G-20110214 it shows a standard cost of $27.94 When we look at the costed BOM it shows a cost of $94.58 When we run weberp/StockCostUpdate.php?StockID=AACM-PA-2G-20110214 we are not able to edit/change the Standard Material Cost Per Unit, it is a display only field. Is there someplace else that we need to look to change the Standard Material Cost? We do not build this part on a daily basis, rather due to economies of scale we have to build a 6 month supply of this WIP part, i.e. our sub-tiers need to have minimum economic run quantities in the 1,000's. We will not be making more of this part for a few months. We would like to have our costs correct for items being built using these parts. This is just one example of a part with the wrong standard cost. We have not modified any of the code involved. I have sent Exson all of the code that we have modified: Scripts with customized quote/invoice formats and packing slips based on actual invoice, change to invoice data entry to allow defaulting to quantity 0 rather PO quantity, and a Flatten BOM script. Bob Thomas -- View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Standard-costs-not-updated-editable-tp4657399p4657403.html Sent from the web-ERP-developers mailing list archive at Nabble.com. |
|
From: Phil D. <ph...@lo...> - 2014-05-02 23:40:20
|
I am not sure about Z_BottomUpCosts.php I didn't write this... looks too clever for me as it uses recursive calls to UpdateCosts - so probably nobbled by suhosin/PHP security. However, with weberp/StockCostUpdate.php?StockID=AACM-PA-2G-20110214 could it be that the user does not have access to page Security token 10? To allow stock cost updates? Phil Phil Daintree Logic Works Ltd - +64 (0)275 567890 http://www.logicworks.co.nz On 03/05/14 01:34, rfthomas wrote: > Phil, > > weberp/Z_BottomUpCosts.php is not updating the standard cost. > > For item AACM-PA-2G-20110214 it shows a standard cost of $27.94 > > When we look at the costed BOM it shows a cost of $94.58 > > When we run weberp/StockCostUpdate.php?StockID=AACM-PA-2G-20110214 we are > not able to edit/change the Standard Material Cost Per Unit, it is a display > only field. > > Is there someplace else that we need to look to change the Standard Material > Cost? > > We do not build this part on a daily basis, rather due to economies of scale > we have to build a 6 month supply of this WIP part, i.e. our sub-tiers need > to have minimum economic run quantities in the 1,000's. We will not be > making more of this part for a few months. We would like to have our costs > correct for items being built using these parts. > > This is just one example of a part with the wrong standard cost. > > We have not modified any of the code involved. I have sent Exson all of the > code that we have modified: Scripts with customized quote/invoice formats > and packing slips based on actual invoice, change to invoice data entry to > allow defaulting to quantity 0 rather PO quantity, and a Flatten BOM script. > > Bob Thomas > > > > -- > View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Standard-costs-not-updated-editable-tp4657399p4657403.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 > |
|
From: Phil D. <ph...@lo...> - 2014-05-03 00:00:17
|
Whoops no - it looks like for manufactured items the StockCostUpdate.php
script the material cost is always hidden
I've made a small modification around line 170:
if ($myrow['mbflag']=='M'){
echo '<tr>
<td>' . _('Standard Material Cost Per Unit') .':</td>
<td class="number"><input type="text"
name="MaterialCost" class="number" value="' .
locale_number_format($myrow['materialcost'],$_SESSION['StandardCostDecimalPlaces'])
. '" /></td>
</tr>
I can't see a good reason why this is not allowed? Of course each time
you make some the cost will be over-ridden based on the BOM as described
and then updated based on the variance on manufacture once the WO is closed.
Phil
Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz
On 03/05/14 11:40, Phil Daintree wrote:
> I am not sure about Z_BottomUpCosts.php I didn't write this... looks too
> clever for me as it uses recursive calls to UpdateCosts - so probably
> nobbled by suhosin/PHP security.
>
> However, with
>
> weberp/StockCostUpdate.php?StockID=AACM-PA-2G-20110214
>
> could it be that the user does not have access to page Security token
> 10? To allow stock cost updates?
>
> Phil
>
> Phil Daintree
> Logic Works Ltd - +64 (0)275 567890
> http://www.logicworks.co.nz
>
> On 03/05/14 01:34, rfthomas wrote:
>> Phil,
>>
>> weberp/Z_BottomUpCosts.php is not updating the standard cost.
>>
>> For item AACM-PA-2G-20110214 it shows a standard cost of $27.94
>>
>> When we look at the costed BOM it shows a cost of $94.58
>>
>> When we run weberp/StockCostUpdate.php?StockID=AACM-PA-2G-20110214 we are
>> not able to edit/change the Standard Material Cost Per Unit, it is a display
>> only field.
>>
>> Is there someplace else that we need to look to change the Standard Material
>> Cost?
>>
>> We do not build this part on a daily basis, rather due to economies of scale
>> we have to build a 6 month supply of this WIP part, i.e. our sub-tiers need
>> to have minimum economic run quantities in the 1,000's. We will not be
>> making more of this part for a few months. We would like to have our costs
>> correct for items being built using these parts.
>>
>> This is just one example of a part with the wrong standard cost.
>>
>> We have not modified any of the code involved. I have sent Exson all of the
>> code that we have modified: Scripts with customized quote/invoice formats
>> and packing slips based on actual invoice, change to invoice data entry to
>> allow defaulting to quantity 0 rather PO quantity, and a Flatten BOM script.
>>
>> Bob Thomas
>>
>>
>>
>> --
>> View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Standard-costs-not-updated-editable-tp4657399p4657403.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
>
|
|
From: rfthomas <rf...@as...> - 2014-05-05 15:11:22
|
Phil, Thank you. The change allowed us to update the costs. Bob Thomas -- View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Standard-costs-not-updated-editable-tp4657399p4657407.html Sent from the web-ERP-developers mailing list archive at Nabble.com. |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X