易助存货与会计总账对账.ppt

存货与会计对账
——吴彦
整理ppt
目录
为什么存货与会计要进行对账
为什么可以对账
对账一般的处理流程
差异的处理方法
整理ppt
为什么存货类的报表要和会计总账进行对账？
为了保证业务类的单据和财务报表的一致性，A') AND NDA BETWEEN '' AND '' AND NDB=''
整理ppt
--入库成本
--业务单据金额
SELECT SUM(LNA*LNA) FROM JSKLNA WHERE LNA=' AND LNA BETWEEN '' AND ''
--会计凭证金额
SELECT SUM(NDB*NDB) FROM KJSNDB LEFT JOIN KJSNDA ON NDA=NDB AND NDA=NDB WHERE NDB='A' AND NDA BETWEEN '' AND '' AND NDB=''
整理ppt
--出库成本
--业务单据金额
SELECT SUM(LNA*LNA) FROM JSKLNA WHERE LNA=‘’ AND LNA BETWEEN '' AND ''
--会计凭证金额
SELECT SUM(NDB*NDB) FROM KJSNDB LEFT JOIN KJSNDA ON NDA=NDB AND NDA=NDB WHERE NDB='A' AND NDA BETWEEN '' AND '' AND NDB='
整理ppt
--领退料成本
--业务单据金额
SELECT SUM(LNA*LNA) FROM JSKLNA WHERE LNA='' AND LNA BETWEEN '' AND '' AND LNA='O'
--会计凭证金额
SELECT SUM(NDB*NDB) FROM KJSNDB LEFT JOIN KJSNDA ON NDA=NDB AND NDA=NDB WHERE NDB='' AND NDA BETWEEN '' AND '' AND NDB=''
整理ppt
--生产入库成本(主件)
--业务单据金额
SELECT SUM(LNA*LNA) FROM JSKLNA WHERE LNA='' AND LNA BETWEEN '' AND '' AND LNA='I'
--会计凭证金额
SELECT SUM(NDB*NDB) FROM KJSNDB LEFT JOIN KJSNDA ON NDA=NDB AND NDA=NDB WHERE NDB='' AND NDA BETWEEN '' AND '' AND NDB=''
整理ppt
--生产入库退回(主件)
--业务单据金额
SELECT SUM(LNA*LNA) FROM JSKLNA WHERE LNA='' AND LNA BETWEEN '' AND '' AND LNA='O'
--会计凭证金额
SELECT SUM(NDB*NDB) FROM KJSNDB LEFT JOIN KJSNDA ON NDA=NDB AND NDA=NDB WHERE NDB='' AND NDA BETWEEN '' AND '' AND NDB=''
整理ppt
--委外进货成本(主件)
--业务单据金额
SELECT SUM(LNA*LNA) FROM JSKLNA WHERE LNA='' AND LNA BETWEEN '' AND '' AND LNA='I'
--会计凭证金额
SELECT SUM(NDB*NDB) FROM KJSNDB LE