浪潮ERP软件银行对账、银行余额调整表账面余额计算方法
软件版本: PS9.1_pack3 软件模块: 账务处理
问题描述:
银行对账、银行余额调整表账面余额计算方法
产生原因:
解决方法:
单位账当前余额:
1初始余额:
SELECT ZWDZZH_CSDWYE FROM ZWDZZH WHERE ZWDZZH_KMBH =’科目编号’
2借方发生
select sum(ZWRJZD_JE) FROM ZWRJZD WHERE ZWRJZD_KMBH=’科目编号’ AND ZWRJZD_YWRQ<=’登录日期’ AND ZWRJZD_SFCS=’0′ AND ZWRJZD_JZFX=’1′
3贷方发生
select sum(ZWRJZD_JE) FROM ZWRJZD WHERE ZWRJZD_KMBH=’科目编号’ AND ZWRJZD_YWRQ<=’登录日期’ AND ZWRJZD_SFCS=’0′ AND ZWRJZD_JZFX=’2′
单位账当前余额 = 1 + 2 – 3
银行账当前余额:
1初始余额:
SELECT ZWDZZH_CSYHYE FROM ZWDZZH WHERE ZWDZZH_KMBH =’科目编号’
2发生
select sum(ZWYHZD_SFJE -ZWYHZD_FFJE) FROM ZWYHZD WHERE ZWYHZD_KMBH=’科目编号’ AND ZWYHZD_YWRQ<=’登录日期’ AND ZWYHZD_SFCS=’0′
银行账当前余额 = 1 + 2
二、余额调整表
单位日记账账面余额:
1初始余额:
SELECT ZWDZZH_CSDWYE FROM ZWDZZH WHERE ZWDZZH_KMBH =’科目编号’
2借方发生
select sum(ZWRJZD_JE) FROM ZWRJZD WHERE ZWRJZD_KMBH=’科目编号’ AND ZWRJZD_YWRQ<=’查询月份最后一天’ AND ZWRJZD_SFCS=’0′ AND ZWRJZD_JZFX=’1′
3贷方发生
select sum(ZWRJZD_JE) FROM ZWRJZD WHERE ZWRJZD_KMBH=’科目编号’ AND ZWRJZD_YWRQ<=’查询月份最后一天’ AND ZWRJZD_SFCS=’0′ AND ZWRJZD_JZFX=’2′
单位日记账账面余额 = 1 + 2 – 3
银行日记账账面余额:
1初始余额:
SELECT ZWDZZH_CSYHYE FROM ZWDZZH WHERE ZWDZZH_KMBH =’科目编号’
2发生
select sum(ZWYHZD_SFJE -ZWYHZD_FFJE) FROM ZWYHZD WHERE ZWYHZD_KMBH=’科目编号’ AND ZWYHZD_YWRQ<=’查询月份最后一天’ AND ZWYHZD_SFCS=’0′
银行账当前余额 = 1 + 2
注:如果系统设置中选择了‘银行余额调整表按凭证日期显示’选项,计算余额调整表账面余额时把上面条件中的业务日期换为凭证日期。
原创文章,转载请注明: 转载自浪潮888博客
本文链接地址: 浪潮ERP软件银行对账、银行余额调整表账面余额计算方法
文章的脚注信息由WordPress的wp-posturl插件自动生成