|
问题现象:在用友U8erp系统中用友U8版本号:U8软件的财务系统产品线应收模块出现如下问题:年结时显示年结失败错误号是0请帮忙解答!
原因分析:使用检测工具发现问题。
解决方案:在用友erp 系统版本U8软件中UPDATEAp_DetailsetcInvCode=b.cInvCode,ibvid=b.autoidFromSaleBillVouchaINNERJOINSaleBillVouchsbona.SBVID=b.SBVIDinnerjoinap_detailconc.ccovouchtype=a.cvouchtypeandc.ccovouchid=a.csbvcodewherec.cInvCodeisnullandc.cflag=‘ar‘andc.iflagb.ccodeselect*fromap_detailainnerjoin(select*fromap_detailwherecflag=‘ap‘andccovouchtypein(‘01‘,‘02‘,‘03‘,‘p0‘)andcvouchtypein(‘48‘,‘49‘))bona.ccovouchtype=b.ccovouchtypeanda.ccovouchid=b.ccovouchidanda.ibvid=b.ibvidanda.cvouchtypein(‘01‘,‘02‘,‘03‘,‘p0‘)anda.ccodeb.ccode。
|
|