问题现象: | 做完核销,在核销制凭证的时候,或者借贷不平,或者没有科目。 |
问题原因: | 因为SALEBILLVOUCHS表的累计收款金额有问题,造成制单处理不平。 |
解决方案: | 可以通过以下脚本进行处理: update salebillvouchs set iexchsum=isum-iamount_f,imoneysum=inatsum-iamount from salebillvouchs a inner join (select ibvid,sum(idamount_f-icamount_f) as iamount_f,sum(idamount_f-icamount_f) as iamount from ap_detail where ccovouchtype like '2%' and iflag |
相关补丁: | |
版本: | 8.51 |
模块: | 应收 |
产品: | U851----应收款管理 |
问题名称: | 制单不平 |
最后更新: | 2005-11-22 00:00:00 |