简易鼎捷易飞存货对账

 目前鼎捷易飞产品标准系统没有存货对账模块，每次给客户对账都是非常耗时间和精力的一件事，客户满意度也不会太高，

所以我们经过一段时间分析，结合客户实际运用，给客户做了一个简单的实际运用SQL，给各位参考并相互学习进步，欢迎同行指导，谢谢

1,首先核对余额表与库存明细表科目期初是否正确,
2,再拉出对账年月余额表与库存明细表科目核对总差异
3,分别拉出总账余额,库存余额,分录余额,
(--总账余额ACT
SELECT TB005,SUM(TB007*TB004) FROM ACTTB 
LEFT JOIN ACTTA ON TA001=TB001 AND TA002=TB002
WHERE TA003<='20181031' AND TB005='1403' AND TA006<>'1' --- AND  TA003>='20181001'  
GROUP BY TB005

--分录余额
SELECT TB005,SUM(TB004*TB007) FROM AJSTB 
LEFT JOIN AJSTA ON TA001=TB001 AND TA002=TB002
WHERE TB005='1403'  AND TA006<='20181031' AND TA014='Y'  ----AND TA006>='20181001'
GROUP BY TB005

--库存余额
SELECT SUM(LA013*LA005) FROM INVLA INNER JOIN INVMB ON MB001=LA001 
INNER JOIN CMSMC ON MC001=LA009 
LEFT JOIN INVMA ON MA002=MB005
WHERE  LA004<='20181031' AND MA004='1403' AND MC004=1 ---AND LA004>='20181001' )
完整请联系博主！