Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Is actualcost field in stockmaster obsolete?
08-10-2013, 11:46 AM,
#1
Is actualcost field in stockmaster obsolete?
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?
Regards,
Pak Ricard
Reply
08-10-2013, 07:36 PM,
#2
RE: Is actualcost field in stockmaster obsolete?
Hi, Richard,

it seems that the actual cost has never been calculated.

Best regards!

Exson
Reply
08-12-2013, 07:40 AM,
#3
RE: Is actualcost field in stockmaster obsolete?
I think so ... would need to grep around to be sure.
Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Reply
05-15-2023, 01:55 PM,
#4
RE: Is actualcost field in stockmaster obsolete?
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 ;-)
Regards,
Pak Ricard
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)