Hi All,
I am trying to get the Cost prices for all item\Resource from ProdCalcTrans Table in order to display it in the Cost Estimates and Costing Reports.
I have made I simple code base on other display methods on the same Table but I only get the Resource Process Id cost price (And the actual one) but not the Item cost
I would like to have the Prices at the time the Report As Finished was made (if possible)
this is my code so far:
your help is greatly appreciated!
display CostPrice AKS_ItemCostPrice()
{
RouteCostCategoryIdProcess processCatId;
WrkCtrTable wrkCtrTable;
InventTable inventTable;
if(this.isItemCost())
{
return InventTable.costPcsPrice(this.InventDimId,null,null,ProdTable::find(this.TransRefId).StUpDate,false);
}
else if(this.isResourceCost())
{
select firstonly ProcessCategoryId from wrkCtrTable
where wrkCtrTable.WrkCtrId == this.Resource;
return RouteCostCategory::find(wrkCtrTable.ProcessCategoryId).CostPrice;
}
return 0;
}
