ERP成本计算公式

--本期工单需领材料成本=3167927.38  （此数字远小于10的数字，说明--本月有材料的加权成本小于上个月的加权成本）
SELECT SUM(INVLB.LB011*MOCTB.TB004)
FROM MOCTB as MOCTB   Left JOIN INVLB as INVLB On MOCTB.TB003=INVLB.LB001
WHERE ((INVLB.LB002 = '200711') AND (MOCTB.TB001 = '511') AND (MOCTB.TB002 = '200710045'))
--工单预计产量=1204
--工单单位成本=3167927.38/1204=2631.1689
--本期工单实际领料成本=2365775.20
SELECT SUM(LA017*LA005*-1) FROM MOCTE LEFT JOIN MOCTC ON TC001=TE001 AND TC002=TE002 
LEFT JOIN INVLA ON TE001=LA006 AND TE002=LA007 AND TE003=LA008 LEFT JOIN CMSMC ON TE008=MC001 AND MC004='1' 
LEFT JOIN CSTTA ON TE011=TA003 AND TE012=TA004 AND TA002='200711' 
WHERE TC009='Y' AND TE016 IN ('1','3') AND TE011='511' AND TE012='200710045' AND TC003>='20071101' AND TC003<='20071130'
--本期约旦产量=实际领料成本/工单单位成本=实际领料成本*工单预计产量/工单需领材料成本=2365775.20*1204/3167927.38=899.135
--本期入库材料成本=3261788.54
SELECT SUM(LA017*LA005) FROM MOCTG 
LEFT JOIN MOCTF ON TF001=TG001 AND TF002=TG002
LEFT JOIN INVLA ON TG001=LA006 AND TG002=LA007  AND TG003=LA008
LEFT JOIN CMSMC ON TG010=MC001 AND MC004='1' 
LEFT JOIN CSTTA ON TG014=TA003 AND TG015=TA004 AND TA002='200711' 
WHERE TF006='Y' AND TG014='511' AND TG015='200710045' AND TF003>='20071101' AND TF003<='20071130'
--本期在制约量=期初在制约量+约旦产量-生产入库-委外进货=279.073+899.135-1197=-18.792
--本期在制材料成本=期初材料成本+本期实际领料成本-本期入库材料成本=844805.71+2365775.20-3261788.54=-51207.63








--本期工单需领材料成本=46883.29880000000000