核对销售发票时用的语句
<P>--汇总报表（核对总数用）<BR>SELECT 年月,SUM(A.销售总数量) AS 销售总数量,SUM(A.外购总数量) AS 外购总数量,<BR>SUM(A.销售总不含税金额) AS 销售总不含税金额,SUM(A.外购不含税金额) AS 外购不含税金额,<BR>SUM(A.销售总含税金额) AS 销售总含税金额,SUM(A.外购含税金额) AS 外购含税金额 FROM<BR>(<BR>--销售发票总数量、不含税金额、含税金额报表（所有）<BR>SELECT LEFT(CONVERT(CHAR,B.ACCDAT_0,112),6) AS 年月,SUM(A.QTY_0*B.SNS_0) AS 销售总数量,0 AS 外购总数量,<BR>ROUND(SUM(A.AMTNOTLIN_0*B.SNS_0*B.RATRPT_0),2) AS 销售总不含税金额,0 AS 外购不含税金额,<BR>ROUND(SUM(A.AMTATILIN_0*B.SNS_0*B.RATRPT_0),2) AS 销售总含税金额,0 AS 外购含税金额<BR>FROM SINVOICED A<BR>INNER JOIN SINVOICE B ON A.NUM_0=B.NUM_0<BR>LEFT JOIN ITMMASTER C ON A.ITMREF_0=C.ITMREF_0<BR>WHERE B.ACCDAT_0 BETWEEN '2010-01-01' AND '2010-10-31'<BR>GROUP BY LEFT(CONVERT(CHAR,B.ACCDAT_0,112),6)<BR>UNION ALL<BR>--销售发票总数量、不含税金额、含税金额报表（外购）<BR>SELECT LEFT(CONVERT(CHAR,B.ACCDAT_0,112),6) AS 年月,0 AS 销售总数量,SUM(A.QTY_0*B.SNS_0) AS 外购总数量,<BR>0 AS 销售总不含税金额,ROUND(SUM(A.AMTNOTLIN_0*B.SNS_0*B.RATRPT_0),2) AS 外购不含税金额,<BR>0 AS 销售总含税金额,ROUND(SUM(A.AMTATILIN_0*B.SNS_0*B.RATRPT_0),2) AS 外购含税金额<BR>FROM SINVOICED A<BR>INNER JOIN SINVOICE B ON A.NUM_0=B.NUM_0<BR>LEFT JOIN ITMMASTER C ON A.ITMREF_0=C.ITMREF_0<BR>WHERE B.ACCDAT_0 BETWEEN '2010-01-01' AND '2010-10-31' AND A.YCPLX_0=2<BR>GROUP BY LEFT(CONVERT(CHAR,B.ACCDAT_0,112),6)<BR>)A<BR>GROUP BY A.年月<BR>ORDER BY A.年月</P><P> </P><P>这个供大家参考一下</P>页:
[1]