《高级成本查账的SQL语句.doc》由会员分享,可在线阅读,更多相关《高级成本查账的SQL语句.doc(3页珍藏版)》请在金锄头文库上搜索。
1、第一部分:确保成本归属是否正确;第一步:确认所有的领料单的领料成本是否算到成本计算单中;1、查询【成本计算单】中本期下阶投入的成本汇总;SELECT TI006 as 工单单别,sum(TJ012) as 本期下阶投入成本FROM ACMTJ LEFT JOIN ACMTI ON TJ001=TI001 AND TJ002=TI002 WHERE TI003=201108 GROUP BY TI006order by TI0062、查询领料的投入的成本SELECT TE011,SUM(LA013*LA005*-1) FROM MOCTE LEFT JOIN MOCTC ON TC001=TE0
2、01 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 TE015=TA001 AND TA002=201108 WHERE TC009=Y AND TE016 IN (1,3) AND TC003=20110801 AND TC003=20110801 AND TF003=20110801 AND TH003=20110801 AND TK003=20110801 AND LA004=20110801 AND TA006= 20110801)AND (ACTTA.TA003 = 20110831)AND (ACTTA.TA010 = Y) AND (ACTTB.TB005 LIKE 5001%) GROUP BY TA0064、 按照存货对账的方式对出INV-AJS-ACT的差异;第二步:确保人工和制费和总账能对上;1、 如果人工和制费对不上,那么还要确保高级成本搜集到的人工和制费是否和总账子系统中来源是否相等;