webERP Forum
Is actualcost field in stockmaster obsolete? - Printable Version

+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (http://www.weberp.org/forum/forumdisplay.php?fid=1)
+--- Forum: Development Discussion & Specification (http://www.weberp.org/forum/forumdisplay.php?fid=10)
+--- Thread: Is actualcost field in stockmaster obsolete? (/showthread.php?tid=995)



Is actualcost field in stockmaster obsolete? - PakRicard - 08-10-2013

Hi all:

In most of webERP scripts standard cost is calculated as (materialcost + labourcost + overheadcost).

Also in stockmaster table there is a field called actualcost which I believe it is not used (at least in my webERP actualcost = 0 for all items in stockmaster table).

But, some reports as SalesInquiry use actualcost field (but results are always zero in my case). It is aslo retrieved in some MRP scripts but never used for calculations (as far as I understand that piece of code).

So:

1) is actualcost obsolete?
2) should we get rid of it?
3) should salesinquiry use (materialcost + labourcost + overheadcost) instead of actualcost?



RE: Is actualcost field in stockmaster obsolete? - Exsonqu_Qu - 08-10-2013

Hi, Richard,

it seems that the actual cost has never been calculated.

Best regards!

Exson


RE: Is actualcost field in stockmaster obsolete? - phil - 08-12-2013

I think so ... would need to grep around to be sure.


RE: Is actualcost field in stockmaster obsolete? - PakRicard - 05-15-2023

Just returning to this old topic... In my search for DB optimization, I plan to use actualcost as a PERSISTENT field = stockmaster.materialcost+stockmaster.labourcost+stockmaster.overheadcost to save the hundreds of sums that have to be done, as all over webERP stockmaster.materialcost+stockmaster.labourcost+stockmaster.overheadcost is found and recalculated.
Other than that... actualcost is only used in SalesInquiry.php retuning always 0 as it is never populated ;-)