问题现象: | 因收付款协议设置错误,以采购入库单的下两个月1日作为立账日,导致现在对账出现问题,客户要求从后台修改采购发票,应收应付单,销售发票的立账日,到期日以及账期,立账日为采购入库单的单据日期,账期为0。由于数据量大,客户强烈要求后台批改,请集团看能否处理!数据已上传到集团FTP下U8shenzhen目录下,文件名称是裕亨光电20111115.rar |
问题原因: | |
解决方案: | 您好 该数据分析答复如下: 1.建立增加一个收付款协议,以便与后续业务区别, 如按客户要求:立账日为采购入库单的单据日期,账期为0,编码为:999 2.更改入库单: update rdrecord01 set dCreditStart=ddate,iCreditPeriod=0,dGatheringDate=ddate,cvenpuomprotocol='999' from rdrecord01 inner join rdrecords01 on rdrecord01.id=rdrecords01.id where brdflag=1 and cvouchtype='01' and bcredit=1 and (ddate<>dCreditStart) 3.更改采购发票 update PurBillVouch set PurBillVouch.cvenpuomprotocol=rds.cvenpuomprotocol,PurBillVouch.dCreditStart=rds.dCreditStart,PurBillVouch.iCreditPeriod=rds.iCreditPeriod,PurBillVouch.dGatheringDate=rds.dGatheringDate from PurBillVouch inner join PurBillVouchs on PurBillVouch.PBVID=PurBillVouchs.PBVID inner join (select cvenpuomprotocol,ddate,dCreditStart,iCreditPeriod,dGatheringDate,bcredit,ccode, rdrecords01.* from rdrecord01 inner join rdrecords01 on rdrecord01.id=rdrecords01.id where brdflag=1 and cvouchtype='01' and bcredit=1 ) rds on PurBillVouchs.rdsid=rds.autoid 4.更改ap_detail : update Ap_Detail set ap_detail.cGatheringPlan=pur.cvenpuomprotocol,ap_detail.dCreditStart=pur.dCreditStart,ap_detail.iCreditPeriod=pur.iCreditPeriod,ap_detail.dGatheringDate=pur.dGatheringDate from Ap_Detail inner join ( select cvenpuomprotocol,dCreditStart,iCreditPeriod,dGatheringDate,bcredit,cpbvcode,PurBillVouchs.* from PurBillVouch inner join PurBillVouchs on PurBillVouch.PBVID=PurBillVouchs.PBVID where cvenpuomprotocol is not null ) pur on pur.id=ap_detail.ibvid where cGatheringPlan is not null and cvouchtype in ('01','02') 由于非正常更改数据, 由于直接修改数据库,修改前请务必做好数据备份,验证确认没有问题再使用! 如对问题答复有疑问敬请及时反馈 U8/CRM/PLM |
相关补丁: | |
版本: | U8 V10.0 |
模块: | 应收应付 |
产品: | 财务会计 |
问题名称: | 应收款立帐日问题 |
最后更新: | 2011-11-16 16:36:12 |