应收系统如果核销后生成的凭证借贷方不平的可能原因
2015-4-3 0:0:0 wondial应收系统如果核销后生成的凭证借贷方不平的可能原因
文章标题:应收系统如果核销后生成的凭证借贷方不平的可能原因。 u8应收系统如果核销后生成的凭证借贷方不平,而且差别很大,有可能是此次核销的发票余额不对。此数据的问题在于客户“shxg”的4张发票在salebillvouchs表的imoneysum,iexchsum字段和Ap_Detail表的icamount不一致,造成在应收系统中查寻发票时显示的发票余额错误。以下是修改此数据的脚本,仅供参考。 SELECT ibvid,icamount into a FROM Ap_Detail WHERE (cCoVouchID = '0000000222') AND (cDwCode = 'shxg') AND (cVouchType = '48') ORDER BY iBVid SELECT AutoID,imoneysum,iexchsum into b FROM SaleBillVouchs WHERE (SBVID = '222') ORDER BY AutoID update salebillvouchs set imoneysum=0, iexchsum=0 where salebillvouchs.autoid in ( select b.AutoID from b left join a on b.autoid=a.ibvid where a.ibvid is null ) update salebillvouchs set imoneysum=2220.6200,iexchsum=2220.6200 where salebillvouchs.autoid='2518' and (SBVID = '222') update salebillvouchs set imoneysum=31510.6200,iexchsum=31510.6200 where salebillvouchs.autoid='2558' and (SBVID = '222') update salebillvouchs set imoneysum=12734.0600,iexchsum=12734.0600 where salebillvouchs.autoid='2571' and (SBVID = '222') update Ap_Detail set iCAmount =35106.75 where ibvid='2527' AND (cVouchType = '48') update Ap_Detail set iCAmount_f=iCAmount WHERE (cVouchID = '0000000420') AND (cDwCode = 'shxg') AND (cCoVouchID = '0000000222') and ibvid=2527 UPDATE salebillvouchs SET imoneysum = 0, iexchsum = 0 FROM salebillvouchs AS a WHERE a.sbvid = '305' or a.sbvid = '295' drop table a drop table b如果您的问题还没有解决,可以到 T+搜索>>上找一下答案
相关阅读
- 用友U8材料采购科目借贷发生不平有余额是什么原因详解2021-10-9 9:57:49
- 用友ERP-U8成本管理模块培训2019-5-13 12:8:25
- invalid object name 'tempdb..temp-accvouch70554a1232019-4-23 8:0:0
- 实时错误‘404’:automation错误2019-4-23 8:0:0
- 对于用友软件进行SQL跟踪器时,应注意什么问题?能写个步骤吗?2019-4-23 8:0:0
- 我们企业成本精细核算,需要针对每一件存货的每一次出入库进行记账, u8 能够支持吗2019-4-23 8:0:0
- 明细账打印预览死机2019-4-23 8:0:0
- 进UFO时总提示“MFC42.DLL中导致无效页错误就关闭退出2019-4-23 8:0:0
- 连接不上服务器故障分析2019-4-23 8:0:0
- 下标越界,用友软件年结后查询货位票未能统计表报错2019-4-23 8:0:0